Goals
- Create a functional data table
- Apply specific sorts and filters
- Use conditional formatting
Program
Create a data table
Format Table
Set Table Style Options
Apply Totals
Workshop: Transform a range of data into a table
Use a data table
Use sorting at one or more levels
Apply filters (classic or advanced)
Calculate subtotals
Workshop: Working with the data of a table
Highlight certain data
Apply conditional formatting
Create a custom formatting rule
Use sorts and filters with formatting
Duration
0.25 day
Price
£ 2495
Audience
All
Prerequisites
Have followed « Excel: Creating and handling tables » or have equivalent knowledge
Reference
BUR100975-F
Sessions
Contact us for more informations about session date