Adv. Excel Video Course - Innozant MIS & Data Analytics & Data Science
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.
Topics for this course
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
It's really great I have learn a lot from this course thank you Sir
Overall advance excel course is superb but there is one thing is left that major project like sales ,finance or retail etc
Superb Experience , It helped me alot and gave me new perspective & confidence to switch my current role
good
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.