Our Service

Master's in Excel Technology (MET)

MASTER'S IN EXCEL TECHNOLOGY (MET)

Ad- EXCEL                                           VBA MACRO'S

• CREATING EMPLOYEE SALARY SHEET
• CREATING CHARTS
• PIVOT TABLES & REPORTS
• TEXT FUNCTIONS, LOGICAL FUNCTIONS
• LOOKUP & REFERENCE FUNCTIONS
• LOGICAL FUNCTIONS
• ADVANCED FILTERS, SORTING
• DATA VALIDATION
• GOAL SEEK
• GROUP, UNGROUP, SUB TOTALS
• FREEZE PANES
• PAGE SETUP, PRINTING
• FORMATTING & CONDITIONAL FORMATTING
• PROJECTS RELATED TO THE FUNCTIONS

• CREATE A MACRO
• MSG BOX
• WORKBOOK AND WORKSHEET OBJECT
• RANGE OBJECT
• VARIABLES
• IF THEN STATEMENT
• LOOP
• MACRO ERRORS
• STRING MANIPULATION
• DATE AND TIME
• EVENTS
• ARRAY
• FUNCTION AND SUB
• APPLICATION OBJECT
• ACTIVEX CONTROLS
• USERFORM