Microsoft Excel Introduction


Hands-On Course 522 – 1 Day

Course Requirements

Learners must be confident using a mouse and keyboard.

What You Will Learn

In particular you will be able to:

  • Get working with Microsoft Excel efficiently and effectively
  • Optimize your worksheets by creating and using formulas
  • Modify worksheets to manipulate and edit data
  • Format and style worksheets to get more impact from data
  • Produce printed workbooks

About This Course: This course will provide you with the foundational Excel knowledge and skills necessary for business today. As you apply the robust functionality that’s part of Excel to your organization’s raw data, you will be able to gain a level of insight into that data that would have been almost impossible years ago. Excel helps you organize, calculate, analyze, revise, amend, and present your data in ways that will help you and the decision makers in your organization steer forward in the right direction.

Course Outline
Getting Started with Microsoft® Excel®

  • Identify the Elements of the Excel Interface
  • Create a Basic Worksheet
  • Use the Help System

Performing Calculations

  • Create Formulas in a Worksheet
  • Insert Functions in a Worksheet
  • Reuse Formulas

Modifying a Worksheet

  • Manipulate Data
  • Insert, Manipulate, and Delete Cells, Columns, and Rows
  • Search for and Replace Data
  • Spell Check a Worksheet

Formatting a Worksheet

  • Modify Fonts
  • Add Borders and Color to Cells
  • Apply Number Formats
  • Align Cell Contents
  • Apply Cell Styles

Printing Workbook Contents

  • Define the Basic Page Layout for a Workbook
  • Refine the Page Layout and Apply Print Options

Managing Large Workbooks

  • Format Worksheet Tabs
  • Manage Worksheets
  • Manage the View of Worksheets and Workbooks

Customizing the Excel Environment

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

Long Course Description

Getting Started with Microsoft Excel (2007, 2010, 2013 2016)
Performing Calculations
Modifying a Worksheets
Formatting a Worksheet
Printing Workbook Contents
Managing Large Workbooks
Customizing the Excel Environment