fbpx

Spreadsheet

  • Nesting Excel Formula – MATCH, ISNA and IF to find which items are missing from a list

    Here’s a video I’ve recorded for our delegates who have completed Excel Level 3 Gurus course. It shows how to ‘nest’ 3 formulas to find if an item appears in a different list. That’s a useful thing to be able to do, so I take you step by step through how to build the formula. Try it yourself!

    Read more…
  • What are Pivot Tables?

    The PivotTable feature is a popular feature as it helps you see information in a way that it is grouped (and therefore condensed) into a smaller number of rows. To understand what a pivot table is take a look at this example of a long list of data. The data could be potentially up to a million rows – no-one could draw any conclusions about what it means so we can easily create a Pivot Table from the data. Good data to start with should have…

    Read more…
  • Excel – view spreadsheet totals with one click!

    Excel spreadsheets shortcut tip

    Don’t get lost in your budget Excel spreadsheets anymore! With this very useful shortcut you can streamline the information in your workbook to reveal what is relevant, simplifying your data within seconds. It’s always useful to see all the data in finance spreadsheets like a cash flow forecast or a profit and loss account, but sometimes you just want to see the important numbers. Any type of spreadsheet which contains formulas can…

    Read more…