Excel

  • 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 colleagues

    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 they take hundreds of times a day – and doing it faster! We offer shortcut training and work with them to master new features in software your…

    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 – 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…
  • 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…
  • 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…
  • Excel – Pivot Table new Set Defaults feature for advanced users

    This is cool for those of you who are serious PivotTable users and want to set defaults so that you can quickly format your PivotTables as you usually do, instantly. Every pivot table row field is now getting its own column thanks to Tabular Layout and Repeat All Item Labels being turned on by default! This blog is for more advanced users, we offer training to create PivotTables on our Excel Ninjas course, or we do a Live Online 2 hour session…

    Read more…
  • Excel – Keep your headings at the top

    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 keeping your headings at the top in Excel. Column headings disappear as you scroll down a spreadsheet, which is frustrating as…

    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 – What is Business Intelligence?

    Microsoft Power BI is a suite of tools that enable you to connect to your data, analyse it and then share it easily. If you know me, you’ll have heard me raving about Business Intelligence! It’s amazing – 4 new main tools, which we teach in our One Day Classroom course. Use Pivot Tables? Love them? Then you’ll love Power Pivots…. crazy way to join tables from different files, giving you a summary of all that…

    Read more…