Overview
Courses Benefits
You Will Learn How To
- Resolve formula errors
- Manage data such as removing duplicates, validating and transposing data
- Answer “What-if” scenarios using goal seek
- Work with PivotTables
- Create basic dashboards to visualize data
- Use Macros to automate repetitive tasks
- Protect your spreadsheet from misuse by others
Who Should Attend
Course Outline
Auditing Worksheets
- Tracing Formula Precedents and Dependents
- Showing Formulas
- Evaluating Formulas
- Setting Error Checking Options
- Using Error Option Buttons
- Running an Error Check
Data Tools
- Consolidating Information
- Removing Duplicates
- Configuring Data Validation
- Transposing Data
- Converting Text to Columns
- Using Goal Seek
PivotTable Basics
- What is a PivotTable?
- Creating a PivotTable
- Using the PivotTable Fields Pane
- Using PivotTable Classic View
- Viewing Details of Summarized Data
- Sorting Pivoted Data
- Filtering Pivoted Data
Advanced PivotTable Features
- Using Natural Language to Create PivotTables
- Changing Field Layout and Sorting
- Adding Calculated Fields
- Showing Values in Different Ways
- Customizing Column Names
- Changing Order of Rows
- Changing Order of Columns
- Grouping Data
- Changing the PivotTable Layout
- Creating PivotTables from Data in Multiple Worksheets
Creating Basic Dashboards
- Creating a Basic PivotChart
- Using Slicers
- Using Sparklines
- Creating Timelines
- Using the Camera Tool
Using Macros
- Recording a Macro
- Editing a Macro
- Running a Macro
NOTE: Macro programming is not covered
Working with Others
- Co-authoring
- Sharing a Workbook
- Protecting a Worksheet
- Protecting Cells
- Protecting a Workbook