Explore the mandatory and advanced skills of Microsoft Excel to boost your office performance with the Microsoft Excel Complete Course – Level 1, 2 and 3 course.
It is quite impossible to find an office that does not use the world’s most popular and user-friendly spreadsheet program that helps you to organize your work and makes your financial records and other data easy to handle. Throughout the course, you will learn all the things chronologically that makes it one of the best choices for all types of learners starting from beginner to advanced learners.
You will be acquainted with the user interface of the application and how the basic techniques of calculating sums, average, and totals. The course shows you how to count the cells, wrap the text, merge the cells, and create graphs and charts. Moreover, the course shows you the strategies of using Pivot tables, hyperlinks, and the methods of inserting, editing and deleting comments and the right ways of pasting, sorting, and converting columns to rows
Apart from these, you will learn formulas, such as IF, COUNTIF, SUMIF, VLOOKUP, HLOOKUP, and AVERAGEIF.
To recapitulate, the course covers all the essential areas and features of Microsoft Excel.
Method of Assessment:
Upon conclusion of the course, there’s an online multiple-choice quiz assessment, which will determine whether you have passed the course. The test is marked immediately and results are published instantly (60% pass mark).
Certification:
Certificates can be obtained at an additional cost of £9.99 for PDF, £16.99 for Printed Hardcopy format and £24.99 for Both for Both PDF and Hardcopy Certificates.
Requirements
There are no academic entry requirements for this course, and it is open to students of all academic backgrounds.
Course Curriculum
Microsoft Excel - Beginners | |||
Module One – Getting Started | 00:30:00 | ||
Module Two – Opening and Closing Excel | 01:00:00 | ||
Module Three – Working with the Interface | 01:00:00 | ||
Module Four – Your First Worksheet | 01:00:00 | ||
Module Five – Viewing Excel Data | 01:00:00 | ||
Module Six – Building Formulas | 01:00:00 | ||
Module Seven – Using Excel Functions | 01:00:00 | ||
Module Eight – Using Quick Analysis | 01:00:00 | ||
Module Nine – Formatting Your Data | 01:00:00 | ||
Module Ten – Using Styles, Themes, and Effects | 01:00:00 | ||
Module Eleven – Printing and Sharing Your Workbook | 01:00:00 | ||
Module Twelve – Wrapping Up | 01:00:00 | ||
Excel for Newbies – Activities | 00:00:00 | ||
Microsoft Excel - Intermediate Level | |||
Module One – Getting Started | 00:30:00 | ||
Module Two – Working with Permissions and Options | 00:30:00 | ||
Module Three – Sharing Workbooks | 00:30:00 | ||
Module Four – Performing Advanced Formula and Function Tasks | 00:30:00 | ||
Module Five – Working with Array Formulas | 01:00:00 | ||
Module Six – Working With Macros | 00:30:00 | ||
Module Seven – Working With Forms | 00:30:00 | ||
Module Eight – Applying Advanced Chart Features | 01:00:00 | ||
Module Nine – Working With Slicers and Timelines | 00:30:00 | ||
Module Ten – Working With Multiple Tables, Relationships and External Data | 00:30:00 | ||
Module Eleven – Working With PowerView | 00:30:00 | ||
Module Twelve – Wrapping Up | 01:00:00 | ||
Activities- Microsoft Excel – Intermediate Level | 00:00:00 | ||
Microsoft Excel - Advanced Level | |||
Module One – Getting Started | 01:00:00 | ||
Module Two – SmartArt and Objects | 01:00:00 | ||
Module Three – Auditing | 01:00:00 | ||
Module Four – Creating Charts | 01:00:00 | ||
Module Five – Working with Charts | 01:30:00 | ||
Module Six – Creating Pivot Tables and Pivot Charts | 01:00:00 | ||
Module Seven – Macros | 01:00:00 | ||
Module Eight – Solving Formula Errors | 01:00:00 | ||
Module Nine – Using What If Analysis | 01:00:00 | ||
Module Ten – Managing Your Data | 02:00:00 | ||
Module Eleven – Grouping and Outlining Data | 01:00:00 | ||
Module Twelve – Wrapping Up | 00:30:00 | ||
Activities-Microsoft Excel – Advanced Level | 00:00:00 | ||
Mock Exam | |||
Mock Exam- Microsoft Excel Complete Course – Level 1, 2 and 3 | 00:30:00 | ||
Final Exam | |||
Final Exam- Microsoft Excel Complete Course – Level 1, 2 and 3 | 00:30:00 |
Good Experience
As a person who wants to learn Excel as fast as I can for my career, I can say that this is the best complete course I have ever taken. I am now able to use the Excel program at ease and be more productive with my work.