Knowledge Pack – Microsoft Excel Tables
Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge
Excel Table seems like a trivial feature. But if used correctly, it transforms and improves the way you use Excel dramatically. Here is a set of articles (the entire knowledge
If you use OneNote extensively, it will soon have lots of content. Linking to that OneNote content from other applications is a frequent need. Here is how you do it…
Presentation download with reference links Download the Presentation (3 MB). I have added lots of links to related articles and external references including books written by stalwarts in Excel analytics
Thank you for the overwhelming response for Data Analytics webinar video. More than 800 attendees, 70+ questions. Watch the video on YouTube (use 720P) or Download (MP4, 188 mb, 60
Data Analytics Webinar In just one hour, learn how to gather data, how to clean it quickly and smartly, how to summarize, visualize and analyze it and share your results
This is an amazing feature which is largely unknown. Just create desired calculations in Excel, publish to SharePoint and now, parameters can be changed on a browser page with automatic
How to do Page Down Up using the mouse Simple but useful. Try it out.
Read the previous article to understand how to Pin commonly used programs to taskbar. But recently, I went beyond this. I thought – the order in which these icons are
The technical term is called PIN. Right click on any application that is running and choose Pin to Task bar. Also notice that the commonly used files appear there. You
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.
