Computer Software & Applications

Filters

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

(SSTE402/26) 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,...

$270

(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...

$115

(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,...

$115

(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...

$115

(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...

$115

(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...

$180

(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...

$115

(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...

$180

(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...

$180

(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.

$180

(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...

$180

(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...

$115

(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...

$180

(SSTE460/26) Surgent’s The 10 Must-Know Excel Features

Transform your Excel skills with our comprehensive training program, designed for users at all levels seeking to master the full suite of Excel capabilities. From powerful data analysis tools like PivotTables and advanced functions such as XLOOKUP, to the nuances of data validations and conditional formatting, this course offers a deep dive into Excel's most...

$115

(SSTE455/26) Surgent’s 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 could 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...

$115

(SSTE436/26) Surgent’s Create Paginated Reports with Power BI Report Builder

Elevate your data reporting skills to new heights with this cutting-edge course. This two-hour, expertly crafted training is designed to transform the way you visualize and present data, leveraging the powerful capabilities of Microsoft Power BI Report Builder. Ideal for professionals who aspire to turn complex data into compelling, print-ready reports, this course is a...

$95

(SSTE435/26) Surgent’s Leverage PowerBI.com to Create Data Analysis for Others

Unlock the full potential of data analytics with this specialized course. This two-hour intensive course is specifically designed to empower professionals in harnessing the powerful features of Microsoft PowerBI.com. Whether you're a data analyst, business intelligence professional, or someone keen on mastering data visualization and report creation, this course is your gateway to becoming a...

$115

(SSTE431/26) Surgent’s Clean, Transform, and 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...

$115

(SSTE458/26) Surgent’s Improve Design and Productivity with Excel Tables

Excel tables are a fundamental feature that streamlines data organization, analysis, and visualization in Excel. Throughout this course, you will discover how to transform raw data into elegant, efficient, and visually appealing tables. By harnessing the full potential of Excel tables, you will be able to make better data-driven decisions and collaborate more effectively in...

$95