Professional Basic / Inter. & Advanced Excel Trainer In Dubai


BASIC / INTERMEDIATE EXCEL – MICROSOFT OFFICE 2003/ 2007 / 2010 /2013 / 2016 Training Course Outlines: Starting the Excel program  What is the Active Cell?  The Excel cell referencing system  Entering numbers and text  Default text and number alignment  Entering a date  Worksheets and Workbooks  Saving a workbook  Closing a workbook  Creating a new workbook  Opening a workbook  Switching between workbooks  Saving a workbook using another name  Saving a workbook using a different file type SELECTION TECHNIQUES MANIPULATING ROWS AND COLUMNS MANIPULATING CELLS AND CELL CONTENT WORKSHEETS FONT FORMATTING ALIGNMENT FORMATTING NUMBER FORMATTING FREEZING ROW AND COLUMN TITLES FORMULAS  Creating formulas  The easy way to create formulas  Copying formulas  Operators  Using operators in formulas  Relative cell referencing  Absolute cell referencing FUNCTIONS  What is a function?  Sum function  Average function  Max function  Min function  Count function  The COUNTA function  The COUNTBLANK function  The Round function  Using the IF function 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

More details

Name Description
Website na

Ad details

Ad ID : 7677
1 month, 17 days ago

Advertiser details

priya ranjan (273)
Contact Advertiser Share

Add comment


Contact form

What's wrong with this ad?

Sorry, you need to register or login first.

Add to favourites

Sorry, you need to register or login first.

Latest Videos

About Us is the leading classifieds website for users in the Middle East and worldwide. Since its launch in 29th Jan 2016, Khaleej Ad has become the number one platform for users to buy, sell, or find anything in their community. A community where people can sell or buy goods, Where job seekers post their job requirement ads, A place where Employers can post their new job posts and search correct candidates for their company. Their are various categories and sub categories where registered users can post their ads.

Your advantages at khaleejad however are that your Free ad will be live for 60 days and therefore reaches a much larger audience. What makes it even more interesting is that you can upload pictures, videos, and integrate a link to your website if you wish to do so.


Follow Us On Facebook