Course Overview
This class teaches the basic functions and features of Excel 2007. After an introduction to spreadsheet terminology and Excel's window components, you will learn how to use the Help system and navigate worksheets and workbooks. Next, you will enter and edit text, values, formulas, and pictures, and you will save workbooks in various formats. Additionally, you will move and copy data, learn about absolute and relative references, and work with ranges, rows, and columns. This course also covers simple functions, basic formatting techniques, managing large worksheets, and printing.
Course Objectives
Getting Started, Basic Worksheet Skills, Creating Formulas, Formatting the Worksheet, Working with Large Worksheets, Using Protection and Comment Boxes, Using Page Setup and Printing Options
Agenda
1 - Introduction
2 - Getting Started
- Understanding the Three Primary Functions of Excel
- Understanding Spreadsheet Terminology
- Launching Excel
- Exploring the Excel Interface
- Opening a Workbook
- Examining Formulas
- Understanding Worksheets
- Using Zoom
- Changing Views
- Navigating Spreadsheets
3 - Basic Worksheet Skills
- Creating a New Workbook
- Entering Data
- Selecting Parts of a Workbook
- Using Multiple Worksheets
- Using AutoFill
- Deleting Ranges
- Using Undo and Redo
- Deleting a Worksheet
- Saving a Workbook
4 - Creating Formulas
- Understanding the Order of Operations
- Entering Simple Formulas
- Using SUM, MAX, and MIN
- Using AutoSum
- Using AVERAGE
- Creating a Formula
- Working with Date Arithmetic
- Using AutoCalculate
- Relative vs. Absolute Cell Addressing
5 - Formatting the Worksheet
- Adjusting Column Width and Row Height
- Inserting and Deleting Rows and Columns
- Hiding Rows and Columns
- Changing Number Formatting
- Changing Character Formatting
- Aligning Data
- Adding Borders and Shading
- Using Format Painter
- Using Cell Styles
- Using Themes
6 - Working with Large Worksheets
- Using Zoom
- Freezing and Unfreezing Panes
- Splitting a Window
- Tiling Multiple Workbooks
- Using Synchronous Scrolling
7 - Using Protection and Comment Boxes
- Adding and Deleting Comments
- Locking and Unlocking Cell Ranges
8 - Using Page Setup and Printing Options
- Using Spell Check
- Inserting Page Breaks
- Using Page Break Preview
- Using Print Preview
- Changing the Orientation and Margin
- Working with Print Areas
- Setting Print Titles
- Adding Headers and Footers
- Printing Gridlines and Comments
- Using the Print Dialog Box
9 - Conclusion