MIS Training in Depth - Advance Excel MIS Certificate Course
| Office Productivity | |
| 1447 students | |
| 5.5 lectures | |
| 2021-05-31 12:25:16 | |
| $19.99 $0 |
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