Excel 2016 Intermediate
Students will learn to manipulate multiple Worksheets and Workbooks; create, modify, and analyze charts; and utilize Advanced Functions and Formatting.
Summary: Students will learn to manipulate multiple Worksheets and Workbooks; create, modify, and analyze charts; and utilize Advanced Functions and Formatting.
Experience Needed: Excel 2016 – Introduction, or relevant experience.
Course Content:
Using Multiple Worksheets and Workbooks
- Using Multiple Worksheets
- Inserting New Worksheets
- Creating Multiple Views
- Navigating in Multiple Workbooks
- Moving and Copying Data between Worksheets
- Linking Data Between Worksheets
- And more
Charting
- Using Charts
- Creating a Chart
- Changing Chart Type and Style
- Add Data to an Existing Chart
- Change the Data in an Existing Chart
- Managing Chart Objects
- And more
Advanced Functions
- Creating and Using Functions
- Using Built-in Functions
- Using Dates and Times
- Using Dates in Calculations
- Auditing Worksheets
- Unedifying the Auditing Commands
- And more
Advanced Formatting
- Using Comments in a Worksheet
- Reviewing, Showing, and Hiding Comments
- Working with Styles
- Using Format Paining
- Conditional Formats
- Clear Conditional Formats
- And more
Students will receive an email confirming their registration for requested course. Two business days before the scheduled class, students will each receive their electronic course and materials and their Microsoft Teams link used to join their training class. After class ends, students will receive a certificate of completion along with their class evaluation.
