Excel Introduction for Beginners

Course Overview

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

Audience

Users who are new to spreadsheets.

Skills Gained

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

Prerequisites

None.

Course Outline

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