Self-Study Text
(SSTE424/26) Surgent’s Microsoftr Excelr 365 and Excelr 2019: Getting Started with Excel
Microsoftr Excelr 365 and Excelr 2019: Getting Started with Excel is a three-lesson basic level course that introduces you to the Excel software and then guides you through basic Excel features using step-by-step hands-on activities.Although this is a basic level course, experienced Excel users switching from earlier versions of Excel can benefit from this course's...
Read More
Self-Study Video
(SSTE456/26) Surgent’s 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 explore them. To learn ALL the capabilities of Excel would take hundreds of hours of training, so this 2-hour course is designed to give...
Read More
Self-Study Text
(SSTE452/26) 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
(SSTE454/26) 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
(SSTE400/26) Surgent’s Microsoft 365: Working with Excel Formulas and Functions
This course is a three-lesson intermediate level course. This course guides you through creating, copying and pasting, reviewing, and correcting basic and complex formulas in Excel using step-by-step hands-on activities. This course emphasizes using a standard keyboard and mouse actions to perform tasks in Excel.
Read More
Self-Study Video
(SSTE434/26) Surgent’s Create Visuals in Power BI to Successfully Analyze Data
Unlock the full potential of your data with this cutting-edge course. Designed to span a focused, four-hour session, this course is your gateway to mastering the art of data visualization using the powerful tools of Microsoft Power BI Desktop and PowerBI.com. Whether you're a business professional, a budding data analyst, or simply someone interested in...
Read More
Self-Study Video
(SSTE432/26) Surgent’s Build a Data Model for Analysis in Power BI
This intensive 4-hour course offers a deep dive into data modeling in Power BI, with a focus on Microsoft Excel's Power Pivot that is applicable to Power BI Desktop. Designed for professionals looking to enhance their data analysis skills, the course covers the essential aspects of building robust, efficient data models. Participants will learn how...
Read More
Self-Study Video
(SSTE462/26) Surgent’s The Latest and Greatest Excel Features
In the ever-evolving world of data analysis and office productivity, Microsoft Excel remains at the forefront, continuously introducing new and powerful features. This comprehensive course is designed to familiarize participants with the most recent and significant updates in Excel as well as some old favorites. This course offers an in-depth exploration of these features, ensuring...
Read More
Self-Study Text
(SSTE425/26) Surgent’s Microsoftr Excelr 2019: Exploring Useful Excel Functions
This course is a one-lesson intermediate level course that guides you through creating formulas using Financial, Date & Time, Math & Trig, Statistical, Lookup & Reference, Database, Text, and Logical functions.
Read More
Self-Study Text
(SSTE450/26) Surgent’s Microsoftr Excelr 2019: Getting Started with 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.
Read More