ADVANCE EXCEL MACRO VBA TUTOR IN NAVI MUMBAI IN NAVI MUMBAI

MS EXCEL A Workshop on ADVANCE EXCEL TRAINING FOR MIS AND VBA MACRO LEARNING Hello = 99'87'29'38'11 = Day I Introduction to Excel with hands-on Excel tricks while handling corporate huge data Excel shortcuts Practical Example of Some Important Functions Such As: Countif Sumif Averageif Countifs Sumifs Quick Charts Find Search Len Mid Left Right Vlookup Hlookup Lookup Relative Referencing Absolute Referencing Mixed Referencing Match_Index Match_Vlookup Floor Indirect Validation Dynamic Validation Conditional formatting for cell Name Manager Condition formatting with changing conditions More than 50 Formula = Day II WHAT IS EXCEL MACRO WHAT IS DEVELOPER TAB HOW TO MAKE DEVELOPER TAB VISIBLE IN EXCEL RIBBON STEPS TO ADD DEVELOPER TAB IN YOUR EXCEL RIBBON WHERE TO WRITE THE VBA CODE IN EXCEL HOW TO RECORD MACRO IN EXCEL HOW TO RUN MACRO IN EXCEL 5 to 10 Different example of simple Macro with Excel Shortcuts which includes Do – loop For – Next Select – Case Add-ins Input box Message Box Warning Box Drop down Label Text bar User Forms Multiple Module using in one macro Making macros for Fun & Game