Learn Complete Data Analytics With Excel In 30 Min

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 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
Requirements
MS office installed on desktop/ laptop
Office 365 for xlookup
Includes a Udemy certificate of completion which you can use to illustrate your Excel and Power BI skills on your resume and in interviews.
Videos are made using Excel 2016, techniques work with any version of Excel - unless stated in the individual videos
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 slicersGet LIFETIME access to project files, homework exercises, and 1-on-1 expert supportPractice on 2 related datasets for power BIGet free access to 160 formulas with detailed examples for eachBonus : 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 eachAll excel shortcuts pdfPivot TablesPivot ChartsSlicersDashboardsCopying text from any imageConditional formattingGoal seekData tableSolverText to columnsProtect sheetRemove duplicatesData validationCase studies on automation using VBA What all you will learn from excel course:165 formulas sheet with detailed examples for eachAll excel shortcuts pdfPivot TablesPivot ChartsSlicersDashboardsCopying text from any imageConditional formattingGoal seekData tableSolverText to columnsProtect sheetRemove duplicatesData validationCase studies on automation using VBA
Overview
Section 1: Demo video on Excel Pivots with 160 + detailed excel formulas sheet
Lecture 1 Introduction video on pivot tables and charts with dashboards and slicers
Lecture 2 Formulas sheet
Section 2: Excel - Pivots, Charts, Dashboards, Slicers
Lecture 3 Pivot Tables, Charts, Dashboards, Slicers, Paste Special, Data Validation etc.
Lecture 4 Selecting multiple criteria - Student Query.
Lecture 5 Demo video on pivot tables and shortcut to get text from images to avoid typing
Section 3: Excel - Xlookup All Variants with practice file
Lecture 6 Xlookup lesson with practice file
Section 4: Excel - Additional downloads
Lecture 7 Download attached Excels, where you learn conditional formatting, goal seek etc
Section 5: Excel - Pivot Practice Files , 5 additional pivot data sheets for practice
Lecture 8 Bonus Lecture - Excel sheet with data on loan, accidents, expenses, food, hockey
Students or professionals who work with any kind of data in excel to draw insights from it,From Analytics for Accounting/ Bookkeeping to Analytics for investment banking or Analytics for data science. Anyone who is looking to become expert in data analysis in Excel at work and on their resume.

Homepage

https://www.udemy.com/course/excelpivots/