Microsoft Excel Certification Level 1

Please Note: This course uses the Windows version of Microsoft Office 2016. Any other versions will have some differences in the functions.

Microsoft (MS) Excel is one of the most widely used data capture and analysis tools in the world. Whether the team member is new to the use of Excel spreadsheets or already has some knowledge of the software and is looking to improve upon their skills, this series of courses – Level 1, Level 2 and Level 3 Excel – can assist.

What’s Covered in the Course?

This Level 1 starter course is recommended for anyone in the business that may use Excel for uncomplicated data capture and analysis, such as tracking simple expenditure or for calculating sums or totals. The course is ideal for anyone who:

  • Has never used Excel before;
  • Has only a basic understanding of the software;
  • Wishes to update their skills to the latest version of the software.

It is also the ideal starting point for those who wish to go on to use Excel for more advanced applications, such as functions and formulae.

The course covers all the basics, such as calculations of sums, averages and totals. The team member will learn some of the basic functions, such as IF, COUNTIF, SUMIF and AVERAGEIF, as well as the use of pivot tables, creating graphs and charts.

The second half of the Level 1 course covers ‘sheets’ – the Excel equivalent of a page. The team member will learn how to rename, delete, hide and unhide a sheet and how to move and copy a sheet. They will also learn how to change the colour of the tabs.

What are the Benefits of the Course?

  • Skilled Excel users are able to transform raw data to the benefit of the organisation;
  • The explicit training videos allow employees to learn at their own pace, as there is no time limit or deadline by which to complete the courses.
  • Learners can access these courses from any mobile device – tablets, computers, and mobiles – with access to the internet;
  • As each lesson is only a few minutes long, it is convenient to stop and start again, whenever the learner wishes to do so - this encourages employees to study when they have the time, even if it is during a lunch break;
  • Lifetime access to the course materials means that the learner will always be able to refresh their knowledge and skills, even years later.


Course Modules/Lessons

Module 1: Introduction to Excel

Module 2 : Add

Module 3 : Multiply

Module 4 : Subtraction in Excel

Module 5 : Dividing

Module 6 : Sort

Module 7 : Percentage

Module 8 : Running Totals

Module 9 : Print

Module 10 : Paste Special

Module 11 : Merge

Module 12 : Filter

Module 13 : Average

Module 14 : AVERAGEIF

FIND OUT HOW WE CAN HELP TRAIN YOUR STAFF



FAQ's

  • Who can take the Microsoft Excel Certification Level 1 course?

    There are no entry requirements to take the course.

  • What is the structure of the course?

    The course is broken down into 14 individual modules. Each module takes between 20 and 90 minutes on average to study. Although students are free to spend as much or as little time as they feel necessary on each module.

  • Where / when can the course be studied?

    The course can be studied study at any time and from any internet connected device

  • Is there a test at the end of the course?

    Once you have completed all 14 modules there is a multiple choice test. The questions will be on a range of topics found within the 14 modules. The test, like the course, is online and can be taken a time and location of your choosing.

  • What is the pass mark for the final test?

    The pass mark for the test is 70%.

  • What happens if a user fails the test?

    If the user doesn’t pass the test first time they will get further opportunities to take the test again after extra study. There are no limits to the number of times a test can be taken.

  • How long does it take to complete the Microsoft Excel Certification Level 1 course?

    We estimate that the course will take about 15 hours to complete in total, plus an additional 30 minutes for the end of course test.