Excel Tips &
Pivot Table
Excel Tips
-
Select And Replace Blank Cells
-
Unstack Data Using the Delete Blank Rows
-
Remove Duplicate
-
Parse Data In Excel
-
Extract Number From Text
Select And Replace Blank Cells
Unstack Data Using the Delete Blank Rows
Remove Duplicate
Parse Data In Excel
Extract Number From Text
Pivot Table
-
PivotTables can easily transform your dreaded summary report creating session from hours of work to just a few clicks!
-
Provide quick insights by get answer from large data without write complex formula.
-
Easy and fast to create and use, just drag and drop and no VBA macros
Using Formula
Convert to Excel Table
- Select the cell in the table, go to Insert > Tables > Table.
Create Pivot Table
- To create a PivotTable, select a cell in the worksheet > Insert > Tables > PivotTable.
- Then, select the range of the table and where to locate the PivotTable.
Drag and Drop
Pivot Table Diagram
Group Text Fields
-
To group text fields, right-click mouse (select column) > Group > named accordingly
Group Numeric Fields
-
To group the numeric data, go to Analyze > Group > Group Field
Group Date Fields
-
Drag the Date into the Rows field
-
Ungroup default grouping, go to Analyze > Group > Ungroup
-
To group the data, go to Analyze > Group > Group Field
Pivot Chart
-
Click the cell in the PivotTable > Analyze > Tools > PivotChart
Dashboard
-
Copy all the charts to the Dashboard worksheet
-
Select the chart, go to Analyze > Insert Slicer
Dashboard
