Excel 2007 - Beginner

Overview

About this course

Self-paced lessons on Excel 2007 basics: worksheet skills, formulas, formatting and working with large worksheets.

Curriculum

Curriculum

9 modules

Introduction

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

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

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

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

Using Zoom
Freezing and Unfreezing Panes
Splitting a Window
Tiling Multiple Workbooks
Using Synchronous Scrolling

Adding and Deleting Comments
Locking and Unlocking Cell Ranges

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

Course Recap

Who it's for

Who it's for

Users of Excel 2007.

Before you start

No formal prerequisites. Bring curiosity and a willingness to practise.