Excel 2016 - Level 2

This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks...

Course Outline

This course is designed for users with a good understanding of Excel fundamentals. The course will provide more advanced concepts required to consolidate and navigate data across multiple worksheets and workbooks. Participants will work with built-in functions such as ‚??if statements‚?Ě ‚??vlookup‚?Ě, ‚??pmt‚?Ě, ‚??dates‚?Ě, ‚??stats‚?Ě. We will analyze and organize data using charts. some functions and security. Some advanced features include creating templates, styles, conditional formatting and protecting your data.

Course Content
Overview

Customizing the Ribbon
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Command Shortcut Keys
Workbook Templates

Using Multiple Workbooks and Worksheets
Setting up Multiple worksheets
Copying, Moving, Deleting Worksheets
Consolidating Data
Creating Links with Formulas
Hyperlinks
Name Ranges
Paste Special ‚?? linking
Tiling ‚?? sheets, workbooks, applications
Freeze Panes
Split
View Side by Side

Review Spreadsheets
Track Changes
Comments

Functions
Function Concepts
Stats: averagea, counta
Logical: if statements, vlookup
Financial: PMT
Math: Round up, Round down
Dates: today, date

Applying Advanced Formatting
Creating Table Styles
Working with Table Styles
Creating Cell Styles
Using Conditional Formatting
Creating and Managing Conditional Formatting Rules

Charts
Creating Charts
Changing Chart Data
Resizing and Moving a Chart
Change Chart Type
Working with Chart Labels
Working with Chart Backgrounds
Changing a Chart's Source Data
Modifying Chart Elements
Using Chart Templates

Worksheet Organization
Protect Sheet
Protect Workbook
Share Workbook
Allow Users to Edit Ranges
Worksheet Security
Inspect Document
Check Compatibility
Mark as Final
Encrypt with Password

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada