-
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.
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'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 multi-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training, added to that which you've gained from the Microsoft® Office Access® 2016: Part 1 and Microsoft® Office Access® 2016: Part 2 courses, rounds out your Access education and provides you with marketable job skills.
Excel 2016 Level 1 provides the basic concepts and skills to start being productive with Microsoft Excel 2016: how to create, save, share, and print worksheets that contain various kinds of calculations and formatting. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.Excel 2016 Level 2 builds on the basic concepts and skills of our Level 1 course to provide more advanced tools for analysis and presentation of complex, realistic data in Microsoft Excel 2016: how to manage complex workbooks, build more complex functions, use data analysis tools, make an impact with powerful chart and presentation features, and collaborate with other users. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.
Excel 2016 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2016: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. The three levels of our Excel 2016 courses map to the objectives of the Microsoft Office Specialist and Expert exams for Excel 2016. Objective coverage is marked throughout the course.Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyze that data and gain actionable insight is greater than ever. Most users have experienced working with Excel and creating basic PivotTables to summarize data. Excel is capable of doing much more. Students will not only be able to summarize data, but also organize the data in a way that can be meaningfully presented to others. With PowerPivot, students will learn to organize, manipulate, and report on data in the best way possible. This tools combined with maximize your effectiveness when analyzing data.This ILT Series course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
This in-depth one-day course introduces ways to create and work with Pivot Tables to look, organize and summarizes, your data in a variety of ways.You will learn how to use InfoPath to gather and share information by creating and implementing XML-based forms.In our fast-paced digital world, the need to capture ideas, meeting notes, and to-do items is ever present. Microsoft® Office OneNote® 2016 provides a way for you to efficiently create and collect your notes in an electronic notebook.Outlook 2016 is an instructor-led course manual that covers the basic concepts and skills to begin using Microsoft Outlook 2016: How to read and send e-mail, manage contacts, track tasks, and schedule appointments. The course also provides more advanced concepts and skills for Microsoft Outlook 2016 productivity: how to organize Outlook items, use advanced message properties, and collaborate with others. This course and the previous one map to the objectives of the Microsoft Office Specialist exam for Outlook 2016. Objective coverage is marked throughout the course.PowerPoint 2016 Level 1 provides the basic concepts and skills that you need to start being productive with Microsoft PowerPoint 2016: How to create, navigate, format, and customize PowerPoint presentations. This course and the Level 2 course map to the objectives of the Microsoft Office exams for PowerPoint 2016. Objective coverage is marked throughout the course.PowerPoint 2016 Level 2 provides advanced concepts and skills for PowerPoint 2016 power users: how to use advanced formatting features, and animation and transition techniques, add and format media, track corrections and work with multiple presentations, create custom slide shows, and work with security and sharing options. This course, along with the preceding one, maps to the objectives of the Microsoft Office Specialist exam for PowerPoint 2016.Welcome to Microsoft® Project 2016: Part 1. This course is designed to familiarize you with the basic features and functions of Microsoft Project Professional 2016 so you can use it effectively and efficiently in a real-world environment.Microsoft® Office Publisher 2016 is a desktop publishing software application capable of producing greeting cards, certificates, newsletters, and other printed publications. Publisher includes a large collection of templates that provide a great way to start a new publication. Publisher offers a large selection of "building blocks" that can be dragged into your documents, helping you to create page elements such as calendars, newsletter sidebars, and borders. Publisher integrates online sharing and mail merge features, which are handy when you need to send publications to a list of customers, and it's possible to export publications as HTML web pages or PDF documents. With a user-friendly interface, Publisher makes it easy to create and edit publications.From the earliest eras of human existence, visual images have been used to represent knowledge, data, and information. Beginning with the Paleolithic cave paintings and continuing to today’s most complex computer networks, these images leverage the ability of the human brain to rapidly perceive patterns and trends from visual representations.Word 2016 Level 1 Provides the basic concepts and skills to start being productive with Microsoft Word 2016: how to create, format, and set up a document, and how to add graphics and tables. This course, and the two that come after, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course.This course will provide the concepts and skills to use some more advanced features of Microsoft Word 2016, including enhanced formatting, references, editing, and sharing, and saving to various formats. This course, and the two others in this series, map to the objectives of the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course.Word 2016 Level 3 is an instructor-led course manual that covers advanced skills for Microsoft Word 2016 power users: advanced formatting features, document management, references, data fields and sources, macros, and forms. This course, and the two that precede it, maps to the Microsoft Office Specialist and Expert exams for Word 2016. Objective coverage is marked throughout the course.Designed to assist paralegals, law clerks, attorneys and other court/judicial personnel in transitioning existing WordPerfect skills to the Microsoft Office 2013 platform.You already know how to get Microsoft® Office Excel® to perform simple calculations and how to modify your workbooks and worksheets to make them easier to read, interpret, and present to others. But Excel is capable of doing so much more. To gain a truly competitive edge, you need to be able to extract actionable organizational intelligence from your raw data, and present it in a visual format that enables decision makers to view key trends and conclusions at a glance. And that's exactly what this course aims to help you do.This course builds on the foundational knowledge of the Microsoft® Office 365® online apps and takes a deeper look at the specific apps beyond Microsoft Word, Excel®, and PowerPoint®. Knowing that productivity often begins with assembling the right people, this course starts with the Teams app that is used to collaborate on shared files and conduct online meetings.This course is intended to help all users get started with Teams, use messages and channels, communicate in different ways, and customize Teams settings. By the end of this course, users should be comfortable using the Teams app in their day-to-day workflow (both internally and externally).
Course Offerings
-
Microsoft Office