Excel 2010 - Part 1

$275.00


  • Virtual Classroom

  • Onsite

← Continue Searching

Duration: 1 Day

In this course, you will create and edit basic Microsoft Office Excel 2010 worksheets and workbooks. You will learn how to format and print worksheets, manage workbooks, and customize your Excel environment for maximum efficiency.

This course includes access to our exclusive Microsoft Office Online Support Program, enabling you to build your skills and expertise after class. The program provides 24x7 access for 60 Days to:

  • Online labs for continued practice and skills-building
  • Online mentoring via chat from Microsoft Office experts
  • Access to your recorded class, indexed and searchable for your review and reference

Certification:

This course is one of three recommended to help you prepare for Microsoft Exam 77-882: Excel 2010, which is required for the Microsoft Office Specialist (MOS): Microsoft Office Excel 2010 certification.

What You Will Learn

  • Create a basic worksheet by using Microsoft Office Excel 2010
  • Perform calculations in an Excel worksheet
  • Modify an Excel worksheet
  • Modify the appearance of data within a worksheet
  • Manage Excel workbooks
  • Customize the Excel environment
  • Print the content of an Excel worksheet

Audience

Anyone who needs to gain the necessary skills to create, edit, format, and print basic Microsoft Office Excel 2010 worksheets

Prerequistes

  • Familiarity with personal computers and using the mouse and keyboard
  • Comfort using the Windows environment and using Windows to manage information on the computer
  • Ability to launch and close programs, navigate to information stored on the computer, and manage files and folders

Course Outline

1. Getting Started with Microsoft Excel 2010

  • Identifying the Elements of the Excel Interface
  • Creating a Basic Worksheet
  • Using the Help System

2. Performing Calculations

  • Creating Formulas in a Worksheet
  • Inserting Functions in a Worksheet
  • Reusing Formulas

3. Modifying an Excel Worksheet

  • Manipulating Data
  • Inserting, Manipulating, and Deleting Cells, Columns, and Rows
  • Searching for and Replacing Data
  • Spell Checking a Worksheet

4. Formatting a Worksheet

  • Modifying Fonts
  • Adding Borders and Colors to Cells
  • Applying Number Formats
  • Aligning Cell Contents
  • Applying Cell Styles

5. Printing Workbook Contents

  • Defining the Basic Page Layout for a Workbook
  • Refining the Page Layout and Applying Print Options

6. Managing Large Workbooks

  • Formatting Worksheet Tabs
  • Managing Worksheets
  • Managing View of Worksheets and Workbooks

7. Customizing the Excel Environment

  • Customizing General and Language Options
  • Customizing Formula Options
  • Customizing Proofing and Save Options
  • Customizing the Ribbon and Quick Access Toolbar
  • Customizing the Functionality of Excel by Enabling Add-Ins
  • Customizing Advanced and Trust Center Options

Course Labs