Microsoft Excel Level 1

Course Length

1 Day

Course Objective

This course covers the features that people use day to day in Excel. You will learn to create and edit spreadsheets. This includes performing calculations (formulas and functions), copying and moving data, check spelling, and insert and delete rows and columns. You will also learn to make the spreadsheet look attractive with many different formatting options, and change print options. We also cover working with sheets, using Help and making commands easily accessible.

Target Student

This course is intended for those with little or no experience with Excel, who want to learn the features they will use every day. It is also intended for those who have never taken a formal training class (or took one a long time ago) to learn new features and the most efficient way to perform commands.

Prerequisites

Students should be comfortable using the mouse and keyboard.

Delivery Model

Hands-on, instructor led, group-paced, classroom learning. The pace of class is based on the participants' previous computer experience and class expectations. Questions are welcome and encouraged!

Course Outline

Program Fundamentals
How Can I Use Excel?
Understand the Excel Program Screen
Giving Commands
Using Command Shortcuts
Create a New Workbook
Save a Workbook
Close a Workbook
Open a Workbook
Use Workbook Views
Getting Started with Worksheets
Navigate a Worksheet
Enter Labels & Values
Select a Cell Range & Enter Data in a Cell Range
Enter Formulas
Enter Basic Functions
Copy Formulas & Functions
Absolute Cell References
Reference External Data
Editing a Worksheet
Using Undo & Redo
Edit Cell Contents
Copy & Move Cells
Control How Cells Are Moved or Copied
Collect Items to Move or Copy
Check Spelling
Insert Cells, Rows, & Columns
Delete Cells, Rows, & Columns
Hide Rows & Columns
Formatting a Worksheet
Format Text & Dates
Format Values
Adjust Row Height & Column Width
Cell Alignment
Cell Borders & Background Colors
Copy & Clear Formatting
Print Options
Preview & Print a Worksheet
Adjust Margins & Orientation
Headers & Footers
Set the Print Area & use Page Breaks
Add Print Titles, Gridlines, & Row and Column Headings
Adjust Paper Size & Print Scale
Print a Selection, Multiple Worksheets, & Workbooks
Managing Workbooks
Select & Switch Between Worksheets
Insert & Delete Worksheets
Rename, Move & Copy Worksheets
Hide & Change Worksheet Tab Color
Split & Freeze a Workbook
Work with Multiple Workbook Windows
Use Help & Customize Excel
Customize the Quick Access Toolbar
Use Help

Also Includes

  • Detailed class/reference book
  • Certificate of completion.