Self-Study Video
(SSTE433/26) Surgent’s Create Measures in Power BI That Define Your Metrics
Unlock the full potential of your data with this specialized course. Designed for professionals who aspire to excel in the dynamic world of data analysis, this 4-hour intensive training delves deep into the advanced functionalities of Microsoft Power BI. You'll embark on a journey to master the art of Data Analysis Expressions (DAX), a powerful...
Read More
Self-Study Video
(SSTE459/26) Surgent’s Mastering the Excel Lookup Functions
In today's data-driven world, Microsoft Excel has become an essential tool for professionals in any organization. To harness the full potential of Excel, it is crucial to understand and master its lookup functions. This course is designed to equip participants with the knowledge and skills needed to effectively utilize Excel's lookup functions and enhance their...
Read More
Self-Study Video
(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...
Read More
Self-Study Video
(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,...
Read More
Self-Study Video
(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...
Read More
Self-Study Text
(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...
Read More
Self-Study Text
(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...
Read More
Self-Study Text
(SSMG129/25) 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
Self-Study Text
(SSMG113/25) 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
(SSMG112/25) 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