4.05 out of 5
4.05
108 reviews on Udemy

Ultimate Microsoft Office Productivity Tips

Boost Productivity with these Microsoft Office Tips (Excel, Word, PowerPoint & Outlook)
Instructor:
Kyle Pew
5,274 students enrolled
English [Auto-generated]
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

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.

Introduction to the Course

1
Introduction to Course Topics

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

2 Quick Tips on working in Microsoft Excel

1
Automating Excel Data Entry with "FlashFill"

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.

2
Using the Excel Slicer Tool to Filter Data

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

3
Excel Bonus: Summarizing Data with Excel PivotTables

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

4
Excel Bonus: Creating Automation in Excel with Macros

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

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

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

6
Exercise #1 - Microsoft Excel FlashFill and Slicer Tool

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

7
Bonus Exercise: Summarizing Data with Excel PivotTables

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

2 Quick Tips on working in Microsoft Word

1
Editing PDF Documents 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.

2
Using the Navigation Pane 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.

3
Word Bonus: Track Changes in a Word Doc

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

4
Exercise #2 - Microsoft Word Editing a PDF and the Navigation Pane

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

2 Quick Tips on working in Microsoft PowerPoint

1
Converting PowerPoint Bullet Points to SmartArt

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.

2
Inserting Online Videos in PowerPoint Presentations

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

3
PowerPoint Bonus: Formatting Bullet Points

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

4
PowerPoint Bonus: Quickly Align and Distribute Items in PowerPoint

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

5
Exercise #3 - Creating Engaging Presentations with PowerPoint

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

2 Quick Tips on working in Microsoft Outlook

1
Clean Up Your Outlook Inbox with Conversation View

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

2
Convert an Email Conversation into a Meeting Request

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

3
Exercise #4 - Using Microsoft Outlooks Conversation View

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.

Congratulations - Bonus Material

1
Congratulations on Completing the Course
2
BONUS - Special Offer! Discount on any of my courses!
3
BONUS - Other Microsoft Office Resources
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.1
4.1 out of 5
108 Ratings

Detailed Rating

Stars 5
64
Stars 4
29
Stars 3
12
Stars 2
1
Stars 1
2
94612b587f2623eec6ec147f8514b7be
30-Day Money-Back Guarantee

Includes

1 hours on-demand video
2 articles
Full lifetime access
Access on mobile and TV
Certificate of Completion