Microsoft Office Time-Saving Techniques

Become More Productive in Microsoft Office Excel, Word, PowerPoint and Outlook
4.4 (13 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.
1,569 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 36
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

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


What are the 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.

What am I going to get from this course?

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

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Microsoft Office 2013 Time-Saving Tools for the Office Newb Course Intro
04:05

Get an overview of the course

Section 2: Excel - Save Time Creating Dynamic Reports with PivotTables
02:50

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

06:25

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

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

04: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

Article

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

10 pages

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.

4 questions

Test your knowledge on Excel PivotTables

Section 3: Excel - Save Time by Automating Excel Tasks by Using Macros
02: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.

09: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.

06: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.

08: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.

Article

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

8 pages
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.
4 questions

Test your Knowledge of automating Excel tasks with Macros

Section 4: Word - Creating Consistent Formatting with Styles
06: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.

05: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.

04:35

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

08:18

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

2 questions

Test your knowledge of Word Styles

Section 5: Word - Creating a Dynamic Table of Contents
05:52

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

04:14

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

04:08

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

2 questions

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

Section 6: PowerPoint - Understanding and Using the Master Slide
02: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.

10: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.

07: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.

2 questions

Test your knowledge of PowerPoint Master Slides

Section 7: PowerPoint - Managing a PowerPoint Presentation with Custom Shows
03:26

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

05:00

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

Article

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

6 pages

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

1 question

Test your knowledge of PowerPoint Custom shows

Section 8: Outlook - Organizing Your Outlook Content with Categories
03: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.

07: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.

02: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.

04:57

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

2 questions

Test your knowledge of organizing your Outlook content

Section 9: Outlook - Automating your Outlook Experience with Quick Steps
04: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.

06: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.

Article

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

5 pages
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.
1 question

Test your knowledge of Outlook Quick Steps

Section 10: CONGRATULATIONS! BONUS COURSES
BONUS! - Special Offer! Discount on Any of my Courses!
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kyle Pew, Microsoft Certified Trainer - 25,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!

Ready to start learning?
Take This Course