Contact for queries :
020 3900 4072

Want to get a new job or become better at your existing one?

MS Excel is the highest used and most in demand tool for processing your data. When you acquire this skill, you will become a sought after employee. If you are proficient in Excel, you can see your business in a completely different light. 

So, if you are looking for a job or even developing your business, learning Excel Essential is for you.

If you want to learn Microsoft Excel Course Online and have a basic understanding of Excel Essentials, this course is for you.

After soft skills, having a good understanding of Microsoft Excel is one of the most sought after skills employers look for today. Make sure you can Excel in the competitive job market of the time and keep yourself valuable.

If you are a novice looking for starting with Excel, or you want to have a Microsoft Excel Course Certification in your CV or portfolio, this place is truly for you.

Why take this course?

Our instructor of this course, Alan Jarvis has been using Excel for over 20 years now. But when it comes to being good at something and being able to teach it, there is a huge difference. He has tens of thousands of students in his portfolio. And he held their hands from the beginner stage to mastery.

This course took over 4 months for him to produce. He tested it extensively with hundreds of people. If something didn’t work or wasn’t clear, he revised the course until it did. His mission was to make this the best possible course on Excel.

Who is this course for?

This Microsoft Excel Essentials: Level 2 course is suitable for beginners to amateurs. After you take the decision of taking a Microsoft Excel Course Online, you probably want a course that will hold your hand as you go from beginner to advanced level. Anyone interested in working in this sector or who simply wants to learn more about the topic can benefit from this course. If you’re an individual looking to excel within this field then Microsoft Excel Essentials: Level 2 course is for you.

Course Requirements

The Microsoft Excel Essentials: Level 2 course is open to all. There is no formal entry requirements. All you need is a passion for learning, a good understanding of the English language, numeracy and IT, and to be over the age of 16.

How is the course assessed?

To successfully complete the course you have to pass an automated, multiple-choice test. The assessment is delivered through our online learning platform. You will receive the results of your assessment immediately upon completion.

Will I receive a certificate of completion?

Upon successful completion, you will qualify for the UK and internationally-recognised Microsoft Excel Course Certification and you can choose to make your achievement formal by obtaining your PDF Certificate at a cost of £5 and Hardcopy Certificate for £15.

Why choose the Institute of Accountancy:

  • High-quality e-learning study materials.
  • Step-by-step guideline.
  • 24/7 Access to the Learning Portal.
  • Recognised Accredited Qualification.
  • Study in a user-friendly, advanced online learning platform.
  • Excellent customer support.

Career Prospects

A Microsoft Excel Course Online could take you a long way in terms of your career. Being an expert in Excel can unlock the door to many career opportunities such as:

  • Administrative Assistant
  • Data Analyst
  • Accountants
  • Financial Analyst
  • Retail Store Manager
  • Project Manager
  • Business Analyst
  • Financial Planner
  • Investment Banker
  • Corporate Development Officer

Course Curriculum

