Duration: 1 day | Book this course
Cost: $265.00 + GST
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:
- Enter and edit information in a worksheet and manage workbooks.
- Navigate worksheets and workbooks.
- Perform calculations on worksheet data.
- Manipulate worksheet data.
- Format the contents of a worksheet.
- 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