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.

Learn how to use Canva, a free and easy design tool, to create eye-catching marketing materials for your business. From social media graphics to flyers and business cards, this hands-on class will show you how to design professional-looking content-even if you're not a graphic designer.

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.

Learn how to use Canva, a free and easy design tool, to create eye-catching marketing materials for your business. From social media graphics to flyers and business cards, this hands-on class will show you how to design professional-looking content-even if you're not a graphic designer.

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.

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.

Learn to work smarter and faster, by expanding your use of AI to apply workflows that automate complex tasks, decision-making processes, and reduce manual work to improve efficiency and productivity. Topics include workflows for sorting emails and customer forms, sentiment analysis, and generating replies and summaries. Participants will learn how to design and implement AI-driven workflows tailored to specific team requirements. The course consists of 8 hours of online, asynchronous instruction delivered in two-hour sessions over the course of 4 weeks. Completion of the "Intro to AI" course is recommended but not required.

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.