37 Word & Excel 2016 Productivity Tips
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add 37 Word & Excel 2016 Productivity Tips to your Wishlist.

Add to Wishlist

37 Word & Excel 2016 Productivity Tips

Turbo Charging Your Workday Productivity
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Donna Hanson
Last updated 6/2017
English
Curiosity Sale
Current price: $10 Original price: $35 Discount: 71% off
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Increase their productivity by utilising MUST know tricks and shortcuts
  • Recognise how these shortcuts can save time and reduce risk and stress
View Curriculum
Requirements
  • 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
Description

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.

Who is the target audience?
  • Anyone interested in increasing productivity with Word & Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
44 Lectures
01:37:49
+
Module 1 - Introduction to the Course
1 Lecture 01:22

Watch this video and download the workbook before you start the program.  It will show you the best way to work through the material and ensure you get value from the program.  

Preview 01:22
+
Module 2 - Microsoft Excel Tips, Tricks & Shortcuts
12 Lectures 22:48

Welcome to the Microsoft Excel Tips, Tricks & Shortcuts Introduction Video.

Watch this before starting on this module.

Preview 01:06

This videos shows you to to leverage the power of Excel 2016 to quickly SUM (add up) data.

Preview 02:21

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.

Preview 01:09

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.

Preview 01:19

This video shows you how to quickly create a graph to provide a visual representation of your data in Excel 2016.

Preview 03:35

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.

Excel 2016 - Splitting data from one cell into multiple cells (Text to Columns)
01:18

In this video we should you how to trim excess spaces out of cells using the TRIM Function

Excel 2016 - TRIM Function
02:03

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.

Excel 2016 - Proper Function
01:52

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.

Excel 2016 - Concatenate Function
02:37

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

Excel 2016 - Fit to a Page
01:33

This video shows you how to apply headers and footers to the top and bottom of your printed Excel 2016 worksheets.

Excel 2016 - Headers & Footers
02:34

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.

Excel 2016 - Transpose
01:21

Take this quiz to check in on your Excel Tips & Shortcuts skills.

75% is a pass.

Excel Tips & Shortcuts Quiz
4 questions
+
Module 3 - Microsoft Word Tips, Tricks & Shortcuts
9 Lectures 21:43
Module 3 - Microsoft Word Tips, Tricks & Shortcuts Introduction Video
01:09

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.

Word 2016 - Format Painter
01:18

This video shows you how to change the default line spacing in Word 2016 to suit your preferences.

Word 2016 - Line Spacing
01:33

This video shows you tips and tricks to make working with and understanding bullets in Word 2016 easy.

Word 2016 - Bullets
02:44

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.

Word 2016 - Tables
04:33

This video shows you tips and shortcuts that will save you time, stress and frustration when copying and pasting data in Word 2016.

Word 2016 - Copying & Pasting Tips
01:34

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.

Word 2016 - Page Breaks
01:06

This video explores what headers and footers are and how to insert them in Word 2016 documents.

Word 2016 - Headers & Footers
04:43

This video shows you the tricks you need to know to make inserting an Excel worksheet into a Word document easier.

Word 2016 - Inserting an Excel Worksheet into a Word Document
03:03

Take this quiz to check in on your Word Tips & Shortcuts skills.

75% is a pass.

Word Tips & Shortcuts Quiz
4 questions
+
Module 4 - Microsoft Excel - Automation
11 Lectures 29:04

This module gets you started on how to leverage Excel to automate common tasks.

Watch this video before starting this segment.

Module 4 - Microsoft Excel Automation Introduction Video
01:19

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.

Excel 2016 - Range Names
01:46

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.

Excel 2016 - 3 Dimensional Formulas
04:39

This video introduces the concept of Pivot Tables. What they are and how they make data analysis much easier in Excel 2016.

Excel 2016 - Pivot Tables
03:55

This video shows you how to Subtotal long lists of records quickly and easily.

Excel 2016 - SubTotals
01:40

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.

Excel 2016 - Droplists
03:17

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.

Excel 2016 - Conditional Formatting
01:44

This video shows you how to utilise the remove duplicates feature of Excel 2016 to clean up multiple entries in an Excel list.

Excel 2016 - Remove Duplicates
01:25

This video shows you how to create hyperlinks in spreadsheets and the benefits of using them in files to be accessed by others.

Excel 2016 - Hyperlinks
02:36

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.

Excel 2016 - Protection
03:17

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.

Excel 2016 - Macros
03:26

Take this quiz to check in on your Excel Automation skills.

75% is a pass.

Excel Automation Quiz
4 questions
+
Section 5 - Word 2016 - Automation
10 Lectures 21:49

This video offers an introduction to the power of Automation in Microsoft Word.

Watch this before completing Module 5.

Module 5 - Microsoft Word Automation Introduction Video
01:26

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.

Word 2016 - Autocorrect
03:00

Quickparts is an extension of Autocorrect.

It enables you to insert larger blocks of repetitive text into Word 2016 documents with a few clicks.

Word 2016 - Quickparts
01:10

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.

Word 2016 - Watermarks
00:49

This video shows you what you MUST know about inserting one Word document into another to make combining documentation in Word 2016 easy.

Word 2016 - Inserting One File Into Another
01:08

This video shows you how to utilise Word 2016's inbuilt styles for document consistency and to make global changes to headings.

Word 2016 - Styles
04:12

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.

Word 2016 - Table of Contents
02:06

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.

Word 2016 - Templates
02:04

This video takes you through the process of completing a mail merge using an Excel list as the data source.

Word 2016 - Mail Merge with Excel Data Source
04:17

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.

Word 2016 - Inserting File Name & Path
01:37

Check in to test your knowledge with Word Automation.

75% is a pass.

Word Automation Quiz
4 questions
+
Summary Video
1 Lecture 01:03
Summary Video - You've finished, Congratulations, Watch this video.
01:03
About the Instructor
Donna Hanson
0.0 Average rating
0 Reviews
0 Students
1 Course
Speaker | Trainer | Educator

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.