|
Technology Training Centre ~ Excel Word Training in Edmonton Cancellation Policy
Description: This course introduces a user to Excel’s intermediate features for editing a worksheet, using cell commands and tracking changes. Charting data is explored along with building skills to manage multiple worksheets. Building on skills learned in Level 1, more advanced uses of functions and formulas are explored along with creating and defining range names. Analyzing and organizing data along with manipulating and formatting objects such as clip art, SmartArt and graphic onjects is revisited.
Course Content
Worksheet Organization
- Range Names
- Workbook Templates
- Worksheet Security
- Outlining
Advanced Formulas
- Using the IF Function
- Linking Formulas
Using Multiple Workbooks and Worksheets
- Working with Multiple Workbooks
- Setting Up Multiple Worksheets
- Using Multiple Worksheets
- Creating Links with Formulas
- Modifying and Restoring Links
- Consolidating Data
Working with Charts
- Creating Charts
- Changing Chart Data
- Modifying Chart Elements
- Creating Custom Charts
Applying Formatting
- Creating Styles
- Working with Styles
- Using Conditional Formatting
- Annotating Worksheets
Pre-Requisites: Excel 2007 – Level 1 or equivalent experience
Certificates offered: Certificate of completion
Duration Details: 1 day
9:00am - 4:00pm
Facility Location: Edmonton Training Center
B-11 Cameron Library
University of Alberta
Edmonton
Alberta
Canada
T6G 2J8
| 
