-
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.
Students will benefit most from this course if they want to accomplish basic workplace tasks in Excel 2016, or if they want to have a solid foundation for continuing on to become an Excel Expert. If they intend to take a Microsoft Office Specialist or Expert exam for Excel, this course is a good place to start their preparation, but they will need to continue on to other courses in the series to be fully prepared for either exam. -
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 this course, you will build upon your knowledge of the Office 2010, 2013, or 2016 desktop application suite to work productively in the cloud-based Microsoft Office 365 environment
-
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.
-
This course covers the basic functions and features of Outlook Business Contact Manager.
-
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.
-
This course builds upon the foundational Microsoft Office 2007/2010 knowledge and skills you’ve already acquired. It focuses on the enhanced features you’ll want to leverage to improve the way you manage, organize, present, and distribute your company’s data and information.
-
In this course, you will learn about and use a SharePoint Team Site to access, store, and share information and documents.
-
In this course, you will learn how to create, configure, and manage a SharePoint Team Site so that your team or organization can share information and collaborate effectively.
-
This course is an introduction to Microsoft® Office 365® with Skype® for Business in a cloud-based environment. It can be used as an orientation to the full suite of Office 365 cloud-based tools, or the Skype for Business lessons can be presented separately in a seminar-length presentation with the remaining material available for later student reference.
Using the Office 365 suite of productivity apps, users can easily communicate and collaborate together through Microsoft® Outlook® mail and Skype for Business instant messaging and online meetings. Additionally, the Microsoft® SharePoint® team site provides a central storage location for accessing and modifying shared documents. This course introduces working with shared documents in the familiar Office 365 online apps—Word, PowerPoint, and Excel—as an alternative to installing the Microsoft® Office desktop applications. This course also introduces several productivity apps—Teams, Yammer, Planner, and Delve—that can be used in combination by teams for communication and collaboration. -
This 1 day course is designed for information workers who are using or will use Office 365. This course will provide students with the knowledge and skills to efficiently use Office 365 on a day-to-day basis. The course is designed with real world scenarios in mind. Students will learn how to use Outlook Online, Skype for Business, OneDrive for Business, SharePoint Online, and OneNote. At the end of this course students will be able to effectively navigate Office 365 and make use of all of the features of Office 365.
Application Courses
Our Application Software courses are ideal for everyone!
From administrative staff, to sales pros and even upper management, mastering the software you use daily will increase productivity and make your tasks stress-free and enjoyable! Click the course link to view the outline. The arrow denotes class downloadable exercise files for your convenience and practice.
-
Microsoft Office
-
Adobe Creative Suite
-
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. Or, your carefully designed and formatted document may end up looking like a jumbled mess on someone else's computer. So, how do you balance the need to communicate ideas to large groups of people with the enormous diversity found in today's electronic devices? The answer: you don't have to because Adobe created the Portable Document Format (PDF) as a solution to incompatible document formats.
Adobe® Acrobat® Pro DC puts the power of the Portable Document Format, literally, at your fingertips. By taking advantage of the functionality and features available in Acrobat, you will ensure the integrity of your electronic documents regardless of who views them, on what devices, or with what operating systems. And that will give you the confidence and peace of mind that comes with knowing that what you meant to communicate is what your document recipients will see. -
This ILT Series course will teach students fundamental concepts and terminology, and the features of Adobe Acrobat XI Pro.
-
You will learn the core Adobe Captivate skills needed to create interactive eLearning and mLearning content. In this course, you will learn how to record and produce software demonstrations, interactive training simulations, and soft skills training.
-
In day one of this course, students will learn how to plan, create, and modify a website. Students will also learn how to create pages and format text; define structural elements; create and apply CSS style rules; insert and modify images and links; test and manage Web site files; and publish a site.
-
In this course, you will learn to navigate the Flash CC interface and gain knowledge in using the tools and features necessary for drawing graphics and creating a website that contains an animated introduction. This course covers the Interactive Media Using Adobe Flash Professional CC objectives to help students prepare for the Adobe Certified Associate (ACA) exam. This course is also designed to cover the Adobe Certified Expert (ACE) exam objectives.
-
This course is designed to prepare students for the Adobe Certified Expert exam in Flash CS6. In the Basic section, students will get an overview of Flash and learn how to create new files and publish applications to SWF. In the Advanced section, students will learn the fundamentals of ActionScript and object-oriented programming. They will learn to plan and manage Flash projects, and how to work with text, load external content, and use ActionScript code libraries. They will also learn how to add video and audio to their applications. Finally, students will learn how to debug and test applications, and how to publish to different platforms, including Adobe AIR and HTML5.
-
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. And for those of you who are just embarking on building your creative skills, you will be surprised at “how good” your work will appear, even at the outset of your exploration of the world of graphic design.
-
This course covers the fundamentals of using Illustrator CS6 to create and manipulate vector graphics used for print, web and devices.
-
This course covers the Print & Digital Media Publication Using Adobe InDesign CC objectives to help students prepare for the Adobe Certified Associate (ACA) exam. This course is also designed to cover the Adobe Certified Expert (ACE) exam objectives. This course covers the Print & Digital Media Publication Using Adobe InDesign CC objectives to help students prepare for the Adobe Certified Associate (ACA) exam. This course is also designed to cover the Adobe Certified Expert (ACE) exam objectives.
-
This course is designed for students who want to create professional documents and print layouts.
-
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.
-
Photoshop CS6: Basic and Advanced, ACE Edition will help students prepare for the Adobe Certified Expert exam for Photoshop CS6. Students will modify digital images to add creative effects and repair defects.
-
-
QuickBooks
-
This course is designed to teach users the ins-and-outs of QuickBooks and its features.
-
-
Basic PC Skills and Windows Operating Systems
-
Through a combination of word association and your own natural dexterity, you will learn how to type using all ten fingers and how to make firm keystrokes without looking at the keyboard or growing fatigued.
-
This ILT Series course teaches the core features and functions of Windows 7.
-
Students should take this ILT Series course if their goal is to become more proficient in using Windows 7.
-
This course will help you to define what a PC is, and familiarize you with the Windows 8 user interface and its basic capabilities. In this course, you will explore Windows 8 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.
-
This ILT Series course teaches more advanced functions of Windows 8. Students will learn how to use the Control Panel, to manage folder and file settings, monitor apps and system performance with Task Manager, and update Windows.
-
Whether you’re new to computers or have used them in the past, this class will help you become more comfortable using a personal computer (PC) and, more specifically, the Windows 10 interface. This course will help you to define what a PC is, and familiarize you with the Windows 10 user interface and its basic capabilities.
-
-
Reporting Software
-
This two day interactive workshop was designed for new users of Crystal Reports 2008 and Crystal Reports 2011. Some of the topics covered include a review of the software features, report design and the creation of presentation quality reports.
-
This two-day workshop is designed to enhance your basic report writing skills and move you into creating more complex reports. Time will be spent walking you through the tips and tricks of advanced report writing along with a good amount of hands on practice.
-
-
Customer Relationship Management
-
Web Design
-
In this course, students will create a basic web page, Structure content, Apply styles, Work with tables, Navigate a website, Create web page layouts, Manage CSS, test a website, Create advanced navigation, Incorporate metacontent and multimedia, Create basic forms.
-
Search Courses
-
Angelina Julien , Schumacher Group
"I'll apply Excel to my job, I'm a medical biller, and I'm required to take payments, so this will really help me. Ryan is excellent and a very thorough instructor. The class was very informative and fun."