Self-Study Text
(SSMG101/25) Surgent’s Microsoft 365: Exploring Useful Excel Functions
This course is a one-lesson intermediate level course that guides you through using the Quick Analysis feature to quickly insert row and column totals and creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions. The functions covered in this course are the:•IRR, NPV, FV, PV,...
Read More
Self-Study Text
(SSMG137/25) Surgent’s Microsoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables
Microsoftr Excelr 365/Excelr 2019: Working with Data Ranges and Tables is a two-lesson, intermediate level course that guides you through organizing, entering, and validating worksheet data and then effectively sorting, filtering, subtotaling, and outlining the data. You also learn how to define well-organized data as an Excel table; then use Table features to work with...
Read More
Self-Study Text
(SSMG136/25) Surgent’s Microsoftr Excelr 2019: Working with Formulas and Functions
This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel 2019 using step-by-step, hands-on activities.
Read More
Self-Study Text
(SSMG105/25) Surgent’s Microsoftr Excelr 2016: Creating and Formatting Charts
Excel provides a variety of tools you can use to create, format and enhance charts: contextual Ribbon tab buttons, menus and galleries, shortcut menus, keyboard shortcuts, task panes, and more. This course allows you to explore using these tools to create and format common chart types.
Read More
Self-Study Text
(SSMG135/25) Surgent’s Microsoftr Excelr 2016: Useful Functions for CPAs
This course guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text and Logical functions.
Read More
Self-Study Text
(SSMG111/25) Surgent’s Microsoftr Excelr 2016: Getting Started
This course introduces you to the Excel 2016 software and then guides you through basic Excel features using step-by-step hands-on activities.
Read More
Livestream
(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...
Read More
Livestream
(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...
Read More
Livestream
(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...
Read More
Livestream
(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...
Read More
