CPE & Event Catalog

Fundamental Excel techniques all accounting and financial professionals should know and use. Creating date-based calculations in Excel. How to create Excel templates. Key options you should enable in Excel. Linking data in Excel.

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

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

Current audit requirements.

An overview of financial management. Financial statements and cash flow. Evaluating a firm's financial performance. The time value of money. Valuation of stocks and bonds. Capital budgeting: techniques and practice. Short-term financing. Debt financing. International finance.

Role of an accountant. Chart of accounts. General ledger and trial balance. Accounting procedures accounting for receivables. Accounting for investments, and more.

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.

The types of reports available in QuickBooks Online, by subscription level. Customizing reports to meet your needs. Spreadsheet Sync in QuickBooks Online Advanced.

Brand discovery. Brand marketing. Core values. Getting seen online. Audience marketing.

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.

Understanding the importance of data analytics in modern business environments. Generating and interpreting data analytics using everyday applications such as Microsoft Office Excel and Microsoft's Power BI platform. Using regression analysis to create and validate forecasts and projections.

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.