This course is being held online with a live instructor. Students will have access to training labs after the course as well.
Contact us for additional dates held monthly!
WORKING WITH FUNCTIONS
- Define Cell Ranges and Reference Them in Formulas
- Perform Conditional Calculations
- Carry Out Logical and Specialized Functions
- Work with Date and Time Functions
- Understand and Execute Text Functions
2 – WORKING WITH LISTS
- Sort and Filter Data
- Learn the Capabilities of Database Functions
- Query Data with Database Functions
- Outline and Subtotal Data
3 – ANALYZING DATA
- Build and Modify Tables
- Create Formatting Rules
- Apply Conditional Formatting to Alter Groups of Cells
4 – VISUALIZING DATA WITH CHARTS
- Organize and Represent Data with Charts
- Modify and Format Charts
- Discover and Implement Advanced Chart Features
5 – ANALYZING DATA WITH PIVOTTABLES AND PIVOTCHARTS
- Create a PivotTable
- Analyze PivotTable Data
- Present Data with PivotCharts
- Filter Data Using Timelines and Slicers
Date: April 20
Times: 9 am – 5 pm
Cost (member): $265
Cost (non-member):$325