Want to automatically update the date and time on your spreadsheet? Or pick text strings from other cells to automatically copy and update to a different cell? You will learn how to incorporate text, date and time functions in your spreadsheet that will make data entry a breeze. In this webinar, we will focus on Text functions and Date & Time functions. In the Text function section, you will learn how to use the various Text functions to join and separate text entries as well as formatting the results. In the Date & Time function section, you will learn how to perform various date and time calculations. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This program reviews the statutory and regulatory guidance as they relate to fringe benefits. There will be an emphasis on entertainment, meals and business transportation expenses, including qualified employer-provided parking, with a focus on planning opportunities. Recent federal tax legislation, cases and rulings will also be addressed. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Do you use Microsoft (Office) 365? Are you satisfied that you are getting the most that you can from it? If you answered yes then no, this course will provide a really high return on your investment of time and money in this application suite. John Higgins, one of the profession's leading experts on the integration of Microsoft 365 into business, will explain and demonstrate the depth and breadth of the Microsoft 365 ecosystem. The course is designed to raise your awareness of all that you can do with Microsoft 365 and substantially increase your monthly subscription ROI. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Guidance on how to account for digital assets (bold):

Accounting for stablecoins may not be stable:

Though the use of digital assets is rapidly expanding, accounting guidance has not kept pace. As a result, accounting for digital assets can feel shaky.

The AICPA can help:

The AICPA practice aid on accounting and auditing for digital assets and this webcast can help you answer the question of what to do when you or your client accounts for stablecoins. You'll be helped to understand how to account for other transactions and investments involving crypto and digital assets under U.S. GAAP. You’ll also learn more about what the AICPA is doing to lend clarity and guidance to this murky but increasingly important field.

Learn how you can add more value:

Whether you’re a CPA with attest clients or an industry accountant responsible for corporate accounting policy, this guidance will give you a clear path to help your clients or firm by applying the most up-to-date accounting policy. Detailed examples and use cases will demonstrate real-world application of this guidance.

Note:
FASB issued ASU No. 2023-08, Intangibles—Goodwill and Other—Crypto Assets (Subtopic 350-60):
Accounting for and Disclosure of Crypto Assets, which is effective for all entities for fiscal years beginning after December 15, 2024. This ASU is not yet reflected in this webcast.

This course focuses on how to integrate independence and avoid conflicts of interest in situations accounting professionals face daily. Participants will be able to know not just what is the right thing to do according to the AICPA Code of Professional Conduct, but how to put values into action. As part of this course, we also walk through real-world examples of individuals and companies faced with these dilemmas. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing, and reporting information. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

This webcast is part of the 2020 Power BI Series. Please see below for the suggested viewing order.

Before you can analyze data, you first must get the data. This webcast focuses on getting data into Excel using different data sources. Whether your data is text, comma delimited (CSV), reports, Excel, databases, web, applications and/or many others, Excel provides the ability to access that data.

You will learn about tools that have been added to Excel that will make accessing that data even easier, such as data models and Power Query (Get and Transform). After this webcast you will finally be able to get the data you need to perform data analysis.

This series is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this webcast series apply to all versions of Excel.

Explore the other webcasts in the 2020 Power BI Series:

Power BI - Introduction to MS Power BI Tools

Power BI - Analyze Your Data With Excel Pivot Tables

Power BI - Create Excel Dashboards for Maximum Impact

Power BI - Use Power Query to Transform Your Data

Power BI - Go Beyond PivotTables with Power Pivot

Power BI - Use Advanced Calculations with DAX Formulas

Power BI - Use PBI Desktop to Create Reports and Dashboards

Power BI - Share Your Data Analysis using PowerBI.com

Learn the inner workings of a government investigation from people who've gone through them. In 2019, the U.S. Attorney's office in Boston brought charges against more than 50 people in a single case. Those people did not have any idea that law-enforcement officers would have an interest in them. They were movie stars, business owners, CEOs, and professionals. Yet each of those people retained Rick Singer, a man who claimed that he could help their children get accepted into elite colleges. Although the parents thought they were making a donation to a nonprofit, they unintentionally implicated themselves in serious criminal charges that would expose them to the possibility of many years in federal prison. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

The Excel for Accounting Professionals webcast series concludes by applying many of the items covered at the same time. We start by discussing dynamic headers, and how important they are when automating reporting workbooks. Next, we review how to transpose the orientation of the conditional summing function to produce horizontal or crosstab reports. We review the idea of mapping tables and show how they are the key to unlocking major efficiency gains. Lastly, we use data validation in our digital reports and review a critical worksheet that belongs in just about every recurring-use workbook:
ErrorCk. The webcast is designed with time for you to work along. This hands-on workshop is an effective way to learn Excel, since you'll be completing the same exercises demonstrated by the instructor. A link will be provided so you can download the necessary Excel files. During the session, the instructor will provide time for you to complete the exercises using your Microsoft Excel for Windows. For each topic presented, the instructor explains the topic and demonstrates it with Excel exercises. Then, the instructor provides time for you to complete many of the same exercises. Finally, the instructor demonstrates the solutions for all the exercises in the practice workbook and then moves to the next topic. This format allows you to work along rather than just watch passively, enabling you to immediately practice the skills demonstrated.

This course will help you develop a strategic marketing and business development plan for your firm using 7 key principles to help maximize lead generation. You will learn how to establish and grow your B2B business in any niche using time-tested strategies, proven processes for attracting and retaining customers, and how to measure your results so you can spend your money and time effectively to own your market and attract higher ROI clients. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.