Adobe Training
Acrobat Connect Training
Acrobat Training
Captivate Training
Dreamweaver Training
Flash Training
Flex Training
Illustrator Training
InDesign Training
Photoshop Training
VMware
VMware Training
Web Development
AJAX Training
CSS Training
HTML Training
JavaScript Training
PHP MySQL Training
Ruby on Rails Training
XML Training
Microsoft Office
Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training
Business Skills
Anger Management Class
Business Communication
Business Etiquette Training
Business Writing Class
Change Management
Customer Service Training
Project Management Training
Sales Training
Supervisor Training
Time Management Training
QuickBooks
QuickBooks Training
Excel for Mac Training | Chicago
Fast Facts
1 day
Max 12 students
9.00am to 4.30pm
One per student
Included
Excel 2008 for Mac - Level 3
Course Description
Excel 2008 Level 3 for Mac is our advanced Excel training class on teh Mac platform. This is a hands-on class where participants will learn to create macros, collaborate with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.
Target Audience
This class is aimed at students who need to learn Excel's advanced features such as Macros, Scenarios and What-If analysis. Attendees are recommended to have completed Excel 2008 for Mac - Level 2 or have the equivalent experience prior to completing this course.
Learning Objectives
Upon successful completion of this Advanced Excel training course students will be able to:
- Increase Productivity by Streamlining Workflow.
- Collaborate with Others.
- Audit Worksheets.
- Analyze Data using What If Scenarios.
- Work with Multiple Spreadsheets and Workbooks.
- Importing and Exporting Data.
- Use Excel with the Web.
- Structure Workbooks with XML.
This class is currently not offered as a public class. We can however provide a private class at our facilty or an on-site class for groups for 2 or more. Please call us for details.
Course Outline
Unit 1: Streamlining Workflow
- Creating Macros
- Editing Macros
- Applying Conditional Formatting
- Adding Data Validation Criteria
- Updating a Workbook's Properties
- Modifying Excel's Default Settings
Unit 2: Collaborating with Others
- Protecting Files
- Sharing an Excel Spreadsheet
- Set Revision Tracking
- Review Tracked Revisions
- Merging Workbooks
- Administer Digital Signatures
- Restricting Document Access
Unit 3: Auditing Worksheets
- Tracing Cells
- Troubleshoot Errors in Formulas
- Troubleshoot Invalid Data and Formulas
- Watching and Evaluating Formulas
- Creating a Data List Outline
Unit 4: Analyzing Data
- Creating a Trendline
- Creating Scenarios
- Performing What-If Analysis
- Performing Statistical Analysis with the Analysis ToolPak
Unit 5: Working with Multiple Workbooks
- Creating a Workspace
- Consolidating Data
- Linking Cells in Different Workbooks
- Editing Links
Unit 6: Importing and Exporting Data
- Exporting Excel Data
- Importing a Delimited Text File
Unit 7: Using Excel with the Web
- Publishing a Spreadsheet to the Web
- Importing Data from the Web
- Creating a Web Query
Unit 8: Structuring Workbooks with XML
- Developing XML Maps
- Importing and Exporting XML Data
