CPE & Event Catalog

VLOOKUP function. SUMIFS function. VLOOKUP and SUMIFS comparison.

Rearranging a pivot table. Modify a pivot table. Slicers. Group. Pivot table calculations. Auto formatting a pivot table. Pivot table charts. Data source.

SQMS 1. SQMS 1. SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.SQMS 2. SAS. SSARS 26. 8 components and differences from SQCS 8.

Gaming operations. Accounting systems. Gaming specific accounting. Payroll accounting. Receivables and payables accounting. Fixed asset accounting. Interest capitalization, and more.

Collaboration and security techniques. Tables, data models, and PivotTables. Advanced formulas. Data queries. Creating effective visualizations.

Tips for improving efficiency with QuickBooks and QuickBooks Online. Better reporting when working in QuickBooks environments. Tips for cleaning up QuickBooks and QuickBooks Online instances. Managing inventory more effectively when working with QuickBooks and QuickBooks Online.

Exploring AI applications in accounting and finance. Understanding AI features in everyday tools. Embracing the future: AI's impact on finance and accounting.

Budget-centric features in Excel. Capital budgeting techniques. Working with Solver and Scenario Manager in budgeting and forecasting environments. Collaboration issues, version control, and audit history.

The importance of Business Intelligence in today's business climate. Differentiating between Power BI licensing options. A hands-on approach to creating effective Power BI reports and dashboards.

Evolving trends in the accounting profession, including shifts in supplier dynamics. Advanced software solutions tailored for various service lines and niche markets. Innovative automation tools, with an emphasis on AI and machine learning in accounting. Optimized technology stacks to boost productivity and profitability.

Basic rules. Creating a custom function. Editing and deleting a custom function.

Creating a chart. Editing and updating charts. Formatting and graphics. Creating a default chart. Custom chart types. Different chart types. Scaling. Printing charts. Link excel data into PowerPoint presentations.

Dashboard mockup. Chart overview. Creating charts. Chart basics. In-cell charts. Linking charts and cells. Camera tool. Sparklines. Creating mini charts. Dynamic charts.

Overview of new functions. Dynamic arrays. XLOOKUP. Overview of text functions.

Business math basics. Data analysis. Interest and related topics. Markups and markdowns. Price elasticity. Cost-volume-profit analysis. Sales forecasting. Charts.

What to look for in Excel 2024. How to take advantage of new functions and features in Excel. Integrating Excel data with other applications. Improving Excel security.

Understanding the best types of visualizations to use in specific situations. Creating compelling visualizations using Excel. Adding interactivity to your Excel-based visualizations.

Excel charts and visualizations. The worksheet ribbon. Chart overview. Chart sheets. Advanced charting practices. Sparkline graphics. Custom number formats and shapes. Excel dashboarding.

Pivot tables. The worksheet ribbon. Pivot table data analysis. Goal seeking.

The worksheet ribbon. Importing and cleaning data. Validating data. Worksheet outlines. Lining worksheets. Protecting data.