Microsoft Excel Introduction
Course Description
Microsoft Excel Introduction is part of a 3-level study program. This course aims to give participants a thorough understanding of the basics of creating and working with spreadsheets using Microsoft Excel. It covers creating a new workbook, adding data, editing data, working with formulas, printing and charting.
Learning Outcomes
At the completion of Microsoft Excel Introduction you should be able to:
- navigate your way around Microsoft Excel
- open and navigate within workbooks and worksheets
- understand and work with ranges in a worksheet
- use the fill operations available to fill a data series
- understand, create and work with formulas and functions
- understand and use formula cell referencing
- understand and use the number formatting features in Excel
- sort data in a list in a worksheet
- filter data in a table
- print your workbook data
- create effective charts in Microsoft Excel
Prerequisites
Microsoft Excel Introduction assumes little or no knowledge of the software. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Course Duration
The Microsoft Excel Introduction course is run over one-day but can be customised to suit your needs.
Course Overview
- The Excel Workbook Screen
- Using the Ribbon
- Accessing the Backstage View
- Using Shortcut Menus
- Using the Quick Access Toolbar
- Typing Text, Numbers and Dates
- Using Easy Formulas
- Saving a New Workbook
- Check Spelling
- Opening an existing workbook
- Navigating a workbook
- Navigating using the keyboard
- Using Go To
- Recent Files and Folders
- Overwriting Cell Contents
- Editing Longer Cells
- Editing Formulas
- Clearing Cells
- Deleting Data
- Using Undo and Redo
- Selecting Contiguous Ranges
- Selecting Non-Contiguous Ranges
- Selecting Larger Ranges
- Selecting Rows
- Selecting Columns
- Using Fill for Quick Copying
- Copying from One Cell to Another
- Copying from One Cell to a Range
- Copying from One Range to Another
- Filling a Series
- Filling a Growth Series
- Extracting with Flash Fill
- Creating Basic Arithmetic Formulas
- Using the SUM Function
- Summing Non-Contiguous Ranges
- Calculating an Average
- Finding a Maximum & Minimum Value
- Creating More Complex Formulas
- What if Formulas
- Relative Formulas
- Problems with Relative Formulas
- Creating Absolute References
- Changing Fonts and Font Size
- Use Formatting Techniques
- Customise Colours
- Use Format Painter
- Apply General Formatting
- Format Money & Percentages
- Format Dates
- Increasing and Decreasing Decimals
- Perform Alphabetical & Numeral Sort
- Sorting on More Than One Column
- Apply and Use a Filter
- Clear a Filter
- Multiple Value Filters
- Creating Custom Filters
- Use Print Preview
- Printing a Range or Entire Workbook
- Print Options
- Creating a New Chart from Scratch
- Working with an Embedded Chart
- Customise Chart Options
Course Includes
Skills Analysis
Certificate
We come to you
Hands-on training
Email Support
Real-world examples
Course Pricing
Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.
| Number of participants | Investment (per day) |
|---|---|
| 1-on-1 Training | $500.00 |
| 2-3 participants | $650.00 |
| 4-6 participants | $800.00 |
| 7-8 participants | $950.00 |
| 9-10 participants | $1,200.00 |
Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.
View other course outlines
Excel Intermediate
- 1 day course duration
Excel Advanced
- 1 day course duration