Microsoft Excel 2010 Advanced Training Course
Details
The MS Excel 2010 Advanced Training Course is the final course in the Excel 2010 training series and is designed to bring your Excel 2010 skills up to the expert level.
Pdtraining’s Excel 2010 Advanced course covers the following topics: importing and exporting text files and XML data, the use of logical (IF, OR, AND, NOT), PMT, math & statistical functions, VLOOKUP, MATCH, INDEX and PMT functions as well as editing VBA functions, calculating time and other advanced features.
This comprehensive training course is now available in Atlanta, Austin, Baltimore, Birmingham, Boston, Charlotte, Chicago, Dallas, Houston, Jackson, Los Angeles, Manhattan, Miami, New York, Orlando, Philadelphia, San Antonio and Seattle.
You may attend the scheduled public classes or choose the Client Site Training course which could be tailored to your particular needs and schedule.
http://professionaldevelopmenttraining.com/courses/excel-2010-advanced-training-in-atlanta-baltimore-boston-charlotte-chicago-los-angeles-new-york-miami-orlando-philadelphia-seattle-and-us-wide
Outline
This Excel 2010 Advanced training course running in Atlanta, Austin, Baltimore, Birmingham, Boston, Charlotte, Chicago, Dallas, Houston, Jackson, Los Angeles, Manhattan, Miami, Orlando, New York, Philadelphia, San Antonio and Seattle, is rated 5.0/5.0 in overall quality by ProCert Labs, builds on the skills and concepts taught in Excel 2010: Intermediate. Participants will work with advanced formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, participants will learn about data validation and database functions such as DSUM. They will learn how to import and export data, and how to query external databases.
Finally, participants will learn about the analytical features of Excel (such as Goal Seek and Solver), running and recording macros, SmartArt graphics, and conditional formatting with graphics.
This course will help participants prepare for the Microsoft Office Specialist core-level exam for Excel 2010 (exam 77-882) and the Microsoft Office Specialist Expert exam for Excel 2010 (exam 77-888). For comprehensive certification training, participants should complete the Introduction, Intermediate, and Advanced courses for Excel 2010.
Prerequisites:
Excel 2010: Intermediate or equivalent experience.
Excel 2010 Advanced Training Course - Lesson 1Getting Started
- Housekeeping Items
- Workshop Objectives
- The Parking Lot
- Action Plan
SmartArt and Objects
- Inserting SmartArt
- Adding Text to the Diagram
- Resizing and Moving the Diagram
- Resetting the Diagram
- Adding Pictures from Your Computer
- Adding Clip Art
- Adding Text Boxes
- Drawing Shapes
- About the Contextual Tabs
- Lesson Two: Review Questions
Auditing
- Tracing Precedent Cells
- Tracing the Dependents of a Cell
- Displaying Formulas Within the Sheet
- Adding, Displaying, Editing ,and Removing Comments
- Lesson Three: Review Questions
Creating Charts
- Inserting a Chart
- Overview of the Chart Tools Tabs
- Understanding the Parts of a Chart
- Resizing and Moving the Chart
- Changing the Chart Style
- Lesson Four: Review Questions
Creating Pivot Tables
- Inserting a PivotTable
- Choosing Fields and Grouping Data
- Overview of the Pivot Table Tools Tabs
- Lesson Five: Review Questions
Working with PivotTables and PivotCharts
- Changing the Data Displayed and Refreshing the PivotTable
- Applying a Style to Your Pivot Table
- Creating a Pivot Chart from a Pivot Table
- Creating a Pivot Chart from Data
- Some Real-life Examples
- Lesson Six: Review Questions
Macros
- Displaying the Developer Tab
- Recording and Running Macros
- Changing the Security Level
- Customizing and Changing the Quick Access Toolbar
- Lesson Seven: Review Questions
Solving Formula Errors
- Using Named Ranges
- Understanding Formula Errors
- Using the Trace Errors Commands
- Using Error Checking
- Evaluating Formulas
- Lesson Eight: Review Questions
Using What If Analysis
- Using Goal Seek
- Using the Scenario manager
- Using a One Input Data Table
- Using a Two Input Data Table
- Lesson Nine: Review Questions
Managing Your Data
- Transposing Data from Rows to Columns
- Using the Text to Columns Feature
- Checking for Duplicates
- Creating Data Validation Rules
- Consolidating Data
- Lesson Ten: Review Questions
Grouping and Outlining Data
- Grouping Data
- Adding Subtotals
- Outlining Data
- Viewing Grouped and Outlined Data
- Lesson Eleven: Review Questions
Wrapping Up
- Words from the Wise
- Review of Parking Lot
- Lessons Learned
- Completion of Action Plans and Evaluations
Schedules
| No. of Days: | 1 |
| Total Hours: | 7 |
Welcome to pd training, we are an Australian-owned international training and professional services organisation. We have around 400 specialist trainers across Australia delivering thousands of courses each year in our 16 areas of specialty.
We provide industry-leading post course reinforcement, a training management system, world-class Personality Profiling, and support custom training roll outs across Australia and the world.
Professional Development Training provides Australia's leading and most comprehensive training solution. Learners receive our exclusive industry-leading post course reinforcement framework to help them beat the forgetting curve, and make the most of the training.
Management receive a range of benefits including a training management system that makes quoting, booking and reporting on training easier and faster than ever before.
Related Courses
