Filters

Changing any of the form inputs will cause the list of events to refresh with the filtered results.

(SSMG100/25) Surgent’s Microsoft 365: Getting Started with Excel PivotTables and PivotCharts

This course is a two-lesson advanced level course that guides you through creating, formatting, and modifying PivotTables and PivotCharts in Excel using step-by-step hands-on activities.In Lesson 1, you learn how to create a blank PivotTable; then use the Fields List to manually arrange data in the PivotTable. Next, you learn how to create a PivotTable...

Non Member: $180
Credit Hours: 4

(SSMG128/25) Surgent’s Microsoftr PowerPointr 2016: Getting Started

This course guides you through creating and opening PowerPoint presentations; inserting, reorganizing, and deleting slides; applying a design theme and switching between different PowerPoint views. You learn how to insert various types of content on slides, such as bulleted lists, tables, charts, shapes, pictures, SmartArt graphics and sound clips; how run a slide show and...

Non Member: $270
Credit Hours: 6

(LITE02/26) Using ChatGPT with Excel

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT but...

Non Member: $90
Credit Hours: 2

(LITE03/26) Excel for Staff Level 1 – What You Never Learned

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with...

Non Member: $90
Credit Hours: 2

(LITE05/26) Excel for Staff Level 2 – Getting More Out of Excel

Excel can do so many things but what are some of the features that can really help accountants take their Excel skills to the next level? This course is designed to do just that. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this two-hour course is designed to...

Non Member: $90
Credit Hours: 2

(LITE06/26) Clean, Transform & Load Data in Power BI

This intensive 2-hour course is designed specifically for those aiming to master data management skills in the modern business environment. As data becomes increasingly central to accounting and financial analysis, the ability to effectively manage, clean, and transform this data is critical. This course delves into Microsoft Power Query, a potent tool within Excel and...

Non Member: $90
Credit Hours: 2

(LITE08/26) Excel for Staff Level 3 – Build Reports and Analyze Data

Excel for Staff Level 3 - Build Reports and Analyze Data is a comprehensive, 2-hour course tailored for professionals looking to enhance their Microsoft Excel skills in creating reports and performing data analysis. This course bridges the gap between basic Excel functionality and the advanced techniques required for effective data-driven reports. Participants will learn to...

Non Member: $90
Credit Hours: 2

(SSTE430/26) Surgent’s Become a Data Analysis Expert

In today's rapidly evolving business landscape, accounting professionals are expected to be more than just number crunchers; they are expected to be insightful interpreters of data. In an era where data is king, this course is your gateway to becoming a savvy data analyst, giving you a competitive edge in your field. We will guide...

Non Member: $115
Credit Hours: 2

(SSTE461/26) Surgent’s Taking Advantage of Array Formulas in Excel

This intensive 2-hour course is designed to unlock the potential of array formulas in Microsoft Excel. Array formulas are a vital tool in Excel for their unique ability to perform multiple calculations on one or more items within an array, making them indispensable for complex data analysis and calculations. They enable users to write fewer,...

Non Member: $115
Credit Hours: 2

(SSTE457/26) Surgent’s Using ChatGPT with Excel

In this innovative course, participants will learn to combine the power of artificial intelligence with the functionality of Microsoft Excel. You will learn how to leverage ChatGPT, OpenAI's powerful language model, to improve your Excel skills and decrease the time it takes to build spreadsheets. The course will include a quick introduction to ChatGPT, but...

Non Member: $115
Credit Hours: 2