Excel 2010 Combo Training Courses

About the Excel 2010 Combo

Duration: 4 days (32 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

Jun 19, 2017 – Jun 22, 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

  • » create a basic worksheet by using Microsoft Excel 2010.
  • » perform calculations in an Excel worksheet.
  • » modify an Excel worksheet.
  • » modify the appearance of data within a worksheet.
  • » manage Excel workbooks.
  • » print the content of an Excel worksheet.

Back to Top

arrow Course Outline

  • Lesson 1: Getting Started with Excel
    1. Identify the Elements of the Excel Interface
    2. Navigate and Select Cells in Worksheets
    3. Customize the Excel Interface
    4. Create a Basic Worksheet
  • Lesson 2: Performing Calculations in an Excel Worksheet
    1. Create Formulas in a Worksheet
    2. Insert Functions in a Worksheet
    3. Reuse Formulas
  • Lesson 3: Modifying an Excel Worksheet
    1. Edit Worksheet Data
    2. Find and Replace Data
    3. Manipulate Worksheet Elements
  • Lesson 4: Modifying the Appearance of a Worksheet
    1. Apply Font Properties
    2. Add Borders and Colors to Cells
    3. Align Content in a Cell
    4. Apply Number Formatting
    5. Apply Cell Styles
  • Lesson 5: Managing an Excel Workbook
    1. Manage Worksheets
    2. View Worksheets and Workbooks
  • Lesson 6: Printing Excel Workbooks
    1. Define the Page Layout
    2. Print a Workbook

Back to Top

Excel 2010: Level 2   More on this course

1 day | 8 hours

arrow Course Objectives

  • » use advanced formulas.
  • » organize worksheet and table data using various techniques.
  • » create and modify charts.
  • » analyze data using PivotTables, Slicers, and PivotCharts.
  • » insert and modify graphic objects in a worksheet.
  • » customize and enhance workbooks and the Microsoft Office Excel environment.

Back to Top

arrow Course Outline

  • Lesson 1: Calculating Data with Advanced Formulas
    1. Apply Cell and Range Names
    2. Calculate Data Across Worksheets
    3. Use Specialized Functions
    4. Analyze Data with Logical and Lookup Functions
  • Lesson 2: Organizing Worksheet and Table Data
    1. Create and Modify Tables
    2. Format Tables
    3. Sort or Filter Data
    4. Use Functions to Calculate Data
  • Lesson 3: Presenting Data Using Charts
    1. Create a Chart
    2. Modify Charts
    3. Format Charts
  • Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts
    1. Create a PivotTable Report
    2. Filter Data Using Slicers
    3. Analyze Data Using PivotCharts
  • Lesson 5: Inserting Graphic Objects
    1. Insert and Modify Pictures and ClipArt
    2. Draw and Modify Shapes
    3. Illustrate Workflow Using SmartArt Graphics
    4. Layer and Group Graphic Objects
  • Lesson 6: Customizing and Enhancing the Excel Environment
    1. Customize the Excel Environment
    2. Customize Workbooks
    3. Manage Themes
    4. Create and Use Templates

Back to Top

Excel 2010: Level 3   More on this course

1 day | 8 hours

arrow Course Objectives

  • » enhance productivity and efficiency by streamlining the workflow.
  • » collaborate with other workbook users.
  • » audit worksheets.
  • » analyze data.
  • » work with multiple workbooks.
  • » import and export data.
  • » integrate Excel data with the web.
  • » structure workbooks with XML.

Back to Top

arrow Course Outline

  • Lesson 1: Streamlining Workflow
    1. Topic 1A: Update Workbook Properties
    2. Topic 1B: Create a Macro
    3. Topic 1C: Edit a Macro
    4. Topic 1D: Apply Conditional Formatting
    5. Topic 1E: Add Data Validation Criteria
  • Lesson 2: Collaborating with Other Users
    1. Topic 2A: Protect Files
    2. Topic 2B: Share a Workbook
    3. Topic 2C: Set Revision Tracking
    4. Topic 2D: Review Tracked Revisions
    5. Topic 2E: Merge Workbooks
    6. Topic 2F: Administer Digital Signatures
    7. Topic 2G: Restrict Document Access
  • Lesson 3: Auditing Worksheets
    1. Topic 3A: Trace Cells
    2. Topic 3B: Troubleshoot Invalid Data and Formula Errors
    3. Topic 3C: Watch and Evaluate Formulas
    4. Topic 3D: Create a Data List Outline
  • Lesson 4: Analyzing Data
    1. Topic 4A: Create a Trendline
    2. Topic 4B: Create Sparklines
    3. Topic 4C: Create Scenarios
    4. Topic 4D: Perform a What-If Analysis
    5. Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak
  • Lesson 5: Working with Multiple Workbooks
    1. Topic 5A: Create a Workspace
    2. Topic 5B: Consolidate Data
    3. Topic 5C: Link Cells in Different Workbooks
    4. Topic 5D: Edit Links
  • Lesson 6: Importing and Exporting Data
    1. Topic 6A: Export Excel Data
    2. Topic 6B: Import a Delimited Text File
  • Lesson 7: Integrating Excel Data with the Web
    1. Topic 7A: Publish a Worksheet to the Web
    2. Topic 7B: Import Data from the Web
    3. Topic 7C: Create a Web Query
  • Lesson 8: Structuring Workbooks with XML
    1. Topic 8A: Develop XML Maps
    2. Topic 8B: Import and Export XML Data

Back to Top

Excel 2010: Level 4   More on this course

1 day | 8 hours

arrow Course Objectives

  • » manipulate data using statistical and lookup functions.
  • » analyze data using the data analysis tools in Microsoft Excel 2010.
  • » make investment decisions using the financial functions in Excel 2010.
  • » examine data using math functions in Excel 2010.
  • » manipulate data using text and information functions in Excel.
  • » create templates and work with Excel's advanced chart options.
  • » manage data in Excel workbooks.

Back to Top

arrow Course Outline

  • Lesson 1: Manipulating Data Using Statistical and Lookup Functions
    1. Forecast GDP Using Statistical Functions
    2. Evaluate Sales Data Using Statistical Functions
    3. Analyze Stock Data Using Statistical Functions
    4. Mine Data Using the Lookup and Reference Functions
  • Lesson 2: Analyzing Data Using Data Analysis Tools
    1. Analyze Sales Data Using Descriptive Statistics
    2. Analyze Time Series Data Using Exponential Smoothing
    3. Analyze Data Using Regression
    4. Identify the Beta Value of a Security
    5. Analyze Sector Data Using Correlation and Covariance Matrices
    6. Optimize a Stock Portfolio Using Solver
  • Lesson 3: Working with Data Using Financial Functions
    1. Develop an Investment Schedule Using Financial Functions
    2. Make Investment Decisions Using Financial Functions
  • Lesson 4: Examining Data Using Math Functions
    1. Analyze Sales Data Using Math Functions
    2. Calculate Stock Returns Using Math Functions
    3. Aggregate GDP Data Using Math Functions
  • Lesson 5: Manipulating Data Using Text and Information Functions
    1. Manipulate Data Using Text Functions
    2. Validate Data Using Information Functions
  • Lesson 6: Working with Templates and Charts
    1. Create Advanced Templates
    2. Create Advanced Charts
  • Lesson 7: Managing Data in Workbooks
    1. Retrieve and Paste Data
    2. Clean Data in Workbooks

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
  • » 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

Excellent instructor!

- Mano M.

Course(s) Taken

» Excel 2016 Combo

Excellent instructor. She was very organized, personable and answered all questions that were asked.

- Siobhan M.

Course(s) Taken

» Excel 2010 Combo

The instructor was awesome.

- Stephanie M.

Course(s) Taken

» Excel 2010 Combo

  More testimonials »  

Back to Top

Ways to contact us

Back to Top