Skip to content

Excel Special

The spreadsheets of my life

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

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

Excel — The essential skills for the regular user

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

An overview of the essen­tial skills in Excel that a reg­u­lar user should have in order to be able to work with spread­sheets quick­ly & effi­cient­ly — a begin­ning of a series. Read More

CategoriesOthers

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

Tips on large number of SUMIFS slowing down the spreadsheet

Posted on 23-09-202023-09-2020 by Tsvetan Georgiev

It is not uncom­mon to face large amounts of data that need to be aggre­gat­ed across myr­i­ad cells in Excel. If you have to =SUMIFS() through big ranges, you might spend too much time wait­ing for the cal­cu­la­tions to fin­ish. Bet­ter data struc­ture and focus on effi­cien­cy might help you out of this sit­u­a­tion. Read More

CategoriesSpreadsheet Philosophy

Finding similar items in Excel based on their properties

Posted on 02-06-202002-06-2020 by Tsvetan Georgiev

You can find sim­i­lar items in Excel based on their under­ly­ing prop­er­ties. Run­ning shoes are used to show how to approach the prob­lem and con­struct an array for­mu­la that gets the job done. Read More

CategoriesAdvanced Techniques

(Wrap-up) The gas money splitting tool

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

The final touch­es to the cal­cu­la­tor are being put in order for it to be a fin­ished prod­uct. Read More

CategoriesOthers

=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
Older posts →

New post email notification

Loading

Categories

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