Microsoft Office Suite

Working with technology was never as exciting as now…when we know how to use it

Objectives:
Training Objective – The primary objective is that the participant, at the end of the course, will be able to extract the best from Word 2007/2010/2012, PowerPoint 2007/2010/2012 and Excel 2007/2010/2012 – the three most commonly used Office Suite Programs.

Structure:
The topics will be covered in the following manner:

(a) Advanced Word (b) Advanced Powerpoint
Getting Started with the interface Getting Started with PowerPoint
Creating and saving documents Creating and Saving Presentations
Printing the documents Printing Presentations
Editing and Formatting Text Designing Presentations
Formatting Paragraphs Working with Text
Formatting Pages Proofing Your Content
Proofing Documents Working with Pictures & Multimedia
Modifying Your Work Environment Working with Tables and Charts
Using Bullets and Numbering Viewing Presentations
Creating Tables and Charts Sharing Your Presentations
Styles Customizing Your Work Environment
Using Building Blocks
Sorting Data
Working with Macros
Working with Columns
Working with Illustrations
Sharing Documents
Working with Long Documents

(c) Advanced Excel

  • Advanced understanding of the interface
  • Formulas in Excel
    • Financial
    • Mathematical Functions
    • Text Manipulation Functions
    • Date Manipulation Functions
  • Pivot Tables
  • Charts
  • Goalseek
  • Scenario manager
  • Solver
  • Descriptive Statistics
  • Hypothesis Testing
  • Regression, trend analysis and extrapolation
  • Import and Export of Data
  • Macros
  • VBA for Excel

What you will gain from this program:

  • Improve efficiency by learning about the advanced features of Advanced Excel
  • Model data better by using Advanced Formatting, Grouping, Sorting and Filtering, etc.
  • Better presentation of data using Tables and Charts appropriately
  • Learn the built-in Formulae better to help you perform your job in the shortest time
  • Learn how to use Excel for decision making and problem solving using Pivot Tables / Pivot Charts and Data Tools
  • Learn how to automate repetitive tasks using Macros