fbpx

Excel

  • 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…
  • Excel – How to add Conditional Formatting

    I often get asked about how you can utilise Microsoft Excel in your daily routine, to help you work more efficiently. I recently showed a delegate how to use Conditional Formatting on a list of personnel, where typically you might want to see who was off sick more often than other staff, or who had taken more holidays. I thought you might be interested to see how this can work. I created a short ‘How to’ video which is about 2 minutes long…

    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…
  • How to Compare Spreadsheets The Right Way

    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 video I will show you a new feature in Microsoft Excel that you can use to compare differences between spreadsheets called Excel Inquire.  …

    Read more…