LANTEC Events

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.

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations, people work with a wide variety of devices running on a wide variety of platforms. And sometimes, what works well or looks good on one device, won't work at all on another device.

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.

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.

Adobe® Photoshop® CC focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe® Bridge and organization of files in Bridge is covered. This course delves into some of the more advanced image creation and editing techniques and offers you hands-on activities that demonstrate how these techniques can be used in combination to create exciting visual effects.

This course provides the basic concepts and skills to start being productive with Microsoft Word 2016, including 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.

Excel Basic 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 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.

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.

Adobe® Photoshop® CC focuses on some of the basic features of Photoshop so that the student can navigate the environment and use Photoshop tools to work with photographic images. In addition, the orientation to Adobe® Bridge and organization of files in Bridge is covered. This course delves into some of the more advanced image creation and editing techniques and offers you hands-on activities that demonstrate how these techniques can be used in combination to create exciting visual effects.