MIS Training in Depth – Advance Excel MIS Certificate Course

1

MIS Training in Depth – Advance Excel MIS Certificate Course, Excel 2019, Basic to Advance Commands, Lookup Series, Macro, Form, Pivot Table, MIS Report, Templates, Referencing..

Excel Course – Advanced Lookup, Indirect, Pivot Table, Slicer, Timeline, Macros, MIS and more.

Microsoft Office 2019, 2016, 2013, 2010, 2007 ..

Lookup application

MIS Report – Reporting

Employee leaflet, interest calculation, school management ..

Pivot tables and charts, powerful reports and data analysis

paste Special

Lookup – Lookup, Two-Way Lookup, Helper Value Lookup, Lookup Column, Lookup in Multisheet

Multi Workbook Connection

Importing external data – website, database, text file.

Own templates

Multi Table Vlookup

Flash fill

Excel ai

Relative referencing, absolute / fixed referencing, mixed referencing $

Dynamic dropdown

Automatic macro

Indirect work

data validation.

Project discussion

No code macro

Excel function

Master excel tools

Formulas – IF, VLOOKUP, INDEX, MATCH, ETC.

Lookup application

MIS Report – Reporting

Employee leaflet, interest calculation, school management ..

Pivot tables and charts, powerful reports and data analysis

paste Special

Lookup – Lookup, Two-Way Lookup, Helper Value Lookup, Lookup Column, Lookup in Multisheet

Multi Workbook Connection

Importing external data – website, database, text file.

Own templates

Multi Table Vlookup

Flash fill

Excel ai

Relative referencing, absolute / fixed referencing, mixed referencing $

Dynamic dropdown

Automatic macro

Indirect work

data validation.

Project discussion

No code macro

Relative referencing, absolute / fixed referencing, mixed referencing $

Dynamic dropdown

Automatic macro

Indirect work

data validation.

Project discussion

Excel Course – Advanced Lookup, Indirect, Pivot Table, Slicer, Timeline, Macros, MIS and more.

Microsoft Office 2019, 2016, 2013, 2010, 2007 ..

Are there any course requirements or prerequisites?

– computer knowledge

Who is this course for:

Whoever wants to learn excel

Successful excel pro

Business Owners, Career Seekers

Whoever wants to learn excel

Successful excel pro

Business Owners, Career Seekers

Free $19.99 Redeem Coupon
We will be happy to hear your thoughts

Leave a reply

100% Off Udemy Coupons
Logo