Learn complete data analytics with excel in 30 minutes – Charts, Pivots, Dashboard, Formulas
What you will 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 2 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.
Description
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 shortcutsWhat 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
English
language
Content
Free excel sheet of 160 formulas with detailed example for each formula.
Formulas sheet
Excel – Pivots, Charts, Dashboards, Slicers
Pivot Tables, Charts, Dashboards, Slicers, Paste Special, Data Validation etc.
Additional downloads – Excel
Download attached Excels, where you learn conditional formatting, goal seek etc
Advanced usage of excel – Automation VBA case studies
VBA Case studies automation
Pivot Practice File – Download
Bonus Lecture