Are you seeking to advance your data analysis capabilities? This course will help you gain a better overall understanding of data analysis, in particular by using tools such as Excel's PivotTables, PivotCharts and Power Pivot, to analyze data from a variety of sources, then organize, cleanse, manipulate and report that data with maximum insight and effectiveness, to improve business decisions. Books are provided, along with classroom hands-on activities. It is not mandatory, but strongly recommended that students already have some degree of Excel proficiency or have taken Excel Levels 1, 2 and 3, as this course qualifies as "Excel 4."

Students in this course will achieve advanced mastery of a fully comprehensive set of Adobe Acrobat Professional skills such as creating, editing, combining PDFs, advanced editing by creating bookmarks, links, buttons, elements, multimedia, watermarks, comments, markup, shared reviews, interactive forms, digital signatures, security, conversions and optimization. Comes with course textbook. Note: student must already have their own Acrobat Pro subscription to use in class for learning activities.

This training provides concepts and skills for more engaging and successful delivery of knowledge and ideas using visual presentation software such as MS PowerPoint, Google Slides and others. Topics covered include necessary equipment, best practices, organizing content, using templates to polish appearance and save time, utilizing multimedia to increase engagement, major dos and don’ts, and other essential tips to ensure a successful presentation that keeps your audience’s attention. Also, hands-on lab activities utilize PowerPoint in-depth, and a course book is included. This course is both for students with little to no familiarity using presentation software and also for those who have experience, but are looking to expand and sharpen their skills, learning more advanced PowerPoint features than the average “deck-builder.”

Excel Level 1 teaches basic concepts and skills to start being productive with Microsoft Excel and is a strong start on a journey towards becoming an Excel Expert. It covers how to create and format worksheets that contain calculations with formulas and functions, including using proper reference types. Moving and copying data correctly, basic chart creation and various other tips and tricks are also covered. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 2 and Excel 3, map to the objectives of both exams.

This course provides an overview about Google Workspace, either free or paid editions, with a primary focus on its most commonly used apps such as Gmail, Drive, Calendar, Chat, Meet, Docs, Sheets, Slides, Forms and Keep, with hands-on activities. Students will learn about tapping into its communication and collaboration potential. It is for students who have little to no familiarity with Google Workspace but are contemplating using it for personal or business purposes. It is strongly recommended but not required for the course, if students already have a Google or Gmail account to use in class.

Excel Level 2 continues the journey of transformation into an Excel Expert, teaching to use more advanced tools for analysis, rearrangement and presentation of more complex, yet realistic data. This course covers managing workbooks with more elaborate functions, ranges, tables, validation and summarizing tools like consolidation and subtotaling. The very popular and powerful feature of PivotTables and also conditional formatting are taught, along with more advanced charts. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 1 and Excel 3, map to the objectives of both exams. Although Excel 1 is strongly recommended for foundational concepts, it is not a requirement for Excel 2.

This class covers essential skills related to the latest version of Intuit's popular online bookkeeping program. Topics covered include customizing company-level settings, setting up customers, dealing with bank deposits, bank feeds, and reconciliation processes for bank and credit card accounts.

Excel Level 1 teaches basic concepts and skills to start being productive with Microsoft Excel and is a strong start on a journey towards becoming an Excel Expert. It covers how to create and format worksheets that contain calculations with formulas and functions, including using proper reference types. Moving and copying data correctly, basic chart creation and various other tips and tricks are also covered. Books are provided, along with classroom hands-on-keyboard activities. For students who might consider the optional Microsoft Office Specialist Excel Associate and Expert exams, this course along with Excel 2 and Excel 3, map to the objectives of both exams.