Microsoft Excel Training - Beginner to Advanced Level (Udemy.com)

Learn from Microsoft Excel Specialist & Certified Trainer

( 99 Reviews )

Created by: Ramzan Rajani

Produced in 2021

What you will learn

I will train you on creating Summary reports with Pivot table
You will be able to create stunning charts (Column, Line & Pie)
Will be comfortable in writing your own IF Conditions and Multiple Level of IFs with examples
Will be able to pull data from another file with Vlookup (Step by Step explanation)
You will learn Pivot table Step by Step for creating Summary reports
Conditional Formatting with 10+ Sub options
Paste Special (To convert Formulas to Values)
You will also learn how to create drop down button in Cells for selection
Macros (Recording & Running) to automate your basic formatting work
I will also train you on using SUMIF & SUMIF formulas

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 94 / 100

Course Description

Excel skills are in high demand by most of the organizations.
In this course I will teach you Step by Step how to generate Summary reports, formulas from basic to advanced level including Vlookup, IF Condition, Multiple IFs and lot many which you can use in your reporting.
Each topic in this course is presented in a separate video lesson
This course will teach you how to save time and be productive.
You should Pause the video, rewatch, and repeat exercises until you mastered them.
Happy Learning !

Thanks & Regards
Ramzan Rajani
(Microsoft Excel Specialist and Certified Trainer)
ramzanrajani@gmail.comWho this course is for:

Finance Manager
Students
HR Managers
Sales Manager
Training Manager
Executives
Analyst

Time: 6h

Instructor Details

Ramzan Rajani

4.7 Rating
99 Reviews

Ramzan carries more than 18+ years of experience in the field of IT Training & Project Management. After getting his Diploma in Information Technology he did his MBA with Dual Specialization in IT Project Management.
He has experience of designing, managing & implementing large databases bearing very good understanding and extensive experience in Advance Excel, VBA - Macros programming, advance Powerpoint, Excel Dashboard, MS Access & MSP (Microsoft Project).
Along with other companies around the world he has done trainings for the following companies in UAE - Dubai : Manipal University, Etisalat, World Bank Group, Sharjah Islamic Bank, Emirates NBD, Redbull, Carestream health, Rotana, Funcity, Johnson & Johnson, Mastercard, Dulsco, AstraZeneca & MAF (Majid al Futtaim Properties).
Ramzan is based in Dubai.

Excel Basics (2017)

4.9 (15 Reviews)

Provider: YouTube
Time: 12h

Free

Microsoft Excel - Online Tutorial for Beginners (2010)

0.0 (0 Reviews)

Provider: Chandoo.org
Time: 1h 30m

Free

Excel Power Pivot and Power Query For Dummies

Excel Power Pivot and Power Query For Dummies (2016)

0.0 (0 Reviews)

Provider: Amazon

$14.53

More Courses

Reviews

4.7

99 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Pradeep

Good course for beginners. Thank you.

By Sarah Chenault

Very helpful information and very easy to follow lectures.

By Vikas Metange

Nicely explained the basic concepts and the good lesson for the beginner.

By Leon Schultz

This course provides one of the best and comprehensive guides for beginners and intermediates that I have personally encountered - also compared to paid Workshops and online courses. Great pace and depth, very skilled teacher. Thanks alot Mr. Rajani!

By Girish R S

very nicely explained. Each and everything crystal clear.. Thanks

By Alex pequeno

very clear, easy to understand.

By Usman Ali

Easy to Understand, The way he explain is very good...

By Daniel Alejandro LÃ³pez Castro

Muy bien explicado, se toma su tiempo para asegurar que el tema se entiende completamente

By Hector Alvizurez

I like the detailed explanation. exelent

By Gaurav Rohilla

Awesome videos....In-depth tutorial covering almost all the options of a particular function

By Brenda Campbell

I was looking for basic and instructor seemed to be talking to people more experienced than I. Also this is the 1st class I've taken online and wish I had

a paper copy to refer back to. Instructor certainly knew what he was doing.

By Nancy Assi