Introduction to Microsoft Excel

1 Day, 9:00-4:00

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the skills needed to enter and edit information, write formulas, format cells, and print in Microsoft Excel. This course is geared to new users who have little or no experience using Microsoft Excel or another spreadsheet application.

Course Objectives

• Understand how to enter text, numbers, and dates properly
• Write basic formulas that add, subtract, multiply, and divide cells
• Format workbooks by setting columns widths, aligning data, formatting numbers, and applying borders/shading
• Manage worksheets, keep headings on the screen, and sort data
• Set print options and print workbooks

Building Simple Workbooks

• Understanding Excel Terminology
• Reviewing Workbook Data
• Entering General Text, Numbers, and Dates
• Editing and Deleting Cell Contents
• Understanding Mouse Pointer Shapes
• Selecting Cells, Rows, and Columns
• Moving Data by Drag-and-Drop
• Copying Data with the Fill Handle
• Reversing Mistakes with Undo and Redo
• Checking for Spelling Errors
• Saving and Closing Workbooks
• Using Microsoft Office Help

Managing Worksheets

• Renaming Worksheets
• Adding Color to Worksheet Tabs
• Moving Worksheets
• Inserting and Deleting Worksheets

Writing and Copying Basic Formulas

• Understanding Formulas Elements and Syntax
• Understanding Excel’s Order of Precedence
• Creating Basic Formulas
• Using Functions
• Using the Sum Button
• Copying Formulas
• Using the Insert Function Tool
• Creating Named Ranges
• Using the TODAY Function to Insert the Current Date
• Using Dates in Formulas
• Using AutoCalculate

Formatting Worksheets

• Changing Column Widths
• Applying Fonts, Bold, Underline, and Italics
• Copying Formatting from One Cell to Another
• Aligning Data in Cells
• Centering Data Across Columns
• Wrapping Text within Cells
• Formatting Numbers and Formulas
• Formatting Dates
• Applying Borders
• Applying Fill Color
• Inserting and Deleting Columns or Rows
• Inserting Columns and Rows
• Deleting Columns and Rows
• Inserting Pictures
• Moving and Resizing Pictures
• Deleting Pictures

Working with Larger Workbooks

• Keeping Headings on the Screen as You Work
• Previewing Before Printing
• Printing Row and Column Headings
• Hiding and Unhiding Columns
• Sorting Lists of Information
• Creating Custom Sorts
• Printing Worksheets