Microsoft Excel Complete Course – Beginners, Intermediate, Advanced

Online Self-Paced

Improve your competency in Microsoft Office with this Microsoft Excel Complete Course – Beginners, Intermediate, Advanced. Microsoft Excel is the most widely used spreadsheet program in the world. It allows businesses to conduct data analysis, record expenditures and carry out simple to complex maths calculations. Want to master Excel? This complete training course will help you gain the practical skills and knowledge you need to perform everyday data-based tasks faster and more efficiently.

This course is designed to help you familiarise with the major functionalities of Excel, with step-by-step guidance. You will start with simple tasks like viewing excel data, working with the interface, using quick analysis and more. At an intermediate skill level, you will learn about macros, forms, slicers, timelines etc. Finally, at an advanced level, you will learn how to create charts, pivot tables, solve formula errors and manage your data more effectively. This online course is the ultimate online guide for learning MS Excel. Certify your skills in this leading office software and gain maximum career progression!

Entry Requirement

This course is available to all learners, of all academic backgrounds.
Learners should be aged 16 or over to undertake the qualification.
Good understanding of English language, numeracy and ICT are required to attend this course.

Who is this Course for?

Professionals who want to learn how to use Microsoft Office Excel.
People who have a need to analyze and organise large amounts of data.

Assessment

At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful.
Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam.

Career Path

Microsoft Excel Complete Course – Beginners, Intermediate, Advanced is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as:

Accounting
Management consultant
Investment Banking Analyst
Marketing
Engineering
Researchering

Take this course

Course Awarding Bodies

course curriculum

Microsoft Excel - Beginners

Module One – Getting Started
Module Two – Opening and Closing Excel
Module Three – Working with the Interface
Module Four – Your First Worksheet
Module Five – Viewing Excel Data
Module Six – Building Formulas
Module Seven – Using Excel Functions
Module Eight – Using Quick Analysis
Module Nine – Formatting Your Data
Module Ten – Using Styles, Themes, and Effects
Module Eleven – Printing and Sharing Your Workbook
Module Twelve – Wrapping Up
Excel for Newbies – Activities

Microsoft Excel - Intermediate Level

Module One – Getting Started
Module Two – Working with Permissions and Options
Module Three – Sharing Workbooks
Module Four – Performing Advanced Formula and Function Tasks
Module Five – Working with Array Formulas
Module Six – Working With Macros
Module Seven – Working With Forms
Module Eight – Applying Advanced Chart Features
Module Nine – Working With Slicers and Timelines
Module Ten – Working With Multiple Tables, Relationships and External Data
Module Eleven – Working With PowerView
Module Twelve – Wrapping Up
Activities- Microsoft Excel – Intermediate Level

Microsoft Excel - Advanced Level

Module One – Getting Started
Module Two – SmartArt and Objects
Module Three – Auditing
Module Four – Creating Charts
Module Five – Working with Charts
Module Six – Creating Pivot Tables and Pivot Charts
Module Seven – Macros
Module Eight – Solving Formula Errors
Module Nine – Using What If Analysis
Module Ten – Managing Your Data
Module Eleven – Grouping and Outlining Data
Module Twelve – Wrapping Up
Activities-Microsoft Excel – Advanced Level

Mock Exam

Mock Exam- Microsoft Excel Complete Course – Beginners, Intermediate, Advanced

Final Exam

Final Exam- Microsoft Excel Complete Course – Beginners, Intermediate, Advanced

Explore More at John Academy

Certificate of Achievement

After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at the cost of £39 or in PDF format at the cost of £24.

PDF certificate’s turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days.