Advance Excel

Do you have an intermediate understanding of Excel but are keen to break through to true mastery? Want to finally use the programme with ease and confidence at work and become known as an expert user?

With this course you will learn how to create and format Pivot Tables, automate complex tasks with Macros, learn few functions and formulas and much more. You can learn what you need as quickly as possible, with as little
hassle as possible.

When you’re finished with this course, you’ll be a pro at Excel.

Who this course is for:

  • Our Advanced Excel course is suitable for those with a sound working knowledge of Excel who wish to progress to the most complicated functions and features.

What you’ll learn

  • Differentiate yourself at work. Quickly and dramatically
  • Take your career to the next level!
  • Build nested functions
  • Understand advanced Excel functions
  • Create complicated, problem-solving formulas with advanced logic, master Pivot Tables, automate complex tasks and much more…

Course Module 

  • Introduction

  • Using ROUND

  • Text

  • Using TEXT

  • The LEN Function

  • The IF Function

  • Using IF

  • More On IF

  • Using UPPER, LOWER & PROPER

  • The TRIM Function

  • Using VALUE

  • Working With Multiple Sheets

  • Drop Down

  • A Real World Scenario

  • Using COUNTIF & COUNTA

  • COUNT Together

  • Relative & Absolute

  • Introduction To Macros

  • Using VLOOKUP

  • Creating a VLOOKUP Invoice

  • VLOOKUP & IF

  • SUBTOTAL

  • Using HLOOKUP

  • Conclusion

Career Support & Job Market

Introducing local job market

Freelancing Guideline

Outsourcing Marketplace

So, come soon to be an expert in excel.

Course Details
Course Duration
2 Months
  • Above price/duration can change at any time.
  • Course fee is non-refundable. Once registered, students are not allowed to cancel the registration but can transfer to same/another course at a later date.
  • MCB reserve the rights to cancel course/classes if students’ registration are insufficient ( minimum numbers for a batch ) – if we cancel  we refund full registration/course fee.