Comparison – Pivot Table vs Power Pivot
Here is a quick listing of the key differences from a usage point of view. It will help you choose the right type based upon the analytical objectives.
New Event: Excel Efficiency Transformation for Finance
Online Courses Power BI & Pivot Tables
Here is a quick listing of the key differences from a usage point of view. It will help you choose the right type based upon the analytical objectives.
Here is a quick post to show the practical scenario when the Remove Top and Bottom Rows options are useful while cleaning up data using Power Query. Remove Top Rows
Here is another short but power packed video which explains how analytics can drive growth. Read the related articles here. [youtube https://youtu.be/W2sP3n7LYMo]
Redundant or unwanted columns can confuse the users of Pivot Table. Here is how you can hide unwanted columns from appearing in the Pivot Table field list. This setting is
We have seen many methods of using Excel and related Power BI tools for analyzing data. Now, all that can be done WITHOUT using Excel – using a stand-alone tool
In the earlier article, we saw how Power BI Desktop can help us create complex, interactive, and useful reports from various sources of data. Here is a detailed walk-through of
Here is an animated globe showing the new year dawning across time zones. Created using Power Map. You can also create it using Excel 2013 onwards. In the next article,
Often we get data which is distributed in multiple column sets. Here is how you can convert it to good data (tabular column format) using Power Query. Watch the video.
Read Histogram and Pareto articles first. Excel Data Analysis tool can create a Pareto chart while creating a histogram. Small tweak but very useful.
Join the Free Excel Efficiency Transformation for Finance Event
Sat 27th Feb, 3 pm IST