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…
  • Select to the last cell

    This video explains how to the use some of the many shortcut techniques to move and select data on your spreadsheet. If you want to format a section of your Excel spreadsheet, click on the cell you want to select from and use the keyboard shortcut described in my short ‘How To’ video below. I’ll also share a tip for what to do if the selection ‘overshoots’ the range you want to select. These tips are part of our…

    Read more…
  • Excel BI Training Courses

    Watch the clips below as I show you some of the things you can learn on our higher level Excel courses. We provide Excel Business Intelligence (BI) Level 4 where we look at how to cleanse data quickly and combine files just by dropping them into a folder, repeatedly, Excel Dashboards Level 5 (full of advanced formulas and techniques to make a Dashboard within your spreadsheet, and Excel Visualizations Level 6 where you will learn your first DAX…

    Read more…
  • What’s involved in our Advanced Excel Courses – Business Intelligence (BI), Dashboards and Visualizations?

    Here with a few snippets from the courses, is what you can expect on our advanced level Excel courses. No need to worry, everything is broken down into steps and we can explain it all with great materials to back it up. Read in our Trustimonials what other people have said about these courses! These courses are designed to follow on from our Excel Gurus Level 3 course – if you’d like a copy of our brochure please call us on 01952…

    Read more…
  • Access your Office 365 Apps from anywhere

    With so many of my customers moving onto Office 365 I thought this post I shared on LinkedIn would be useful. You can use the Office Apps for Excel, Word, PowerPoint, OneNote and Outlook from any browser but of course you’ll need to know your login details. You will also have access to other useful Microsoft apps you may not have seen before so watch this space for updates!

    Read more…
  • Upskill your team with Microsoft Office training

    Business owner Tracey Westbury explains the effect of using Imagine Training’s services on her business. We work with employers like you to train your workforce, helping you achieve your goals for higher productivity, quality and growth through training that is targeted to specific actions you take hundreds of times a day – and doing it faster! We offer shortcut training and work with your staff to master new features in software…

    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…