Course Information

Start Date 12 Nov 2018, Monday
End Date 13 Nov 2018, Tuesday
Time 09:00 am to 05:00 pm
Venue 100 Orchard Road, Concorde Hotel Singapore
Fee $1,280 nett (Inclusive of hotel buffet lunch, light refreshments and course materials)
Contact 6720 3333 (Ms Rina)
Registration Form

Nov 2018

Mastering Microsoft Office 2013/2016: Tips and Tricks to Improve Your Productivity using Intermediate to Advanced Techniques

Boost Up Your Productivity with Highly Effective Timesaving Tips and Hidden Tricks in Microsoft Office 2013/2016

Microsoft Office skills remain as one of the top critical skills uses by executives and business professionals in their day-to-day work. Yet, many of us are unaware that embedded in MS offices are highly effective tools and features that can help you work faster, be more efficient and you complete complex tasks in a short time and less stress.

  • Boost the potential of Word –  Do you want to learn useful shortcuts in Microsoft Office 2013/2016 to speed up your work?
  • There’s nothing worse than a boring PowerPoint presentation. Do you want to produce excellent and Impactful Powerpoint presentation quickly and impress your audience?
  • Do you want to learn to automate your data entry and discover how to create charts that dazzle by simply unlocking MS Excel Hidden Features?
  •  Do you want to learn how to calculate with advanced functions & formulas, create interactive charts using Excel?
  • Do you want to boost your capability, competency and confidence in handling MS suite of productivity tools using time-saving tricks?
2 Day Practical Hands-On Training by Microsoft Certified Expert, Ms Valene Ang

In this 2-days highly hands-on workshop, you will learn Office 2013/2016’s new online features and master office productivity tools which are very easy to pick up using Valene’s step by step guide. Use real-world examples and case studies, you will learn hands-on effective tips to fully harness the hidden analysis power of Microsoft office and its powerful modeling functions for decision making, analysis, marketing, accounting and finance.

Key Takeaways- Discover the Hidden Power of MS Office
  • Gain insights to new features in Microsoft office 2013/2016
  • Increase productivity  and ease of use through practical tips to speed up your work
  • Learn Data Analysis and Reporting Features in Excel 2013/2016
  • Mail Merge and format Documents using Word 2013/2016
  • Create interactive slide show using special techniques with PowerPoint 2013/2016
  • Reduction of time needed to work on repetitive task by using time saving features in Microsoft Office
Don’t Waste Your Time Through Trial and Error – Who Should Attend?

MS office is designed to meet the needs of organizations of all sizes – individuals, sole proprietors, large and mid-sized businesses, government agencies and educational institutions.

This workshop is for Microsoft Office 2013/2016 is highly recommended for executives, senior officers of government agencies, entrepreneurs and professionals seeking to enhance their MS office skills set and improve their productivity at work.

Note: this is an intermediate course and participants should have working knowledge in Microsoft Excel, Word 2013/2016 and PowerPoint 2013/2016 to benefit from this workshop.


“Well done Valene! Really enjoy this class. You have been very patient and helpful” – Manager, Prudential Assurance

“Excellent! I will definitely recommend this workshop” – Manager, Singapore National Police Force

MS Excel Expert and Microsoft Certified Trainer: Valene Ang

Valene Ang is a Microsoft Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She brings with her 20 years’ experience in corporate training and consultancy. Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and course material, assisting corporate clients in business data analysis and providing dynamic report solutions.

She had conducted many Microsoft Office workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real life Excel problems. As a Certified Trainer, Ms Ang has trained hundreds of executives, managers and directors from across medium sized organisations, government offices and multinational companies. Some of her high profile clients including PSA International, DFS Galleria Singapore, Neptune Orient Lines Limited (NOL), National Environment Agency (NEA), Inland Revenue Authority of Singapore (IRAS), CPF Board, Public Utility Board (PUB), Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic, Baxter Healthcare Pte. Ltd, and many more.

Program Highlights

Day 1
Chapter 1: Awesome New Features in Microsoft Office 2013/2016

  1. A New Look for Start Screens
  2. Search and Download Online Templates
  3. Quick Access to Files using Open Screen
  4. Pin Frequently Used Files and Folders to Open Screen
  5. Save Files to OneDrive and Other Locations
  6. Share Your Documents with Other Users
  7. Set Office Theme for Your Application
  8. Insert Apps into Excel, Word and PowerPoint 2013/2016

