About This Training Course

This Excel 2010 - Level 1 Essentials for creating Financial Documents Training Course aims to give the new spreadsheet user a thorough grounding in the basics of spreadsheeting and using Microsoft Excel 2010. Particular emphasis is placed on the importance of accuracy, good formula building techniques, and sound formatting and design principles.

Subjects Covered

"Course content
ÿ Getting To Know
Microsoft Excel
· Starting Microsoft Excel
· The Excel 2010 Screen
· How Microsoft Excel 2010
Works
· Using The Ribbon
· Using Ribbon Key Tips
· Minimizing The Ribbon
· Understanding The
Backstage View
· Accessing The Backstage
View
· Using Short Cut Menus
· Understanding Dialog Boxes
· Launching Dialog Boxes
· Understanding The Quick
Access Toolbar
· Adding Commands To The
QAT
· Understanding The Status
Bar
· Exiting Safely From Excel
ÿ Creating A New
Workbook
· Understanding Workbooks
· Creating A New Workbook
· Typing Text
· Typing Numbers
· Typing Dates
· Typing Formulas
· Saving A New Workbook
· Easy Formulas
· Checking The Spelling
· Making Basic Changes
· Printing A Worksheet
· Safely Closing A Workbook
ÿ Working With
Workbooks
· Opening An Existing
Workbook
· Navigating A Workbook
· Navigating Using The
Keyboard
· Using Go To
· Understanding Data Editing
· Overwriting Cell Contents
· Editing Longer Cells
· Clearing Cells
ÿ Selecting Ranges
· Understanding Cells And
Ranges
· Selecting Contiguous Ranges
· Selecting Non-Contiguous
Ranges
· Using Special Selection
Techniques
· Selecting Larger Ranges
· Selecting Rows
· Selecting Columns
ÿ Formulas And
Functions
· Understanding Formulas
· Creating Formulas That Add
· Creating Formulas That
Subtract
· Formulas That Multiply And
Divide
· Understanding Functions
· Using The SUM Function To
Add
· Summing Non-Contiguous
Ranges
· Calculating An Average
· Finding A Maximum Value
· Finding A Minimum Value
· More Complex Formulas
· What If Formulas
ÿ Copying Data
· Understanding Copying In
Excel
· Using Fill For Quick
Copying
· Copying From One Cell To
Another
· Copying From One Cell To A
Range
· Copying From One Range To
Another
· Copying Relative Formulas
· Copying To A NonContiguous Range
ÿ Formula Referencing
· Absolute Versus Relative
Referencing
· Relative Formulas
· Problems With Relative
Formulas
· Creating Absolute References
· Cre

Training Course Outcomes

"At the completion of this Excel 2010 - Level 1 Essentials for creating Financial Documents Training Course participants will be able to:
navigate your way around Microsoft Excel 2010
create a new workbook
open and navigate within workbooks and worksheets
understand and work with ranges in a worksheet
understand, create and work with formulas and functions used to perform calculations
copy and paste data in Excel
understand and use formula cell referencing to create more complex formulas
use font formatting techniques to greatly enhance the look of a worksheet
align the contents of cells in a number of ways
format rows and columns in a worksheet
understand and use the number formatting features in Excel
print your workbook data
create effective charts in Microsoft Excel"

Prerequisites

"This Excel 2010 - Level 1 Essentials for creating Financial Documents Training Course assumes little or no knowledge of spreadsheets or Microsoft Excel 2010.
However, it would be beneficial to have a general understanding of personal computers and the Windows operating system environment."

Other Information

"Advanced Training provides a range of computer training solutions offering flexible delivery methods, a cost effective approach, smooth implementation and an exceptional level of quality service.

Advanced Training Locations:

• Queen Street, Melbourne - Victoria
• Moore Street, Turner - Canberra
• York Street, Sydney - New South Wales
• Church Street, Parramatta - New South Wales
• Astor Terrace, Spring Hill - Brisbane, Qld
• Innovation House, Mawson Lakes - South Australia
• Patrick Street, Hobart - Tasmania
• St George's Terrace, Perth - Western Australia "