Welcome To The Course
Welcome FREE 00:02:00
Project 1 - Creating A Data Entry Screen To populate Multiple Template
Proof Of Concept 00:05:00
Planning Ahead 00:02:00
Creating Our Data Entry Screen 00:04:00
(Custom) Formatting Dates And Time 00:06:00
Simple Calculations With Time 00:03:00
More (Useful) Calculations With Time 00:08:00
It’s About Time (And Dates) 00:08:00
Adding With Time 00:04:00
Creating A Template From An Image 00:12:00
Importing A Template From An Existing Excel File 00:02:00
Converting Time To A Decimal 00:06:00
A Little Bit Of Simple Data Entry 00:12:00
Simple Conditional Formatting For A Cleaner View 00:05:00
Calculating Time Out Of House Using Travel Time 00:05:00
Simple Logical Testing And Nested Logical Testing 00:08:00
Building Text Strings With A Formula 00:12:00
Before We Move OnAccessing The Developer Ribbon 00:01:00
A Tick Box Exercise (Of Sorts) 00:07:00
Auto-populating Check Boxes 00:12:00
PRACTICE EXERCISE 1 – Time To Add A New Entry 00:02:00
Defining A Working Area, And Protecting Your Work 00:05:00
PRACTICE EXERCISE 2 – Set Up A Working Area, And Limit User Entry 00:01:00
Project 2 - Building A Database With Excel
Simple VLOOKUPs 00:04:00
Step 1 – Get Some Data In, And Split It 00:04:00
Using Data Validation To Get The Right Input 00:04:00
Let’s Build Our Database! 00:06:00
Importing Data From A Text File 00:02:00
Importing Data From A Word File 00:03:00
Pulling Data From Multiple Sources 00:04:00
Using OTHER Look-Ups To Look Up! 00:05:00
LOOKUP From A LOOKUP With No Intermediary Step 00:02:00
Data Arrays Don’t Have To Start At A1 00:03:00
Some Common Reasons VLook-Ups Fail 00:06:00
One Inherent Flaw In Vlook Up 00:01:00
POWER USER – A Breakdown Of Looking Up Backwards 00:07:00
POWER USER – The Other Way Of Looking Up Backwards 00:07:00
Backwards Look-Ups In Action 00:04:00
POWER USER – Dealing With Inconsistencies In User Entry 00:08:00
POWER USER – Fuzzy VLOOKUPs 00:04:00
Power User – VLOOKUPs With Multiple Inputs 00:10:00
Power User – Looking Up Multiple Inputs Using An Array Formula 00:05:00
VLOOKUP’s BrotherHLOOKUP 00:05:00
POWER USER – The Holy Grail – How To Return Multiple Values From A Single Look Up 00:13:00
What To Look For When THAT Formula Didn’t Work 00:04:00
The Fastest Way To Modify Your Column Numbers 00:07:00
POWER USER – Vlook-Ups With Moving Columns 00:03:00
Putting It All Together 00:10:00
The Finishing Touch – How Many Records Did I Find 00:05:00
Project 3 - Named Ranges
A Simple Static Named Range Using A Single Cell 00:04:00
Creating A Named Range Using A Range Of Cells 00:03:00
Using Row Labels To Name Multiple Ranges 00:03:00
POWER USER – A Magic Trick Using Row And Column Labels 00:05:00
POWER USER – Dynamic Named Ranges 00:08:00
POWER USER – What To Do With Dynamic Names Ranges With Titles 00:05:00
3035 – POWER USER – Dynamic Charts 00:12:00
3040 – Horizontal Dynamic Named Ranges For Charts 00:11:00
Project 4 - What Can I have For Dinner?
What This Project is ACTUALLY Used For! 00:01:00
Hyperlinking To A Different Sheet In The Same Workbook 00:04:00
Creating Our First Macro 00:06:00
Assigning A Macro To A Button 00:04:00
Creating A List For Our Dropdown Using A Dynamic Named Range 00:02:00
Using A Conditional Format To Know When A Value Is Missing 00:05:00
Copying Conditional Formats And Creating Our Drop-Downs 00:03:00
Building Our FormulaINDIRECT Function 00:03:00
Building Strings For Indirect Sheet And Cell References 00:07:00
It’s A One Or A Zero 00:03:00
Working The Percentages And Adding Traffic Lights 00:04:00
POWER USER – The HYPERLINK Function (And Problem) 00:03:00
PRACTICE EXERCISE 1 – Fill In The Blanks 00:01:00
PRACTICE EXERCISE 2 – Pretty It Up (With A Macro) 00:02:00
PRACTICE EXERCISE 3 – Create A VLOOKUP Using A Built String With INDIRECT 00:02:00
Project 5 - Using Excel For Gantt Charts....Timelines And Project Plans!
Creating A Gantt Chart Using A Worksheet 00:08:00
Building The First Part Of Our Logical Test 00:04:00
Multiple Logical Tests At Once Using AND 00:08:00
Conditional FormattingWhere The Magic Happens 00:06:00
Gantt Charts Using The Built In Charting Tools 00:05:00
Gantt Charts With Different Colors For Different Criteria 00:08:00
Bonus Section - Just For Fun
How I Created Randomly Generated License Plate Numbers! 00:07:00
Student Questions Answered!
Calls Text Data – Or How To Return a Column Title If Value is 1 00:07:00
Calls Text Data 2 – This Time Using Text! 00:09:00
Extracting Phone Numbers From A Cell 00:03:00
What Is The CHOOSE Function Really Used For 00:15:00
Casing And Text Functions 00:07:00
Dynamic Charting From A Drop Down 00:10:00
SUMIF With Dynamic Sum Range 00:06:00
VLOOKUPs With Pictures! 00:05:00
Data Validation With Dependent Dropdowns 00:04:00
Data Validation With Dependent Dropdowns (Dynamic Named Range Workaround) 00:09:00
Kinda A Vlookup From 2 Drop-down Lists 00:07:00
Tiered Pricing 00:09:00
Worksheet Protection 00:05:00
The Middle Name Problemand Solution! 00:09:00
Finding Matches, And Counting Entries 00:08:00
Fee Calculator, or LOOKUPs That Are True, Not False 00:06:00
Resources
Resources : Microsoft Excel Essentials: Level 2 – Intermediate/Advanced 00:00:00

Course Reviews

4.5

4.5
1 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • £321.00 £19.00
  • UNLIMITED ACCESS
  • Course Certificate
  • Number of Units96
  • Number of Quizzes0
  • 8 hours, 54 minutes
  • CPD Accredited
  • Gift this course

Instructors

1 STUDENTS ENROLLED

    Our Students Say..

    Google Rating
    5.0