GTI Courses

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.

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.

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.

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 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 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 one-day workshop will help you teach participants how to:

• Describe what is meant by a project
• Explain what project management means
• Identify benefits of projects
• Identify the phases of a project’s life cycle
• Sell ideas and make presentations related to pitching a project
• Prioritize projects
• Begin conceptualizing your project, including goals and vision statements
• Use project planning tools
• Contribute to creating a Statement of Work

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.