Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Microsoft Office Time-Saving Techniques

Name: Microsoft Office Time-Saving Techniques
Rating: 4.4 (216 reviews)

Become More Productive in Microsoft Office Excel, Word, PowerPoint and Outlook

Created byKyle Pew • 2,000,000+ Students

Last updated 3/2016

English

What you'll learn

Practice the skills you'll learn with section quizzes and exercises
You will learn how to cutback on the clutter and disorganization of your Outlook Inbox
You will become a Microsoft Word master by learning how to effectively manage large Word documents
You will learn how to create consistently formatted PowerPoint presentations by harnessing the power of PowerPoint master slides
You will become more efficent in working with large data sets in Excel
Ultimately you will learn to save time with these Microsoft Office productivity techniques.

Course content

9 sections • 35 lectures • 2h 29m total length

Introduction to the course material4:05
Get an overview of the course

Understanding Excel PivotTables2:50
Learn how to take a large data set within Excel and summarize the data with a PivotTable
Creating an Excel PivotTable6:25
Learn the step by step process to summarize data using a PivotTable.
Creating PivotTable Calculations5:46
Not only will you be able summarize data using PivotTables, but you will also learn how to create and manipulate the calculations within your PivotTables
Creating PivotCharts4:46
If summarize data isn't enough you will also learn how to take the PivotTable report and display the data visually using a Pivot Chart
Exercise: Microsoft Excel PivotTables0:26
Completing this exercise will take you through creating an Excel PivotTable in order to summarize data based on a large set of Excel data.
Microsoft Excel PivotTable Step by Step Handout10:00
A PDF step by step instruction on the topic of Excel PivotTables. This PDF is fully illustrated and contains exercises at the end of each section to provide you with an example to practice with.
Excel PivotTables

Understanding Excel Macros2:12
During this video Kyle will introduce you to the concept of an Excel Macro and how Macros can ultimately save you time while working in Microsoft Excel.
Using the Macro Recorder9:05
During this video Kyle will walk you through using the Microsoft Excel Macro Recorder tool. Using the Macro recorder is one of the most efficient ways of automating your tasks within Excel.
Creating a Button to Run a Macro6:26
During this video lecture Kyle will talk you through the steps of creating a button to run your Excel Macro. Using a button provides not only you but others an interface to run your macros.
Editing Excel Macros with VBA8:46
During this video lecture Kyle will take you into the world of Excel VBA, were you can make edits to macros that you have created using the Macro recorder. By editing a macro with VBA you will create more dynamic, logic based Macros.
Exercise: Create a Microsoft Excel Macros0:41
Completing this exercise will walk you through each step in order to automate an Excel task using the Macro recorder.
Microsoft Excel Macros Step by Step Handout8:00
A PDF step by step instruction on the topic of Excel Macros. This PDF is fully illustrated and contains exercises at the end of each section to provide you with an example to practice with.
Excel Macros

Formatting a Document with Styles6:50
Word styles will introduce you not only how to properly format a Word doc but will also open your documents up to many other features automating the maintenance of large documents.
Creating Custom Word Styles5:27
Microsoft Word not only has many out of the box styles ready for you to use, but you can also take advantage of custom styles created by you. Learn how to brand your documents to fit your color and font schemes.
Updating/Editing Word Styles4:35
Learn how you can easily modify a style that updates your entire document.
Word Styles and the Navigation Pane8:18
Learn how styles are not just for formatting. Take advantage of styles for navigation and quick reordering of word content.
Word Styles

Using Styles to Create a Dynamic Table of Contents5:52
Learn how to take a styled document and have Word generate the Table of Contents based on those styles.
Creating the Table of Contents4:14
Through a few simple clicks of the mouse, automate the creation of a Table of Contents
Updating/Editing the Table of Contents4:08
Learn how quickly a table of contents can be updated with the proper edits to a document
Word Table of Contents

Understanding PowerPoint Master Slides2:18
During this video lecture Kyle will introduce you to the Power of PowerPoint master slides and how they can be used to create consistentcy throughout your presentation.
Using a Master Slide in PowerPoint10:29
During this video lecture Kyle will walk you through using PowerPoint master slides. By placing an image in the PowerPoint master slide you can automate the steps that you would normally take to place that same image on each individual slide in your presentation.
Creating a Custom Slide Layout7:04
During this video lecture Kyle will introduce you to creating a custom slide layout that can be used on any of your slides in your presentation.
PowerPoint Master Slides

Understanding PowerPoint Custom Shows3:26
During this video lecture Kyle will introduce you using Custom Shows in your PowerPoint presentations saving you time and managing one document.
Creating and Viewing Custom Shows in PowerPoint5:00
During this video lecture Kyle will walk your through the steps of creating Custom Shows in PowerPoint.
Exercise: Using Microsoft PowerPoint Custom Shows0:32
Completing this exercise will help you become more efficient in working with PowerPoint presentations that contain custom shows.
Microsoft PowerPoint Custom Shows Step by Step Handout6:00
A step by step handout in PDF format that you can use to walk through the steps of working with PowerPoint custom shows.
PowerPoint Custom Shows

