Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Microsoft Excel 2010 Level 2

GK# 8237

Course Overview

TOP

In this clinic with hands-on labs, you will become familiar with the intermediate features and functionality of Microsoft Excel 2010.

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Organize, protect, and display data, using various tools
  • Create linking formulas and use the IF function
  • Set up multiple worksheets using information from other sources through consolidation
  • Copy and paste links to combine information into one worksheet
  • Create and modify charts to present data effectively
  • Customize charts to enhance their appearance
  • Create and apply styles to format worksheets consistently and quickly
  • Use conditional formatting, comments, text boxes, and sparklines to highlight and explain data

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Worksheet Organization

  • Range Names
  • Workbook Templates
  • Worksheet Security
  • Outlining
  • Review Exercise

2. Advanced Formulas

  • Using the IF Function
  • Linking Formulas
  • Review Exercise

3. Using Multiple Workbooks and Worksheets

  • Working with Multiple Workbooks
  • Setting Up Multiple Worksheets
  • Using Multiple Worksheets
  • Creating Links with Formulas
  • Modifying and Restoring Links
  • Consolidating Data
  • Review Exercise

4. Working with Charts

  • Creating Charts
  • Changing Chart Data
  • Modifying Chart Elements
  • Creating Custom Charts
  • Review Exercise

5. Applying Formatting

  • Creating Styles
  • Working with Styles
  • Using Conditional Formatting
  • Annotating Worksheets
  • Using Sparklines
  • Review Exercise

Prerequisites

TOP

Who Should Attend

TOP

Those who are familiar with Microsoft Office Excel 2010

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 1 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 1 day

Request this course in a different delivery format.
Enroll