Microsoft Excel 2010 Training for Intermediate I and or II or Expert - Instructor Led Blended Learning

Training For Microsoft Excel Days I and or & II - Each class is $299. Select I & II if you are doing both classes.

Where: SmartPath LLC, 2018 156th Ave, NE, Bellevue, WA

Date and Time: See the above menu for details. If you are a group of three the class is automatically GTR. Please sign up 7 days before the class begins.

Instructions Once This is a GTR Class (Guaranteed To Run): The latest pre-registration is required by 5:00 PM the day before the first day of class begins. Register by clicking the "add to cart" button above. Payment will be required at the same time. You may use either a credit card or debit card. Other ways to register and Pay by Cash, Cashier's Check, Employer Check, or Voucher.

MS Excel I - Beginning Excel to Intermediate Class Content - Day One

Excel II - Intermediate Excel to Advanced Training for Intermediate - Class Content - Day Two:

Working with Advanced Features of Excel 2010
Introduction
Setting Excel Options
Setting Workbook Properties
Customizing the Ribbon
Customizing the Quick Access Toolbar
The Track Changes Feature
Linking and Embedding Objects
Sharing a Workbook
Working with the Advanced Features
Self Test

Module Summary


Glossary


Course 10394: Advanced Skills in Microsoft Excel 2010

Working with Advanced Features of Excel 2010
Module Overview

Customizing Excel 2010
Introduction
Setting Excel 2010 Options
Defining Workbook Protection Levels
Customizing Worksheet Views
Self Test

Working with Worksheet Data
Introduction
Manipulating Worksheet Data
Creating Named Ranges
Managing Named Ranges
Inserting Equations
Analyzing Data
Working with a PowerPivot Workbook
Lab: Working with Worksheet Data
Self Test

Working with External Data
Introduction
Defining and Editing External Data Connections
Working with XML Data
Creating and Editing Web Queries
Lab: Working with External Data
Self Test

Working with Tables and Charts
Introduction
Working with Charts
Creating a Sparkline Chart
Creating Different Types of Charts
Adding Trendline to a Chart
Analyzing Pivot Table Data
Lab: Working with Tables and Charts
Self Test

Automating Workbooks
Introduction
Introduction to Macros
Creating a Macro
Editing a Macro
Running and Deleting a Macro
Lab: Working with Macros
Self Test

Module Summary


Glossary


You will follow the training as the Instructor Leds you through all of the class content of these official Microsoft Courses. You will also have a subscription to these courses so you can practice them at any time.

Expert Training - Exam Certification #: MOS 77-888

The Information will appear here shortly or you can check under Office Subscriptions and you will see the content.

You Will Receive

Instructor Led training using official Microsoft Online Training.

One or two days of training

A Certificate of completion for 7 or 14 hours of training for Word I and or Word II or 7 hours of Expert Training

One year subscription the Microsoft Online learning for all of this class content

Free Coffee, Tea, Hot Chocolate, Free Snacks

Free Parking & the bus can drop you off close to our driveway on 156th Ave if you prefer public transportation

Directions to SmartPath LLC