Rusty or new to Microsoft Excel? In this 7-hour in-person class in our hands-on computer lab, learn to create and format worksheets that contain calculations with formulas and functions, including the importance of using proper reference types. Moving and copying data correctly, manipulating data, chart creation, and various other tips and tricks are also covered. Coursebooks, practice files used during class and dozens of additional test worksheets with solutions are also provided for further practice, or even as templates in your future builds. Gain the confidence to build, repair and upgrade spreadsheets. Participants leave this course with a new or increased love of Excel, a powerful and legendary data tool.

Fairly handy with Excel, and ready to enhance your data analysis skills? This 7-hour in-person class, held in our hands-on computer lab, introduces Microsoft Power BI. It leverages familiarity with Excel while introducing advanced tools for data connection and visualization. Power BI offers functionalities exceeding those available in traditional spreadsheets, allowing for the creation of interactive reports and dashboards. Its visualization and reporting features support comprehensive exploration, analysis, and communication of business insights. Learn about connecting to various data sources, analyzing, cleaning, transforming, loading, visualizing, and reporting data using Power BI. Leave equipped to build your own real-time PBI dashboards. Books provided. While not required, completing Excel Levels 1-3, PivotTables, and Power Pivot are recommended to get the most out of this course.

Ready to scale the ladder to Excel Expert heights? In this 7-hour in-person class in our hands-on computer lab, you’ll learn about Excel’s most powerful and advanced tools for data analysis and presentation. Practice logical and lookup functions, more advanced formulas, arrays, auditing, error-trapping, and the much beloved date, time, text, and other functions. Learn about importing external data via Power Pivot, exporting data, What-If Analysis and automating repetitive tasks with macros. Coursebooks, practice files used during class and dozens of additional test worksheets with solutions are also provided for further practice, or even as templates in your future builds. Excel 1 and 2 are strongly recommended but not required.

Interested in using Google Workspace for personal or business tasks with little prior experience? This 7-hour in-person course covers the essentials of Google Workspace, highlighting differences between Free and Paid versions. You'll participate in hands-on computer lab sessions with the Free Edition’s core apps Gmail, Chat, Meet, Docs, Sheets, Slides, Forms, Keep, and Sites. By course end, you'll be able to use Google Workspace for file creation, data organization, communication, and collaboration. Books are included. A Gmail account is required for practice activities.

Feel comfortable with Excel basics but want to advance to an intermediate level? In this 7-hour in-person class in our hands-on computer lab, you’ll learn advanced tools for analysis, organization and presentation of more complex data. Practice using more elaborate functions, creating ranges and tables, data validation, conditional formatting and advanced charts. A highlight is learning to wield the popular and powerful feature of PivotTables, a highly effective tool for dynamic data summarization. Coursebooks, practice files used during class and dozens of additional test worksheets with solutions are also provided for further practice, or even as templates in your future builds. Excel 1 is strongly recommended but not required.

Ready to create, edit and turbo-charge PDFs with pro features? This comprehensive 7-hour in-person course, conducted in our hands-on computer lab, provides advanced training in Adobe Acrobat Professional. You’ll develop proficiency in creating, editing, and combining PDFs; implementing advanced features such as bookmarks, links, buttons, multimedia elements, watermarks, comments, markup, shared reviews, interactive forms, digital signatures, security, conversions, and optimization. Course textbook is included. Must have access to an Acrobat Pro subscription, to use in class for learning activities.

Got data?  “…sometimes it’s hard to know where to start, especially when you have a lot of data.” (Microsoft)   PivotTables (PTs) are a legendary Excel feature. Have you ever used them to summarize, analyze, explore, and present your data? They’re highly flexible and adjustable with a few mouse clicks. In this 4-hour in-person class, held in our hands-on computer lab, learn about preparing raw data, creating PTs from multiple sources, summarizing, organizing, filtering and formatting PTs, followed by creating, manipulating and formatting their synchronized “sister” PivotCharts. Leave with skills to take your pile of data and feed it into PTs and PCs for useful data analysis.Books provided. While not required, completing Excel Levels 1-3 are recommended to get the most out of this course.

Ready to “power-up” and perform more advanced data modeling and analytical capabilities beyond traditional PivotTables? This 4-hour in-person course offers comprehensive instruction in Excel’s Power Pivot add-in. Conducted in our hands-on computer lab, you’ll gain expertise in Power Pivot’s mighty features for processing, transforming, and summarizing large datasets, including utilizing the Power Pivot Data Model. Key topics include navigating the Power Pivot interface, managing data relationships for dynamic reporting, creating calculated fields, columns, and KPIs, applying CUBE functions to access multidimensional database information, and an introduction to DAX date and time functions for advanced time-based calculations. Upon completion, you’ll be more equipped to efficiently interpret complex data and deliver informative reports that support sound business decisions. Books provided. Prior completion of Excel Levels 1-3 and PivotTables are highly recommended to get the most out of this course, but not mandatory.