Scheduled IT Workshops: Click on the Download Agenda link at the bottom of each class description for more information.
Interested in taking one of our computer training workshops? Please call for flexible scheduling. Dates are available Monday through Thursday. Don’t see the workshop you need? Call us at 440.349.5555 to inquire about your training needs or simply complete the form to the right and put the topic in the workshop name field.
This course is intended for students who have a foundational working knowledge of PowerPoint 2016, who wish to take advantage of the application's higher-level usability, security, collaboration, and distribution functionality. You will learn how to customize the PowerPoint 2016 application, and effectively create, collaborate on, secure, and distribute complex multimedia presentations for a variety of situations.
This course is designed for students who wish to gain a foundational understanding of Microsoft PowerPoint 2016 that is necessary to create and develop engaging multimedia presentations. You will learn how to create and deliver engaging multimedia presentations that convey the key points of your message through the use of text, graphics, and animations.
Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills. This course covers 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.
This course is designed for students wishing to gain intermediate-level skills. 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.
This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries to join, filter, and sort data.
This course is intended for students who want to use advanced capabilities in Word, including image manipulation, collaboration and revision tracking, cross-referencing and linking, document security, forms, and process automation through macros.
After you master the basics of using Microsoft® Word 2016 such as creating, editing, and saving documents; navigating through a document; and printing, you're ready to move on to tackling the more advanced features. These features enable you to create complex and professional documents with a consistent look and feel. They also enable you to automate tedious tasks such as preparing a letter to send to every customer of your organization. Creating professional-looking documents can help you give your organization a competitive edge. Implementing time-saving features such as document templates and automated mailings helps your organization reduce expenses
This course is intended for students who want to learn basic Word 2016 skills, such as creating, editing, and formatting documents; inserting simple tables and creating lists; and employing a variety of techniques for improving the appearance and accuracy of document content.
This course is intended for students who are experienced Excel 2016 users and have a desire or need to advance their skills in working with some of the more advanced Excel features. Students will likely need to troubleshoot large, complex workbooks, automate repetitive tasks, engage in collaborative partnerships involving workbook data, construct complex Excel functions, and use those functions to perform rigorous analysis of extensive, complex datasets.
This course builds upon the foundational knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and will help start you down the road to creating advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.
This course teaches the basic functions and features of Visio Professional 2013. Students will learn how to use stencils, scale and resize objects, draw basic shapes and compound lines, and arrange objects. They will also learn how to create diagrams, work with text, apply formatting, work with background pages, and set file and print properties. Finally, students will create network and brainstorming diagrams, set shape properties, and create reports.
In this course, students will further build on the skills acquired in the Microsoft Excel 2013 Basic and Intermediate courses. They will work with advanced functions and formulas, as well as lookup functions such as VLOOKUP, MATCH, and INDEX. In addition, students will learn about data validation, and will use advanced data filtering. They will apply advanced chart formatting options, and create more complex charts. They will work with PivotTables and PivotCharts, export and import data, and query external databases. Students will learn about the analytical features of Excel, such as Goal Seek, and how to create scenarios. Finally, they will run and record macros, and explore VBA code.
This course will teach students how to work with large worksheets in Microsoft Excel 2013, and use multiple worksheets and workbooks efficiently. It will introduce them to more advanced formatting techniques, such as applying special number formats, using workbook styles and themes, adding backgrounds, and mimicking watermarks. In addition, students will learn how to create outlines and subtotals, and how to create and apply cell names. They will sort and filter data, and create and format tables. They will learn how to save workbooks as Web pages, how to insert and edit hyperlinks, and how to share workbooks via email. Students will learn how to audit worksheets for errors, how to protect worksheets, how to share and merge workbooks, and track changes in a workbook. Finally, students will customize the Excel environment, and create and modify custom templates.
This course will familiarize students with spreadsheet terminology and the fundamental concepts of Microsoft Excel 2013, including identifying Excel window components, navigating worksheets, and downloading templates. In addition, students will learn the basics of entering and editing text, values and formulas, and how to save workbooks in the native Excel format, as well as in other formats. They will learn how to move and copy data and formulas, how to determine absolute and relative references, and how to work with ranges, rows, and columns. Students will also learn how to use simple functions, and how to easily apply formatting techniques to worksheet data. They will create and modify charts, and work with graphics. Finally, they will review workbooks for spelling errors, modify page setup, and print worksheets.
This course builds on the skills and concepts taught in Access 2010 Basics. Students will learn how to specify a required field in a table, create a query to extract information from multiple tables, design a custom form, add a Lookup field to a table and export an Access datasheet to Microsoft Excel amongst many other Microsoft Access 2010 Intermediate level skills.
In this course, you will expand your knowledge of Microsoft Word. This course is designed for students who wish to use Microsoft Word to create and modify complex documents and use tools that allow you to customize those documents.
This course builds on the skills and concepts taught in PowerPoint 2010 Intermediate. Students will customize PowerPoint by modifying the ribbon and changing application settings. They will also apply themes and templates and they will work with SmartArt graphics and tables. Students will add multimedia content and interactive elements to slides and they will learn about presentation distribution options including PDF, HTML and online broadcasts. Finally, students will integrate PowerPoint with Word and Excel.
This course builds on the skills and concepts taught in Excel 2010 Intermediate. Students will work with advanced formulas, as well as lookup functions such as VLOOKUP and HLOOKUP. In addition, students will learn about data validation and database functions such as DSUM and DAVERAGE. They will learn how to work with PivotTables and PivotCharts and how to import and export data. Finally, students will learn about SmartArt graphics and conditional formatting with graphics.
This course builds on the skills and concepts taught in Excel 2010 Basics. Students will learn how to use multiple worksheets and workbooks efficiently and they will start working with more advanced formatting options including styles, themes and backgrounds. They will also learn how to create outlines and subtotals, how to create and apply cell names and how to work with tables. Students will insert and edit hyperlinks and learn to share workbooks by email. This course also covers charting techniques, file sharing and merging and workbook templates.
This course teaches the basic functions and features of Word 2010. After an introduction to Word’s window components, students will learn how to use the Help system and navigate documents. Then they will enter and edit text, create and save documents, and learn how to enhance the appearance of a document by using various formatting options. They will also create tables, insert headers and footers, proof and print documents, and insert graphics.
This course teaches the basic functions and features of Excel 2010. After an introduction to spreadsheet terminology and Excel's window components, students will learn how to use the Help system and navigate worksheets and workbooks. Then they will enter and edit text, values, formulas, and pictures, and they will save workbooks in various formats. Students will also move and copy data and work with rows and columns. This course also covers simple functions, basic formatting techniques, and printing.
This course covers the basic functions and features of Access 2010. After an introduction to database concepts and the Access environment and Help systems, students will learn how to design and create databases. Then they will work with tables, fields, and records; and set field properties. Students will then learn to create queries, forms, and reports.
This course will familiarize you with the Windows 10 user interface and its basic capabilities. In this course, you will explore Windows 10 and learn how to create documents, send email, browse the Internet, and share information between applications and with other users.