MIS Training in Depth – Advance Excel MIS Certificate Course
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
