Course Information
Course Overview
Become More Productive in Microsoft Office Excel, Word, PowerPoint and Outlook
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.
Course Content
- 9 section(s)
- 35 lecture(s)
- Section 1 Microsoft Office 2013 Time-Saving Tools for the Office Newb Course Intro
- Section 2 Excel - Save Time Creating Dynamic Reports with PivotTables
- Section 3 Excel - Save Time by Automating Excel Tasks by Using Macros
- Section 4 Word - Creating Consistent Formatting with Styles
- Section 5 Word - Creating a Dynamic Table of Contents
- Section 6 PowerPoint - Understanding and Using the Master Slide
- Section 7 PowerPoint - Managing a PowerPoint Presentation with Custom Shows
- Section 8 Outlook - Organizing Your Outlook Content with Categories
- Section 9 Outlook - Automating your Outlook Experience with Quick Steps
What You’ll Learn
- 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.
Skills covered in this course
Reviews
-
MMariama Kema Toure
It is great course but because I took your excel, word and PPT course. I did not really need this course because I learned all of this already from there except Outlook but then again, I already knew those tips and trips except for one.
-
AAnthoni P
Thanks, for the training on Microsoft Office Time Saving Techniques. Learnt some quick short cuts and automation. Now I can easily do my routine work on Microsoft Office with Time Saving.
-
SSudhindra Gururaj Karpur
Most of the contents were repeatition of earlier courses which I took related to MS Excel, Word and PPT. Still I very much enjoyed the way Kyle facilitates the course and bring out useful tips to increase our productivity. Thanks
-
MMatt Wood
Such a helpful course. The benefits of which will definitely speed up my productivity as I use these applications in my day to day working life. Thanks!