Standard SharePoint Products
Calendar Browser
Kanban Task Manager
Pivot Explorer
Templates Manager
Ideas
Buy
Standard plan
Premium plan
Support
Discount
Services
4 hours sessions
Demonstrations
Enhancement Contracts
Tips
Books
Excel from Scratch
Power Apps with SharePoint from Scratch
PowerShell with SharePoint from Scratch
SharePoint Flows from Scratch
SharePoint Online Essentials
SharePoint Online Exercises
SharePoint Online from Scratch
SharePoint Workflows from Scratch
Microsoft Teams from Scratch
Office 365 from Scratch
Contact
About us
Founder
Tools
PnP Generator
Home
>
Tips
>
Excel 2016 from Scratch
>
Visualization L, slicers, pivot table and chart
Site map
Excel 2016 from Scratch Exercise
Visualization L, Slicers, Pivot Table and Chart
An Excel tutorial by Peter Kalmstrom
In this demo in the Excel 2016 from Scratch series Peter Kalmstrom goes through another exercise on how to visualize data.
In the demo below Peter illustrates fictitious revenues from different company branches per quarter.
Exercise
Please
download the Excel file Peter uses in the demo
and try the exercise before you watch the demos.
Content
This is shown in the demo below:
How to convert a range of cells to a table.
How to add a totals row which summarizes the values in a column to the table.
How to add slicers for columns.
How to color slicers.
How to select several options in a slicer.
How to insert a pivot table and create views.
How to insert a pivot chart that illustrate the view.
How to move the pivot chart to another sheet.
Peter uses Excel 2016 for his demo, but the Excel visualization tools are the same for later versions of Excel.
Learn more
Products
Buy
Services
Tips
Books
Contact
About Us
Tools
Security and integrity
Copyright Kalmstrom Enterprises AB All rights reserved
In
this demo in the Excel 2016 from Scratch series Peter Kalmstrom
goes through another exercise on how to visualize data.
