Excel 2007: Introduction for Beginners (1 day)

About this class

By the end of this course you will be able to produce a formatted worksheet, confidently create basic dynamic formulae and create a visual representation of the data, using the provided manual if required.

Who will the lesson benefit?

Anybody that wants to learn the fundamentals of Microsoft excel.

Contents of this class

Excel Basics

• Spreadsheet Terminology
• Exploring The Excel Window
• Getting Help
• Opening And Navigating Workbooks
• Closing Workbooks

Entering And Editing Data

• Creating Workbooks
• Entering And Editing Labels And Values
• Entering And Editing Formulas
• Saving And Updating Workbooks

Printing

• Preparing To Print
• Page Set Up Options

Modifying A Worksheet

• Moving And Copying Data
• Moving And Copying Formulas
• Using Absolute References
• Inserting And Deleting Ranges

Using Functions

• Entering Functions
• Using Autosum
• Using AVERAGE, MIN, And MAX

Formatting Worksheets

• Formatting Text
• Formatting Rows And Columns
• Number Formatting
• Other Formatting Features

Creating Charts

• Chart Basics
• Printing Charts

Web Features

• Saving Worksheets As Web Pages
• Hyperlinks
• Workbooks And Email