Core Essentials - MS Excel 2007 Course Outline

Core Essentials - MS Excel 2007

Module 1: The Basics

Getting Started

Anatomy of a Spreadsheet

Creating a Spreadsheet

Understanding Workbooks

Using Templates

Using Ribbons and Tabs


Module 2: Working With Data

Inserting and Deleting Rows and Columns

Merging and Splitting Cells

Moving Cells

Using Paste Special

Using Find and Replace

Hiding and Unhiding Cells


Module 3: Basic Excel Tools

Understanding Cell References and Formulas

Basic Functions

Advanced Functions



Spell Check

Sort and Filter


Module 4: Basic Formatting Tools

Working with Fonts on the Home Tab

Using the Font Tab

Changing the Size of Rows and Columns

Adjusting Cell Alignment

Changing Text Direction

Changing Number Format


Module 5: Advanced Formatting Tools

Adding Borders and Colors

Using the Format Painter

Using Cell Styles

Using Conditional Formatting

Formatting Data as a Table


Module 6: Advanced Elements

Adding Pictures

Inserting SmartArt

Drawing Shapes

Drawing Text Boxes

Creating a PivotTable

Creating a Chart


Module 7: Viewing and Printing

Using Views

Using Zoom.

Using Page Setup

Previewing Your Worksheet

Printing Your Worksheet

E-mailing a Workbook


Download this course as a demo

Complete the form below and we'll email you an evaluation copy of this course:

What You Get with Velsoft Courseware