Course Outline
Module One: Create and Manage Worksheets and Workbooks
- Create Worksheets and Workbooks
- Navigate in Worksheets and Workbooks
- Format Worksheets and Workbooks
- Customize Options and Views for Worksheets and Workbooks
- Configure Worksheets and Workbooks for Distribution
Module Two: Manage Data Cells and Ranges
- Insert data in cells and ranges
- Format cells and ranges
- Summarize and organize data
Module Three: Create tables
- Create and manage tables
- Manage table styles and options
- Filter and sort a table
Module Four: Perform operations with formulas and functions
- Summarize data by using functions
- Perform conditional operations by using functions
- Format and modify text by using functions
Module Five: Create charts and objects
- Create charts
- Format graphic elements
- Insert and format objects