What you'll 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

Course content

6 sections • 21 lectures • 40m total length

Introduction to Course Topics2: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

Automating Excel Data Entry with "FlashFill"2:50
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.
Using the Excel Slicer Tool to Filter Data3:06
During this exercise Kyle will introduce you a more intuitive method of filtering a list using the Slicer tool.
Excel Bonus: Summarizing Data with Excel PivotTables2:31
During this lecture Kyle will give you a quick intro into Excel PivotTables.
Excel Bonus: Creating Automation in Excel with Macros2:45
In this lecture Kyle will introduce you to the world of automation using Excel Macros.
Excel Bonus: Editing an Excel Macro with Visual Basic (VBA)3:21
In this lecture Kyle will demonstrate editing an Excel Macro using Visual Basic (VBA)
Exercise #1 - Microsoft Excel FlashFill and Slicer Tool5:00
During this exercise you will automate data entry by using Excel's FlashFill feature and filter a table using a Slicer.
Bonus Exercise: Summarizing Data with Excel PivotTables4:00
This exercise will walk you through the steps of working with Excel PivotTables.

Editing PDF Documents in Microsoft Word1:56
During this lecture Kyle will introduce to a feature new to Word 2013. Microsoft Word now allows you to open and edit PDF documents.
Using the Navigation Pane in Microsoft Word1:50
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.
Word Bonus: Track Changes in a Word Doc3:35
During this lecture Kyle will introduce to using Track Changes in Microsoft Word as well as Accept or Reject the changes made.
Exercise #2 - Microsoft Word Editing a PDF and the Navigation Pane5:00
During this exercise you will practice the new tips of editing a PDF doc and using Word navigation pane to search the document.

Converting PowerPoint Bullet Points to SmartArt2: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.
Inserting Online Videos in PowerPoint Presentations2:49
During this lecture Kyle will introduce you to the wonders of placing online videos in your PowerPoint presentations.
PowerPoint Bonus: Formatting Bullet Points2:38
During this lecture Kyle will demonstrate how you can enhance a simple bullet list by formatting the bullet points.
PowerPoint Bonus: Quickly Align and Distribute Items in PowerPoint2:33
During this lecture Kyle will demonstrate how to create a clean design by automatically aligning items in a PowerPoint slide.
Exercise #3 - Creating Engaging Presentations with PowerPoint5:00
During this exercise you will make a more engaging PowerPoint presentation by using SmartArt and inserting online vidoes

Clean Up Your Outlook Inbox with Conversation View2:46
During this lecture Kyle will introduce you to the Conversation View in Outlook
Convert an Email Conversation into a Meeting Request2:02
During this lecture Kyle will introduce you to the Reply with Meeting option found within Outlook
Exercise #4 - Using Microsoft Outlooks Conversation View4:00
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.

Requirements

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

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.

Who this course is for:

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'll learn

Explore related topics

Course content

Introduction to the Course1 lecture • 3min

2 Quick Tips on working in Microsoft Excel7 lectures • 24min

2 Quick Tips on working in Microsoft Word4 lectures • 12min

2 Quick Tips on working in Microsoft PowerPoint5 lectures • 15min

2 Quick Tips on working in Microsoft Outlook3 lectures • 9min

Congratulations - Bonus Material1 lecture • 1min

Requirements

Description

Who this course is for: