• LOGIN
  • No products in the cart.

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

Course Reviews

4

4
1 ratings
  • 5 stars0
  • 4 stars1
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. Beneficial Excel Course

    4

    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

642 STUDENTS ENROLLED

About Us

LIBM is an international platform for enthusiastic learners. We provide accredited courses to equip professionals with the skills that are necessary for modern-day living. Our service connects students from all over the world, ensuring quality education for all. We also focus on self-development and personal growth training. Join our growing community today and get access to a whole new world of learning and certification!
December 2019
M T W T F S S
     
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

Search Popular Courses

Cart

copyright © LIBM