Excel Basic to Advanced Training

By a top Microsoft Excel Expert & Microsoft Certified Trainer

Practice File Included

Life Time Access

Certificate of Completion

100% Pratical

Who is this workshop for?

Data Analyst

MIS Executive

Accountant

Financial Analyst

Business Analyst

Sales Department

Learning & Development Team

What will you learn in this course?
Course Content

Creating Reports with Pivot table
Using Slicer
Using Timeline
Creating Multiple Reports on one Sheet

Day 1 - Pivot Table

Creating Dynamic Charts
Funnel Chart
TreeMap Chart
Sales vs Target Chart
Secondary Axis Chart
Linking Chart to PowerPoint (Auto Updation)

Day 2 - Charts

Highlight dates on Specific Condition
Implementing Formulas in Conditional Formatting

Learn how to Practically use
Icon Sets
Data Bars
Top / Bottom Rules

Day 3 - Conditional Formatting

Dynamic Table
Magical Fill
Combine First & Last Name without Writing Formulas

Day 4 - Flash Fill

Macros Recording & Running
Creating Dynamic Macros if extra data is added
Understanding Relative Reference in Macro
Viewing Macros Code
Delete Macro

Day 5 - Macros

Cleaning Messy data with Power Query
Learn to Combining Multiple Sheet
Transforming data

Day 6 - Power Query

Practical Assignment

Day 7 - Assignment

Activate Your Exclusive Bonuses

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

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.

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 the Workshop is for YOU?

Please check all boxes, where your answer is YES!

I use MS 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 should register for this course (Microsoft Excel Basic to Advanced Level 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?

All the Videos are Pre-Recorded, hence you can watch at anytime – anywhere

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?

All the Videos are Pre-Recorded, hence you can watch at anytime – anywhere

₹999 ₹5000

3400+ Enrolled

Excel Basic to Advanced Training

Who is this workshop for?

What will you learn in this course? Course Content

Creating Reports with Pivot table

Using Slicer

Using Timeline

Creating Multiple Reports on one Sheet

Creating Dynamic Charts

Funnel Chart

TreeMap Chart

Sales vs Target Chart

Secondary Axis Chart

Linking Chart to PowerPoint (Auto Updation)

Highlight dates on Specific Condition

Implementing Formulas in Conditional FormattingLearn how to Practically use

Icon Sets

Data Bars

Top / Bottom Rules

Dynamic Table

Magical Fill

Combine First & Last Name without Writing Formulas

Macros Recording & Running

Creating Dynamic Macros if extra data is added

Understanding Relative Reference in Macro

Viewing Macros Code

Delete Macro

Cleaning Messy data with Power Query

Learn to Combining Multiple Sheet

Transforming data

Practical Assignment