This Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) is best a combination of Microsoft Excel Beginners , Intermediate and Advanced which is designed to make the most in-depth, bestselling value for money Complete Excel Course on the market and you are getting this best selling course on only £25!
Microsoft Excel is one of the most widely used programmes in the world for visualising and analysing. This software is used in almost every industry, not to mention for personal use in households around the world. Small business owners rely on Excel to track hours, finances, and invoices, and large corporations rely on Excel for data analysis, to visualise data, and innumerable other tasks.
As you participate in each of the 3 courses you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.
You can learn at your own pace, as there is no time limit, nor deadline to complete the courses. You can access the course material with any device that allows you to access the internet, and you will receive online support while you train, which means it is available whenever and wherever you require it.
At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace.
Key features of the course:
- Lifetime access to the course
- No hidden fees, only pay the price of the course which includes exam fees.
- Recognised qualification upon successful completion of the course
- Study from anywhere, anytime, whenever it is convenient for you.
- Affordable and engaging e-learning study materials
- Study at your own pace from tablet, PC or smartphone
- Online tutor support when you are in need.
Who is this course for?
There is no experience or previous qualifications required for enrolment on this course. It is available to all students, of all academic backgrounds.
Assessment and Certification
The course is assessed online with a multiple-choice test, which is marked automatically. You will know instantly whether you have passed or not. Those who pass this test will have the qualification of Microsoft Excel Complete Course (Beginner, Intermediate, Advanced). Certificate will be produced in PDF format at an additional cost of £8.99 and Printed Hardcopy at £12.99.
Course Curriculum
Microsoft Excel Beginners | |||
Getting Started with Microsoft Office Excel 2016 | |||
Navigate the Excel User Interface | FREE | 00:28:00 | |
Use Excel Commands | 00:10:00 | ||
Create and Save a Basic Workbook | 00:19:00 | ||
Enter Cell Data | 00:12:00 | ||
Use Excel Help | 00:05:00 | ||
Performing Calculations | |||
Create Worksheet Formulas | 00:15:00 | ||
Insert Functions | 00:17:00 | ||
Reuse Formulas and Functions | 00:17:00 | ||
Modifying a Worksheet | |||
Insert, Delete, and Adjust Cells, Columns, and Rows | 00:10:00 | ||
Search for and Replace Data | 00:09:00 | ||
Use Proofing and Research Tools | 00:07:00 | ||
Formatting a Worksheet | |||
Apply Text Formats | 00:17:00 | ||
Apply Number Format | 00:08:00 | ||
Align Cell Contents | 00:09:00 | ||
Apply Styles and Themes | 00:12:00 | ||
Apply Basic Conditional Formatting | 00:11:00 | ||
Create and Use Templates | 00:07:00 | ||
Printing Workbooks | |||
Preview and Print a Workbook | 00:10:00 | ||
Set Up the Page Layout | 00:08:00 | ||
Configure Headers and Footers | 00:07:00 | ||
Managing Workbooks | |||
Manage Worksheets | 00:05:00 | ||
Manage Workbook and Worksheet Views | 00:07:00 | ||
Manage Workbook Properties | 00:05:00 | ||
Microsoft Excel Intermediate | |||
Working with Functions | |||
Work with Ranges | FREE | 00:18:00 | |
Use Specialized Functions | 00:11:00 | ||
Work with Logical Functions | 00:23:00 | ||
Work with Date & Time Functions | 00:08:00 | ||
Work with Text Functions | 00:11:00 | ||
Working with Lists | |||
Sort Data | 00:10:00 | ||
Filter Data | 00:10:00 | ||
Query Data with Database Functions | 00:09:00 | ||
Outline and Subtotal Data | 00:09:00 | ||
Analyzing Data | |||
Create and Modify Tables | 00:15:00 | ||
Apply Intermediate Conditional Formatting | 00:07:00 | ||
Apply Advanced Conditional Formatting | 00:05:00 | ||
Visualizing Data with Charts | |||
Create Charts | 00:13:00 | ||
Modify and Format Charts | 00:12:00 | ||
Use Advanced Chart Features | 00:12:00 | ||
Using PivotTables and PivotCharts | |||
Create a PivotTable | 00:13:00 | ||
Analyze PivotTable Data | 00:12:00 | ||
Present Data with PivotCharts | 00:07:00 | ||
Filter Data by Using Timelines and Slicers | 00:11:00 | ||
Microsoft Excel Advanced | |||
Working with Multiple Worksheets and Workbooks | |||
Use Links and External References | FREE | 00:12:00 | |
Use 3-D References | 00:06:00 | ||
Consolidate Data | 00:05:00 | ||
Using Lookup Functions and Formula Auditing | |||
Use Lookup Functions | 00:12:00 | ||
Trace Cells | 00:09:00 | ||
Watch and Evaluate Formulas | 00:08:00 | ||
Sharing and Protecting Workbooks | |||
Collaborate on a Workbook | 00:19:00 | ||
Protect Worksheets and Workbooks | 00:08:00 | ||
Automating Workbook Functionality | |||
Apply Data Validation | 00:13:00 | ||
Search for Invalid Data and Formulas with Errors | 00:04:00 | ||
Work with Macros | 00:18:00 | ||
Creating Sparklines and Mapping Data | |||
Create Sparklines | 00:07:00 | ||
MapData | 00:07:00 | ||
Forecasting Data | |||
Determine Potential Outcomes Using Data Tables | 00:08:00 | ||
Determine Potential Outcomes Using Scenarios | 00:09:00 | ||
Use the Goal Seek Feature | 00:04:00 | ||
Forecasting Data Trends | 00:05:00 | ||
Mock Exam | |||
Mock Exam- Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) | 00:30:00 | ||
Final Exam | |||
Final Exam- Microsoft Excel Complete Course (Beginner, Intermediate, Advanced) | 00:30:00 |
Beneficial Excel Course
I enrolled to the course already fairly familiar with excel but looking to deepen my understanding of the features within the program. To this extent the coverage offered by this course is fantastic, it introduces many of the beneficial features within the program and follows their introduction up with practical demonstrations of their use.
The tutor is clearly very knowledgeable about the subject and presents in a very clear and engaging manner.
A few negatives from the course;
While the coverage of features in the excel program is brilliant this course does not do much to explain how macros can be used in excel, so if this is what you are looking for then this course may not be for you.
Throughout the modules the tutor does occasionally make mistakes when explaining things, and while for the most part these are spotted and clarified, on some instances little explanation is offered as to why something was incorrect or not working.
Finally, the end exam for the course has very little to do with the students understanding of how excel can actually be used. It’s more just a pop quiz of terminology. The examination method does mean it’s difficult to genuinely test the students competence inside excel, however surely the questions could be geared more towards how to use the program rather than asking ‘What does this mean…?’ or ‘Where is this button…?’ It just feels like the exam is essentially pointless in terms of practically using excel in the real world.
Having said that, I want to re-affirm that the course content itself is really very useful to help the student become a more competent user of excel. The speed it is taught at and the progression from Beginner to Advanced level mean that it is applicable to all levels of user and I would recommend this course to anyone who needs to become a more knowledgeable and efficient user of excel.
Dan