admin

About admin

B.Sc. Engineering in Industrial and Production Engineering (IPE) from Shahjalal University of Science and Technology (SUST).

Microsoft Excel PivotTable – Beginner to Advanced

Welcome you to Microsoft Excel Pivot Table Series (Beginner to Advanced) A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data. Pivot Tables work a little bit differently depending on what platform you are using to run Excel. Post 001: Introduction to Pivot Table and purposes of using Pivot Table Post 002: How to create a Pivot Table in Excel and [...]

Excel PivotTable Fields

By default, a PivotTable fields should show up to the right of the Microsoft Excel window when you create a pivot table and select a cell within it. The field list can be used to choose fields for the pivot table layout and to reposition pivot table fields within the layout. The Task Pane for a pivot table is called PivotTable Fields. Areas and Fields are both parts of the PivotTable Fields Task Pane. Fields [...]

Conditions for PivotTable Data Preparation in Excel

Today we'll discuss Fail-Proof Tips to Prepare Excel Data for PivotTables Analysis. Any large data set can be converted to a PivotTable, but it's important to prepare your Excel data in advance for PivotTable analysis. If you don't, your data might be misrepresented by errors or other inaccuracies. When preparing your data for a PivotTable in Excel, it is important to ensure that the data meets certain conditions or requirements. Steps to Prepare [...]

How to Create a Pivot Table in Excel?

In this post, you will learn how to create your first pivot table, which you may have never done before but which seems like magic to you. Even if you use pivot tables frequently, you may improve your understanding of how they work. Microsoft Excel's most noteworthy and terrifying feature is the pivot table. It's useful since it can help you summarize and understand enormous amounts of data. It's intimidating since you're not an [...]

What is a PivotTable and how can it help you?

One of the most common data analysis tools is the PivotTable. Many crucial business questions can be answered quickly with PivotTables. We develop PivotTables for a variety of reasons, one of which is to convey data. We'd like to back up our story with data that's simple to grasp and see. Have you ever discovered yourself staring at spreadsheets with large data sets and not understanding where to begin? How do you [...]

When do you use ISFILTERED Function (DAX)?

In our daily office work, we use Excel to ease our work, and people who know the use of PivotTable can generate reports with a fingertip. But in PivotTable there have few limitations that you can't use Functions. So here comes PowerPivot for Excel to give advanced flexibility over PivotTable. In PowerPivot for Excel and Power BI, you can write measure to give flexibility in report generating. So how this title is related to the [...]

Sum of Current, Previous, Next Month Values using DAX in Power BI and Excel

  You have data in below table (Table: 01) from which you want to get price of previous, current, next month for each row in three new columns in Power BI and Excel PowerPivot (Table: 02). Table: 01 Table: 02 You can do it by using below given DAX formula. This formula will work if you have installed any one of Excel 2016 or above, Microsoft Power Query for Excel (Add-in for Excel 2010, 2013), [...]

Go to Top