Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft Office Time-Saving Techniques to your Wishlist.

Add to Wishlist

Microsoft Office Time-Saving Techniques

Become More Productive in Microsoft Office Excel, Word, PowerPoint and Outlook
4.7 (28 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.
2,782 students enrolled
Created by Kyle Pew
Last updated 8/2016
English
$10 $40 75% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 5 Articles
  • 7 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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 is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
What Will I 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.
View Curriculum
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.
Curriculum For This Course
Expand All 36 Lectures Collapse All 36 Lectures 02:59:57
+
Microsoft Office 2013 Time-Saving Tools for the Office Newb Course Intro
1 Lecture 04:05

Get an overview of the course

Preview 04:05
+
Excel - Save Time Creating Dynamic Reports with PivotTables
6 Lectures 20:17

Learn how to take a large data set within Excel and summarize the data with a PivotTable

Preview 02:50

Learn the step by step process to summarize data using a PivotTable.

Creating an Excel PivotTable
06:25

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 PivotTable Calculations
05: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

Creating PivotCharts
04:46

Completing this exercise will take you through creating an Excel PivotTable in order to summarize data based on a large set of Excel data.

Preview 00:30

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.

Preview 10 pages

Test your knowledge on Excel PivotTables

Excel PivotTables
4 questions
+
Excel - Save Time by Automating Excel Tasks by Using Macros
6 Lectures 27: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.

Preview 02:12

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.

Using the Macro Recorder
09:05

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.

Creating a Button to Run a Macro
06:26

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.

Editing Excel Macros with VBA
08:46

Completing this exercise will walk you through each step in order to automate an Excel task using the Macro recorder.

Exercise: Create a Microsoft Excel Macros
00:43

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.
Microsoft Excel Macros Step by Step Handout
8 pages

Test your Knowledge of automating Excel tasks with Macros

Excel Macros
4 questions
+
Word - Creating Consistent Formatting with Styles
4 Lectures 25:10

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.

Preview 06:50

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.

Creating Custom Word Styles
05:27

Learn how you can easily modify a style that updates your entire document.

Updating/Editing Word Styles
04:35

Learn how styles are not just for formatting. Take advantage of styles for navigation and quick reordering of word content.

Word Styles and the Navigation Pane
08:18

Test your knowledge of Word Styles

Word Styles
2 questions
+
Word - Creating a Dynamic Table of Contents
3 Lectures 14:14

Learn how to take a styled document and have Word generate the Table of Contents based on those styles.

Using Styles to Create a Dynamic Table of Contents
05:52

Through a few simple clicks of the mouse, automate the creation of a Table of Contents

Creating the Table of Contents
04:14

Learn how quickly a table of contents can be updated with the proper edits to a document

Updating/Editing the Table of Contents
04:08

Test your knowledge of working with the Word Table of Contents feature

Word Table of Contents
2 questions
+
PowerPoint - Understanding and Using the Master Slide
3 Lectures 19:51

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.

Preview 02:18

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.

Using a Master Slide in PowerPoint
10:29

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.

Creating a Custom Slide Layout
07:04

Test your knowledge of PowerPoint Master Slides

PowerPoint Master Slides
2 questions
+
PowerPoint - Managing a PowerPoint Presentation with Custom Shows
4 Lectures 08:59

During this video lecture Kyle will introduce you using Custom Shows in your PowerPoint presentations saving you time and managing one document.

Preview 03:26

During this video lecture Kyle will walk your through the steps of creating Custom Shows in PowerPoint.

Creating and Viewing Custom Shows in PowerPoint
05:00

Completing this exercise will help you become more efficient in working with PowerPoint presentations that contain custom shows.

Exercise: Using Microsoft PowerPoint Custom Shows
00:33

A step by step handout in PDF format that you can use to walk through the steps of working with PowerPoint custom shows.

Microsoft PowerPoint Custom Shows Step by Step Handout
6 pages

Test your knowledge of PowerPoint Custom shows

PowerPoint Custom Shows
1 question
+
Outlook - Organizing Your Outlook Content with Categories
4 Lectures 18:59

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.

Preview 03:28

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.

Using Outlook Categories to Organize your Content
07:36

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.

Creating Custom Outlook Categories
02:58

During this video lecture Kyle will walk you though the process of using categories to find Outlook content efficentlly.

Searching Outlook Content by Category
04:57

Test your knowledge of organizing your Outlook content

Organizing Outlook Content
2 questions
+
Outlook - Automating your Outlook Experience with Quick Steps
4 Lectures 11:21

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.

Preview 04:31

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.

Create and Use Outlook Quick Steps
06:20

Completing this exercise will walk your through automating inbox tasks, such as sending email using Outlook Quick Steps.

Exercise: Working with Microsoft Outlook Quick Steps
00:30

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 Step by Step Handout
5 pages

Test your knowledge of Outlook Quick Steps

Outlook Quick Steps
1 question
+
CONGRATULATIONS! BONUS COURSES
1 Lecture 01:09
BONUS! - Special Offer! Discount on Any of my Courses!
01:09
About the Instructor
4.6 Average rating
5,627 Reviews
38,937 Students
15 Courses
Microsoft Certified Trainer - 35,000+ Udemy Students

Qualifications:

Kyle is a Microsoft Certified Trainer (MCT) and a certified Microsoft Office Master Instructor and has been teaching and consulting for the past 10+ years on various computer applications, including;

  1. Microsoft Office Suite 1997, 2000, XP, 2003, 2007, 2010, 2013
    1. Excel, Word, PowerPoint, Outlook, Access and Visio
  2. SharePoint End-User 2007, 2010, 2013
  3. VBA (Excel and Access)
  4. Adobe Suite
    1. Photoshop, Illustrator, InDesign
  5. Maya (Modeling and Animation)
  6. Unity3d (Game Design)
  7. HTML, CSS and JavaScript
  8. Crystal Reports

Kyle is a graduate of the San Francisco Art Institute in the Media Arts and Animation Program. He has worked as a Game Designer for Electronic Arts, designing on games such as Nerf N-Strike, Nerf N-Strike Elite, both for the Wii, and a Sims 3 Expansion Pack for the PC.

Kyle has facilitated courses that range from 1-on-1 interactions to large scale groups of 100+ participants, including; live in person classes, webinar style classes online and live online full courses. He is consistently ranked top in reviews for each of the courses he teaches.

Some of the clients Kyle has provided training for include:

  • Brocade
  • Chevron
  • Genentech
  • Facebook
  • Levi Strauss
  • PMI Mortgage Insurance
  • State Fund
  • Bank of the West
  • VISA
  • Walmart
  • and many more...


What Students have said about Kyle:

      • "Kyle was off the chart "GOOD""

      • "ONE OF THE BEST COURSES THAT I'VE HAD... (IN 12+ YEARS)."

      • "Awesome trainer because I'm computer "stupid" and he helped me understand it."

      • "Kyle Pew is very knowledgeable and presented information with exceptional skill."


In his 10+ years of training (corporate training, 1-on-1 consulting and college courses), Kyle has taught 1000's of courses and 10's of thousands of students all the while maintaining a high level of delivery and satisfaction from the student he has taught.

Teaching Philosophy:

Kyle believes that student’s best learn through the application of real-life business situations through exercises. Allowing students to guide the class with their specific situations allows for the quickest and easiest adaptation to new technology and skills.

In His Spare Time:

Kyle enjoys spending time with his family (6 children). When he’s not busy entertaining his kids, you will find him cheering on his favorite hockey team, the San Jose Sharks, this is their year!

Report Abuse