Microsoft Office Package Trainer In Dubai - Dubai
Available Professional Computer Trainer For MICROSOFT OFFICE PACKAGE 2007/2010/2013 / 2016:
Ms- Office 2007/ 2010 / 2013 / 2016 course outlines:
1)
Microsoft Word - 2007 /2010 / 2013 / 2016
Create document
Basic & advance formatting using letters
Table creation
Printing setup
Use of templates
Shortcut Menus And Keystrokes
2)
Ms - Power point - 2007 /2010 / 2013/ 2016
Create presentation
Use of Templates
Use of Formatting
Use of word and excel applications
Use of organizations chart
Charts/Graphs/Drawn Objects
Drawn Objects
Duplicate/Move/ (ie Copy/Cut/Paste or Drag) Delete
Slide Show Effects
Preset Animation
Transitions
Custom Animations
Prepare Outputs
Preparation
Printing
Deliver a Presentation
Create PPS file
3)
MS-EXCEL – MICROSOFT OFFICE 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
• 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
PRACTICE ON SAMPLE ASSIGNMENTS!
FLEXIBLE FOR HOME TUITION!
REASONABLE FEES!
ONE TO ONE OR GROUP STUDENTS!
HOURLY CLASSES!
PLEASE CONTACT ON : 0567816530