This eLearning Bundle includes 13 Microsoft Office 2016 courses. A comprehensive coverage of all Microsoft Office 2016 applications in an easy to follow video training format. These courses teach the student how to use all of the applications in Office 2016, moving from beginner to expert actions and techniques in Excel, Word, PowerPoint, Outlook and Access. If you want to learn about just one of the features in Microsoft Office 2016 check out one of our other course bundles: Microsoft Excel 2016, Microsoft Word 2016, Microsoft PowerPoint 2016, Microsoft Outlook 2016, and Microsoft Access 2016. These courses provide great examples of all of the features of Office 2016, and give the viewer time to try the actions on their own. After taking these courses you will be an expert user of Microsoft Office 2016!
Microsoft Access 2016: Part 1 (Beginner) – 1:40 hours
A relational database application such as Microsoft Office Access 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Microsoft Access 2016: Part 2 (Intermediate) – 2:30 hours
Your training and experience using Microsoft Access 2016 has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, validate data entered into a database, and customize reports. Extending your knowledge of Microsoft Access 2016 will result in a robust, functional database for your users.You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Microsoft Access 2016: Part 3 (Expert) – 3:20 hours
You’ve covered many of the basic functions of Microsoft Office Access 2016, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple- user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exam for Microsoft Access 2016.
Microsoft Office Excel 2016: Part 1 (Beginner) – 3:00 hours
Microsoft Office Excel 2016: Part 1 (Beginner) introduces you to the basic functions of Excel 2016, allowing you to create worksheets and effectively calculate and present your data. You’ll start by getting familiar with the Excel interface, and then learn how to create worksheets and enter data. You’ll learn how to create simple formulas to perform calculations and explore the difference between relative and absolute cell reference, a critically important understanding in Excel. You’ll discover the many options available for modifying and formatting your worksheets, along with learning how to apply conditional formatting to easily improve the readability of your data. You’ll also gain tips on how to manage your worksheets and workbooks, and how to print your documents without difficulty.This 3-hour course, the first part of our Microsoft Office Excel 2016 series, will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and in-class quizzes to test your comprehension.
Microsoft Office Excel 2016: Part 2 (Intermediate) – 2:30 hours
Microsoft Office Excel 2016: Part 2 (Intermediate) builds on your knowledge of the basic functionality of Excel by teaching you to perform more advanced calculations and specialized actions. To begin, you’ll develop a deeper understanding of the complex formulas and functions that allow you to extract important information from your data. You’ll discover how to sort, filter, and query data to increase the readability of your worksheets. You’ll see how to create and manipulate sophisticated tables and charts. You’ll also discover how to create PivotTables and PivotCharts to analyze and present your data with a high level of flexibility, and you’ll discover helpful ways of filtering data using Timelines and Slicers. The second part of our Microsoft Office Excel 2016 series, this course is 2 hours and 30 minutes in length and will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and a final quiz to test your comprehension.
Microsoft Office Excel 2016: Part 3 (Advanced) – 1:40 hours
Microsoft Office Excel 2016: Part 3 teaches you advanced ways of collaborating with others, automating complex tasks, and predicting future potential outcomes. To begin, you’ll learn how to track, retrieve, and consolidate data in different worksheets or workbooks. You’ll master advanced auditing tools to verify data, and you will see how to evaluate formulas to correct errors. You’ll learn how to collaborate with others while protecting the integrity of your documents. You’ll advance your understanding of macros to automate tasks and practice using Sparklines to visualize data. Lastly, you’ll learn how to utilize the power of Excel to help you predict a variety of potential outcomes. The third part of our Microsoft Office Excel 2016 series, this course is 1 hour and 40 minutes in length and will help you prepare for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions, practice files, and a final quiz to advance your skills and abilities.
Microsoft PowerPoint 2016: Part 1 – Foundations – 3:41 hours
Microsoft Office PowerPoint 2016: Part 1 shows you how to utilize many of the functions and features available through PowerPoint to create engaging and professional presentations. This introductory-level course begins by guiding you through the PowerPoint interface and reviewing some basic functions. You’ll practice creating a PowerPoint presentation, and you’ll learn how to add and edit text and modify the slides. You’ll also perform more advanced text editing and formatting operations. The course outlines how to use graphics, screen shots, and visual effects to energize your presentation. You’ll also learn how to add tables and charts to help you convey key points to your audience and create greater visual appeal. The first part of our Microsoft Office PowerPoint 2016 series, this course is 3 hours and 40 minutes in length and will help prepare you for the Microsoft Office PowerPoint 2016 certification exam. It features easy-to-follow visual instructions, practice files, and in-class quizzes to ensure comprehension of these key capabilities.
Microsoft PowerPoint 2016: Part 2 – Advanced – 3:30 hours
Master the advanced tools and functions of this powerful program that help you save time and enhance your work to create outstanding, state-of-the-art presentations. In this course, you’ll learn how to customize the user interface to improve efficiency, create customized templates and insert SmartArt and animations. You’ll also learn how to utilize math equations, use collaborative tools, add security and distribute your presentation in different formats. The course is 3.5 hours long and divided into 7 lessons that can be taken at your own pace. It contains downloadable student materials including a convenient keyboard shortcut guide. The course is intended for more advanced users and is an exceptional resource for preparing for the Microsoft Office Specialist (MOS) Certification exam for Microsoft PowerPoint 2016.
Outlook 2016 – Part 1 (Foundations) – 4:00 hours
Discover the essential email, calendar, and contact management functions of Microsoft Outlook 2016 that allow you to work more efficiently with this beginner-level training course. The Outlook 2016 – Part 1 (Foundations) course will familiarize you with Outlook’s interface. Learn to send and receive emails, compose professional messages, include attachments, organize your inbox, schedule and manage meetings, create and update a list of contacts, and track your workflow. This 4-hour course contains 8 different lessons, which you can work through at your convenience. The lessons include videos with step-by-step visual demonstrations, expert narration, downloadable practice files, and online quizzes, for a comprehensive and interactive learning experience. To further enrich your Outlook skills and take full advantage of the application’s productivity features, consider pairing this course with Outlook 2016 – Part 2 (Advanced).
Outlook 2016 – Part 2 (Advanced) – 3:30 hours
Boost your productivity when working with Microsoft Outlook 2016 by using the advanced features and options outlined in this user-friendly training course, which builds on your foundational Outlook skills. With the Outlook 2016 – Part 2 (Advanced) course, you will discover how to customize the application to best suit your workflow and personal preferences. Learn to modify default settings and leverage available efficiencies for email communication, managing your mailbox and contacts, collaborating with colleagues, scheduling meetings and tasks, and safeguarding your important data. This 3.5-hour course contains 9 different lessons, which you can move through at your own pace. For a complete learning experience, the lessons include videos with detailed visual and audio demonstration, downloadable practice files, and online quizzes. If you’d like to reacquaint yourself with Outlook basics, consider pairing this course with Outlook 2016 – Part 1 (Foundations).
Microsoft Word 2016: Part 1 – Beginner Level – 3:00 hours
Hone your Microsoft Word 2016 skills with this instructive training course, designed to help you take advantage of the application’s abundant features and tools for producing professional-quality documents. In the Word 2016: Part 1 – Beginner Level course, we’ll cover formatting text and paragraphs, boosting your efficiency, managing lists, adding tables, inserting graphic objects, managing page appearance, and publishing error-free, readable documents. The 3-hour course includes 8 different learning modules, which you can work through at your convenience. With video demonstrations, audio narration, downloadable practice files, and a final online quiz, this user-friendly course offers comprehensive interactive training which can be used to prepare for Microsoft Office specialist certification. Consider taking Word 2016: Part 2 – Intermediate Level to further enrich your proficiency with Word.
Microsoft Word 2016: Part 2 – Intermediate Level – 2:40 hours
Take your Microsoft Word 2016 skills to the next level with this insightful training course, outlining the word processor’s more advanced features for creating polished and professional documents. In the Word 2016: Part 2 – Intermediate Level course we’ll cover how to use tables and charts, customize formats with styles and themes, insert content using Quick Parts, automate formatting using templates, controlling document flow, managing long documents, and using mail merge features. You can complete the 7 learning modules of this 2.5-hour course at your desired pace. With step-by-step video demonstrations, audio narration, downloadable practice files, and online quizzes, this practical course offers comprehensive training which can be used to prepare for Microsoft Office specialist certification. To brush up on your Word basics, consider also taking the Word 2016: Part 1 – Beginner Level.
Microsoft Word 2016: Part 3 – Advanced – 3:00 hours
Microsoft Office Word 2016: Part 3 focuses on advanced features and shows you how to manipulate images, create custom graphics, collaborate in real-time, and automate repetitive tasks. You’ll learn how to use and edit images and graphics, as well as add videos, which is a new feature to Word 2016. You’ll learn how to collaborate with others simultaneously on the same document by storing your work on the Cloud, and you’ll discover how to prepare your documents for sharing by removing confidential information or restricting certain access. You’ll find out helpful ways to add and manage references, bookmarks, and hyperlinks. To save you time, you’ll learn to create and record macros to automate repetitive tasks. This 3-hour advanced course, the third part of our Microsoft Office Word 2016 series, will help prepare you for the Microsoft Office Specialist exams. It features easy-to-follow visual instructions and includes practice files and in-class quizzes.