Essentials of Microsoft Excel

3 Hours

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the most essential skills needed to enter and edit information, write formulas, format cells, and print spreadsheets in Microsoft Excel.

Course Objectives

• Understand how to enter text, numbers, and dates
• Write basic formulas that add, subtract, multiply, and divide cells
• Format columns/rows and format cells with borders, shading, fonts, etc.
• Insert and delete columns or rows
• Preview and print workbooks

Building Simple Workbooks

• Understanding Excel Terminology
• Examining Important Screen Elements
• Opening Workbooks
• Reviewing Workbook Data
• Entering General Text
• Entering Numbers
• Entering Dates
• Editing Cells
• 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
• Saving Workbooks
• Closing Workbooks

Writing and Copying Basic Formulas

• Understanding Formula Syntax
• Creating Basic Formulas
• Using Functions in Formulas
• Using the Sum Button
• Copying Formulas

Formatting and Printing Worksheets

• Changing Column Widths
• Applying Fonts, Bold, Underline, and Italics
• Aligning Data in Cells
• Formatting Numbers and Formulas
• Formatting Dates
• Applying Borders
• Applying Fill Color
• Inserting and Deleting Columns or Rows
• Previewing Before Printing
• Printing Worksheets