Skip to content

Excel Special

The spreadsheets of my life

  • Home
  • Cookie policy (EU)
  • Glossary Term Archives

Category: Basic Techniques

Deal­ing with com­pli­cat­ed tasks requires good under­stand­ing of the basics. The cat­e­go­ry is meant to shed some light on the build­ing blocks that are used to tack­le spread­sheet challenges.

Excel essentials — Keyboard shortcuts

Posted on 03-03-202103-03-2021 by Tsvetan Georgiev
This entry is part 3 of 3 in the series Excel — The Essentials

The soon­er you start using key­board short­cuts in Excel, the bet­ter. I will focus on the com­bi­na­tions that I believe are the most wide­ly applic­a­ble regard­less of indus­try or expe­ri­ence lev­el. Read More

CategoriesEssentials

Excel essentials — The Interface And Its Customization

Posted on 08-02-202103-03-2021 by Tsvetan Georgiev
This entry is part 2 of 3 in the series Excel — The Essentials

The Excel inter­face is some­thing every user, regard­less of their lev­el, should under­stand well. Those are the most fun­da­men­tal pieces of infor­ma­tion you should keep in mind. Read More

CategoriesBasic Techniques, Essentials

Getting all records that meet a criteria with the =AGGREGATE() function

Posted on 26-12-202026-12-2020 by Tsvetan Georgiev

Some­times you need to get only some of the data rows in Excel that match cer­tain cri­te­ria (or more than one). One of the ways to do that is by using the often neglect­ed =AGGREGATE() func­tion. Read More

CategoriesBasic Techniques

=CHOOSE() from a list of values in Excel

Posted on 12-05-202002-06-2020 by Tsvetan Georgiev
This entry is part 6 of 7 in the series The gas mon­ey split­ting tool series

The =CHOOSE() func­tion allows you to define a list and pin­point a sin­gle entry from it to be returned as a result. Since list ele­ments can be both val­ues and ref­er­ences, this solu­tion can be applied in var­i­ous sit­u­a­tions. Read More

CategoriesBasic Techniques

Excel =LOOKUP() with conditions

Posted on 17-04-202017-04-2020 by Tsvetan Georgiev
This entry is part 5 of 7 in the series The gas mon­ey split­ting tool series

The =LOOKUP() func­tion in Excel can return val­ue from a vec­tor that sits against an exact/approximate match in anoth­er one. Flex­i­bil­i­ty can be added in the for­mu­la by employ­ing a con­di­tion whether some vec­tor ele­ments to be used or not. Read More

CategoriesAdvanced Techniques, Basic Techniques

Finding data in Excel with INDEX()+MATCH()

Posted on 21-02-202016-04-2020 by Tsvetan Georgiev
This entry is part 4 of 7 in the series The gas mon­ey split­ting tool series

Com­bin­ing the =INDEX() and =MATCH() func­tions is a way to save on time and pos­si­bly some doc­u­ment per­for­mance. In this post the sim­plest use of the func­tions is used to extract data from a two-dimen­sion­al table. Read More

CategoriesBasic Techniques

New post email notification

Loading

Categories

  • Advanced Techniques
  • Basic Techniques
  • Essentials
  • Others
  • Spreadsheet Philosophy
Proudly powered by WordPress