Understanding Outlook Categories3:28
During this video lecture Kyle will introduce you to the working with Outlook and categories and how they will help you better maintain your Outlook inbox.
Using Outlook Categories to Organize your Content7:36
During this video lecture Kyle will walk you through how Outlook categories can be used to help organize your Outlook content, Inbox, Calendar, Contacts or Tasks.
Creating Custom Outlook Categories2:58
During this video lecture Kyle will take into creating your own custom Outlook categories that can be used to tag and organize your Outlook content.
Searching Outlook Content by Category4:57
During this video lecture Kyle will walk you though the process of using categories to find Outlook content efficentlly.
Organizing Outlook Content

Understanding Outlook Quick Steps4:31
During this video lecture Kyle will introduce you to how you can automate some of the more routine tasks, using Outlook Quick Steps, that we all do in our Outlook Inbox.
Create and Use Outlook Quick Steps6:20
During this video lecture Kyle will walk you through how to create Outlook Quick Steps that can be used to save you time and automate routine Inbox tasks.
Exercise: Working with Microsoft Outlook Quick Steps0:27
Completing this exercise will walk your through automating inbox tasks, such as sending email using Outlook Quick Steps.
Outlook Quick Steps Step by Step Handout5:00
A PDF step by step instruction on the topic of Outlook Quick Steps. This PDF is fully illustrated and contains exercises at the end of each section to provide you with an example to practice with.
Outlook Quick Steps

Requirements

If you'd like to follow along you'll need Microsoft Office installed. Otherwise you can sit back, relax and enjoy learning some time-saving tools.

Description

We've all wished for more time to accomplish more during our busy days. What we really need is to learn how to cutback on the time we spend doing routine tasks. For example, the average office worker spends 25% of their work week managing their Outlook inbox.

Use the Microsoft Office Applications to their full potential

Microsoft Word Styles to create consistent formatting and automate a Table of Contents
Create Excel Macros to automate your work
Use PowerPoint Master Slides to create eye catching presentations
Organize your Outlook inbox with Categories

Spend less time doing routine tasks

If you've ever thought there must be an easier more efficient way of doing something in Microsoft Office, then this course is for you.

During this course I will introduce you to some of the time-saving techniques and tools that each of the Office applications provide. By implementing the tools that I'll walk you through, you will cutback on the time it takes to complete a task, getting back that 25%, and create more dynamic and efficient documents.

Lecture Topics

You will gain an understanding of how to work with and become more efficient with large sets of data in Excel (Excel Lists/Tables).

Create dynamic reports with Excel PivotTables
Get Excel to work for you by automating tasks with Macros
Take a quiz at the end of the section to test what you've learned

You will learn to streamline your efforts in creating and maintaining Microsoft Word documents.

Use Word styles to create consistency throughout the formatting of your documents
Take advantage of Microsoft Words built in Tables of Contents tool
Take a quiz at the end of the section to test what you've learned

You will be immersed into the time-saving techniques of creating efficient PowerPoint presentations.

Use Master Slides to eliminate slide by slide formatting
Use Custom Shows within the same presentation file
Take a quiz at the end of the section to test what you've learned

You will break the shackles that tie you to Microsoft Outlook, ultimately getting that time back to be more productive with your day.

Use Outlook categories, making searching an organizing a breeze
Automate routine Outlook tasks by using "Quick Steps"
Take a quiz at the end of the section to test what you've learned

Each section has a quiz where you can test your knowledge on the topics discussed throughout the videos.

At completion of this course you will be amazed at all the extra time you have during your workday.

Who this course is for:

This Microsoft Office course is designed for individuals that are looking to become more efficient in the Microsoft Office Suite of applications. If you've ever felt like there should be a quicker, easier way of completing a task in Excel or spending too much of your busy day managing and organizing your Outlook inbox, then this course is for you.

Microsoft Office Time-Saving Techniques

What you'll learn

Explore related topics

Course content

Microsoft Office 2013 Time-Saving Tools for the Office Newb Course Intro1 lecture • 4min

Excel - Save Time Creating Dynamic Reports with PivotTables6 lectures • 30min

Excel - Save Time by Automating Excel Tasks by Using Macros6 lectures • 35min

Word - Creating Consistent Formatting with Styles4 lectures • 25min

Word - Creating a Dynamic Table of Contents3 lectures • 14min

PowerPoint - Understanding and Using the Master Slide3 lectures • 20min

PowerPoint - Managing a PowerPoint Presentation with Custom Shows4 lectures • 15min

Outlook - Organizing Your Outlook Content with Categories4 lectures • 19min

Outlook - Automating your Outlook Experience with Quick Steps4 lectures • 16min

Requirements

Description

Who this course is for: