Microsoft Excel Beginners to Advanced Certificate Training Courses
Everything is Included!
Choose between 9 individual short courses on how to use and master Microsoft Excel spreadsheet software or get it all for ONE LOW PRICE with the Microsoft Excel COMPLETE training course package.
These short courses will teach you how to use Microsoft Excel using
- video tutorials,
- training workbooks with step-by-step practical exericses
- exercise files that we created to demonstrate how to use Excel
- knowledge review assessments to highlight important learning milestones in each short course
The Microsoft Excel Beginners 301 workbook is available as free download!
Enrol today, start quickly and learn fast
Here’s what’s included with the Premium Microsoft Excel Training Short Courses
Microsoft Excel Online Training Video Tutorials
As a student you can watch the online Microsoft Excel training video tutorials as often as you want, print the training workbooks and go through the step-by-step exercises.
The Excel training video tutorials replicate the practical exercises in the workbooks using the exercise files included in the courses. You’ll watch a video that explains exactly what you need to do, from beginners skills to advanced skills – one step at a time.
Microsoft Excel Exercise Files
The Microsoft Excel exercise files are carefully created (often showing several stages of modifying an Excel exercise file) so you get to see exactly how each stage of the process works. You’ll be able to replicate the videos to use the powerful Microsoft Excel tools that are used in most offices.
There are dozens of files and they are completely unlocked and available for you to use in the office where you work or even personally to help you manage and organise aspects of your everyday life. There are exercise files to help you calculate mortgage or finance repayments as well as set household budgets. manage a home roster and lots more.
Microsoft Excel Training Workbooks
Everyone loves our Microsoft Excel training workbooks because they take you through the learning process one step at a time – starting from the basics and building onto more advanced features.
As you progress from beginners to advanced Excel skills the course workbooks re-enforce important Excel features and functions along the way so they stay in your memory.
You’ll perform basic tasks on some of the exercise files and then use advanced Excel features to complete similar tasks on those same files in a much faster time and with better results.
Sample our absolute beginners to Microsoft Excel Training Workbook for FREE (see below for more details).
Enrol for 12 months or LIFETIME Access
Microsoft Excel Training Course knowledge reviews test your new skills at every stage and provide you with the learning resources to review your answers and go over the learning material again if you need to. These assessment tests form the basis for you to achieve a Beginners to Advanced Certificate in Microsoft Excel.
Learn more about how the online Excel course works.
——–
LIVE! EzyLearn News and Updates
——–
Recent Microsoft Excel Course Testimonials
We only ask for testimonials when a student has completed their course and receives their certificate. Here is a recent testimonial.
I found the Excel course very useful as I learnt new things to incorporate into my use of excel in my small business. Eg. shortcuts, easier ways of using aspects of excel, additional features to what I had been using etc. It has also made me more aware of what things you can do in excel so I would now have more confidence in using and experimenting with its various functions. I found the courses well-structured with video, workbook and exercises.
Jenny Ryan (Migration Consultant)
See other Testimonials, Feedback, Reviews & Customers
EzyLearn Worklife Interviews
We interviewed some EzyLearn graduates after they completed their studies to find out more about their work life. We asked them about
challenges they face in the workplace,
- their opinions and experience of EzyLearn and
- how things have changed for them.
See EzyLearn Worklife Interviews
Training Enquiry
Get the right training for your goals, needs, circumstances and budget
Absolute Excel Beginners to Advanced Excel Training Courses
The online Microsoft Excel COMPLETE training course includes everything. It is ONE price for ALL 9 courses (and every new Excel course we create) including:
- Excel Beginners Training Course 301: Open and Understand Spreadsheets
- Excel Beginners Training Course 302: Creating and Editing Spreadsheets
- Excel Beginners Training Course 303: Formulas, functions and formatting
- Excel Intermediate Training Course 304: Viewing and printing
- Excel Intermediate Training Course 305: Charts & Graphs
- Excel Intermediate Training Course 306: Intermediate Functions and cell referencing
- Excel Advanced Training Course 307: Databases, filter/sort, named ranges
- Excel Advanced Training Course 308: Pivot tables, 3D formulas, Advanced Formulas and protection
- Excel Advanced Training Course 309: Goal Seek, data consolidation and Solver
New & Updated Excel Course Materials
We create our Microsoft Excel training course manuals, video tutorials and exercise files and rather than pay rent on training rooms and hire trainers for classroom lessons we allocate more resources to providing student support and updating and adding to our course materials.
As an Excel course student you get access to all new and updated resources for the duration of your course access. Initial course access is for 12 months and there are options to extend your course access with an annual membership or with our LIFEITME course access enrolment option.
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 so you can fit your study into your busy life in short easy to manage stages.
Microsoft Excel Beginners Certificate Training Course (free sample)
- 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 Intermediate Certificate Training Course
- 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 Advanced Certificate Training Course
- Microsoft Excel (course 307) – Databases, filter/sort, named ranges, Get and Transform Data (NEW)
- 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
9 Microsoft Excel courses available separately!
If you only need Excel Beginners, Intermediate or Advanced you can enrol into these separately rather than enrol into the Microsoft Excel COMPLETE Training Course Package.
Training Methods used for Excel Training Courses
We have taught over 15,000 students how to use Microsoft Excel between 1996-2006 at our Sydney training centres (Lane Cove, Dee Why, Gordon and Parramatta) and then online from 2007 until today. As a training course creator we update our training materials regularly to ensure they are current and up-to-date so that students are comfortable performing office support and administration tasks that are performed in millions of offices around the world.
See What EzyLearn Students Say..
We interviewed EzyLearn graduates after they completed their studies to find out more about their work life. We asked them about
some of the challenges they face in the workplace,
- their opinions and experience of EzyLearn, and
- how things have changed for them.
See EzyLearn Worklife Interviews
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 video tutorials
- 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 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?
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.
Text EZYEXCEL to 0488 883 655 to get the
FREE Excel Training Course Sample
Training Enquiry
Get the right training for your goals, needs, circumstances and budget
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.
Learn how to use Pivot tables and Pivot Charts to better understand the practical application from a lot of data. Perform data analysis to determine the best way of utilising the resources available to you.
One of the case studies you’ll go through involves deciding how to best utilise several meeting and training rooms based on historical usage information.
This case study can apply to manufacturing, sale of products and many other useful situations were you analyse data to make business decisions.
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.
* Practical Excel Training Case Studies to reduce your mortgage
The property market in Australia sometimes runs hot and ordinary people borrow 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. The financial functions in Microsoft Excel enable you to perform a variety of calculations to see the potential future outcomes (and savings).
The property loan calculator is one of the case studies that makes 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.
Microsoft Excel Macro Micro Course
So many programs export into the Excel spreadsheet format because Excel has the power to help you manipulate the numbers to generate forecasts, cashflow reports, graphs and charts and even just change the format of exported data so you can import it into another application.
Our Microsoft Excel Advanced Training Course takes some information that was exported from the popular Xero Accounting software. You’ll learn how to use Excel Macros to perform repetitive tasks quickly.
When you have a given export format and you need to make the same formatting or function changes every time you can do it faster with a Macro – faster still with a button you can click to launch the Macro.
Certificate in Business Administration
Learn the skills to perform data entry, office administration support jobs as well as advanced skills needed in office administrator jobs. This course package includes training using Microsoft Office software programs as well as Australia’s leading accounting software programs MYOB and Xero Accounting
See the contents of the Certificate in Business Administration (open at our new course catalogue website)
See the full list of topics covered see our
Microsoft Excel Course Outline.