GTI Courses

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.

This course focuses on Adobe® Illustrator® CC, the component within CC used to create “drawn” graphics, while enabling its users to integrate content from other domains (such as photo-oriented graphics and animation, which belong to Adobe® Photoshop® and Flash®). With Illustrator's many, easily used tools, you will discover that not only can you unlock the same creative impulses you've always had as you've picked up a pencil to sketch out an idea, but also capture those multiple ideas and “what ifs” during the creative process in ways that you never imagined.

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 separates database professionals from casual database users or occasional designers.

This one-day workshop teaches participants to:

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.

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.

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.

If your agency receives or plans to receive government grants, this class is for you.

The two-day grant management class is for grant-recipient organizations across all disciplines. As such, in this class, you'll learn how to manage your federal, state or local government grants in accordance with laws and mandatory compliance guidelines.

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.

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.