29 & 30 Apr 2019 (Mon & Tue)
Having trouble viewing?
Click Here

Mastering Microsoft Office 2016 Intermediate to Advanced Techniques

Course Information
  Date   29 & 30 Apr 2019 (Mon & Tue)
  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

Mastering Microsoft Office 2016 Intermediate to Advanced Techniques

In this complex and fast-changing job market, Microsoft Office skills remain as one of the most in-demand career skills employers look for in job candidates. Microsoft Office 2016 is widely used in most of the companies to help the employees perform their day-to-day activities efficiently.  Yet, a lot of people are unaware that it offers well-hidden powerful features that could drastically improve their productivity at the workplace.  

2 Day Practical Hands-On Training by Microsoft Certified Expert, Ms Valene Ang

In this 2-days course, you will learn many useful features in Microsoft Office 2016 such as share your documents with other users, pin your frequently used files to the new Open Screen, Flash Fill, Quick Analysis Tools, Timeline and so on.  
You will also learn how to use Excel 2016 data consolidating features to speed your daily work and boost your productivity at work; how to use Word 2016 to edit PDF documents and mail merge multiple addresses to letters; how to use PowerPoint 2016 to create eye-catching presentation slides.

Key Takeaways - Discover the Hidden Power of MS Office

In this 2-day workshop, participants will learn how to:

  • Create personalized letters or emails to multiple contacts at one go  
  • Create and edit PDF documents in Word 
  • Use Flash Fill in Excel to format and copy data in a flash 
  • Use Quick Analysis to analyse and format data instantly 
  • Create multimedia photo album with PowerPoint in 15 minutes 
  • Create personalized custom slide show with PowerPoint
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 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.
This workshop is for users of Microsoft Office 2016 who intend to produce excellent results quickly and increase their productivity efficiency.

Note: This is a fast pace advanced level workshop; it is not suitable for beginners and those who uses Microsoft Office 2016 program occasionally. Participants are required to bring a laptop equipped with Windows version Microsoft Office 2016 program.

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 over 19 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 Apr 2019 (Mon & Tue)
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.

Course Outline

Chapter 1: Awesome Features In Microsoft Word             
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             
2.1           Keyboard Shortcuts In Microsoft Word 2016     
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           
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           Apply Document Formatting0.
3.5           Add Page Color And Page Borders            
3.6           Insert Section Breaks    
3.7           Insert Headers And Footers                         
3.8           Insert Table Of Contents               
3.9           Insert Index Page To Document

Chapter 4: Awesome Features In Microsoft PowerPoint                 
4.1           Create Contents Using 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               
4.7           Customize Picture Using Format Picture Task Pane
4.8           Create a Multimedia Photo Album          

Chapter 5: Creating Slide Contents Using PowerPoint    
5.1           Keyboard Shortcuts In Microsoft PowerPoint 2016         
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    
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 Features In Microsoft Excel              
7.1           Automatically Fill In Values Using Flash Fill        
7.2           Easier Charting Using Recommended Charts     
7.3           Easier Chart Customization Using 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           Timeline Filter For PivotTable   

Chapter 8: Speeding Up Your Work Using Excel 
8.1           Keyboard Shortcuts In Microsoft Excel 2016      
8.2           Using “Tell Me What You Want To Do”
8.3           Enter Data In Multiple Worksheets Concurrently             
8.4           Speed Up Document Creation Using Templates                
8.5           Create Consistent Look Using Cell Styles And Themes                    
8.6           Populate Data Automatically Using Autofill
8.7           Validating Data                  Using Rules
8.8           Using Pick Lists to Restrict Data Entry                     
8.9           Protecting Worksheet Content And Workbook Structure              

Chapter 9: Consolidating Data
9.1           Create Linking Worksheets and Workbooks
9.2           Summarizing Values Using 3-D Reference Formulas       
9.3           Arranging All Open Windows     
9.4           Consolidating Data From Different Worksheets                
9.5           Consolidating Data From Different Workbooks                  
9.6           Editing Links From Different Workbooks