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