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
Tag: chart
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.
Field setting in Pivot Table Excel
In this video we take look at fields setting in pivot table of Microsoft Excel and introduce you the tools in this setting
Calculated fields in Pivot Table
In this video we talk about the calculated fields in Microsoft Excel pivotTable and seeing its advantages
Change pivot table data source
In this video we talk more about pivot table and the options that this tool has for us.
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
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
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.
Excel combo chart
When you want to compare two variables by using Excel charts, if those two variable have same measuring index then we can plot them in one charts. However, if those variables has different measurements, like one being money amount and one being quantity, then we need to use combo box which enables us to have two different measurement units in one chart.
Basic of Charts in Microsoft Excel
In this video we talk about how can make a chart in Excel and what are the main properties of charts in Excel. Creating a chart is one of the main tools for data analyzing and Excel simple and beautiful charts are one its most well known advantages of this software