Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Word & Excel 365 Productivity Tips
Rating: 4.4 out of 5(1,395 ratings)
7,817 students

Microsoft Word & Excel 365 Productivity Tips

How to make your workday more productive
Created byDonna Hanson
Last updated 5/2024
English

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!

Course content

6 sections • 45 lectures • 1h 37m total length

  • Introduction Video - Watch This Video & Download Resources Before You Start1: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.  

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

***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 Excel

  1. Shortcuts to adding or summing data

  2. How to copy worksheets EXACTLY as you want them

  3. How to send a single worksheet in a file to someone instead of the whole worksheet

  4. 1 Key Graph/Chart creation

  5. How to split data in one cell into multiple columns

  6. How to easily remove extra spaces in cells

  7. How to easily change the casing of text in cells

  8. How to "add" cells containing text together

  9. How to get ALL your data to print on a single page

  10. How to set up headers & footers on your worksheet

  11. How to flip data you've already entered from being across the spreadsheet to down the spreadsheet

  12. How to make finding and referring to key information in your spreadsheet easy

  13. Simple formulas to add up data across multiple worksheet

  14. How to create a pivot table to enable you to analyse data

  15. How to easily subtotal a long list of data

  16. How to create droplists to keep data entry in cells consistent

  17. How to highlight cells that meet a specific criteria

  18. How to remove duplicate entries from data lists

  19. How to leverage hyperlinks to move around larger spreadsheets

  20. How to protect your data from user errors

  21. How to automate common, repetitive tasks.

Microsoft Word

  1. How to apply formatting from one part of a document to another with a couple of clicks

  2. Setting up default line spacing

  3. Making bullets work for you, not against you.

  4. Simple tips on creating and working with tables.

  5. Copying and pasting "insider" tips to save hours of frustration

  6. Fast tracking page breaks

  7. Understanding headers and footers and how they work in Word

  8. Inserting an Excel worksheet into a Word document.

  9. How to automatically insert common text

  10. How to insert larger blocks of text with a few clicks

  11. How to insert watermarks on documents

  12. How to insert one file into another

  13. Using styles to make document formatting EASY

  14. Creating an automated table of contents

  15. Creating templates to save time and frustration on repetitive tasks

  16. Easy mail merge with an Excel worksheet as a data source

  17. 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

Report abuse