Microsoft Excel

Unclear and poorly laid out spreadsheets are much more likely to contain errors. Learning to present your spreadsheets clearly is extremely important. And the larger the spreadsheet, the harder it is to control! So get it right the first time.…

  Have you ever considered turning your list into a Data Table? From this, you can easily create a Pivot Table.  A Pivot Table is a table of values which are aggregations of groups of individual values, much like a…

VLookup is used to look up information in a list and extract the data into another list. It can also be used for matching; is the value I have in one list, also in another? The benefit of using Index…

  Cell References tell your formula how it works. Using the right kind will let you copy your formulas across your data. All while keeping them working as intended We also teach this on our Microsoft Excel courses, as it’s…

Formulas and Functions are some of Excels most powerful tools. They allow the user to make complex and insightful spreadsheets. Understanding Formulas In Excel An Excel formula is an expression that returns a result. They save you time and effort.…