Home | Career Tracks | Boot Camps | Course Search | Student Log In | Request Info | 1-800-482-3172 | Contact Us

About Us
Corporate IT Training
Vocational IT Training
CareerSource Solutions
Government/VA Solutions
Financing Options
Other Training Information
Student Resources
Entrance Exam TEST
Career Services
Promotions
Press Releases
Course Catalog
Course Search
Forms
Real Estate Classes
Store
Connect With Us

MOS: Microsoft Office 2010 - Excel Boot Camp

 

 

Click Here to View Schedules & Pricing and to Enroll Online

 

 

Duration: 1 Day

 

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 course prepares you for Exam 77-882


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
 

 

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
  • Academy Code of Honor: Test Pass Guarantee
  • Optional: Package for Hotel Accommodations, Lunch and Transportation

 

Academy Code of Honor:  
The Academy guarantees that students shall pass all vendor examinations during the training program or may re-attend within one year of the program completion date. Students will only be responsible for accommodations and vendor exam fees.  

Student Login | Request Info | Course Search | Contact Us