Mastering Excel Formulas LIVE

By a top Microsoft Excel Specialist & Microsoft Certified Trainer

5 days Workshop

27th Aug to 31st Aug

Daily 1 hour

LIVE Masterclass

8 pm to 9 pm

LIVE with Trainer

Who is this workshop for?

Data Analyst

Sales Specialist

Accountant

Financial Analyst

Project Managers

Finance Team

What will you learn in this workshop?

Basic formulas In Excel

Difference between: Sum & SubTotal
Min, Max & Average Formulas
Left, Right & Mid
Count, CountA & CountBlank
Concatenate, Trim & Clean
Adding $ Sign in Formulas

Module 1

Mastering 6 Most Important Excel Functions

CountIF & CountIFS
SumIF & SumIFs
Average IF & Average IFs

Module 2

Mastering Vlookup

Using Match Function to
Fully Automate Vlookup
Understanding Index & Match

Module 3

Logical Conditions

IF Condition
Multiple IFs
Using AND & OR Condition in IF

Module 4

Other Valuable Excel Functions you should know

Converting Case: Upper, Lower & Proper Length
Find with Search
Text & Substitute
Today & Now
Calculating Time
Calculating Differences Between Dates with DATEDIF (Legacy Function)

Module 5

Practical Assignment

Complete 1 hour Assignment and Get Your Course Completion Certificate

Assignment

Activate your exclusive bonuses worth over

₹ 9,500

Excel Tips & Tricks E-Book

An Excel cheatsheet with shortcuts to simplify your learning and save your time.

₹4500

100+ PowerPoint Infographics

Create stunning presentations easily using premium Infographic Templates

₹2000

Customised Excel Template Bundle

An easy-to-use Excel template bundle to make your life easier

₹3000

10% Flat Discount on all future 5-day workshops

Lifetime 10% discount on all future 5-days workshops and webinars.

Priceless

Grab Your Bonuses Now! Time is running out!

00Hours
00Minutes
00Seconds

Meet your Trainer

Ramzan is passionate about telling stories with data. Microsoft Certified Trainer,Excel Specialist with Power BI.

17+ years of experience in managing large databases, from requirements gathering through implementation and support.
Currently serving corporate clients across Gulf and Europe taking care of their training programs, helping them in preparing & analysing customized summaries & MIS Reports, Creating Dynamic HR, Sales & Financial Dashboards, Automating regular reports with Macros and Creating Interactive Dashboards using Power BI

Have conducted sessions in corporates such as Ferrari, Landmark, National Bank of Fujairah, Roche, King Span and many other companies in UAE, India, Saudi Arabia, Oman, Qatar, Malaysia & Maldives with excellent feedback.
Have trained more than 55,000+ people from various companies from Junior to Senior management across GCC locations.
Ramzan helps answering business questions using data in creative ways.

Earn your Excel Formulas Expert certification

Yes, you will receive certification from a Microsoft Certified Trainer, which lends a lot of credibility to your certificate and resume.

You may not believe me, but you can believe them

Experiences shared by people who previously attended this workshop

Still Wondering If the Workshop is for YOU?

Please check all boxes, where your answer is YES!

I have started to use Microsoft Excel daily but i still haven’t mastered it.

I want to get better job opportunities but I lack Excel knowledge.

I want to be more efficient and faster in using Microsoft Excel & save time daily.

I want to learn Advanced Excel Formulas to make my work smoother and life easier.

I feel Advanced Excel is difficult and I need a mentor for understanding it.

I want to create a good reputation among my manager & colleagues with stunning Excel reports.

If you checked ANY of the boxes above, then you’re invited to join The 5 Days Excel Formula Workshop.

Frequently Asked Questions

We have answered all common questions below that you might have about the workshop. For any further queries, please reach us at [email protected]

I made the payment but didn’t receive any email

Write to us at [email protected] and our support team will be able to resolve your issue in the shortest amount of time.

Will this be live or pre-recorded?

The workshop will be completely LIVE.

How much experience do I need for this workshop?

There is no prior experience required for this workshop.

Can I get a refund?

No. We do not offer refunds in any case. If you are unsure about the workshop, read testimonials, learn more about the trainer, and make an informed decision. If you miss the live workshop, we will move you to the next batch only ONCE.

Will I get a certificate after completion?

Yes, you will receive a certificate of completion from a Microsoft Certified Trainer after completing the workshop.

What is the time zone?

It is IST(Indian Standard Time).