Advanced excel - Beginner to Ninja level (Including Charts)

Offered byUDEMY

Advanced excel - Beginner to Ninja level (Including Charts)
at
UDEMY
Overview

This course helps learn Excel Online for MIS Reporting, Data Cleaning, Data Analysis, Charting, Time-saver tricks with Examples

Duration	13 hours
Total fee	₹449
Mode of learning	Online
Official Website	Go to Website
Credential	Certificate

Advanced excel - Beginner to Ninja level (Including Charts)
at
UDEMY
Highlights

Certificate Will be issued after completion of training

Advanced excel - Beginner to Ninja level (Including Charts)
at
UDEMY
Course details

Skills you will learn

Excel Conditional Formatting Vlookup Macros Data analysis Advanced Excel

Who should do this course?

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

What are the course deliverables?

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]

More about this course

This Course 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.

Advanced excel - Beginner to Ninja level (Including Charts)
at
UDEMY
Curriculum

Look ups

VLOOKUP - Pre-requisites and Common Pitfalls

VLOOKUP - True (1) vs. False (0)

Reverse Look Up and Pivot Table

Data Validation (Numbers, Dates, Text length)

INDEX with MATCH ? Reverse 2-way Lookup

Data Cleansing Functions

Using CONCATENATE, & - to join data strings

Text-to-Columns - Delimited

Logical Formulaes and Conditional Formatting

Logical formulas I - IF, Nested IFs

Logical formulas II - AND, OR with IF

What If Analysis

What IF Analysis ? Scenario Manager

What IF Analysis ? Goal Seek

3D Data Consolidation, Print Tricks, Password, Formula Audit

3-D Data Consolidation from same/different Workbooks #1

3-D Data Consolidation from same/different Workbooks #2

Charts

Basic Charts ? Bar, Column, Pie

Special Charts: Thermometer Charts

Macros Basics

Macros ? Overview, Developer tab, Settings

Macros ? Recording, Running; Using Buttons to run Macros

Advanced excel - Beginner to Ninja level (Including Charts)
at
UDEMY
Faculty details

Rishabh Pugalia

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.