Microsoft Office Excel Training Course
Melbourne, VIC
Subject: Microsoft Excel
Creating and Manipulating Data:
Insert data by using AutoFill
Ensure data integrity
Modify cell contents and formats
Change Worksheet Views
Manage worksheets
Formatting Data and Content:
Format worksheets
Insert and modify rows and columns
Format cells and cell content
Format data as a table
Creating and Modifying Formulas:
Reference data in formulas
Summarize data using a formula.
Summarize data using subtotals.
Conditionally summarize data by using a formula
Look up data by using a formula...
Creating and Manipulating Data:
Insert data by using AutoFill
Ensure data integrity
Modify cell contents and formats
Change Worksheet Views
Manage worksheets
Formatting Data and Content:
Format worksheets
Insert and modify rows and columns
Format cells and cell content
Format data as a table
Creating and Modifying Formulas:
Reference data in formulas
Summarize data using a formula.
Summarize data using subtotals.
Conditionally summarize data by using a formula
Look up data by using a formula.
Use conditional logic in a formula.
Format or modify text by using formulas.
Display and print formulas.
Presenting Data Visually:
Create and format charts
Modify charts
Apply conditional formatting
Insert and modify illustrations
Outline data
Sort and filter data
Collaborating and Securing Data:
Manage changes to workbooks
Protect and share workbooks
Prepare workbooks for distribution
Save workbooks
Set print options for printing data, worksheets, and workbooks
When
Please contact us for upcoming dates and/or more information about this class
Where
Melbourne, VIC 3004
Type
- Class / Group Sessions
Price: $500.00
Notes:
Free if eligible for government funding.
The teachers
-
- Taught By
- Ali Lalani
Other Microsoft Excel Listings
-
Microsoft Excel Essentials Course
YES Management and Technology...
Overview & Objectives: The skills and knowledge covered in this book are sufficient for real-world applications such as budgeting, analysing sales, producing reports, creating charts...
see more »
$399.00
-
Microsoft Excel Advanced Course
YES Management and Technology...
Overview & Objectives: This course aims to increase your productivity by providing the skills and knowledge to use Microsoft Excel 2003 effectively. Course Duration: 7 Hours (Part...
see more »
$399.00
-
Microsoft Excel 2007 - Level 2 Short Course
Holmesglen Institute of...
Expand your computing knowledge of MS Excel and provide extensive answers, solutions and presentations. Includes formulas, complex printing options, intricate chart options, data sorting...
see more »
$200.00
-
Microsoft Excel - Estimating For Builders Course
Holmesglen Institute of...
Improve your basic Excel and estimating skills for the building industry with this application based course. Designed and led by a professional tradesperson, you will be introduced...
see more »
$310.00
-
Microsoft Excel 2007 - Level 3 Short Course
Holmesglen Institute of...
Advance your Microsoft Excel computing skills to include advanced analysis tools, pivot tables, Solver, outlining and summarising and some key automation features such as macros. Students...
see more »
$200.00