ExcelDemy | Page 27 of 31 | Free Excel Tutorial & Online Courses

Monitor Cells with Excel Watch Window!

Jun 7, 2021 Advanced Excel

Sometimes we have a great deal of data in the workbook. Everything is important but most important is the last row of the data containing, say, the ...

Types of What-If analysis in Excel

Mar 31, 2021 Data Analysis with Excel

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. Excel can handle much-sophisticated models than the ...

A What-If example in Excel

Jul 9, 2018 Data Analysis with Excel 6

This article is part of my series: What-If Analysis in Excel – A Step by Step Complete Guide. You can create dynamic models in Excel. This is one of ...

How to Create Pivot Table Data Model in Excel 2013

Mar 31, 2021 Advanced Excel 1

So far, we have focused exclusively on pivot tables that are generated from a single table of data. The Data Model feature has brought additional ...

How to create a pivot table report in Excel

Mar 31, 2021 Excel Pivot Table 1

You can convert a huge table of data into an attractively printed report using a pivot table. The following figure shows a small portion of a pivot ...

A Pivot Table Example in Excel with Real Data

Mar 31, 2021 Excel Pivot Table

We are going to work with a pivot table example in this section. We shall learn some useful ways to work with pivot tables. The following figure ...

How to Create a Pivot Chart in Excel!

Mar 31, 2021 Excel Pivot Table 1

With a pivot chart, you can graphically represent the data summarized in a pivot table. If you know how to create charts in Excel, you’ll face no ...

How to Reference PivotTable Data in Excel Formulas with GETPIVOTDATA?

Aug 28, 2020 Excel Formulas 1

In this article, I have shown you how you can reference PivotTable Cell Data in Excel formulas using GETPIVOTDATA function. If you feel uneasy with ...

How to Create a Timeline in Excel to Filter Pivot Tables!

Mar 31, 2021 Excel Pivot Table 1

A Timeline is conceptually similar to a Slicer, but Timeline is specially designed to simplify time-based filtering in a pivot table. Note: ...

What is a Slicer in Excel

Mar 31, 2021 Excel Pivot Table

A Slicer is an interactive control. A Slicer makes your job easy to filter data in a pivot table. The following figure shows a pivot table with three ...

How to Filter Excel Pivot Tables with Slicers!

Mar 31, 2021 Excel Pivot Table

Before proceedings to our main topic, you need to know what is actually a Slicer. What is a Slicer A Slicer is an interactive control. A Slicer ...

How to Insert a Calculated Item into Excel Pivot Table!

Mar 31, 2021 Excel Pivot Table 1

In this article, I'll show you how you can insert a calculated item into an already created Excel Pivot Table. Some Excel users avoid these two items ...