Complete-Microsoft-Excel-Course

Learn Excel from Beginner to Advanced Level

By a top Microsoft Excel Expert & Microsoft Certified Trainer

Practice File
Included

Life time Access

Certificate of
Completion

100% Practical

About the Course

Excel Version: Office 365 (Latest Version)
Skill Level: Suitable for Beginners to Advanced Users
Accessibility: Accessible via any internet browser, available as a lifetime resource
Language: Instruction in English
Video Duration: A comprehensive 20 hours and 15 minutes of content
Instructor: Expertly guided by a Microsoft Certified Trainer

What will you learn in this workshop ?
Course Outline and Topics

Excel Shortcuts (Speed Booster)

Excel Shortcuts Part 1

Excel Shortcuts Part 2

Revision

Conditional Formatting

Summarize Data with Pivot Table

Creating Charts

Column Chart

Line & Pie Charts

Combination Chart

Secondary Axis Chart

Linking Chart to PPT

Data Validation (Creating Drop Down in Cells)

Sparklines

Dynamic Table

Power Query

Data Protection

Grouping Rows & Columns

Hyperlink

Inserting Objects

Macros : Recording and Running

FORMULAS

Sum and SubTotal Formulas

Min, Max and Average Formulas

Clean & Trim Formulas

Change Case Formulas

Concatenate Formula

CountIF AND CountIFS

SumIF AND SumIFS

Basic IF Condition

Advanced IF

Linking Data From Other Sheet

Vlookup Basic to Advanced Level

Left, Right & Mid Formulas

Today & Now Formulas

Round, RoundUp & RoundDown Formulas

Text & Substitute Formulas

Networkdays Formulas

IF Condition with AND & OR Condition

Index & Match Formulas

Join Now & Start Learning

Time is running out!

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.

Get your Microsoft Excel 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 this Workshop is for YOU ?

Please check all boxes, where your answer is YES!

I use Advanced Excel on a daily basis, but I haven't mastered it yet.

I'd like to advance my career, but I don't have Advanced Excel skills.

I feel Advanced Excel is difficult and I need a trainer to understand it.

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

I want to be more effective and faster with Microsoft Excel and constantly save time.

I'd like to learn Advanced Excel in order to make my career and life easier.

If you checked ANY of the boxes above, then you’re invited to join The Microsoft Excel Basic to Advanced 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

I made the payment but didn’t receive any email

Write to us at contact@upgradeskill.ae 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 is recorded with practice files and your can learn as per your flexibility

How much experience do I need for this workshop?

There is no prior experience required for this workshop.

Can I get a refund?

Yes, we offer a refund policy. If the training is not right for you, you have 7 days to let us know, and we will happily refund your payment in FULL no questions asked.

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?

As its Recorded Videos, hence you can learn as per your time zone