1he1

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
Excel Level I
Tagged on:
WordPress management provided by OptSus.com