Posted on Leave a comment

Dashboard in Microsoft Excel

Dashboard is one of the best way to have data status under control. We use dashboard to control the status of situations in time line and to report them to management. In this video we show how to develop a simple management dashboard in Excel

Posted on Leave a comment

Create simple pivot Chart

In this video we show how to create a Pivot Chart in excel. which is very simple and can immediately done by using pivot table.

Posted on Leave a comment

slicer , timeline slicer and refreshing data in Pivot Table

In this video we show that how to use slicer for filtering data, and how we can use timeline slicer

Posted on Leave a comment

Designing your pivot Table for reporting

In this video we talk about how we can design and customize the pivot table in order to have a report of main table in Microsoft Excel

Posted on Leave a comment

Basic of Pivot Table in Excel

Pivot table is one the most useful tools of Microsoft Excel for getting quick and easy report. In this video we talk about how we can create and generate sample report by using pivot table in Excel.