Microsoft Excel Level 2

Details

1-day course. $275 / participant - minimum enrollment required. Discounted pricing available for 6 participants or more. Contact us for additional information.

We offer three levels of Microsoft Excel training in Toronto, Mississauga, and Ottawa - Level 1 | Level 2 | Level 3 Data Management | Level 3 Spreadsheet Analysis. Courses available for Excel 2003, 2007, 2010, 2013.

Prerequisites

Microsoft Excel Level 1

Course Objectives

Upon completion of the course, participants will be able to accomplish the following:

• Organize, protect, and display data using various tools
• Use the IF function, create linking formulas, and manage links
• Manage and arrange multiple workbooks, insert and manage multiple worksheets within a workbook, and consolidate data from multiple sources
• Create and modify charts to present data effectively; customize charts to enhance their appearance
• Create, apply and modify styles to format worksheets consistently and quickly; use comments, text boxes to annotate worksheets, and sparklines to highlight and explain data

Course Content

Worksheet Organization
Managing Range Names ; Creating and Using Workbook Templates ; Applying Worksheet Security ; Creating and Using Outlines

Advanced Formulas
Using the IF Function ; Linking Formulas ; Modifying and Restoring Links

Using Multiple Workbooks and Worksheets
Working with Multiple Workbooks ; Working with Multiple Worksheets ; Consolidating Data

Working with Charts
Creating Charts ; Changing Chart Data ; Modifying Chart Elements ; Creating Custom Charts

Applying Formatting
Working with Styles ; Annotating Worksheets ; Using Sparklines