Apply Excel chart templates and customize a chart once. Save as template. Apply it manually or automatically – using a macro. Download macro file from here (zip) Contents Related videos
Clean-up data quickly using the amazing Power Query Convert multiple column data into two columns using Excel or Power BI with the UNPIVOT feature of Power Query. Download sample file
Simplify data cleanup Power Query magic. Excel and Power BI Split column by position – made easy. No trial and error, no mistakes. Download sample file Contents Related videos Consolidate
Learn 4 ways to open multiple Excel files instantly including shortcuts on how to startup, open multiple files tips and more. Contents Related videos Best Practices for Data Entry Best
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
