Learn Complete Data Analytics with Excel in 30 min only.

Learn complete data analytics with excel in 30 minutes - Charts, Pivots, Dashboard, Formulas

4.05 (26 reviews)
Udemy
platform
English
language
Finance
category
instructor
1,186
students
1 hour
content
Apr 2023
last update
$34.99
regular price

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 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

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

Screenshots

Learn Complete Data Analytics with Excel in 30 min only. - Screenshot_01Learn Complete Data Analytics with Excel in 30 min only. - Screenshot_02Learn Complete Data Analytics with Excel in 30 min only. - Screenshot_03Learn Complete Data Analytics with Excel in 30 min only. - Screenshot_04

Reviews

Angelo
November 22, 2021
Excellent course with great homework exercises. The instructor is knowledgeable and provides clear instructions to complete the tasks.
William
November 19, 2021
great explanation, i always prefer just to use SQL to analyze data, because i didnt really good with excel, but with this, i guess i can start to analyze data with excel pivot table
Subhasish
November 19, 2021
Fantastic course. Until today Pivot table was a very scary tool and I would use it with very vanilla use cases. Now I feel super confident.
David
September 22, 2021
The course material seems to be good, but the delivery is less than optimal. The audio pauses after every few words and the instructor speaks too fast.
Priya
January 6, 2021
Delivers as promised, in less than 1 hour i was able to apply the learnings and draw insights from our sales data. My manager was impressed with the dashboard visualization of our sales data region wise. Thank you for the simple yet effective way of explanation in the course.
Ram
January 3, 2021
Awesome!! Can't believe pivots and dashboards are so simple. The explanations are very clear and exactly to the point. Thank you for the bonus provided: automating typing from images. Iam ready to draw insights from any data now :D. Also, received cashback of 45 INR, will celebrate with an ice-cream. Thank you, Sir.

Charts

Price

Learn Complete Data Analytics with Excel in 30 min only. - Price chart

Rating

Learn Complete Data Analytics with Excel in 30 min only. - Ratings chart

Enrollment distribution

Learn Complete Data Analytics with Excel in 30 min only. - Distribution chart
3543100
udemy ID
10/3/2020
course created date
10/27/2020
course indexed date
Bot
course submited by