Chapter 2: Awesome New Features in Microsoft Excel 2013/2016

  1. One Workbook with One Window
  2. Automatically Fill In Values using Flash Fill
  3. Easier Charting Using Recommended Charts
  4. Easier Chart Customization using New Chart Tools
  5. Summarize Data using Recommended PivotTables
  6. Create a Combo Chart
  7. Easier Data Analysis with Quick Analysis Tool
  8. Easier Table Data Filtering using Slicer
  9. Easier PivotTable Dates Filtering using Timeline

Chapter 3: Speeding Up Your Work using Excel 2013/2016

  1. Keyboard Shortcuts in Microsoft Excel 2013/2016
  2. Enter Data in Multiple Worksheets Concurrently
  3. Populate Data Automatically using AutoFill
  4. Speed Up Document Creation using Templates
  5. Create Consistent Look using Cell Styles and Themes
  6. Validating Data using Pick Lists
  7. Lookup Data using VLOOKUP, INDEX and MATCH Functions
  8. Protecting Worksheet Content and Workbook Structure

Chapter 4: Data Analysis and Reporting Features in Excel 2013/2016

  1. Summarizing Values using 3-D Reference Formulas
  2. Consolidating Data from Different Worksheets
  3. Consolidating Data from Different Workbooks
  4. Editing Links from Different Workbooks
  5. Grouping Data using Auto Outline
  6. Inserting Automatic Subtotals
  7. Remove Duplicate Records
  8. Creating Dynamic Chart from Table

Chapter 5: Awesome New Features in Microsoft Word 2013/2016

  1. Search and Download Templates from Online Sources
  2. Open and Edit PDF Contents
  3. View Document without Tabs and Ribbons in Read Mode
  4. Reply to Comments and Make Them As Done
  5. Live Layout and Alignment Guides
  6. Layout Options to Arrange Images and Text Around Them
  7. Quickly Change the Document Look using Document Formatting
  8. Collapse Or Expand Parts of A Document

Chapter 6: Mail Merging and Formatting Documents using Word 2013/2016

  1. Keyboard Shortcuts in Microsoft Word 2013/2016
  2. Mail Merge Multiple Addresses to Letters
  3. Mail Merge Multiple Addresses to Labels
  4. Create Multilevel Lists to Organize Items
  5. Change Document Themes and Formatting
  6. Copy Only Formatting using Format Painter
  7. Insert Preformatted Text from Quick Parts Gallery
  8. Restrict Editing of Important Data in Document

Chapter 7: Managing Long Documents using Word 2013/2016

  1. Navigate and Search using Navigation Pane
  2. Insert Cover Page to the Document
  3. Insert Watermark Behind the Content Page
  4. Insert Headers and Footers
  5. Add Page Color and Page Borders
  6. Insert Section Breaks
  7. Insert Table of Contents
  8. Insert Index Page to Document

Chapter 8: Awesome New Features in Microsoft PowerPoint 2013/2016

  1. Improvement in Presenter View
  2. Include Your Own Notes for Each Slide
  3. Easier Collaboration with Comments Pane
  4. Real Time Collaboration using Comments and Reply
  5. Use Up Extra Space on Widescreen Projector or Television
  6. Insert Online Pictures and Online Video
  7. Customize Picture using Format Picture Task Pane
  8. Create Contents using New Templates

Chapter 9: Creating Slide Contents using PowerPoint 2013/2016

  1. Keyboard Shortcuts in Microsoft PowerPoint 2013/2016
  2. Insert Contents from Word Outline
  3. Reuse Slides from Other Presentation
  4. Create Consistent Look using Themes
  5. Create Consistent Look using Slide Master
  6. Create New Slide Layouts in Master View
  7. Organize Presentation into Sections
  8. Save Presentation in PDF Formats

Chapter 10: Creating Interactive Slide Show using PowerPoint 2013/2016

  1. Insert Pictures and Screenshot
  2. Insert Shapes and SmartArt Graphics
  3. Add Custom Animation to Contents
  4. Add Transitions to Slides
  5. Add Video and Background Music
  6. Navigate Your Slide Show using Hyperlink
  7. Rehearse Your Presentation using Rehearse Timings
  8. Set Up an Auto Run Slide Show