PivotTables in Excel are a great way to visualize your data. However, in order to easily query and summarize your data in the PivotTable, you need to properly structure your data set before building the PivotTable. Not only is the practice of streamlining your dataset into fewer columns good for PivotTables for different dimensions, this […]
What are your favorite Excel keyboard shortcuts? I talk about my top 5 and why I think they are useful for all analysts. The key takeaway is to stop using your mouse or trackpad on your laptop, and commit to learning these keyboard shortcuts to be more efficient and productive in Excel. My #1 Excel […]
This is the first episode of Dear Analyst, a podcast about Excel, data analysis, software, and everything in between. In this episode, I talk about the Copy and Paste Special Values feature in Excel, and why it’s not a good habit to get into when it comes to structuring the data in your Excel files. […]
Excel for the Real World I studentThis was a great class! I haven’t worked with excel in years and it was a great refresher course.
Emerald Green Cover for Mac Excel $24.99 
Cool Blue Cover for Mac Excel $24.99 
Hot Pink Cover for Mac Excel $24.99 
