Certificate in Microsoft Excel Course Guide

Upskill and improve your career prospects and earning capabilities with The Online Business Academy. Download your free PDF info pack to find out more about this course.

Gain an Industry Recognised Qualification

Receive a Free CV Review From Resume Hub

Receive Unlimited Tutor Support From Industry Experts

Certificate in Microsoft Excel

Detailed Course Curriculum

1. Microsoft Excel Basics

The Excel Basics module is the first module in the Certificate in Microsoft Excel course, designed for beginners who are new to Excel. In this module, participants will be introduced to the Excel environment and learn basic skills necessary to create and work with Excel workbooks. Participants will learn how to navigate the Excel interface, use the ribbon and quick access toolbar, and work with cells and ranges. The module will also cover using OneDrive, a cloud storage service that allows users to save and share their Excel workbooks with others. This module provides a foundation for the rest of the course and lays the groundwork for more advanced Excel skills covered in subsequent modules.

2. Working with Cells and Sheets

The Working with Cells and Sheets module provides students with fundamental skills and techniques to work effectively with cells and sheets in Excel. The module covers key topics such as cell basics, including entering, selecting, and editing cells, modifying columns, rows, and cells, and formatting cells. Participants will also learn about number formats, including currency, date and time, and percentages. The module also covers working with multiple worksheets, including how to insert, rename, move, copy, and delete worksheets. Other topics covered include using Find & Replace to quickly locate specific data in a worksheet, checking spelling, and page layout and printing options. By the end of this module, students will have the skills and knowledge to create, format, and manage cells and sheets in Excel.

3. Formulas and Functions

The Working with Formulas and Functions module in the Microsoft Excel course is an essential component for learners looking to become proficient in using Excel for data analysis. In this module, participants will learn how to create and edit formulas in Excel, understand and use simple functions such as SUM, AVERAGE, and MAX to perform calculations, and explore more advanced functions such as IF, COUNTIF, and VLOOKUP. They will also learn how to use cell references, absolute and relative references, and how to troubleshoot formula errors. The module emphasizes hands-on practice exercises, allowing learners to work with formulas and functions in Excel and apply their newly acquired knowledge in real-world scenarios.

4. Working with Data

This module focuses on data management techniques and tools. Students will be introduced to various tips and tricks for organizing and structuring data, such as freezing panes and sorting data. They will also learn how to filter and group data effectively and use tables and charts to represent data visually. Additionally, the module covers conditional formatting, which enables learners to highlight specific data based on certain conditions. By the end of this module, students will have a strong foundation in data management skills that will help them work more efficiently and effectively in Excel.

5. Doing More with Excel

In this module, students will explore advanced features of Microsoft Excel that will help them work more efficiently and effectively with large amounts of data. They will learn about data analysis tools such as PivotTables and PivotCharts, which can be used to quickly summarize and analyze data. The module also covers collaboration tools, including co-authoring and sharing workbooks, as well as techniques for inspecting and protecting sensitive data. By the end of this module, students will have gained advanced Excel skills that will enable them to work with complex data sets and collaborate more effectively with others.

6. Microsoft Excel Extras

This module aims to cover a range of additional Excel features that are not covered in detail in other modules of the course. Participants will learn about Office 365 and how it can be used to enhance their Excel experience. The module also covers the latest features in Office 2019, which includes new chart types and data analysis tools. Students will also be introduced to reference styles that can be used to ensure consistency in referencing across different Excel sheets and workbooks. The module will also provide an overview of Office Intelligent Services that can be used to simplify data entry and automate tasks. Finally, participants will learn about using the Draw tab to create custom shapes, and working with icons to improve the visual appeal of their Excel workbooks.

7. Microsoft Excel Quiz

The Microsoft Excel Quiz module is an assessment tool designed to evaluate a student’s understanding and proficiency in using Microsoft Excel. The quiz comprises multiple-choice questions covering a broad range of topics, from basic to advanced functions, formatting, data management, and more. The module aims to help students identify areas where they need to improve their Excel skills, and it provides them with immediate feedback on their performance. Additionally, the quiz provides an opportunity for students to apply their knowledge and put their skills into practice.

What Our Students Say

I've just got my first Google Ads client!!

I’ve just got my first google ads client!! I’m really happy and would like to thank you guys for your help in teaching me the ins and outs of Google Ads! I loved the module on setting up your own agency. My goal is to grow mine and get more clients nowl!

Thank you Imogen

I absolutely loved this course! Its simple structure made it easy to follow, and I want to give a special shoutout to Imogen, the fantastic tutor. She was incredibly helpful and always there whenever I got stuck.

I now run my own Facebook Ads

As a business owner I knew I had to run facebook ads if I wanted to grow but I didn’t know where to start. A friend recommended the facebook ads course here and it has been a game changer. It walked me though setting up various types of campaigns step by step and everything I learnt I now apply to my business. Also thanks to Richard for the help throughout the course!

