First released for Windows users in 1987, Excel is the spreadsheet application that forms part of the Microsoft Office suite. It is used by millions of people across the world in a range of professions from education, medical and business to admin, finance and sales. It’s also ideal for individuals who like to keep on top of their own household budgets!
Excel 2019 for Windows is an online program that will teach you how to store and analyse large quantities of data to increase efficiency in today’s complex and time-poor home and work environments.
In this IT course, you will discover the software’s interface and features; learn how to create and format charts, graphics, workbooks, tables and formulas; and share, illustrate and collaborate on documents.
You will also study how to insert, manipulate, group, reference, sort and filter data and use intelligent data types in order to forecast and solve problems.
On completion of this course, you will be familiar with a universal software program that will enable you to work more efficiently and effectively with data sets, which will ultimately enhance your skillset and employability!
Unit 1 - Getting started
Finding and opening the application
Exploring the application
Using the zoom function
Using the view modes
Moving between documents
Unit 2 - Creating and saving workbooks
Creating & opening a document
Saving a document
Saving a document as a PDF
Recovering unsaved documents
Inserting headers & footers
Adjusting print page layout
Printing a document
Creating an accessible document
Protecting a document
Unit 3 - Formatting data
Setting data type
Formatting and aligning data
Changing cell styles
Using document themes
Using formulas to modify a text case
Creating and formatting a title
Creating a table
Resizing and inserting columns & rows
Transferring format styles
Unit 4 - Illustrating documents
Inserting an image
Inserting a screenshot
Editing an image
Inserting a hyperlink
Using smart lookup
Unit 5 - Inserting and manipulating data
Selecting cells and inputting data
Inserting special characters
Editing multiple worksheets simultaneously
Deleting items in a spreadsheet
Undoing & redoing actions
Creating automatic data series
Using the flash fill feature
Inserting dropdown menus
Configuring spell check and autocorrect
Copying and pasting data
Using the paste special tools
Transposing a data range
Unit 6 - Sharing and collaborating on a document
Sending a document via email
Sharing a workbook via a link
Managing link access and permissions
Saving documents to OneDrive
Managing a workbook’s version history
Commenting on a document
Following and tracking document changes
Unit 7 - Using basic formulas
Inserting a formula
Performing simple calculations
Using automated formulas in a table
Creating automated cumulative totals
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Converting number types
Factorising the results of a division
Creating random values
Unit 8 - Creating charts and graphics
Insert, edit and remove charts
Customise chart labels
Format a chart
Customise chart elements
Customise chart axes
Create a chart template
Present negative values in a chart
Unit 9 - Custom and conditional formatting
Format currency, percentage and phone numbers
Changing text format
Custom format dates or times with worksheet data
Custom colour formatting
Conditional custom formatting to data values
Conditional formatting rules and tools
Advanced conditional formatting tools
Unit 10 - Finding and grouping data
Using find tools
Finding items with basic search queries
Customise and refining search queries
Locating and selecting graphical objects
Replacing cell contents and formats
Find and replace tools
Using freeze tools
Grouping rows and columns
Group tools to create outlines
Unit 11 - Forecasting and solving problems
Checking and evaluating formulas
Using formulas to estimate loan-related costs
Goal seek tool
Using the solver add-in
Inserting a forecast worksheet
Using data tables
Unit 12 - Referencing data
Using data across multiple worksheets
Absolute and relative cell references
Naming data ranges
Using the name manager
Using constant values
Using cell references
Monitoring changes and errors
Configuring automatic updates
Formula auditing tools
Unit 13 - Sorting and filtering data
Sorting data in a worksheet
Customise sort options
Using multiple criteria and sort levels
Creating and using custom sort lists
Using column filters
Applying multiple filters to data
Creating filter arguments
Applying colours to sort and filter data
Advanced filter tools
Hiding duplicate values
Unit 14 - Working with different chart styles
Inserting and editing a pie chart
Creating a scatter chart
Creating a bubble chart
Creating a radar chart
Using Combo chart
Creating and editing a map chart
Unit 15 - Working with excel tables
Converting a data range
Formatting tools and styles
Table settings and tools
Using slicers to filter data
When you study with Australian Online Courses, you will be assessed using a competency-based training method.
Competency-based training focuses on the achievement of skills and knowledge against set criteria to ensure your competency is industry relevant. You will not be benchmarked against other students.
If you do not achieve a competency result on your first attempt, you have two more attempts to pass your assessment. So, you have three attempts in total to obtain a competency result.
In this way, you can complete your course in your own time and at your own pace with the assistance of unlimited tutor support.
In this course, you will be assessed via multiple-choice questions to determine your mastery of details and specific knowledge gained during your studies to achieve a ‘competent’ or ‘not yet competent’ result.
Benefits of Multiple-Choice Assessments
Appropriate for assessing students’ mastery of details and specific knowledge.
Can be used to assess both simple knowledge and complex concepts.
Questions can be answered quickly to accurately assess a students’ mastery of many topics relatively quickly.
Assessment can be quickly and reliably scored to achieve a ‘competent’ or ‘not yet competent’ result.
As the answers are visible, multiple-choice questions offer the opportunity for the continuation of the learning process, offering educational value.
Why Choose Australian Online Courses?
Professional development that is widely recognised and respected;
Improve your employment opportunities;
Study online, anywhere via our elearning system;
High-quality professional development programs written by industry experts;
No entry requirements;
All course materials provided online – no textbooks to buy;
Unlimited tutor support;
Easy to understand course content;
We offer twelve (12) months’ access, with extensions available upon application (fees apply);
Certificate of Attainment/Completion issued for your CV (hard copy provided); and
Course may be tax deductible; see your tax advisor.
How long will it take to complete this course?
The approximate study hours for this course is 15 hours. We offer twelve (12) months’ access, with extensions available upon application (fees apply).
Can I purchase optional printed materials?
While printed materials are not available for purchase, transcripts of video lectures and other learning resources are available for printing via our elearning system.
When can I start this course?
You can start within 60 minutes during business hours when you enrol and pay in full with a credit card!
Credit card: Within 60 mins during business hours.
BPAY: Within 1-2 working days.
Internet Banking: Within 1-2 working days.
Cheque/Money Order: Upon receipt of mailed cheque.
Will I receive a certificate upon completion of this course?
Yes! You will receive a Certificate of Attainment upon successful completion of your assessment.
Do I need to attend classes or undertake any work placements?
No. All courses are delivered online via our e-learning system and there are no work placement requirements in this course.
What support can I expect from Australian Online Courses?
Unlimited tutor support is available throughout your studies via email during business hours Monday to Friday. Our Administrative team are available Monday to Friday via email, live chat and telephone.
I am an international student. Can I enrol into this course?
Yes! We accept enrolments from individuals both within Australia and internationally; location is no barrier to entry into our programs.
Professional development for:-
Individuals working in small, medium and large organisations who need to produce professional documents and communications.