Microsoft Excel Training Courses
Absolute Excel Beginners to Advanced Excel Training Courses (One Price for ALL Courses)
Unlike some larger training companies, our online Microsoft Excel training course includes everything. It is ONE price (see enrolment page for course prices) for ALL courses (and every new Excel course we create) including:
- Course 301: Open and Understand Spreadsheets
- Course 302: Creating and Editing Spreadsheets
- Course 303: Formulas, functions and formatting
- Course 304: Viewing and printing
- Course 305: Charts & Graphs
- Course 306: Intermediate Functions and cell referencing
- Course 307: Databases, filter/sort, named ranges
- Course 308: Pivot tables, 3D formulas, Advanced Formulas and protection
- Course 309: Goal Seek, data consolidation and Solver
See what is included in each of our Microsoft Excel Online Training Courses
Each of our Microsoft Excel Training Courses are designed as a half day training session for the training centres we use to operate in Sydney between 2000 and 2006. Although we include all of these 9 courses for the one low price we’ve demonstrated below how they are usually separated into Beginners, Intermediate and Advanced Excel Courses.
Microsoft Excel Beginners Course (free sample available – click here)
Microsoft Excel (course 301) – Open and Understand Spreadsheets
Microsoft Excel (course 302) – Creating and Editing Spreadsheets
Microsoft Excel (course 303) – Formulas, functions and formatting
Read more about the Microsoft Excel Beginners Courses (and receive your free sample)
Microsoft Excel (course 304) – Viewing and printing
Microsoft Excel (course 305) – Charts & Graphs
Microsoft Excel (course 306) – Intermediate Functions and cell referencing
Read more about the Microsoft Excel Intermediate Courses
Microsoft Excel (course 307) – Databases, filter/sort, named ranges
Microsoft Excel (course 308) – Pivot tables, 3D formulas, Advanced Formulas and protection
Microsoft Excel (course 309) – Goal Seek, data consolidation and Solver
Read more about the Microsoft Excel Advanced Courses
Microsoft Office Beginners Essentials Combination Offer
Are you a beginner to the Microsoft Office suite of programs and would like to learn all of these programs in one course? That’s why we created the Microsoft Office Beginners Essentials Courses – a fantastic way to get a solid understanding about how to navigate, use and create documents, spreadsheets and presentations as well as manage emails, calendars, contacts and tasks. All of these courses are available for one low price with 12 months access and the option or a certificate if you want one.
Microsoft Excel Training Course Inclusions, special offers and free samples
Check out our specials page to see if you are eligible for a discounted price on Excel Courses! Get all the learning tools, start straight away and have a resource for 12 months or life.
*** CURRENT OFFER: Enrol into the Excel Course and Certificate and receive the Microsoft Word Course for free!
See OFFER 1 – Job Seeker Offer ***
There are now a whole bunch of free courses that are included for all EzyLearn students. No matter which of our courses you enrol into you’ll be able to use your login details to access all of these online courses for free!
EzyLearn has been delivering online courses since 2006 but unless you’ve been watching you may not have heard of us so we’ve always offered samples of our training workbooks and videos for you to get to know our training style. The Microsoft Excel Beginners 301 workbook is available as free download!
Enrol today, start by 5pm next business day and learn fast
As a student you can watch the online Microsoft Excel training videos as often as you want, print the training workbooks and go through the step-by-step exercises. Our videos replicate the exercises in the workbooks using the exercise files included in the courses.
* Microsoft Excel Exercise Files
We provide the Microsoft Excel exercise files so that you can practice what you learn (and gain real experience with the software). There are dozens of files and many of them can be used in real life scenarios in your office or even to help calculate mortgage or finance repayments.
* Microsoft Excel Training Workbooks
Everyone loves our Microsoft Excel training workbooks because they take students through the learning process one step at a time. All 9 workbooks are designed to progress students from basic to more advanced skills when they are needed in the learning process. You’re welcome to sample our absolute beginners to Microsoft Excel Training Workbook (see below for more details).
Students NOW have the option of enrolling for LIFETIME MEMBERSHIP
Our course includes Microsoft Excel knowledge reviews to test your new skills and provide you with the learning resources to review your answers and go over the learning material again if you need to. Learn more about how the online course works.
All 9 Microsoft Excel courses for the one low price
We’ve only supplied these course outlines as Excel Beginners, Intermediate and Advanced to help demonstrate the value of our Microsoft Excel Courses because we include EVERYTHING for one low price. If you are an intermediate Excel users you may learn something from the Beginners courses and focus on the Advanced courses and if you are more advanced you can brush up on the skills taught in earlier courses. Why do some training companies still offer these Microsoft Excel courses separately!
Training Methods used for Excel Training Courses
Videos, Tests, Workbooks, Exercise Files
Each of the 9 Microsoft Excel courses is divided into sections of explanatory videos (real life using of the exercise files and the software) followed by Knowledge Reviews that are designed to test your knowledge of the features taught in that section.
So in summary we use these training methods:
- Detailed demonstration training videos
- Knowledge Review tests
- Exercise files that are unlocked and you can work with
- Training workbooks that take you through every stage of performing the Excel operations
You Choose How You Want To Learn
No matter how you like to learn:
- Watch the training videos and replicate it yourself on your own computer
- Follow a training workbook using the exercise files
- Just opening the Excel exercise files and playing around with them
- Watch, try it yourself and then test yourself
We have all the training methods covered, AND you can go over and over the training materials as often as you want during your membership period – Did we mention that we have a LIFETIME course access option?
* BONUS OFFER Courses *
For a limited time only we’re offering the Xero Online Accounting OR the Microsoft Word Online Training Course for only $97 extra when you enrol into the Certificate option for either MYOB Accounting or our Microsoft Excel Training Courses.
Give ALL your staff training on ALL our Courses and get a MASSIVE discount off the normal prices
Do you have a team of people and want them to have access to all our courses with our ALL YOU CAN LEARN training programs? Order a Business Software Training Licence and give them access to all the great EzyLearn features:
- Enrol Now, Learn Fast
- All skill levels included (beginners to advanced)
- Training video, workbooks, exercises and tests
- Go over the course material as often as you need
See our latest Group, Discount, Combo and Corporate Training Offers..
Frequently Asked Questions About Our Microsoft Excel Training Courses
The A-Z of Excel Course Questions
- How long will it take me to complete the course?
- Can I go over the training materials more than once?
- Are their any prerequisites?
- When can I start?
- How long can I access the Excel courses?
- Do I get a certificate?
Feel free to visit our Microsoft Excel Training Course FAQ’s for all the common questions and answers about our courses.
Our other online courses
Enrol into this course and you’ll automatically get free access to the first course for several of our other online courses.Click the image to see the other courses we offer.
Case Study: Pivot Tables and Charts
Pivot Tables in Microsoft Excel is a powerful features that enables you to get valuable information from a huge list of data.
We had the information we knew – that Absolute Beginners and Excel were the most popular courses and that we could offer these courses in the morning, just after lunch or in the evening. You’ll be able to use our exact data in a Pivot table to see when students like to come to a training centre to do a course – we used this information to schedule our courses up to 6 months in advance!
Why Online Excel Training Courses
It’s a great thing that we create our own Excel training courses and exercise files because what we discovered was that students prefer to learn when they want and at their own pace! Even back then we knew that there had to be a better way than scheduling rooms, courses and trainers around holidays, sick days and long weekends. Read about our journey from a physical training centre business to an online training company.
As owners of our own Microsoft Excel Course Training workbooks, videos and exercise files – and with a low cost model of hosting and online support – we can provide ALL of our content for one low price (AND the option of LIFETIME course access). Best of all you get access to new material and updated content during your membership period.
* NEW Excel Training Course Content
The property markets in most capital cities in Australia were running hot in 2015 and ordinary people are borrowing a lot of money to enter and stay in these property markets.
Microsoft Excel is a fantastic tool to help you learn how to save tens of thousands of dollars of your mortgage and reduce your loan by a decade or more. It’s one of the ways that we make Microsoft Excel useful and practical for everyone. Excel can be fun and useful as well as a great tool for businesses.
Goal Seek using Microsoft Excel
Goal Seek is an advanced topic that helps you input the variables that you know to help you find the information you need. After you master the basics you’ll be able to use the powerful features to get the decision making information you need from a software program as valuable and widely used as Microsoft Excel.
See the full list of topics covered see our
Worksheets, Database & Charts. Selecting information: Understanding the mouse cursors used within Excel, how to select cells, columns and rows and multiple ranges of information, how to select cells using the keyboard. Copy and Paste: Drag and drop, cut, copy and paste in a worksheet and from one worksheet to another and even between different software programs. Editing cells: Typing and entering information, editing existing information and entering the changes, using the status bar information, escaping out of cells. Changing column width and row height for single and multiple columns as well as making all the columns the same width and using AutoFit. Database: Creating a simple database, understanding simple database structure (ideal knowledge for mail merge with Microsoft Word), Inserting and deleting columns, using Undo and redo options.
Formulas: Entering formulas using the keyboard, arrow keys and the mouse, understand the importance of relative cells references, common formula errors, using multiplication and division and how to combine two formulas in one. AutoCalculate: Get quick additions and basic functions quickly without having to enter formulas. Functions: Introductions to functions and function syntax, Autosum, Autosum for several and selected ranges and an introductions to other basic functions like Maximum, Minimum, Average and more… Functions: Sum function in more detail, using the formula bar and editing functions, using the F2 key, using Autofill to save a lot of time copying (or filling) functions using relative cell references. Formatting: This effects the way your spreadsheet looks, everything from lines, colours, shading, and even the format of text and numbers. Topics include: Currency formatting, date and text formatting, merging cells and centering, Alignment formatting and text control within single and Â merged cells, fill colour, font colour and Borders. Advanced formatting: Autoformats that allow you to quickly make your spreadsheet look very professional, repeat last action, and format painter make it faster for you to duplicate commands and formatting, using format painter with entire spreadsheets to apply multiple formatting in just a couple clicks.