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
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.
You will gain an understanding of how to work with and become more efficient with large sets of data in Excel (Excel Lists/Tables).
You will learn to streamline your efforts in creating and maintaining Microsoft Word documents.
You will be immersed into the time-saving techniques of creating efficient PowerPoint presentations.
You will break the shackles that tie you to Microsoft Outlook, ultimately getting that time back to be more productive with your day.
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.
Learn how to take a large data set within Excel and summarize the data with a PivotTable
Learn the step by step process to summarize data using a PivotTable.
Not only will you be able summarize data using PivotTables, but you will also learn how to create and manipulate the calculations within your PivotTables
If summarize data isn't enough you will also learn how to take the PivotTable report and display the data visually using a Pivot Chart
Completing this exercise will take you through creating an Excel PivotTable in order to summarize data based on a large set of Excel data.
A PDF step by step instruction on the topic of Excel PivotTables. This PDF is fully illustrated and contains exercises at the end of each section to provide you with an example to practice with.
Test your knowledge on Excel PivotTables
During this video Kyle will introduce you to the concept of an Excel Macro and how Macros can ultimately save you time while working in Microsoft Excel.
During this video Kyle will walk you through using the Microsoft Excel Macro Recorder tool. Using the Macro recorder is one of the most efficient ways of automating your tasks within Excel.
During this video lecture Kyle will talk you through the steps of creating a button to run your Excel Macro. Using a button provides not only you but others an interface to run your macros.
During this video lecture Kyle will take you into the world of Excel VBA, were you can make edits to macros that you have created using the Macro recorder. By editing a macro with VBA you will create more dynamic, logic based Macros.
Completing this exercise will walk you through each step in order to automate an Excel task using the Macro recorder.
Test your Knowledge of automating Excel tasks with Macros
Word styles will introduce you not only how to properly format a Word doc but will also open your documents up to many other features automating the maintenance of large documents.
Microsoft Word not only has many out of the box styles ready for you to use, but you can also take advantage of custom styles created by you. Learn how to brand your documents to fit your color and font schemes.
Learn how you can easily modify a style that updates your entire document.
Learn how styles are not just for formatting. Take advantage of styles for navigation and quick reordering of word content.
Test your knowledge of Word Styles
Learn how to take a styled document and have Word generate the Table of Contents based on those styles.
Through a few simple clicks of the mouse, automate the creation of a Table of Contents
Learn how quickly a table of contents can be updated with the proper edits to a document
Test your knowledge of working with the Word Table of Contents feature
During this video lecture Kyle will introduce you to the Power of PowerPoint master slides and how they can be used to create consistentcy throughout your presentation.
During this video lecture Kyle will walk you through using PowerPoint master slides. By placing an image in the PowerPoint master slide you can automate the steps that you would normally take to place that same image on each individual slide in your presentation.
During this video lecture Kyle will introduce you to creating a custom slide layout that can be used on any of your slides in your presentation.
Test your knowledge of PowerPoint Master Slides
During this video lecture Kyle will introduce you using Custom Shows in your PowerPoint presentations saving you time and managing one document.
During this video lecture Kyle will walk your through the steps of creating Custom Shows in PowerPoint.
Completing this exercise will help you become more efficient in working with PowerPoint presentations that contain custom shows.
A step by step handout in PDF format that you can use to walk through the steps of working with PowerPoint custom shows.
Test your knowledge of PowerPoint Custom shows
During this video lecture Kyle will introduce you to the working with Outlook and categories and how they will help you better maintain your Outlook inbox.
During this video lecture Kyle will walk you through how Outlook categories can be used to help organize your Outlook content, Inbox, Calendar, Contacts or Tasks.
During this video lecture Kyle will take into creating your own custom Outlook categories that can be used to tag and organize your Outlook content.
During this video lecture Kyle will walk you though the process of using categories to find Outlook content efficentlly.
Test your knowledge of organizing your Outlook content
During this video lecture Kyle will introduce you to how you can automate some of the more routine tasks, using Outlook Quick Steps, that we all do in our Outlook Inbox.
During this video lecture Kyle will walk you through how to create Outlook Quick Steps that can be used to save you time and automate routine Inbox tasks.
Completing this exercise will walk your through automating inbox tasks, such as sending email using Outlook Quick Steps.
Test your knowledge of Outlook Quick Steps
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;
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:
What Students have said about Kyle:
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.
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!