I have a really great understanding of SEO

I can't express enough how grateful I am for the SEO course at the Online Business Academy. It provided with a really good, overall understanding of SEO principles and techniques. The tutors were also incredibly supportive and there whenever I needed help.

Very friendly and helpful stuff

Loved this course! It was straightforward and the staff were exceptional. I can't find any complaints, had a great learning experience and got to brush up on my accounting knowledge.

This course exceeded my expectations

This course was absolutely fantastic! It far exceeded my expectations in terms of quality and content. The material was presented in a clear and concise manner, making it easy to understand and apply. I was impressed by the depth of knowledge covered and the practical exercises provided, which helped solidify my understanding.

I recommend this to other e-comm store owners

I highly recommend the marketing course for e-commerce entrepreneurs at the Online Business Academy. The course focused on the unique challenges faced by e-comm sellers, providing valuable insights and strategies. Enrolling in this course has been a great investment so far.

Meet Your Expert Tutors

Your tutors will be here to help whenever you get stuck and need some help

Ronnie L.

Ronnie is an experienced and knowledgeable tutor specializing in Business courses. With a degree in accounting from De La Salle University, Ronnie brings practical examples and real-world insights to his teaching. Currently pursuing an MBA at the University of Queensland, he remains committed to continuous learning and staying up-to-date with the latest industry trends. Ronnie's exceptional communication skills and emphasis on practical application empower students to grasp complex business concepts and apply them in real-world scenarios.

Denise B.

Denise, a dedicated part-time tutor at the Online Business Academy, specializes in teaching Microsoft Office and Google Docs. As a stay-at-home mom, she brings practical experience and a nurturing approach to her role. Denise's expertise in these productivity tools allows her to effectively guide students in mastering their features and functionalities. Beyond teaching, she finds joy in cooking and spending quality time with her family. Her passion for cooking fuels her creativity in the kitchen, while engaging in family activities reinforces her nurturing nature and brings balance to her life.

Imogen H.

Imogen is a former Payroll Specialist with three years of experience, specializing in Xero and QuickBooks. With a deep understanding of payroll processes, regulations, and industry best practices, Imogen is dedicated to sharing her expertise as a payroll tutor. Her extensive knowledge of Xero and QuickBooks allows her to provide comprehensive training and support to students, equipping them with the skills needed to effectively manage payroll using these popular accounting software platforms.

Why Choose the Online Business Academy?

Industry Leader

Education Experts

World-class Learning Platform

Student Focused

Superior Support

Real Outcomes

Not sure if this is the right course for you?

This course comes with a 10-day money-back guarantee. This means you can cancel at any time within the 10 days and get a full-refund, no questions asked.

Frequently Asked Questions

How do I enrol?

There are no entry requirements or pre-requisites to enrol into this course. You can enrol online directly by clicking on “Enrol Now” and follow the prompts. Alternatively, you can enrol over the phone with our friendly student advisors. Give them a call on (02) 8006 0556 or email them at support@oba.au.

How much does this course cost?

This course costs $199 + GST. Click here to get started now.

How long is this course?

This course takes approximately 15-17 hours, and you’ll have lifetime access to this course. Study in your own time, at your own pace. Most of The Online Business Academy courses are designed so that you do one module a week. But if life gets busy you can take longer and even apply for a course extension if you need more time.

What job can I get once I have completed the qualification?

Upon the completion of this course, you can obtain a job as a Administrator, Office Clerk or Receptionist. These jobs in Australia earn approximately $55,000 per year but can be as high as $64,236 per year. (Payscale)

Contact a friendly student advisor on (02) 8006 0556 to find out about potential career outcomes and see where our courses can take you. Employers also constantly approach The Online Business Academy looking for students and employers also advertise jobs in the Career Centre (available once you enrol). You’ll also receive a FREE CV review.

Where will my qualification be recognised?

This qualification is Internationally recognised. Our qualifications are highly sought after by employers around the world and accredited by global industry bodies such as ICOES.

How does online learning work?

Your course will be delivered through our online learning platform. You can access our online learning platform from any web browser 24/7 so you can work whenever and wherever you want. You can also interact with your tutors and other students within the learning environment.

Online learning allows you to make the best use of your time and puts all the resources you need at your fingertips. There are no set course start dates, you can start whenever you are ready. Your tutors and student services will check in on your progress and help you every step of the way

Do you have a money back guarantee?

Absolutely! You’ve got an 10-day cooling off period (or trial period) at the start of your course. Take that time to look through all your learning material and get a feel for online learning. If you decide the course isn’t for you within the trial period, you’ll get a full money back guarantee.

Or speak to a student advisor.
Call (02) 8006 0556.