My QUICK And EASY Method For Building An Interactive Dashboard In Excel
My QUICK And EASY Method For Building An Interactive Dashboard In Excel
Welcome back to Day 10 of 30 Day Excel Analyst – transforming your analytical skillset in 30 days.
Watch the video HERE
This week we’re dealing with something Excel professsionals must do most days: analyse data. Yesterday, we explored how to deal with what’s called continuous numerical data in Excel. But, what if you have to analyse text rather than numbers? Data that’s better described as ‘discrete’? People often want to do this – so what are the options in Excel?
Now, I avoided pivot tables for the first few years of my career as an Excel analyst. I would go to great lengths to avoid using them at all. I found pivot tables in Excel difficult to set up and generally unpredictable – the way they would automatically resize really unsettled me. But, this reticence wasn’t a bad thing since I found some great alternatives, including Excel’s data analysis formulae that we’ll cover later in data analysis week.
Over the years, however, I’ve come to appreciate the unique power of pivot tables in Excel. But, it’s not just their immense computational power. A pivot table opens up the possibility of pivot charts, slicers – the building blocks of an interactive dashboard in Excel. Yes, in today’s session we won’t just understand how to analyse discrete data in Excel, we’ll also build an Excel dashboard using a quick and easy method that you can apply to your work today. Welcome back to 30 Day Excel Analyst!
READ MORE ABOUT OUR PROFESSIONAL EXCEL DEVELOPMENT COMMUNITY: MEMBERS MONDAY