Microsoft Excel Course Titles
Excel Introduction
Duration: 1 day | Book this course
Cost: $325.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 basic calculations and manipulate worksheet data; format the worksheet contents; and prepare, set up, and print information.
Prerequisites
Prerequisites
Familiarity with the Windows operating system is essential. If you are unsure, please complete a Training Needs Assessment form by clicking here or phone our Bookings Administrator on (07) 857.0776.
Who Should Take This Course
New users of Microsoft Excel.
Course Objectives
Course Objectives
Upon completing this course, you will have learned how to:
- Create, save and close a workbooks.
- Enter and edit text and numbers in a worksheet.
- Navigate worksheets and workbooks.
- Perform basic calculations on data.
- Manipulate rows and columns
- Format the contents of a worksheet.
- Prepare, set up, and print information.
Course Outline
Course Outline
Worksheets and Workbooks
- The Excel screen (The File menu, the Ribbon, Quick Access Toolbar, Zoom, Views)
- Creating, Saving, and Closing Workbooks
- Understanding different file types including Compatability mode
- Understanding the difference between a workbook and a worksheet
Using Excel
- Selection Techniques
- Entering information (Text, Numbers, Formulas and Dates)
- Editing information in cells
- Undoing and redoing an action
Manipulating rows and columns
- Inserting and deleting rows and columns
- Resizing rows and columns (including best-fit option)
- Freezing row and column headers
Copying, Moving and Deleting Information
- Copying and moving cell content (cut, copy, paste)
- Deleting cell content
Worksheets
- Inserting a new worksheet
- Renaming and deleting a worksheet
- Copying or moving worksheets between workbooks
Using Excel Functions to perform basic calculations
- Understanding the difference between a Formula and a Function
- AUTOSUM function
- AVERAGE function
- MAX function
- MIN function
- COUNT function
Writing Formulas
- Introduction to Formulas
- Easy ways to create formulas
- Copying formulas using AutoFill
- Formula error messages
- Relative, Absolute, and Mixed cell referencing
Formatting
- Font formatting
- Alignment formatting
- Format Painter
- Number formatting
Checking spelling in a Worksheet
Printing
- Comparing workbooks side by side
- Print Preview
- Setting the Page Options and Margins
- Adding Headers and Footers
- Inserting and Removing a Page Break
- Printing a Worksheet