• LOGIN
  • No products in the cart.

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

Course Reviews

5

5
1 ratings
  • 5 stars1
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Good Experience

    5

    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.

TAKE THIS COURSE
422 STUDENTS ENROLLED

Top Sale Courses

ABOUT

We are a company who is best known for offering awarding body accredited courses for anyone who wishes to take their professional life to the next level.
St. Pauls College, 83 Victoria Street, London, SW1H 0HW

020 3900 1809
info@stpaulscollege.co.uk

Certificate Code

top
COPYRIGHT © 2017 STPAULSCOLLEGE.CO.UK