Microsoft Excel Training – Beginner to Advanced Level
Description
What you’ll learn
-
You will learn how to create Summary Reports with Interactive Dashboard 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 with Practice Files)
-
You will learn Pivot table Step by Step for creating Summary reports
-
Conditional Formatting with 12+ Sub options
-
Paste Special (To convert Formulas to Values)
-
You will also learn how to create Drop Down button in Cells with Validation options
-
Macros (Recording & Running) to Automate your regular formatting work
-
I will also train you on using SUMIF & SUMIF formulas which is used to create Summary Reports
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.com
Who this course is for:
- Finance Manager
- Students
- HR Managers
- Sales Manager
- Training Manager
- Executives
- Analyst
- Admin
Course content
- Useful Excel Shortcuts
- Conditional Formatting (Highlight / Color data on the basis of Criterias)
- Deleting Blank Rows from huge database (3 Methods)
- Sorting & Filtering
- Creating Beautiful Charts
- PIVOT Table – Creating Dashboard – Summary Report with Pivot Table
- Paste Special
- Validation
- Macros Recording and Running
- Sub total & Text to Column (To Seperate First Name & Last Name)
Price
: 14.99 EUR
Brand
Ramzan Rajani
12 reviews for Microsoft Excel Training – Beginner to Advanced Level Ramzan Rajani, Sale
There are no reviews yet.