Questions? Feedback? powered by Olark live chat software

Excel 2010 Combo Training Courses

About the Excel 2010 Combo

Duration: 3 days (24 hours)

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.

Next Class Dates

Sep 11, 2017 – Sep 13, 2017
 
9:00am – 5:00pm EST
 
 

Back to Top

This training consists of the following courses:

Excel 2010: Level 1   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Get started with Microsoft Office Excel 2010
  • » Perform calculations
  • » Modify a worksheet
  • » Format a worksheet
  • » Print workbooks
  • » Manage workbooks

Back to Top

arrow Course Outline

  • Getting Started with Microsoft Office Excel 2010
    1. Navigate the Excel User Interface
    2. Use Excel Commands
    3. Create and Save a Basic Workbook
    4. Enter Cell Data
    5. Use Excel Help
  • Performing Calculations
    1. Create Worksheet Formulas
    2. Insert Functions
    3. Reuse Formulas
  • Modifying a Worksheet
    1. Insert, Delete, and Adjust Cells, Columns, and Rows
    2. Search for and Replace Data
    3. Use Proofing and Research Tools
  • Formatting a Worksheet
    1. Modify Fonts
    2. Add Borders and Colors to Worksheets
    3. Apply Number Formats
    4. Align Cell Contents
    5. Apply Styles and Themes
    6. Apply Basic Conditional Formatting
    7. Create and Use Templates
  • Printing Workbooks
    1. Preview and Print a Workbook
    2. Define the Page Layout
  • Managing Workbooks
    1. Manage Worksheets
    2. Manage Workbook and Worksheet Views
    3. Manage Workbook Properties

Back to Top

Excel 2010: Level 2   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Customize the Excel environment
  • » Create advanced formulas
  • » Analyze data by using functions and conditional formatting
  • » Organize and analyze datasets and tables
  • » Visualize data by using basic charts
  • » Analyze data by using PivotTables, slicers, and PivotCharts

Back to Top

arrow Course Outline

  • Customizing the Excel Environment
    1. Configure Excel Options
    2. Customize the Ribbon and the Quick Access Toolbar
    3. Enable Excel Add-Ins
  • Creating Advanced Formulas
    1. Use Range Names in Formulas
    2. Use Specialized Functions
    3. Use Array Formulas
  • Analyzing Data with Functions and Conditional Formatting
    1. Analyze Data by Using Text and Logical Functions
    2. Apply Advanced Conditional Formatting
  • Organizing and Analyzing Datasets and Tables
    1. Create and Modify Tables
    2. Sort Data
    3. Filter Data
    4. Use SUBTOTAL and Database Functions
  • Visualizing Data with Basic Charts
    1. Create Charts
    2. Modify and Format Charts
  • Analyzing Data with PivotTables, Slicers, and PivotCharts
    1. Create a PivotTable
    2. Analyze PivotTable Data
    3. Present Data with PivotCharts
    4. Filter Data by Using Slicers

Back to Top

Excel 2010: Level 3   More on this course

1 day | 8 hours

arrow Course Objectives

  • » Work with multiple worksheets and workbooks simultaneously
  • » Share and protect workbooks
  • » Automate workbook functionality
  • » Apply conditional logic
  • » Audit worksheets
  • » Use automated analysis tools
  • » Present your data visually

Back to Top

arrow Course Outline

  • Working with Multiple Worksheets and Workbooks Simultaneously
    1. Use 3-D References
    2. Use Links and External References
    3. Consolidate Data
  • Sharing and Protecting Workbooks
    1. Collaborate on a Workbook
    2. Protect Worksheets and Workbooks
  • Automating Workbook Functionality
    1. Apply Data Validation
    2. Work with Forms and Controls
    3. Work with Macros
  • Applying Conditional Logic
    1. Use Lookup Functions
    2. Combine Functions
    3. Use Formulas and Functions to Apply Conditional Formatting
  • Auditing Worksheets
    1. Trace Cells
    2. Search for Invalid Data and Formulas with Errors
    3. Watch and Evaluate Formulas
  • Using Automated Analysis Tools
    1. Determine Potential Outcomes by Using Data Tables
    2. Determine Potential Outcomes by Using Scenarios
    3. Use the Goal Seek Feature
    4. Activate and Use the Solver Tool
    5. Analyze Data with Analysis ToolPak Tools
  • Presenting Your Data Visually
    1. Use Advanced Chart Features
    2. Create Sparklines

Back to Top

This training prepares students for the following exam(s):

  • » 77-882: MOS: Microsoft Office Excel 2010
  • » 77-882: MOS: Microsoft Office Excel 2010
  • » 77-882: MOS: Microsoft Office Excel 2010

Back to Top

Available Similar Training Offerings

» Microsoft Office 2010 Package Level 1

Back to Top

Recent Client Testimonials & Reviews

Instructor is great! She is concise and an excellent presenter. I learned so much. I love how the instructor broke every thing down and did not rush through any topic.

- Danielle C.

Course(s) Taken

» Excel 2016 Combo

The online classroom worked very well and thoroughly enjoyed what the instructor taught.

Laura C.

Course(s) Taken

» Excel 2013 Combo

The insructor is knowledgeable, helpful & patient.

- Yarelis Q.

Course(s) Taken

» Excel 2016 Combo

  More testimonials »  

Back to Top

Ways to contact us

Back to Top