Ardito Computer Training

Course Description

This one-day introductory class covers all the basics of Microsoft Excel . Participants will learn how to enter and edit information in a worksheet; manage and navigate worksheets and workbooks; perform calculations and manipulate worksheet data; format the worksheet contents; and prepare, set up, and print information.

Prerequisites
Basic Computer Skills or equivalent knowledge

Who Should Take This Course
New users of Microsoft Excel.

Course Objectives

Upon completing this course, you will have learned how to:

1. Enter and edit information in a worksheet and manage workbooks.
2. Navigate worksheets and workbooks.
3. Perform calculations on worksheet data.
4. Manipulate worksheet data.
5. Format the contents of a worksheet.
6. Prepare, set up, and print information.
   

Course Outline

A First Look at Excel

• Starting the Excel program
• Default text and number alignment

 Worksheet and Workbooks

• Creating, Saving, and Closing Workbooks
• Starting a New Workbook Using Templates
• Managing Worksheets and Workbooks
• Changing the View of Your Workbook
• Saving a workbook using a different file type

Help

• Searching for Help
• The Help 'Table of Contents'
• Alt key help

Using Excel

• Selection Techniques
• Selecting the entire worksheet
• Entering information
• Types of information you can enter
• Editing information in cells
• Undoing and redoing an action

Manipulating rows and columns

• Inserting rows into a worksheet
• Inserting columns into a worksheet

Copying, Moving and Deleting Information

• Copying the cell or range of contents
• Deleting cell contents
• Moving the contents of a cell or range

Searching and Replacing Data

Worksheets

• Manipulating worksheets
• Insering a new worksheet
• Deleting a worksheet
• Copying or moving worksheets between workbooks

Freezing row and column titles

Performing Calculations with Formulas

• Introduction to Formulas
• Easy ways to create formulas
• Copying formulas
• Formula error messages
• Relative, Absolute, and Mixed cell referencing

Performing Calculations with Formulas

• What is a function?
• SUM function
• AVERAGE function
• MAX function
• MIN function
• COUNT function

Formatting

• Font formatting
• Alignment formatting
• Format Painter
• Number formatting

Checking spelling in a Worksheet

Customising Excel

• Modifying basic options
• Minimising the Ribbon
• AutoCorrect Options

Printing

• Comparing workbooks side by side
• Previewing a Worksheet
• Setting Up the Page
• Setting the Page Options and Margins
• Adding Headers and Footers
• Inserting and Removing a Page Break
• Setting Worksheet Options
• Printing a Worksheet