Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 6.5 hours on-demand video
  • 3 articles
  • 5 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Excel Analytics

MS-Excel Mastery: Data Analysis & Dashboard Reporting

Get Command Over Your Gold Mine for Decision Making ! That’s Your Data.
Rating: 4.0 out of 54.0 (1 rating)
5 students
Created by Gurudutt Sharma
Last updated 4/2020
Hindi
30-Day Money-Back Guarantee

What you'll learn

  • Why you SHOULD be USING Custom Formatting?
  • SMART Ways to use Conditional Formatting!
  • Relative & Absolute Cell Referencing
  • Dashboard Formula Toolbox
  • Dashboard Formulas Toolbox: Advance
  • Custom Data Validation for Dashboards (Use formulas to check for text, numbers & length)
  • Excel Charts & Graphs: Learn the Basics for a Quick Start
  • Form Controls for Interactive Excel Dashboards
  • Interactive Dashboard with Pivot Table & Slicer
  • Top 21 Microsoft Excel Interview Questions
  • 150+ Excel Keyboard Shortcuts
  • The Best Shortcut Keys

Requirements

  • Data Analysis & Dashboard Reporting course will turn you in an MS-Excel Pro even if you know nothing about MS-Excel.

Description

A Very Unique and Powerful Online Course for Who wants growth in their career?...

Join me for My Easy to Understand Online Course to Get-Command Over Your Gold Mine for Decision Making! That’s Your Data.


"This Unique 30 Days Data Analysis & Dashboard Reporting course will turn you in an MS-Excel Pro even if you know nothing about MS-Excel."

Avoid the Hassles of Learning in Bit and Pieces and leverage my Rich Experience to Get Your Hands On Practice to Learn #1 Business Skills If You want to Grow Your Business or Career with Lightening Speed in the Year 2020. Once You make Systems It will lead to More Revenue and Accelerated Growth.


SAVE TIME & IMPROVE PRODUCTIVITY

  • Cut through the Hassles of learning in Bit & Pieces

  • Copy Paste the Spreadsheet Templates for Hands-on Practice

  • Simplified Course Considering Even If You are not Tech Savvy

  • Get Your Data Clean, Sorted and Automated

  • Jumpstart by Leveraging my Rich Experience

  • Your Key to True Entrepreneurship

  • Reduce Your Efforts

  • Accelerated Business Decision Making, resulting in More Revenue

Let’s Dig Deep and Check what you are going to learn with this

  • Why you SHOULD be USING Custom Formatting?

  • SMART Ways to use Conditional Formatting!

  • Relative & Absolute Cell Referencing

  • Dashboard Formula Toolbox

  • Dashboard Formulas Toolbox: Advance

  • Custom Data Validation for Dashboards (Use formulas to check for text, numbers & length)

  • Excel Charts & Graphs: Learn the Basics for a Quick Start

  • Form Controls for Interactive Excel Dashboards

  • Interactive Dashboard with Pivot Table & Slicer

Who this course is for:

  • Business owners - Manufacturers, Traders or Service Providers
  • CEO, CFO, CIO & COO
  • Department Heads - Finance, Accounts, Sales, Marketing, It & Admin
  • Management Consultants
  • Accounts & Finance Professionals
  • Sales & Marketing Professionals
  • MIS Professionals
  • CA, CMA, CS and Lawyers
  • HR Professionals
  • erson Want to Learn Most Sought Out Professionals & Business Skills

Course content

