MOS: Excel 2010 Boot Camp

Description

Microsoft Office Excel 2010 contains powerful tools to help you analyze, manage, and share critical business data. You can also work with industry-standard Extensible Markup Language (XML) data to make it easier to connect to business processes. This course was designed for students desiring to gain the skills necessary to create macros, collaborate with others, audit and analyze worksheet data, create Pivot Tables and Pivot Charts, incorporate multiple data sources, and import/export data.

This one-day course prepares you for Exam 77-882

What’s included?

  • Authorized Courseware
  • Intensive Hands on Skills Development with an Experienced Subject Matter Expert
  • Hands on practice on real Servers and extended lab support 1.800.482.3172
  • Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.

Methods

  • Instructor Led (the best training format we offer)
  • Live Online Classroom – Online Instructor Led
  • Self-Paced Video

Speak to an Admissions Representative for complete details

Curriculum

Lesson 1: Getting Started with Excel

Identify the Elements of the Excel Interface
Navigate and Select Cells in Worksheets
Customize the Excel Interface
Create a Basic Worksheet

Lesson 2: Performing Calculations in an Excel Worksheet

Create Formulas in a Worksheet
Insert Functions in a Worksheet
Reuse Formulas

Lesson 3: Modifying an Excel Worksheet

Edit Worksheet Data
Find and Replace Data
Manipulate Worksheet Elements

Lesson 4: Modifying the Appearance of a Worksheet

Apply Font Properties
Add Borders and Colors to Cells
Align Content in a Cell
Apply Number Formatting
Apply Cell Styles

Lesson 5: Managing an Excel Workbook

Manage Worksheets
View Worksheets and Workbooks

Lesson 6: Printing Excel Workbooks

Define the Page Layout
Print a Workbook

Lesson 7: Calculating Data with Advanced Formulas

Apply Cell and Range Names
Calculate Data Across Worksheets
Use Specialized Functions
Analyze Data with Logical and Lookup Functions

Lesson 8: Organizing Worksheet and Table Data

Create and Modify Tables
Format Tables
Sort or Filter Data
Use Functions to Calculate Data

Lesson 9: Presenting Data Using Charts

Create a Chart
Modify Charts
Format Charts

Lesson 10: Analyzing Data Using PivotTables, Slicers, and PivotCharts

Create a PivotTable Report
Filter Data Using Slicers
Analyze Data Using PivotCharts

Lesson 11: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt
Draw and Modify Shapes
Illustrate Workflow Using SmartArt Graphics
Layer and Group Graphic Objects

Lesson 12: Customizing and Enhancing the Excel Environment

Customize the Excel Environment
Customize Workbooks
Manage Themes
Create and Use Templates

Lesson 13: Streamlining Workflow

Update Workbook Properties
Create a Macro
Edit a Macro
Apply Conditional Formatting
Add Data Validation Criteria

Lesson 14: Collaborating with Other Users

Protect Files
Share a Workbook
Set Revision Tracking
Review Tracked Revisions
Merge Workbooks
Administer Digital Signatures
Restrict Document Access

Lesson 15: Auditing Worksheets

Trace Cells
Troubleshoot Invalid Data and Formula Errors
Watch and Evaluate Formulas
Create a Data List Outline

Lesson 16: Analyzing Data

Create a Trendline
Create Sparklines
Create Scenarios
Perform a What-If Analysis
Perform a Statistical Analysis with the Analysis ToolPack

Lesson 17: Working with Multiple Workbooks

Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links

Lesson 18: Importing and Exporting Data

Export Excel Data
Import a Delimited Text File

Lesson 19: Integrating Excel Data with the Web

Publish a Worksheet to the Web
Import Data from the Web
Create a Web Query

Lesson 20: Structuring Workbooks with XML

Develop XML Maps
Import and Export XML Data

Enrolled