I believe 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 experince, in this course I cover 37 productivity tips that you must know about Word & Excel to immediately increase your productivity and reduce risk.
Rather than waste time attending a classroom style training course, a small time investment will enable you to focus on the key elements of both programs that will have you immediately increasing your productivity and efficiency with Word & Excel with the additional benefit of reducing risk and frustration so you can get on with more important things in your day.
Welcome to the Microsoft Excel Tips, Tricks & Shortcuts Introduction Video.
Watch this before starting on this module.
This videos shows you to to leverage the power of Excel 2016 to quickly SUM (add up) data.
This video shows you how to copy a worksheet in Excel 2016 whilst still retaining formatting attributes such as column and row widths, shading etc.
This video shows you how to separate one Excel 2016 worksheet from a file to enable you to then send it to someone without them getting all the worksheets in your file.
This video shows you how to quickly create a graph to provide a visual representation of your data in Excel 2016.
This video shows you how to take data that is in a single cells and separate it based upon criteria such as spaces. Useful for data that is imported from other programs and requires analysis that cannot be done when all the data is contained in a single cell in Excel.
In this video we should you how to trim excess spaces out of cells using the TRIM Function
When multiple people are entering data into worksheets there may be times where there is a mix of casing.
For example SoME UPPer and sOME lower and you need them all in Proper casing - capital first letter. This video shows you how to utilise the Proper function in Excel 2016 to achieve this.
This feature is useful when you have data in Excel 2016 that is in multiple columns and you need to join it together in a single cell.
This videos shows you how to get a worksheet that is just slightly bigger than one page to print on a single page in Excel 2016
This video shows you how to apply headers and footers to the top and bottom of your printed Excel 2016 worksheets.
There may be times where data is entered in columns when it would be better entered in rows.
Rather than retype data, the Transpose option in Excel 2016 enables data to be "flipped" to save time reentering.
Take this quiz to check in on your Excel Tips & Shortcuts skills.
75% is a pass.
This video shows you how to quickly and easily take formatting from one piece of text in Word 2016 and apply it to other pieces of text.
This video shows you how to change the default line spacing in Word 2016 to suit your preferences.
This video shows you tips and tricks to make working with and understanding bullets in Word 2016 easy.
Knowing how to create and manipulate tables can make aligning and moving data in your documents easier.
This video shows you tips and tricks to create and manipulate tables with ease.
This video shows you tips and shortcuts that will save you time, stress and frustration when copying and pasting data in Word 2016.
Rather than press enter, enter, enter until you reach a new page, this video shows you how to quickly and easily force a page break and the benefits of forcing page breaks.
This video explores what headers and footers are and how to insert them in Word 2016 documents.
This video shows you the tricks you need to know to make inserting an Excel worksheet into a Word document easier.
Take this quiz to check in on your Word Tips & Shortcuts skills.
75% is a pass.
This module gets you started on how to leverage Excel to automate common tasks.
Watch this video before starting this segment.
This video introduces Range Names in Excel 2016, explores how to create them and the benefits of utilising them to reduce risk and make it easier to navigate files and check formulas.
This video shows you how to utilise 3 Dimensional Formulas to quickly and easily add data that is similar on multiple worksheets to a summary worksheet in Excel 2016.
This video introduces the concept of Pivot Tables. What they are and how they make data analysis much easier in Excel 2016.
This video shows you how to Subtotal long lists of records quickly and easily.
This video explores the benefits of using droplists when sharing worksheets with others and shows you how to create and utilise them in Excel 2016 files.
Conditional Formatting enables you to highlight data in a list in Excel 2016 to make it stand out based upon pre-set conditions. This video shows you how to set this up and utilise conditional formatting.
This video shows you how to utilise the remove duplicates feature of Excel 2016 to clean up multiple entries in an Excel list.
This video shows you how to create hyperlinks in spreadsheets and the benefits of using them in files to be accessed by others.
Protecting Cells & Files minimises the risk of other uses accidentally altering data or formulas reducing risk and minimising re-work. This video shows you how to protect cells and files in Excel 2016.
Macros enable you to fast track common, repetitive tasks. This video shows you what you need to know to cut the processing time on repetitive tasks to seconds in Excel 2016.
Take this quiz to check in on your Excel Automation skills.
75% is a pass.
This video offers an introduction to the power of Automation in Microsoft Word.
Watch this before completing Module 5.
Autocorrect enables you to automatically correct commonly mis-spelt words in Word.
You can also leverage it to enter in data you need to type in on a regular basis with a few keystrokes in Word 2016.
Quickparts is an extension of Autocorrect.
It enables you to insert larger blocks of repetitive text into Word 2016 documents with a few clicks.
Watermarks enable you to show the reader of a document its nature, ie confidential, draft etc.
This video shows you how to activate watermarks in Word 2016.
This video shows you what you MUST know about inserting one Word document into another to make combining documentation in Word 2016 easy.
This video shows you how to utilise Word 2016's inbuilt styles for document consistency and to make global changes to headings.
Inserting a Table of Contents makes your documents look more professional whilst making on screen navigation easier. This video show you how to create them in a Word 2016 document.
Templates enable you to have common documents with foundation text created to enable you to quickly and easily create a new document without the worry of doing a "Save As" and accidentally overwriting important data in Word 2016.
This video takes you through the process of completing a mail merge using an Excel list as the data source.
This videos shows you how to quickly insert a file name and path into the footer of a document in Word 2016 to make it easier to locate at a later stage.
Check in to test your knowledge with Word Automation.
75% is a pass.
For over 20 years, Donna has been working as a speaker, trainer and educator to businesses large and small. She believes the very technology that was supposed to make life easier has in fact created more work.
She is passionate about productivity and believes that we need to get stuff done, faster and smarter so we can get back to enjoying our lives with those we love.
Her style is practical, engaging and make learning fun and easy.
With a degree in Training & Development, Donna's no jargon sessions focus on what you need to know to get more done in less time, rather than tick boxes of topics you may never use.