Name: Microsoft Excel Complete Course – Level 1, 2 and 3
Price: 24.99 GBP
Rating: 5 (1 reviews)

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

1 ratings

5 stars1
4 stars0
3 stars0
2 stars0
1 stars0

Mia EllisNovember 30, 2017 at 11:46 am Reply

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.