Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication 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 Certifications Network & Security Hardware Operating Systems & Servers 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 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 Paid 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 & Gardening 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 & Diet Yoga Mental Health Martial Arts & 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 Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js PHP HTML5 Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 CompTIA Security+
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Data Analysis
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin Mobile App Development SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Personal Development Neuro-Linguistic Programming Personal Transformation Life Purpose Mindfulness Sound Therapy Meditation CBT Cognitive Behavioral Therapy
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Leadership
Digital Marketing Social Media Marketing Marketing Strategy Google Analytics Internet Marketing Email Marketing Copywriting YouTube Marketing Startup

Office ProductivityMicrosoftExcel

Advanced Excel - Beginner to Ninja level (includes Charts)

Learn Excel Online for MIS Reporting, Data Cleaning, Data Analysis, Charting, Time-saver tricks with Examples
Rating: 4.5 out of 54.5 (730 ratings)
3,149 students
Created by Rishabh Pugalia, Yoda Learning
Last updated 8/2020
English
English [Auto]

What you'll learn

  • Formulas and Functions, MIS Reporting techniques, Data Cleaning, Dashboards, Data Analysis, Charts, Tips-n-Tricks
  • Lifetime access to the Videos
  • Donwloadable PDF HandBook and Excel Case Studies
  • HD Quality available upon single-click [bottom-right of video]

Requirements

  • MS Excel 2007/2010

Description

"Advanced Excel Ninja" is a comprehensive online training program on Microsoft Excel. It is divided in 12 sections and covers exhaustive list of topics. There are 90+ tutorial videos and the duration is 13 hrs. Topics often ignored in other advanced online programs have been included. Demo Preview Lecture 89 and 90 to find the difference.

  • VLOOKUP() with MATCH()
  • HLOOKUP() with MATCH()
  • INDEX() with multiple arrays & two MATCH()
  • Using TRANSPOSE() formula
  • Form Control Buttons for Dashboard
  • SUMIF() vs. SUMIFS()
  • SUM() vs. SUBTOTAL() while using Filter
  • Hidden Text-to-Columns tricks
  • Using IFERROR() vs. IF() + ISERROR()
  • Applications of INDIRECT() and OFFSET()
  • Pivot Table tricks on calculating automatic sum, count, percentage and generating grouped data headings
  • 3-Data Consolidation
  • Power of "GO TO - Special" along with Ctrl+Enter
  • Using "Find and Replace" with wildcard characters
  • Combo techniques for Data cleaning
  • Formula-based Conditional formatting
  • Charts - Thermometer, 2 axis, Trendline, Axis value settings
  • Inserting Picture in Comments... and the list of such tricks is very long

So if you intend to take your Excel application skills multiple notches higher, gain from the experience of a training instructor who -

  • Is a qualified Chartered Accountant
  • Has worked with KPMG and J.P. Morgan
  • Has trained 12,500+ professionals (Apr 2010 - June 2016) in face-to-face training programs
  • Has incorporated in this online program 100s of tip-n-tricks, which he has acquired over the years through various forums, experimentation, problem solving challenges and training interaction

And by the way he has conducted more than 200 (two hundred) workshops for one of the Big Four firms, where the participants are from numerous departments and domains. The insights acquired have been meticulously incorporated in to the program.

Instructor: CA. Rishabh Pugalia, Founder, Excel Next

The participants will be provided lifetime access to videos plus downloadable Excel Case Studies and picture-based HandBook (PDF).

Who this course is for:

  • Working Professionals, Students of Professional Courses
  • Aspiring Corporate Trainers (Advanced Excel)

Featured review

Nazar Khan
Nazar K.
1017 courses
5 reviews
Rating: 5.0 out of 5il y a 2 ans
Amazing Trainer, Great and easy to Learn examples with great communication skills practical methodology He has covered each and every aspect of basic and Advance Excel. Highly recommend for Accounts Finance and Business Professionals.

Instructors

Rishabh Pugalia
CA | ex-KPMG, ex-J.P. Morgan | Taught @ PwC, EY, Deloitte
Rishabh Pugalia
  • 4.4 Instructor Rating
  • 819 Reviews
  • 8,929 Students
  • 2 Courses

                    Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 20,000+ professionals across various multi-national companies and professionals' forums. 

                    He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" . 

                   He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums. 

Yoda Learning
Data Analyst |MS Office Expert & PMP | Instructor/Programmer
Yoda Learning
  • 4.4 Instructor Rating
  • 10,091 Reviews
  • 139,668 Students
  • 24 Courses

     

20,000 Classroom Students | 100,000+ Students Online

ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years

I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)

After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.

If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.