Microsoft® Excel: Data Analysis With PowerPivot
Virtual LiveMicrosoft® Excel 2016: Data Analysis With PowerPivot involves the creation of advanced Pivot Tables in Microsoft Excel® using the add-in program, Power Pivot. Data analysis in Excel is limited to using data list or table sources constructed as flat-file databases. With Excel being a spreadsheet program and not a relational database, trying to connect to […]
Advanced Excel for Financial Professionals: Tools to Automate, Analyze, and Audit Financial Data
Virtual LiveCourse Description: Advanced Excel for Financial Professionals: Tools to Automate, Analyze, and Audit Financial Data is designed specifically for accounting professionals who want to deepen their Excel skills for financial reporting, data analysis, and process automation. Participants will explore essential Excel tools and techniques used by CPAs to clean, analyze, and summarize financial data efficiently. […]
Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot
Virtual LiveCourse Description: This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level. In the first half, participants will reinforce foundational skills in working with Excel data lists and tables, including sorting, filtering, and subtotaling. Building on these essentials, the […]
Microsoft Excel® Power Query
Virtual LiveDescription This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will be proficient in importing, reshaping, merging, and automating your data workflows, allowing you to work more efficiently and effectively with large datasets. You will also […]
Using ChatGPT for Data Analysis with Excel and Power BI
Virtual LiveCourse Description Unlock the power of AI to elevate your data analysis skills in this interactive, instructor-led workshop. Using ChatGPT for Data Analysis with Excel and Power BI is a practical, hands-on course designed for analysts, finance professionals, and Excel/Power BI users who want to streamline tasks, uncover insights faster, and automate repetitive processes using natural language. […]
Microsoft® Power BI® Intermediate: From Data Modeling to Interactive Dashboards
Virtual LiveCourse Description: This intermediate-level course takes Power BI users beyond the basics and into the world of scalable, professional-grade reporting. Participants will gain hands-on experience in modeling complex datasets, transforming queries for clean analysis, and building dashboards that tell compelling, data-driven stories. Key topics include designing star schemas, creating DAX measures with variables, developing drillthrough […]
Microsoft® Excel Crash Course: Learn Excel in Two Days!
Virtual LiveThis is a fast-paced course and is designed for those who have been using Excel (any version) at a basic level, as well as those who are self-taught and want to learn short cuts and tips, plus some of the more advanced features. Packed full of information, topics range from fundamentals (using shortcuts) through advanced […]
Microsoft® Power BI® Data Analytics Introduction
Virtual LiveCourse Description: This course involves the creation of exploration, analysis, and reporting of data insights and trends using the Microsoft Power BI® software. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain such insights, trends, and reports. Power BI’s […]
Advanced Excel for Financial Professionals: Tools to Automate, Analyze, and Audit Financial Data
Virtual LiveCourse Description: Advanced Excel for Financial Professionals: Tools to Automate, Analyze, and Audit Financial Data is designed specifically for accounting professionals who want to deepen their Excel skills for financial reporting, data analysis, and process automation. Participants will explore essential Excel tools and techniques used by CPAs to clean, analyze, and summarize financial data efficiently. […]
Microsoft Excel® Power Query
Virtual LiveDescription This four-hour course is designed to teach you how to use Power Query in Excel for data transformation, cleaning, and automation. By the end of the course, you will be proficient in importing, reshaping, merging, and automating your data workflows, allowing you to work more efficiently and effectively with large datasets. You will also […]
Using ChatGPT for Data Analysis with Excel and Power BI
Virtual LiveCourse Description Unlock the power of AI to elevate your data analysis skills in this interactive, instructor-led workshop. Using ChatGPT for Data Analysis with Excel and Power BI is a practical, hands-on course designed for analysts, finance professionals, and Excel/Power BI users who want to streamline tasks, uncover insights faster, and automate repetitive processes using natural language. […]
Microsoft® Power BI® Intermediate: From Data Modeling to Interactive Dashboards
Virtual LiveCourse Description: This intermediate-level course takes Power BI users beyond the basics and into the world of scalable, professional-grade reporting. Participants will gain hands-on experience in modeling complex datasets, transforming queries for clean analysis, and building dashboards that tell compelling, data-driven stories. Key topics include designing star schemas, creating DAX measures with variables, developing drill-through […]