Adv. Excel Video Course - Innozant MIS & Data Analytics & Data Science

5.00(7)
Administrator Expert

Description

Want to learn Excel, but unable due to time restraint or any other reason.

Innozant offers you Mastering Excel Video Course. In this video course you will get pre-recorded video lectures. These topics are arranged in a sequential manner to give you a comprehensive insight into the depth of MS Advanced Excel. Along with videos you will be provided with other resources and assignments. The aim behind crafting this video course is to deliver the learning at your own flexible time and pace.

Benefit:

Life time accessibility

50 hrs + pre-recorded video lectures

Topics covered in sequential manner in full depth.

Assignments and other resources.

Doubt sessions: Once or twice a month

Certificate on completion

What you will learn:

  • Build a solid understanding on the Basics of Microsoft Excel
  • Master Microsoft Excel from Beginner to Advanced
  • Build financial models from scratch
  • Format sheets and charts professionally
  • Learn new keyboard shortcuts and be even faster in Excel
  • Use Cell Styles and format spreadsheets easier and faster
  • Writing Formulas and performing Calculations
  • Create charts with Trend Lines, and Dual Axis
  • Use Excel as a Database with Sort and Filter options
  • Database Design flaws
  • Functions: IF, PMT, VLOOKUP, FIND, SEARCH, MATCH, INDEX and much more…
  • Updated to include the new FILTER, XLOOKUP, SORT & UNIQUE functions
  • Learn several hidden: Excel tips and tricks.
  • Learn to use Pivot Tables, Pivot Charts, Slicers and Time Lines for Interactive Excel Reports.
  • Learn to make dashboards.

Download Brochure

Topics for this course

164 Lessons49h 59m 59s

Time duration: 60 Hrs +

LECTURE:1 – EXCEL INTRODUCTION & PASTE SPECIAL

LECTURE:2 – CELL REFERENCE

LECTURE:3 – CUSTOM AND CONDITIONAL FORMATTING

LECTURE:4 – LOGICAL FUNCTION – 1

LECTURE:5 – LOGICAL FUNCTION – 2

LECTURE:6 – MATH FUNCTION – 1

LECTURE:7 – MATH FUNCTION – 2

LECTURE:8 – TEXT FUNCTION – 1

LECTURE:9 – TEXT FUNCTION – 2

LECTURE:10 – TEXT FUNCTION – 3

LECTURE:11 – DATE AND TIME FUNCTION – 1

LECTURE:12 – DATE AND TIME FUNCTION – 2

LECTURE:13 – DATE AND TIME FUNCTION – 3

LECTURE:14 – STATISTICAL FUNCTION – 1

LECTURE:15 – STATISTICAL FUNCTION – 2

LECTURE:16 – STATISTICAL FUNCTION – 3

LECTURE:17 – DATABASE FUNCTION

LECTURE:18 – INFORMATION FUNCTION

LECTURE:19 – ERROR WORLD

LECTURE:20 – Goto Special Security

LECTURE:21 – PRINTING NAMING RANGE

LECTURE:22 – SORTING

LECTURE:23 – FILTER

LECTURE:24 – ADVANCED FILTER

LECTURE:25 – SUBTOTAL

LECTURE:26 – TEXT TO COLUMN FLASH FILL

LECTURE:27 – DATA VALIDATION – 1

LECTURE:28 – DATA VALIDATION – 2

LECTURE:29 – WHAT IF ANALYSIS – 1

LECTURE:30 – WHAT IF ANALYSIS – 2

LECTURE:31 – SCENARIO DATA CONSOLIDATION DATA TABLE

LECTURE:32 – ARRAY FUNCTION

LECTURE:33 – SUMPRODUCT FUNCTION – 1

LECTURE:34 – SUMPRODUCT FUNCTION – 2

LECTURE:35 – SUMPRODUCT FUNTION – 3

LECTURE:36 – SUMPRODUCT FUNCTION – 4

LECTURE:37 VLOOKUP

LECTURE:38 VLOOKUP COLUMN COLUMNS ROW ROWS

LECTURE:39 – DOUBLE VLOOKUP TWO LOOKUP VALUE

LECTURE:40 – HLOOKUP

LECTURE:41 – LOOKUP FUNCTION

LECTURE:42 – MATCH FUNCTION

LECTURE:43 – INDEX ARRAY FORMAT

LECTURE:44 – INDEX REFERENCE FORMAT

LECTURE:45 – INDEX EXAMPLES

LECTURE:46 – IMAGE LOOKUP OTHERS

LECTURE:47 – INDEX ONE TWO THREE WAY LOOKUP

LECTURE:48 – CHOOSE FUNCTION – 1

LECTURE:49 – CHOOSE FUNCTION – 2

LECTURE:50 – INDIRECT FUNCTION – 1

LECTURE:51 – INDIRECT FUNCTION – 2

LECTURE:52 – INDIRECT FUNCTION – 3

LECTURE:53 – ADDRESS FUNCTION

LECTURE:54 – OFFSET FUNCTION – 1

LECTURE:55 – OFFSET FUNTION – 2

LECTURE:56 – OFFSET FUNCTION – 3

LECTURE:57 – MASTERING VLOOKUP

LECTURE:58 – PIVOT TABLE – 1

LECTURE:59 – PIVOT TABLE – 2

LECTURE:60 – PIVOT TABLE – 3

LECTURE:61 – PIVOT TABLE – 4

LECTURE:62 – PIVOT TABLE – 5

LECTURE:63 – PIVOT TABLE – 6

LECTURE:64 – PIVOT TABLE – 7

LECTURE:65 – EXCEL CHART – 1

LECTURE:66 – EXCEL CHART – 2

LECTURE:67 – DASHBOARD – 1

LECTURE:68 – DASHBOARD – 2

LECTURE:69 – DASHBOARD – 3

LECTURE:70 – DASHBOARD – 4

LECTURE:71 – DASHBOARD – 5

LECTURE:72 – OFFICE 365 – 1

LECTURE:73 – OFFICE 365 – 2

LECTURE:74 – OFFICE 365 – 3

LECTURE:75 – POWER QUERY – 1

LECTURE:76 – POWER QUERY – 2

LECTURE:77 – POWER QUERY – 3

LECTURE:78 – POWER QUERY – 4

CLASS:79 – POWER QUERY – 5

CLASS:80-POWER QUERY-6

SKILL ENHANCER EXCEL MCQ

MIS INTERVIEW RESOURCES

CV FORMAT

Student Feedback

5.0

Total 7 Ratings

5
6 ratings
4
0 rating
3
0 rating
2
0 rating
1
0 rating

good

Best Professioanl Sir In India.

I was searching for excel videos on YouTube and suddenly I found Innozant channel. I can say that no one can meet the level of Jha sir. The way he explains and demonstrate the topics, no one could do that. Thanks for making such a wonderful course at a very affordable price.

Best course structure and teaching. Very helpful for all who want to learn Advanced Excel. Thank you Innozant. Jha sir aap to Cha gaye. Love from Pune Maharashtra.

This is one of the best Excel Course you will get online.Dilip Sir is the best teacher and his way of teaching help me to crack MIS interview Job

My life changer Dilip sir thanks Alot you have give such a motivation which I can't find anywhere .Innozant is the best platform to learn technical skill with the India's Best teacher Thanks Alot Dilip sir Once again

This is one of the best places to learn technical skills. For learning, Innozant provided the best quality content. Please upload any updates to this course if there are any.

2,999.00
  • Course level: Expert
  • Duration 49h 59m 59s

Target Audience

  • Fresher & Undergraduate, Non Technical Candidates