Microsoft Excel

At ITBMS, we recognize that different customers have different training needs. ITBMS meets the specific customer requirements by offering tailored training courses.

 


Advanced Excel concentrates on Excel features and techniques that you will be able to apply every day in order to make your spreadsheets more reliable, more efficient, more automatic and to give them maximum impact. Each of the areas our syllabus addresses are intended to equip you with knowledge and techniques that you will be able to use over and over again to not only make your own spreadsheets better, but also to enable you to help your colleagues and solve their Excel problems.

MS Excel/Advanced Excel/VB Macros

Microsoft Excel

                                                                                                              Duration: 08 hours

       Setting Up a Workbook
       Working with Data and Excel Tables
       Performing Calculations on Data
       Changing Workbook Appearance
       Focusing on Specific Data by Using Filters
       Reordering and Summarizing Data
       Combining Data from Multiple Sources
       Analyzing Alternative Data Sets
       Creating Dynamic Worksheets by Using PivotTables
       Creating Charts and Graphics
       Printing
       Automating Repetitive Tasks by Using Macros
       Working with Other Microsoft Office Programs
       Collaborating with Colleagues

Microsoft Advanced Excel

                                                                                                       Duration: 08 hours

       References
       Ranges
       Conditional Formatting
       Pivot Table
       Advanced Formulas
       Lookup and References
       Logical
       Text
       Date & Time
       Statistical
       Sort & Filters
       Data Tools
       Outline
       Changes
       Macros
       Dashboard

Microsoft VB Macros

                                                                                                       Duration: 08 hours

       Introduction
       Visual Basic basics
       VBA sub-routine/macro
       Variables and Loops
       Branching and Interaction
       Controls and Events
       Useful Objects, Properties, Methods and Constants
       Working Arrays





 


Disclaimer: Course content, version and duration are subject to change without notice as a part of constant upgrade of the product by MICROSOFT TRAINING.

 

 

 

ContactUs.com