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 ﬁnance.
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.
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