Microsoft Excel 2007 Level 2 (S172)
Classroom Learning
Classroom Learning
Also available via
Who Needs to Attend
Those who are familiar with Microsoft Office Excel 2007
Prerequisites
Follow-On Courses
- Microsoft Excel 2007 Level 3 - Data List Management (S173D)
- Microsoft Excel 2007 Level 3 - Spreadsheet Analysis (S173S)
- Microsoft Excel 2007 Level 3 - VBA Macros (S173V)
In this course, you will build on your fundamental Excel skills to become proficient with more advanced Excel 2007 skills, such as using multiple worksheets, combining worksheets, linking formulas, creating and modifying charts, and applying styles to format worksheets.
What You'll Learn
- Organize, protect, and display data, using various tools
- Create linking formulas and use the IF function
- Set up multiple worksheets, using information from other sources through consolidation, and copy and paste links to combine information into one worksheet
- Create and modify charts to present data effectively
- Customize charts to enhance their appearance
- Create and apply styles to format worksheets consistently and quickly
- Use conditional formatting, comments, and text boxes to highlight and explain data
Course Outline
1. Managing Multiple Worksheets and Workbooks
- Using Multiple Worksheets
- Working with Multiple Workbooks
- Naming Cells and Ranges
- Consolidating Data
2. Using Templates and Protecting Workbooks
- Working with Workbook Templates
- Protecting Workbooks and Worksheets
3. Nested Formulae and External References
- Using the IF Function
- Working with External References
- Updating and Restoring Links
4. Working with Charts
- Creating Charts
- Updating Chart Data
- Formatting a Chart
- Creating Custom Chart Template
5. Formatting Excel Data
- Using Cell Styles
- Managing Cell Styles
- Using Conditional Formatting
- Working with Comments
- Creating and Using Worksheet Outlines
Classroom Dates and Locations
Don’t see the location or date you need? No problem – just use our By Request service.
Course Code: 8774
Registration Information
$225 CAD
1 Day Course
Microsoft Course: S172
Practice Files
RSS