Overview

***UPDATED WORKBOOK AND VIDEOS - MAY 2024***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 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 365 these tips also work in previous versions of Microsoft Word & Excel.Topics covered include:Microsoft ExcelShortcuts to adding or summing dataHow to copy worksheets EXACTLY as you want themHow to send a single worksheet in a file to someone instead of the whole worksheet1 Key Graph/Chart creationHow to split data in one cell into multiple columnsHow to easily remove extra spaces in cellsHow to easily change the casing of text in cellsHow to "add" cells containing text togetherHow to get ALL your data to print on a single pageHow to set up headers & footers on your worksheetHow to flip data you've already entered from being across the spreadsheet to down the spreadsheetHow to make finding and referring to key information in your spreadsheet easySimple formulas to add up data across multiple worksheetHow to create a pivot table to enable you to analyse dataHow to easily subtotal a long list of dataHow to create droplists to keep data entry in cells consistentHow to highlight cells that meet a specific criteriaHow to remove duplicate entries from data lists How to leverage hyperlinks to move around larger spreadsheetsHow to protect your data from user errorsHow to automate common, repetitive tasks.Microsoft WordHow to apply formatting from one part of a document to another with a couple of clicksSetting up default line spacingMaking bullets work for you, not against you.Simple tips on creating and working with tables.Copying and pasting "insider" tips to save hours of frustrationFast tracking page breaksUnderstanding headers and footers and how they work in WordInserting an Excel worksheet into a Word document.How to automatically insert common textHow to insert larger blocks of text with a few clicksHow to insert watermarks on documentsHow to insert one file into anotherUsing styles to make document formatting EASYCreating an automated table of contentsCreating templates to save time and frustration on repetitive tasksEasy mail merge with an Excel worksheet as a data sourceHow 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!!

Skills

Reviews