Course Outline
1 - WORKING WITH FUNCTIONS
- Topic A: Work with Ranges
- Topic B: Use Specialized Functions
- Topic C: Work with Logical Functions
- Topic D: Work with Date and Time Functions
- Topic E: Work with Text Functions
2 - WORKING WITH LISTS
- Topic A: Sort Data
- Topic B: Filter Data
- Topic C: Query Data with Database Functions
- Topic D: Outline and Subtotal Data
3 - ANALYZING DATA
- Topic A: Create and Modify Tables
- Topic B: Apply Intermediate Conditional Formatting
- Topic C: Apply Advanced Conditional Formatting
4 - VISUALIZING DATA WITH CHARTS
- Topic A: Create Charts
- Topic B: Modify and Format Charts
- Topic C: Use Advanced Chart Features
5 - USING PIVOTTABLES AND PIVOTCHARTS
- Topic A: Create a PivotTable
- Topic B: Analyze PivotTable Data
- Topic C: Present Data with PivotCharts
- Topic D: Filter Data by Using Timelines and Slicers
6 - WORKING WITH MULTIPLE WORKSHEETS AND WORKBOOKS
- Topic A: Use Links and External References
- Topic B: Use 3-D References
- Topic C: Consolidate Data
7 - SHARING AND PROTECTING WORKBOOKS
- Topic A: Collaborate on a Workbook
- Topic B: Protect Worksheets and Workbooks
8 - AUTOMATING WORKBOOK FUNCTIONALITY
- Topic A: Apply Data Validation
- Topic B: Search for Invalid Data and Formulas with Errors
- Topic C: Work with Macros
9 - USING LOOKUP FUNCTIONS AND FORMULAS AUDITING
- Topic A: Use Lookup Functions
- Topic B: Trace Cells
- Topic C: Watch and Evaluate Formulas
10 - FORECASTING DATA
- Topic A: Determine Potential Outcomes Using Data Tables
- Topic B: Determine Potential Outcomes Using Scenarios
- Topic C: Use the Goal Seek Feature
- Topic D: Forecast Data Trends
11 - CREATING SPARKLINES AND MAPPING DATA
- Topic A: Create Sparklines
- Topic B: Map Data
Target Audience
The job roles best suited to the material in this course are: sales personnel, accountants, administrators, auditors, lab assistants, office job positions.