11 sections • 35 lectures • 6h 16m total length

  • Preview14:06
  • Downloadable Practice Files (30+ Assignments)
    00:01

  • Preview24:30
  • Custom Formatting : Part-2
    07:21

  • 6 Types of Conditional Formatting
    25:50

  • Relative & Absolute Cell Referencing
    06:05

  • SUM and SUBTOTAL
    06:31
  • Count-Functions
    09:48
  • All Date Functions & Formulas (15+ Example)
    20:52
  • Large and Small-Function
    06:27

  • VLOOKUP & HLOOKUP (Lookup AND Reference Function)
    08:01
  • INDEX MATCH Explained (An Alternative to VLOOKUP)
    07:52
  • INDEX MATCH (Part-2)
    05:49
  • SUMIF and SUMIFS
    25:32
  • IF Formula With Multipal Conditions
    12:03

  • Custom Data Validation
    17:23

  • Charting Element-Layout-Design
    06:48
  • Chart Axis & Template Designing
    10:01
  • Conditional Formatting Chart
    13:59
  • Amber Chart
    09:16
  • Bump Chart
    08:12
  • Image Overlay Chart
    10:32

  • Name Range with Formulas
    09:04
  • How to Use FORM CONTROLS
    11:45
  • Interactive Chart with Radio Button
    11:27
  • Interactive Chat with Combo Box
    07:40

  • Download Dashboard Master Files
    00:01
  • Understand Table & Create Pivot
    19:36
  • Format & Summarize Value Field By
    12:34
  • Value Fields Settings: Show Values As
    13:31
  • Grouping: By Date, Value & Text
    07:23
  • Pivot Charts Layout & Designing
    05:03
  • Insert Slicers: Make Data Faster & Easier
    11:55
  • Dashboard: Visual Appearance of Objects
    09:43

Instructor

Gurudutt Sharma
Instructor & Coach: Data Analysis & Visualization
Gurudutt Sharma
  • 4.0 Instructor Rating
  • 1 Review
  • 5 Students
  • 1 Course

My Vision

there is a Gurudutt in every home, who is struggling….

From Middle-class family, I failed in 7th Standard, I could not speak English well, that took a beating on my confidence.

Friends used to laugh at me, make fun of me. I was determined to change the way things were.

From that situation in life, doing my B-tech, getting employed by MNC companies like India Japan Lighting and Neokraft Global was a big deal for me.

But it didn’t happen by chance. I executed a clear plan in my mind to make it happen.

I know there is a Gurudutt in every home, who is struggling, from lack of self-esteem, lack of confidence, lack of required skill set which is required for growth in the career.

There is a lot of data in a company that personnel like you need to visualize and based on hat decision need to be made by you or management.

The right interpretation of data helps you in forecasting and planning to take the right decision for the future.

In this 21st century, the real power lies in the DATA ANALYSIS.

Data is a NEW currency...

Without DATA you are just an opinion

But you need the right tool and knowledge of data visualization techniques to stay ahead in your job.

This ONE knowledge changed my life.

And that’s is the best knowledge of Advance Excel and Data Visualization.

I got recognition in the company

I got to sit and interact with top management

I got the opportunity to solve complex organizational problems through data visualization

I got to become the indispensable company star employee

And all above got me ….

PROMOTION & INCREMENT


A boy once stamped as a failure in his school and by society turned out all odds against him and reached to the helm of top management as a General Manager in an MNC company.

I can attribute my success to so many factors.

But ONE thing which will always stand out will be the knowledge of ADVANCE EXCEL and zeal to learn new things.

In the year 2018, I decided to do something unique.

To help more people like me to advance in their career with the help of advanced excel and data visualization tools.

There was no one to teach me, so I had to figure it all by myself.

I don’t want anyone to be alone on this journey anymore.

“I spent over 17 years mastering Data Analysis, Data Visualization & Dashboard Reporting so you don't have to!”

Until now, these are my credentials

- 350 + live training’s

- 9000 professionals trained

- 1027 online course takers


I Want to Help You!

After 17 years of strong experience in the industry, I've decided to alter direction. Now, I want to share our passion by helping others to get mastery in the advance excel.

Our in-depth and practical courses are designed to empower you to save time, increase productivity at the workplace, get an appreciation for your work and help you get success in your career.


My Mission

My Mission to Empower & Transform 1 Million Career in India by raising their bar by helping them mastery in the advance excel.

If you want me to help you, check out my course page.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.