Self-Study Text
(SSMG115/25) Surgent’s Microsoftr Wordr 365 and Wordr 2019: Getting Started
This course is a three-lesson basic level course that guides you through opening, creating, formatting, previewing, printing, and saving text documents.
Read More
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