Top Institute for IT Training Courses

Adv. Excel Video Course

Administrator Expert

Home
Adv. Excel Video Course

About Course

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

Course Content

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 49 hours59 minutes

Get In Touch

C-54 ,Third Floor, Sector-2, Near Sec-15 Metro Station, Noida ,Landmark-Priyagold Building , Uttar Pradesh , 201301

+91-7065069985

query@innozant.com

Adv. Excel Video Course

About Course

What you will learn:

Course Content

Time duration: 60 Hrs +

LECTURE:1 – EXCEL INTRODUCTION & PASTE SPECIAL

Introduction – Customizing Paste Special

Resources – Introduction Customizing Paste Special

Skil Enhancer level 1

LECTURE:2 – CELL REFERENCE

Cell Reference

Resources – Cell Reference

Cell Reference questions.

LECTURE:3 – CUSTOM AND CONDITIONAL FORMATTING

Custom And Conditional Formatting

Resources – Custom Conditional Formatting

Formatting- Custom/ Readymade/ Conditional

LECTURE:4 – LOGICAL FUNCTION – 1

Logical Function – 1

Resources – Logical Function – 1

SKILL ENHANCER-3

LECTURE:5 – LOGICAL FUNCTION – 2

Logical Function – 2

Resources – Logical Function – 2

SKILL ENHANCER-3

LECTURE:6 – MATH FUNCTION – 1

Math Function – 1

Resources – Math Function – 1

LECTURE:7 – MATH FUNCTION – 2

Math Function – 2

Resources – Math Function – 2

LECTURE:8 – TEXT FUNCTION – 1

Text Function – 1

Resource – Text Function – 1

LECTURE:9 – TEXT FUNCTION – 2

Text Function – 2

Resources – Text Function – 2

LECTURE:10 – TEXT FUNCTION – 3

Text Function – 3

Resources – Text Function – 3

LECTURE:11 – DATE AND TIME FUNCTION – 1

Date And Time Function – 1

Resources – Date and Time Function – 1

LECTURE:12 – DATE AND TIME FUNCTION – 2

Date And Time Function – 2

Resources – Date And Time Function – 2

LECTURE:13 – DATE AND TIME FUNCTION – 3

Date And Time Function – 3

Resources – Date And Time Function – 3

LECTURE:14 – STATISTICAL FUNCTION – 1

Statistical Function – 1

Resources – Statistical Function – 1

LECTURE:15 – STATISTICAL FUNCTION – 2

Statistical Function – 2

Resources – Statistical Function – 2

LECTURE:16 – STATISTICAL FUNCTION – 3

Statistical Function – 3

Resources – Statistical Function – 3

LECTURE:17 – DATABASE FUNCTION

Database Function

Resources – Database Function

LECTURE:18 – INFORMATION FUNCTION

Information Function

Resources – Information Function

LECTURE:19 – ERROR WORLD

Error World

Resources – Error World

LECTURE:20 – Goto Special Security

Goto Special Security

Resources – Goto Special Security

LECTURE:21 – PRINTING NAMING RANGE

Printing Naming Range

Resources – Printing Naming Range

LECTURE:22 – SORTING

Sorting

Resources – Sorting

LECTURE:23 – FILTER

Filter

Resources – Filter

LECTURE:24 – ADVANCED FILTER