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

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

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

Target Audience

  • Fresher & Undergraduate, Non Technical Candidates