Advanced Excel Training In Dubai - Dubai
ADVANCED EXCEL – MICROSOFT OFFICE 2003/ 2007 / 2010 / 2013 / 2016
FOR OFFICE PURPOSE
• USE OF OPERATORS
• ADVANCED FORMULAS
• UNDERSTANDING OF RELATIVE REFERENCE, ABSOLUTE REFERENCE & MIXED REFERENCE.
• USE OF IF STATEMENT, MULTIPLE IF STATEMENT
• FILTER & ADVANCED AUTOFILTER – ( USED TO GENERATE REPORTS)
• CONDITIONAL FORMATTING, HYPERLINK
• USE OF VALIDATIONS
• HOW TO CREATE AND USE OF MACRO IN WORKBOOK
• CHART / 3D CHART / USE OF PIE CHART & SMARTART
• SUMIF, SUMIFS, COUNTIF , COUNTIFS , AVERAGEIF & AVERAGEIFS
• USE OF CONSOLIDATE & SUBTOTALS
• PIVOT TABLE WITH CHART REPORT FEATURES – (USED TO GENERATE REPORTS)
• VLOOKUP WITH ISERROR / ISNA FUNCTIONS – (USED TO GENERATE REPORTS)
• SORTING & MULTIPLE SORTING
. DATA ANALYSIS THROUGH GOAL SEEK & DATA TABLE FEATURES
• LINKING OF WORKSHEET / WORKBOOK
• IMPORT / EXPORT OF DATA
• HOW TO PROTECT FILE, WORKSHEET & WORKBOOK
• USE OF TEMPLATE
• USE OF OTHER APPLICATIONS IN THE WORKBOOK
• HOW TO CUSTOMIZE THE APPLICATIONS
• PRINTING SETUP
• MANY MORE …… with Assignments & Important Notes
FLEXIBLE FOR HOME TUITION!
ONE TO ONE OR GROUP STUDENTS!
REASONABLE FEES!
HOURLY CLASSES!
PLEASE CONTACT ON : 0567816530