Computer Software & Applications

Self-Study Video

Computer Software & Applications

(SSTE146/27) 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

Computer Software & Applications

(SSET141/27) 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 Video

Computer Software & Applications

(SSTE149/27) 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...
Read More

Self-Study Video

Computer Software & Applications

(SSTE155/27) Surgent’s Smart Formula Selection in Excel: What to Use When

Excel gives you multiple ways to solve the same problem, but which formula is the right one? This course teaches a decision-based approach to function selection, helping you confidently choose between similar and competing functions. Through real-world examples and side-by-side comparisons, you'll learn when IFS or SWITCH is cleaner than nested IFs, how SUMPRODUCT can...
Read More

Self-Study Video

Computer Software & Applications

(SSET137/27) 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

Computer Software & Applications

(SSTE128/27) 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

Computer Software & Applications

(SSTE154/27) Surgent’s Excel for Staff Level 3 – Build Reports and Analyze Data

This 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 efficiently gather, organize, and structure data, apply calculations to derive...
Read More

Self-Study Video

Computer Software & Applications

(SSTE153/27) 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 Video

Computer Software & Applications

(SSTE130/27) Surgent’s Power BI – Bringing It All Together for Data Analysis

This is an advanced-level course designed for professionals looking to integrate and optimize their use of Microsoft Power Pivot and Power BI. Building on the foundational knowledge from previous courses, this session focuses on the crucial next steps after creating data models and measures, guiding participants on how to fully utilize the potential of these...
Read More

Self-Study Video

Computer Software & Applications

(SSTE126/27) 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
1236 Next