Course Information
Course Overview
Learn complete data analytics with excel in 30 minutes - Charts, Pivots, Dashboard, Formulas
Learn complete data analysis in excel using pivots in less than 30 minutes and also all excel formulas with detailed examples for each.
"Carefully designed to make people learn pivots in less than 30 minutes, all aspects in the course are right direct to the point with no wastage of time for the candidates"
"Impress your boss and colleagues with the new skills you learnt within a day."
Take your data analysis skills from ZERO to PRO with Excel Pivot Tables
Learn how to use Pivot Tables and Pivot Charts and dashboards to visualize data with slicers
Get LIFETIME access to project files, homework exercises, and 1-on-1 expert support
Practice on 2 related datasets for power BI
Get free access to 160 formulas with detailed examples for each
Bonus : Learn about the real world automation cases built by using Excel VBA, excel shortcuts
What all you will learn from excel course:
165 formulas sheet with detailed examples for each
All excel shortcuts pdf
Pivot Tables
Pivot Charts
Slicers
Dashboards
Copying text from any image
Conditional formatting
Goal seek
Data table
Solver
Text to columns
Protect sheet
Remove duplicates
Data validation
Case studies on automation using VBA
What all you will learn from excel course:
165 formulas sheet with detailed examples for each
All excel shortcuts pdf
Pivot Tables
Pivot Charts
Slicers
Dashboards
Copying text from any image
Conditional formatting
Goal seek
Data table
Solver
Text to columns
Protect sheet
Remove duplicates
Data validation
Case studies on automation using VBA
Course Content
- 5 section(s)
- 8 lecture(s)
- Section 1 Demo video on Excel Pivots with 160 + detailed excel formulas sheet
- Section 2 Excel - Pivots, Charts, Dashboards, Slicers
- Section 3 Excel - Xlookup All Variants with practice file
- Section 4 Excel - Additional downloads
- Section 5 Excel - Pivot Practice Files , 5 additional pivot data sheets for practice
What You’ll Learn
- Complete pivot tables, charts, dashboards, slicers with a bonus file which contains all excel formulas (160) with detailed examples for each, "Carefully designed to make people learn pivots in less than 30 minutes , all aspects in the course are right direct to the point with no, Practice on 6 real world pivot datasets to work on for excel, Learn to impress your manager with great looking dashboards made from pivots, Learn to analyse large data sets with Pivot Tables and make decisions, Earn certification on Excel.
Skills covered in this course
Reviews
-
NNallapareddy Krishna Sahithi
Practical and very useful in daily mis activities.
-
SSufi
Very good for beginners to decrease work time
-
SSekar G
The course is explained in a lucid language & easy to understand.
-
MMaria N
Good