fbpx
Site logo white shadow

Category: Dr Nitin

Pivot data using Power Query

Pivot data using Power Query and Convert flat data with key – value pairs to tabular data. Simplify analysis. Use Power Query – Pivot Column for conversion. Download Sample File

Read »
Excel addins
Three must have add-ins for Excel

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 –

Read »
Microsoft Excel – Flowcharts

Let us explore Flowcharts in Microsoft Excel. Uainf Data to create thew Flow Chart or using Copilot to make it. Related videos Instant flowchart using Copilot or ChatGPT Stop using

Read »
Create flowcharts using Copilot for free

Create professional Flow Chart using Copilot. Get the steps from Copilot and create the actual flowchart using Mermaid Software. Related videos Stop using PowerPoint for flowcharts and infographics – Use

Read »

Popular Articles

Pivot Table Pro Course

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.

Excel to Power BI Course

Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.

Subscribe to Blog

Join 1,745 other subscribers