Ultimate Microsoft Office Productivity Tips

Boost Productivity with these Microsoft Office Tips (Excel, Word, PowerPoint & Outlook)
4.6 (63 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,712 students enrolled
62% off
Take This Course
  • Lectures 23
  • Length 1 hour
  • 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


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


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

About This Course

Published 12/2015 English

Course Description

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.

What are the requirements?

  • In order to practice these tips you will need access to Microsoft Office

What am I going to get from this course?

  • 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

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.

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.


Section 1: Introduction to the Course

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
Section 2: 2 Quick Tips on working in Microsoft Excel

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.


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


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


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


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

5 pages

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

4 pages

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

Section 3: 2 Quick Tips on working in Microsoft Word

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


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.


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

5 pages

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

Section 4: 2 Quick Tips on working in Microsoft PowerPoint

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.


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


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


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

5 pages

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

Section 5: 2 Quick Tips on working in Microsoft Outlook

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


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

4 pages

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.

Section 6: Congratulations - Bonus Material
Congratulations on Completing the Course
BONUS - Special Offer! Discount on any of my courses!
BONUS - Other Microsoft Office Resources

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kyle Pew, 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!

Ready to start learning?
Take This Course