Excel Level I

 

Putting Together a Basic Workbook

 

Suggested Prerequisites: Keyboard mastery a must.

Description: Welcome to Microsoft Excel Level I. This course is the first in a series of five courses designed for individuals who will use Microsoft Excel as a tool to assist them in storing and analyzing numeric data. The topics in this course cover the critical skills necessary to create and modify a basic workbook.

Topics

 

Getting Started with Excel

• An Overview of Excel
• Navigate in Excel
• Enter/Modify/Delete Data
• Save a Workbook

Modifying a Worksheet

• Select Cells and Ranges
• Move and Copy Data
• Fill Cells with Series of Data
• Insert and Delete Cells, Columns, and Rows
• Find, Replace, and Go To Cell Data
• Spell Check a Worksheet

Performing Calculations

• Create Basic Formulas
• Calculate with Functions
• Copy Formulas and Functions
• Create an Absolute Reference

Formatting a Worksheet

• Change Font Size and Type
• Add Borders and Color to Cells
• Merge Cells
• Change Column Width and Row Height
• Apply Number Formats
• Align Cell Content

Printing Workbook Contents

• Set a Print Title
• Create a Header and a Footer
• Set Page Margins
• Change Page Orientation
• Insert and Remove Page Breaks
• Print a Range

Customizing Layout

• Freeze a Worksheet
• Split a Worksheet
• Arrange Worksheets
• Hide and Unhide Columns and/or Rows