Mastering Excel Formulas LIVE

By a top Microsoft Excel Specialist & Microsoft Certified Trainer

1st July 2024

8:00 pm to 9:00 pm

Daily 1 hour

LIVE Workshop

100% Practical

Exclusive LIVE Formula Workshop

Register before December 09, 2024 to unlock bonuses

Who is this workshop for?

Excel users who want to learn how to write advanced formulas from scratch
This course is for you if you are looking for a clearer understanding of how to use common functions, where to find them and some tips and tricks to make your work with functions easier.

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

Mastering 6 Most Important Excel Functions

  • CountIF & CountIFS
  • SumIF & SumIFs
  • Average IF & Average IFs

Mastering Vlookup & Xlookup

  • Vlookup & Xlookup
  • Using IFError in Vlookup
  • Understanding Vlookup with Match

Logical Condition

  • IF Condition
  • Multiple IFs
  • Using AND & OR Condition in IF

Other 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)

Practical Assignment

  • Complete 1 hour Assignment
  • Course Completion Certificate

Activate Your Exclusive Bonuses

Excel Tips & Tricks E-Book

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

AED 99

100+ PowerPoint Infographics

Create stunning presentations easily using premium Infographic Templates

AED 200

Time is running out. Grab your spot fast!

Know Your Mentor

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!

If you checked ANY of the boxes above, then you’re invited to join this  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 contact@upgradeskill.ae