Microsoft Excel 2007/2010 Level 3
Class timetable | Course outline
Course DescriptionExcel Level 3 is the third of 3 levels of Excel training we offer. 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. View past student's video testimonials.
Target Audience
This course is aimed at intermediate users who need to learn advanced Excel features such as Macros, Scenarios and What-If analysis. Participants are recommended to have completed Excel Level 2 or have the equivalent experience prior to this course.
For added peace of mind, Training Connection’s Microsoft Excel training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.
Excel Level 3 Class Timetable
| Los Angeles | May 11 ! | Register |
| Chicago | May 23 † | Register |
| Los Angeles | Jun 13 ! | Register |
| Chicago | Jun 20 ! | Register |
| Los Angeles | Jul 13 ! | Register |
| Chicago | Jul 18 ! | Register |
| Los Angeles | Aug 15 | Register |
| Chicago | Aug 17 | Register |
| Los Angeles | Sep 12 | Register |
| Chicago | Sep 13 | Register |
| Los Angeles | Oct 10 | Register |
| Chicago | Oct 12 | Register |
| Los Angeles | Nov 9 | Register |
| Chicago | Nov 14 | Register |
* Class almost full ! Class guaranteed to run † Class is full
Streamlining Workflow
- Create a Macro
- Edit a Macro
- Apply Conditional Formatting
- Add Data Validation Criteria
- Update a Workbook's Properties
- Modify Excel's Default Settings
Collaborating with Others
- Protect Files
- Share a Workbook
- Set Revision Tracking
- Review Tracked Revisions
- Merge Workbooks
- Administer Digital Signatures
- Restrict Document Access
Auditing Worksheets
- Trace Cells
- Tracer Arrows
- Cell Precedents
- Cell Dependents
- Troubleshoot Invalid Data and Formulas Errors
- Watch and Evaluate Formulas
- Create a Data List Outline
Analyzing Data
- Create a Trendline
- Create Sparklines for Data.
- Create Scenarios
- Perform What-If Analysis
- Perform Statistical Analysis with the Analysis ToolPak
Working with Multiple Workbooks
- Create a Workspace
- Consolidate Data
- Link Cells in Different Workbooks
- Edit Links
Importing and Exporting Data
- Export Excel Data
- Import a Delimited Text File
Using Excel with the Web
- Publish a Worksheet to the Web
- Import Data from the Web
- Create a Web Query
Structuring Workbooks with XML
- Develop XML Maps
- Import and Export XML Data
What's included
Microsoft Excel Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
