Excel custom sort and more
Learn all about sorting in Excel. Simple sort, multi-level, custom order, formatting and more … Two detailed videos. First one is about native Excel features. Second one is about automating
Work Smarter, Grow Faster
Work Smarter, Grow Faster
Learn all about sorting in Excel. Simple sort, multi-level, custom order, formatting and more … Two detailed videos. First one is about native Excel features. Second one is about automating
Distinct count is not available in Pivot Table by default. However, if you create a pivot table using data in data model, you can get this option. As an additional
Once you know how to convert crosstab to tabular format, your data processing becomes super-fast and efficient. Most people struggle with multiple crosstab inputs and waste enormous amount of time
Excel Data Model has been there since 12 years. Despite that, it is not known to majority of Excel users. Even those who know about it do not use it
Budget vs actuals report is a very common need. It could also be target vs actuals or forecast vs actuals. The concept is same. We have two pieces of data.
Excel vs Power BI is a very commonly asked question during the sessions I conduct. However, a to-the-point comparison is not easily available. You will see lot of feature comparisons.
New video. Just released. Watch. Get data from website / web page tables without copy paste. Use Power Query (Get and Transform) Web option. Copy paste just the URL. Choose
Learn how to use Microsoft Lists for data entry and multi-user data capture. Stop using Excel. Eliminate the need for multiple file copies, copy paste and manual consolidation. Get direct,
Use the power of Free Microsoft 365 Copilot to work more efficiently and grow faster in your career.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
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.
