Master Pivot Tables with these 8 How-to Tricks

Pivot Tables are a core tool in Excel used to quickly analyze large, or small, sets of data.  Yet many Excel users have a fear of Pivot Tables as they are often viewed as a more advanced tool.  I would argue Pivot Tables are a core feature, that every Excel user should know. In this […]

Interactive Excel Dashboard youtube premiere

How to recreate this interactive Excel dashboard

Last week I had the pleasure of entering an Interactive Excel Dashboard to the Excel Hash 2021 challenge set by Oz de Soleil.  It was massive fun and it was awesome to pitch myself up against some of the most well-known Excel peeps in the world. In case you missed it, you can check out […]

Overcome Problems when Copying and Duplicating Excel Worksheets

Copying worksheets in Excel is a common task.  It provides massive time savings by allowing you to use the content of the worksheet over and over without the need to regenerate the formulas or the formatting.  Most often copying a worksheet within the same workbook is easy and mostly problem-free.  However, if you are trying […]

Find the corresponding value from Multiple column match in Excel

Do you fancy a bit of an Excel Data Challenge?  Something to get you thinking creatively with your Excel Skills?  Well, I have this problem that requires a multiple column match in Excel to look up and return a corresponding value and I think you will enjoy solving it! I received a spreadsheet from my […]

Learn How to Fix Totals and Subtotals in DAX

Learn how to fix totals and subtotals in DAX for PowerBI and Power Pivot The problem of incorrect totals and subtotals in DAX is a common problem for both Power BI and Power Pivot users. But these incorrect totals, are not wrong. When you appear to have incorrect totals, it’s not because DAX calculated them […]

3 Ways to Set Screen Scroll Lock Area in Excel

Often there are times when a spreadsheet developer has the need to set the screen scroll lock area in Excel restricting where the user can scroll and has visibility. A perfect example would be Excel Dashboards. ****Scroll to the bottom for the video***** Setting the screen scroll lock area improves the user experience and can […]

Excel Hidden and Very Hidden Sheets – What’s the difference?

Hidden and Very Hidden Sheets in Excel – Skip to Video As most of us know, Excel, being such an amazing tool, gives us the ability to Hide sheets from view.  However, what many are not aware of is that Excel also offers the ability to set sheets as very hidden.  Hidden sheets are common […]