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.

Already fairly Excel savvy? It's time for the next era: leveraging AI tools to help you build, repair and upgrade your spreadsheets. In this 4-hour in-person class in our hands-on computer lab, learn how to use Copilot, ChatGPT and Gemini to both assist and teach you how to make your Excel and Google Sheets more powerful and productive. Learn to correctly prompt AI to build accurate and more complex formulas, tables, graphs and conditional formatting. Also, learn to oversee and audit the work your AI assistant performs, because it's not perfect...yet. Excel levels 1 through 3, PivotTables and PowerPivot courses are strongly recommended, but not required. The more you know about Excel, the better you can ensure AI tools work for, not against your worksheets.

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.

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.

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.

Spending too much on accounting software? Utilize Excel as a cost-effective alternative, as it offers robust features for accounting tasks. In this in-person course, you will learn how to use Excel for basic accounting, financial statements, statement of cash flows, bank reconciliation, payroll register, budgeting, and depreciation schedules. Through guided exercises and real-world scenarios, you will practice applying Excel tools to common accounting challenges. By the end of the course, you will be able to confidently use Excel to support everyday accounting tasks and produce clear, professional results. Basic to intermediate familiarity with Excel is recommended, but no advanced skills are 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.

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.