Excel Training | Chicago & Los Angeles
Fast Facts
1 day
Max 8 students
9.00am to 4.30pm
One per student
Included
295.00
Excel 2003 - Level 3
Course Description
This Excel training course covers the more advanced aspects of Microsoft Excel including Macros, Pivot Tables and VLOOKUPS. View past student's video testimonials.
Target Audience
This Excel course is intended for current Microsoft Excel users who wish to learn advanced Excel skills. Students should have already completed Excel Level 2 or have equivalent knowledge prior to attending this course.
Excel Training Deals
Find out more about our Microsoft Excel training and our 100% Money Back Guarantee.
Learning Objectives
Upon successful completion of this Microosft Excel class students will be able to:
- Improving your Productivity using MACROS.
- Collaborate with others using Workbooks.
- Audit Worksheets.
- Perform VLOOKUPS.
- Analyze data using What IF Scenarios.
- Analyze data using PIVOT TABLES.
- Work with multiple Workbooks.
- Import and Export data.
- Structure Workbooks with XML.
Upcoming Classes
Chicago |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2003 - Level 3 | Apr 2 | May 7 ! | Jun 30 |
Los Angeles |
Mar, 2010 | Apr, 2010 | May, 2010 | Jun, 2010 |
| Excel 2003 - Level 3 | Mar 26 | May 5 | Jun 18 |
* Class almost full ! Class guaranteed to run † Class is full
Course Outline
Streamlining Workflow
- Create a Macro
- Edit a Macro
- Customize Access to Excel Commands
- 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
- Adjust Macro Settings
- Administer Digital Signatures
Auditing Worksheets
- Trace Cell Precedents
- Trace Cell Dependents
- Locate Errors in Formulas
- Locate Invalid Data and Formulas
- Watch and Evaluate Formulas
- Group and Outline Data
Using VLOOKUP Function
- How To Use VLOOKUP To Find Data
- How To Limit The Lookup Value For Exact Match
- How To Use The Closest Match For The Lookup Value
Analyzing Data
- Create a Trendline
- Create Scenarios
- Perform What-If Analysis
- Develop a PivotTable Report
- Develop a PivotChart Report
- 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 to Microsoft Word
- Import a Word Table
- Import Text Files
Structuring XML Workbooks
- Develop XML Maps
- Import, Add, and Export XML Data
- Manage XML Workbooks
- Apply XML View Options
Meet the Instructors
Rich
Rich has been creating custom software programs, and delivering tailored training classes for the past 13 years. His passion for instruction and his pursuit of all things technical, combine with his outgoing personality to provide an engaging and enthusiastic exchange of knowledge and ideas with his trainees. Software training for Rich is a labor of love. As he puts it, "When you love what you do, it's really not work after all!"
