Excel Introduction for Beginners

About this class

This course is designed to provide new users with a good understanding of the basic concepts of Microsoft Excel.

Who will the lesson benefit?

Users who are new to spreadsheets.

What delegates will learn

For users new to Excel, this course provides the ideal introduction.

What prerequisites are required

None.

Contents of this class

Excel Basics

• Spreadsheet Terminology
• Exploring The Excel Window
• Opening And Navigating A Workbook
• Closing A Workbook

Entering And Editing Data

• Creating A New Excel Workbook
• Entering And Editing Labels And Values
• Entering And Editing Formulas
• Saving And Updating A Workbook

Printing

• Preparing To Print
• Page Set up Options

Modifying A Worksheet

• Moving A Copying Data
• Moving And Copying Formulas
• Using Absolute References
• Inserting And Deleting Ranges Using Functions
• Entering Functions
• Using Autosum
• Using AVERAGE, MIN, MAX, And COUNT

Formatting Worksheets

• Formatting Text
• Formatting Rows And Columns
• Number Formatting
• Other Formatting Features Creating Charts
• Creating A Chart
• Printing Charts

Web Features

• Saving A Worksheet As A Web Page
• Adding Hyperlinks
• Sending A Workbook Via Email