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
These built-in add-ins are powerful and useful. Power Pivot, Power Maps, and Inquire. Learn how to enable and use them. Contents Related videos Handle millions of rows in Excel –
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
Practical and useful features for browser version of Microsoft Excel Contents Related videos Excel – Find Replace Formatting Multiple header crosstab data clean up – Excel – Power Query How
Write inside cells, do data entry using ink in Microsoft Excel. Erase, select, highlight and more… Contents Related videos How to create Excel Tables – 17 best practices Instant 3D
Instead of VLOOKUP, you can use Power Query Merge. It is faster, more convenient and flexible. Learn how to do it. Watch 5 min video. Power Query Merge Video Contents
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.
