29 & 30 Jan 2019 (Tue & Wed)
Having trouble viewing?
Click Here

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

Course Information
  Date   29 & 30 Jan 2019 (Tue & Wed)
  Venue   100 Orchard Road #04-100, Concorde Hotel S(238840)
  Time   9am to 5pm
  Fees   $1280 (inclusive of lunch and light refreshments)

Contact Rina at 6720 3333 or email:


To unsubscribe, please click here

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 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

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 Microsoft Office 2013/2016 workshop 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.

Don't Miss It - Register Today!

Please contact Rina at (65) 6720 3333 or
email: training@aventisglobal.com

Date 29 & 30 Jan 2019 (Tue & Wed)
Venue 100 Orchard Road #04-100, Concorde Hotel S(238840)
Time 9.00am to 5.00pm
Fee $1280 (inclusive of lunch and light refreshments)
Enquiries Please contact Rina 6720 3333 or
email: training@aventisglobal.com

Sharing is Caring

Sign up in a group of 3 or more to enjoy group discount

Forward this email to your friends or colleagues whom might benefit from this workshop and enjoy a group discount when 3 or more of you sign up.

Program Outline

Chapter 1: Awesome New Features In Microsoft Word 2013      

1.1         Quick Access To Files Using Open Screen             

1.2         Pin Frequently Used Files And Folders To Open Screen   

1.3         Set Office Theme For Your Application  

1.4         Open And Edit Pdf Contents      

1.5         View Document Without Tabs And Ribbons In Read Mode           

1.6         Reply To Comments And Make Them As Done   

1.7         Layout Options To Arrange Images And Text Around Them          

1.8         Quickly Change The Document Look Using Document Formatting             

1.9         Collapse Or Expand Parts Of A Document            


Chapter 2: Mail Merging And Formatting Documents Using Word 2013 

2.1         Keyboard Shortcuts In Microsoft Word 2013       

2.2         Mail Merge Multiple Addresses To Letters          

2.3         Mail Merge Multiple Addresses To Labels           

2.4         Create Multilevel Lists To Organize Items            

2.5         Copy Only Formatting Using Format Painter       

2.6         Change Document Themes        

2.7         Change Document Formatting   

2.8         Restrict Editing Of Important Data In Document


Chapter 3: Managing Long Documents Using Word 2013            

3.1         Navigate And Search Using Navigation Pane       

3.2         Insert Cover Page To The Document      

3.3         Insert Watermark Behind The Content Page       

3.4         Insert Headers And Footers       

3.5         Add Page Color And Page Borders          

3.6         Insert Section Breaks    

3.7         Insert Table Of Contents             

3.8         Insert Index Page To Document


Chapter 4: Awesome New Features In Microsoft Powerpoint 2013         

4.1         Create Contents Using New Templates  

4.2         Save Presentation In Pdf Formats           

4.3         Improvement In Presenter View

4.4         Use Up Extra Space On Widescreen Projector Or Television         

4.5         Real Time Collaboration Using Comments And Reply      

4.6         Insert Online Pictures And Online Video 28

4.7         Customize Picture Using Format Picture Task Pane          


Chapter 5: Creating Slide Contents Using PowerPoint 2013        

5.1         Keyboard Shortcuts In Microsoft PowerPoint 2013          

5.2         Insert Contents From Word Outline        

5.3         Reuse Slides From Other Presentation   

5.4         Create Consistent Look Using Themes   

5.5         Create Consistent Look Using Slide Master          

5.6         Create New Slide Layouts In Master View            

5.7         Organize Presentation Into Sections       


Chapter 6: Creating Interactive Slide Show Using PowerPoint 2013        

6.1         Insert Pictures And Screenshot 

6.2         Insert Shapes And SmartArt Graphics     

6.3         Add Custom Animation To Contents       

6.4         Add Transitions To Slides            

6.5         Add Video And Background Music          

6.6         Navigate Your Slide Show Using Hyperlink           

6.7         Rehearse Your Presentation Using Rehearse Timings      

6.8         Set Up An Auto Run Slide Show 


Chapter 7: Awesome New Features In Microsoft Excel 2013       

7.1         Automatically Fill In Values Using Flash Fill          

7.2         Easier Charting Using Recommended Charts       

7.3         Easier Chart Customization Using New Chart Tools          

7.4         Create A Combo Chart  

7.5         Easier Data Analysis With Quick Analysis Tool     

7.6         Easier Table Data Filtering Using Slicer   

7.7         Summarize Data Using Recommended PivotTables         

7.8         New Timeline Filter For PivotTable         


Chapter 8: Speeding Up Your Work Using Excel 2013     

8.1         Keyboard Shortcuts In Microsoft Excel 2013        

8.2         Enter Data In Multiple Worksheets Concurrently

8.3         Speed Up Document Creation Using Templates 

8.4         Create Consistent Look Using Cell Styles And Themes     

8.5         Populate Data Automatically Using Autofill         

8.6         Validating Data Using Pick Lists 

8.7         Lookup Data Using Vlookup Function     

8.8         Lookup Data Using Index And Match Functions  

8.9         Protecting Worksheet Content And Workbook Structure


Chapter 9: Data Analysis And Reporting Features In Excel 2013 

9.1         Summarizing Values Using 3-D Reference Formulas        

9.2         Arranging All Open Windows     

9.3         Consolidating Data From Different Worksheets 

9.4         Consolidating Data From Different Workbooks  

9.5         Editing Links From Different Workbooks

9.6         Grouping Data Using Auto Outline          

9.7         Inserting Automatic Subtotals