Excel

  • 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…
  • Excel Autofill to complete sequences

    A really simple skill that we teach on our Excel Level 2 Ninjas course is Autofill. I find most people who use Excel don't know how to do this - or only know part of what it can do.

    Watch my short 'how to' video to find out more.

    Read more…
  • Excel Inquire helps you compare spreadsheets

    How to Compare Spreadsheets The Right Way With Excel Inquire

    You know when you’ve got a few different versions of a spreadsheet, and you end up in muddle? This can happen so easily when you email spreadsheets to colleagues – then they work on them and send them back… and in the meantime you’ve made changes to the original copy! In this short ‘how to’ video I will show you a feature in Microsoft Excel that you can use to compare differences between spreadsheets called…

    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…
  • The 5 biggest Excel SINS of 2018!

    As a trainer, I get to see inside a lot of companies and sometimes the confessions from delegates on our courses are horrifying! Of course, no-one is born knowing how to use Excel … and so many people self-educate as they find a ‘gap’ in their knowledge. But the problem with this is you are often missing out and doing things the long way around. Or worse still, as some of these sins show us, employees are actually placing their…

    Read more…
  • Excel – Fill Series – How to fill a series of dates down a column

    We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja! This week’s tip is about how to quickly insert today’s date and create a series of dates down the column. You may want to copy this date down using…

    Read more…
  • Excel – splitting a column into two

    We provide our delegates with ongoing inspiration and support via short ‘How to’ videos that you can watch and learn from. The latest tips are little things that speed up your work, making you super-efficient. You’ll be well on your way to becoming a productivity Ninja! This week’s tip is about how to split one column into two. You may want to sort a spreadsheet by Last Name but only have a Full Name column of data. In…

    Read more…