Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Ultimate Microsoft Office Productivity Tips to your Wishlist.

Add to Wishlist

Ultimate Microsoft Office Productivity Tips

Boost Productivity with these Microsoft Office Tips (Excel, Word, PowerPoint & Outlook)
4.7 (68 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.
4,860 students enrolled
Created by Kyle Pew
Last updated 8/2016
$10 $40 75% off
4 days left at this price!
30-Day Money-Back Guarantee
  • 41 mins on-demand video
  • 2 Articles
  • 18 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?

Join this course to learn some of the best quick tips that the Microsoft Office Suite has to offer.


Due to the popularity of this course, I have added 6 additional tips on how you can boost your productivity in the Microsoft Office suite. These additional tips have come from requests made by students of this course. Tools that these students are interested in learning more about and ultimately boosting their own productivity. So keep an eye out for the bonus lectures beyond the 8 original lectures.


With each new release of Microsoft Office, Microsoft adds more tools to streamline your work and help you become more productive. During this course I will introduce you to 14 of the best, quick tips that the Microsoft Office Suite has to offer in Excel, Word, PowerPoint and Outlook (+ bonus tips).

  • Each of the video lectures contained in this course are short, 2-3 minute clips, and impactful
  • Lectures and simple to understand and apply
  • Take the tips learned and immediately begin to use them everyday
  • Exercise files are provided to immediately practice the material for each lecture

Quick, enroll now and learn the hottest features of Microsoft Office that will propel your Microsoft Office skills to new heights.

Who is the target audience?
  • If you're looking for tips on how to boost your productivity as you work in the Microsoft Office applications, then you're in the right course.
Students Who Viewed This Course Also Viewed
What Will I Learn?
Learn some simple features of Microsoft Office to boost productivity
Editing PDFs in Microsoft Word
Make PowerPoint bullets more interactive and engaging
Automate data entry in Microsoft Excel
Clean up your Outlook Inbox
Work with Excel Macros
Create cleaner PowerPoint Presentations
Report on Excel data with PivotTables
View Curriculum
  • In order to practice these tips you will need access to Microsoft Office
Curriculum For This Course
Expand All 23 Lectures Collapse All 23 Lectures 01:04:41
Introduction to the Course
1 Lecture 02:46

Get to know some of the hottest tips on working in the Microsoft Office Suite

  • Navigating a Word Doc
  • Editing PDF documents with Word
  • Make PowerPoint bullets more engaging
  • Working with Online videos in PowerPoint
  • Automating Excel data Entry
  • Cleaning up your Outlook Inbox
Preview 02:46
2 Quick Tips on working in Microsoft Excel
7 Lectures 14:33

During this lecture Kyle will introduce you to a new feature in Excel 2013 called FlashFill. FlashFill will assist you in breaking a value out of one column into another other, automating the data entry for you.

Preview 02:50

During this exercise Kyle will introduce you a more intuitive method of filtering a list using the Slicer tool.

Preview 03:06

During this lecture Kyle will give you a quick intro into Excel PivotTables.

Preview 02:31

In this lecture Kyle will introduce you to the world of automation using Excel Macros.

Excel Bonus: Creating Automation in Excel with Macros

In this lecture Kyle will demonstrate editing an Excel Macro using Visual Basic (VBA)

Excel Bonus: Editing an Excel Macro with Visual Basic (VBA)

During this exercise you will automate data entry by using Excel's FlashFill feature and filter a table using a Slicer.

Exercise #1 - Microsoft Excel FlashFill and Slicer Tool
5 pages

This exercise will walk you through the steps of working with Excel PivotTables.

Bonus Exercise: Summarizing Data with Excel PivotTables
4 pages
2 Quick Tips on working in Microsoft Word
4 Lectures 07:21

During this lecture Kyle will introduce to a feature new to Word 2013. Microsoft Word now allows you to open and edit PDF documents.

Editing PDF Documents in Microsoft Word

During this lecture Kyle will introduce you to Word's Navigation Pane. Using the Navigation Pane will speed up your searching of large Microsoft Word documents.

Using the Navigation Pane in Microsoft Word

During this lecture Kyle will introduce to using Track Changes in Microsoft Word as well as Accept or Reject the changes made.

Word Bonus: Track Changes in a Word Doc

During this exercise you will practice the new tips of editing a PDF doc and using Word navigation pane to search the document.

Exercise #2 - Microsoft Word Editing a PDF and the Navigation Pane
5 pages
2 Quick Tips on working in Microsoft PowerPoint
5 Lectures 10:16

During this lecture Kyle will demonstrate taking a simple bullet list and transform it automatically into something more graphical and engaging, using a feature called SmartArt.

Converting PowerPoint Bullet Points to SmartArt

During this lecture Kyle will introduce you to the wonders of placing online videos in your PowerPoint presentations.

Inserting Online Videos in PowerPoint Presentations

During this lecture Kyle will demonstrate how you can enhance a simple bullet list by formatting the bullet points.

PowerPoint Bonus: Formatting Bullet Points

During this lecture Kyle will demonstrate how to create a clean design by automatically aligning items in a PowerPoint slide.

PowerPoint Bonus: Quickly Align and Distribute Items in PowerPoint

During this exercise you will make a more engaging PowerPoint presentation by using SmartArt and inserting online vidoes

Exercise #3 - Creating Engaging Presentations with PowerPoint
5 pages
2 Quick Tips on working in Microsoft Outlook
3 Lectures 04:48

During this lecture Kyle will introduce you to the Conversation View in Outlook

Clean Up Your Outlook Inbox with Conversation View

During this lecture Kyle will introduce you to the Reply with Meeting option found within Outlook

Convert an Email Conversation into a Meeting Request

During this exercise you will take advantage of Outlooks Conversation View to clean up your inbox and reply to a conversation with a meeting invite.

Exercise #4 - Using Microsoft Outlooks Conversation View
4 pages
Congratulations - Bonus Material
3 Lectures 02:15
Congratulations on Completing the Course

BONUS - Special Offer! Discount on any of my courses!

BONUS - Other Microsoft Office Resources
About the Instructor
4.6 Average rating
5,647 Reviews
38,999 Students
15 Courses
Microsoft Certified Trainer - 35,000+ Udemy Students


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""


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