Self-Study Video
(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...
Read More
Self-Study Video
(SSTE429/26) Surgent’s Get Started with Power BI
Embark on a journey to master Power BI, a powerful tool for data analysis and business intelligence, in this comprehensive course. This course is meticulously designed for professionals who seek to understand the full spectrum of Power BI capabilities, including its integration with Excel's Power BI features like Power Pivot and Power Query, and its...
Read More
Self-Study Text
(SSTE401/26) 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
(SSTE437/26) 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 Video
(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...
Read More
Self-Study Video
(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...
Read More
Self-Study Text
(SSTE453/26) 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
(SSTE423/26) 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
Self-Study Video
(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...
Read More
Self-Study Video
(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...
Read More