Work Smarter, Grow Faster
Learn about column profiling and column distribution while importing data using Power Query. Related Videos Multiple header crosstab data clean up – Excel – Power Query Eliminate VLOOKUP using Excel
Excel 2013 onwards has a powerful 3D map feature. It can also import any 2D image and plot your data on top of it. Very useful for mapping floor plans,
Checkboxes in Excel have been there for a long time. However, in Oct 2023, Microsoft introduced a simpler and more elegant way to add checkboxes right within Excel cells. Learn
Learn two ways of combining multiple lists and creating all combinations. Pivot table or Power Query? I prefer Power Query. Download sample file and try. Related Videos Convert crosstab data
Learn how to generate reminders from Excel data using Power Automate. Step by step process with detailed explanation. Understand triggers, actions, conditions, variables and loops. Download sample file and follow
Learn how to remove excess formatting with just ONE CLICK. Amazing new feature. Try it out. Related videos Excel audit using Inquire Excel tables – 18 benefits
Learn how to clean up data quickly. Common problem. Tabular data has some intermittent merged rows. Cleaning these manually is time consuming and efficient. Using Power Query this can be
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
In this video, I will show you how to use Power Query to split a column by a delimiter and create new rows for each value. This is useful when
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.
