Microsoft Word & Excel 2016/365 Productivity Tips
What you'll learn
- Increase their productivity by utilising MUST know tricks and shortcuts
- Recognise how these shortcuts can save time and reduce risk and stress
- How to leverage Microsoft Excel and Word to get more done in less time!
- You should be able to use Microsoft Word & Excel at a basic level
- You will need to be using Microsoft Office 2016 or 365
- This course is primarily designed for those seeking to increase their productivity, it is not designed to be an everything you need to know about both programs
Donna believes the very technology that was supposed to make our life easier has created another layer of work which takes us away from things that we want in our lives such as more time with family, time to focus on a new project or simply reducing stress levels and risk of errors.
With over 20 years of Adult Learning & Development experience, in this short course Donna covers productivity tips that you must know about Microsoft Word & Microsoft Excel to immediately increase your productivity and reduce risk.
This sample program covers a range of key tools and features in Microsoft Excel & Microsoft Word that are some of the most common challenges and frustrations participants in face-to-face workshops, one on once coaching sessions or online programs Donna has been asked in her twenty-five years as a professional educator. One tip alone could save you hours of stress and frustration and will enable you to immediate increase your productivity and efficiency with Microsoft Word & Microsoft Excel 2016/365.
This short program addresses 38 of the most common questions my audiences have also provides context for how and where in the “real world” participants might utilise these skills.
Whilst this program is shared in the Microsoft Office 2016/365 these tips also work in previous versions of Microsoft Word & Excel.
Topics covered include:
Shortcuts to adding or summing data
How to copy worksheets EXACTLY as you want them
How to send a single worksheet in a file to someone instead of the whole worksheet
1 Key Graph/Chart creation
How to split data in one cell into multiple columns
How to easily remove extra spaces in cells
How to easily change the casing of text in cells
How to "add" cells containing text together
How to get ALL your data to print on a single page
How to set up headers & footers on your worksheet
How to flip data you've already entered from being across the spreadsheet to down the spreadsheet
How to make finding and referring to key information in your spreadsheet easy
Simple formulas to add up data across multiple worksheet
How to create a pivot table to enable you to analyse data
How to easily subtotal a long list of data
How to create droplists to keep data entry in cells consistent
How to highlight cells that meet a specific criteria
How to remove duplicate entries from data lists
How to leverage hyperlinks to move around larger spreadsheets
How to protect your data from user errors
How to automate common, repetitive tasks.
How to apply formatting from one part of a document to another with a couple of clicks
Setting up default line spacing
Making bullets work for you, not against you.
Simple tips on creating and working with tables.
Copying and pasting "insider" tips to save hours of frustration
Fast tracking page breaks
Understanding headers and footers and how they work in Word
Inserting an Excel worksheet into a Word document.
How to automatically insert common text
How to insert larger blocks of text with a few clicks
How to insert watermarks on documents
How to insert one file into another
Using styles to make document formatting EASY
Creating an automated table of contents
Creating templates to save time and frustration on repetitive tasks
Easy mail merge with an Excel worksheet as a data source
How to easily insert a file name and path into a document footer.
Includes Downloadable workbook with step-by-step instructions + NEW Downloadable Excel Practice Worksheet!!
Who this course is for:
- Anyone interested in increasing productivity with Word & Excel
Want to reduce your stress and frustration with everyday Microsoft Office programs and also increase your productivity?
Want to learn practical tools and features of Microsoft Office programs that relate back to what you do in your day-to-day work?
Then I'd love to help.
For over 25 years, I've has been working as a speaker, trainer and educator to businesses large and small. I believe the very technology that was supposed to make life easier has in fact created more work!
I am passionate about productivity and believe that we need to get stuff done, faster and smarter so we can get back to enjoying our lives with those we love.
My style is practical, engaging and fun, because I think when things are fun, we learn more.
I have a degree in Training & Development, and years of real-world business experience which means no jargon sessions that focus on what you need to know to get more done in less time with less stress.
Join me here and let me help you:
- Learn what you need to do to make analyzing data in Microsoft Excel EASY.
- Learn what you need to know to easily create Word documents and reports that are professional EVERY SINGLE TIME.
- Learn how to make your next presentation with Microsoft PowerPoint engaging and get your message across to your audience without putting them to sleep.
- Learn SECRET tips to help you IMMEDIATELY increase your productivity AND reduce your stress with Microsoft Word & Excel.
My motto is "You don't know what you don't know."