The Event requested could not be found

March 1, 2021 7:00am – 10:30am

Webcast: K2's Advanced Excel Reporting - Best Practices, Tools and Techniques | 4203604I

Learn to build advanced Excel reports, including reports where the source data resides in your accounting software or another database. Leverage Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP) to connect Excel to external data sources, such as your accounting software database, and to extract data for reporting and analysis. Incorporate PivotTables into reporting, including how to add calculations to your PivotTables, grouping PivotTable data into fiscal reporting periods and how filtering PivotTables using Slicers. Address best practices to present compelling and captivating Excel-based reports and charts, and to use two Excel add-ins – BizNet's Excel Business Information Suite and Microsoft's Power Pivot – to streamline and automate many of the manual processes associated with building Excel-based reports. Stop spending time accessing and converting financial data into useful reports. Take full advantage of Excel's reporting tools.

More Information

Webcast
Accounting & Auditing
4
March 1, 2021 9:00am – 10:40am

Webcast: K2's Small Business Cloud Accounting Shootout | 4203891E

Cloud-based accounting solutions are taking the market by storm. With so many choices available today, it can be difficult to know which are best for you and your clients. Learn the strengths, best fit, and target market for many of the leading cloud-based solutions, including QuickBooks Online, Sage Business Cloud Accounting, Xero and Accounting Suite. Additionally, review some lesser-known but practical options like Zoho and Wave Accounting. Don't miss this opportunity to consider cloud-based options available to small businesses.

More Information

Webcast
Accounting & Auditing
2
March 1, 2021 10:00am – 1:30pm

Webcast: K2's Advanced Excel Reporting - Best Practices, Tools and Techniques | 4203604J

Learn to build advanced Excel reports, including reports where the source data resides in your accounting software or another database. Leverage Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP) to connect Excel to external data sources, such as your accounting software database, and to extract data for reporting and analysis. Incorporate PivotTables into reporting, including how to add calculations to your PivotTables, grouping PivotTable data into fiscal reporting periods and how filtering PivotTables using Slicers. Address best practices to present compelling and captivating Excel-based reports and charts, and to use two Excel add-ins – BizNet's Excel Business Information Suite and Microsoft's Power Pivot – to streamline and automate many of the manual processes associated with building Excel-based reports. Stop spending time accessing and converting financial data into useful reports. Take full advantage of Excel's reporting tools.

More Information

Webcast
Accounting & Auditing
4
March 1, 2021 11:00am – 12:40pm

Webcast: K2's The Perfect Storm - Data Governance and Privacy Regulations | 4204370E

How do you control the data you are responsible for? Consider the impact of the May 2018 General Data Protection Regulation (GDPR). Also, the December 11, 2019 introduction of a law in India giving authorities sweeping access to data. Plus, the most important piece of U.S. legislation, the California Consumer Privacy Act (CCPA) in force as of January 1, 2020. Companies like Microsoft and Apple claim to be ready, and plan to implement CCPA across the country. What about your business? Have you completed your implementation? Learn practical steps to be compliant with mandated regulations.

More Information

Webcast
Information Technology
2
March 2, 2021 6:00am – 1:30pm

Webcast: K2's Excel Tips Tricks and Techniques for Accountants | 4203636M

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Learn efficient and effective ways to work with Excel, including countless tips, tricks, and techniques to improve your productivity, reduce time spent on mundane tasks and customize Excel for accuracy and efficiency. Gain skills like formula-building, best practices for linking Excel data from other worksheets and workbooks and how to streamline report generation and printing. Your K2 instructor will reinforce key points with practical, real-world examples to improve your understanding and comprehension. Drawing on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals to assure you receive only the most relevant and useful information and guidance.

More Information

Webcast
Information Technology
8
March 2, 2021 7:00am – 2:30pm

Webcast: K2's Excel Tips Tricks and Techniques for Accountants | 4203636N

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Learn efficient and effective ways to work with Excel, including countless tips, tricks, and techniques to improve your productivity, reduce time spent on mundane tasks and customize Excel for accuracy and efficiency. Gain skills like formula-building, best practices for linking Excel data from other worksheets and workbooks and how to streamline report generation and printing. Your K2 instructor will reinforce key points with practical, real-world examples to improve your understanding and comprehension. Drawing on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals to assure you receive only the most relevant and useful information and guidance.

More Information

Webcast
Information Technology
8
March 2, 2021 10:00am – 5:30pm

Webcast: K2's Excel Tips Tricks and Techniques for Accountants | 4203636O

Excel is the accountant's tool of choice for analyzing and reporting financial data, yet many use time-consuming and error-prone processes to complete everyday tasks. Learn efficient and effective ways to work with Excel, including countless tips, tricks, and techniques to improve your productivity, reduce time spent on mundane tasks and customize Excel for accuracy and efficiency. Gain skills like formula-building, best practices for linking Excel data from other worksheets and workbooks and how to streamline report generation and printing. Your K2 instructor will reinforce key points with practical, real-world examples to improve your understanding and comprehension. Drawing on over twenty-five years of experience in delivering spreadsheet training to accounting and financial professionals to assure you receive only the most relevant and useful information and guidance.

More Information

Webcast
Information Technology
8
March 2, 2021 12:00pm – 2:00pm

Webcast: Time Management for CPAs | 4203417C

Develop a framework of "effective" time management. Identify the three time factors: time wasters or stealers, time savers and time management techniques. Highlight concepts that distinguish the relationship between time management and behavioral science versus traditional time management tools or gimmicks. Finally, explore the need to manage oneself to improve time management.

More Information

Webinar
Management
2
March 3, 2021 6:00am – 1:30pm

Webcast: K2's Excel Best Practices | 4203637M

As spreadsheets continue to evolve, so must your practices for creating, editing, and auditing. Gain an in-depth understanding of techniques to work with Excel, learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel and reporting on data contained in Excel. Today's best practices for Excel differ significantly from those of the past. Course materials include relevant examples to enhance your learning experience. Participate in this program to update your skills, using Excel to its fullest potential. This course covers features found in Excel versions 2007 and newer.

More Information

Webcast
Information Technology
8
March 3, 2021 7:00am – 2:30pm

Webcast: K2's Excel Best Practices | 4203637N

As spreadsheets continue to evolve, so must your practices for creating, editing, and auditing. Gain an in-depth understanding of techniques to work with Excel, learning best practices associated with Excel spreadsheets in each of the following areas: creating and editing Excel workbooks, securing Excel workbooks, collaborating with others in Excel and reporting on data contained in Excel. Today's best practices for Excel differ significantly from those of the past. Course materials include relevant examples to enhance your learning experience. Participate in this program to update your skills, using Excel to its fullest potential. This course covers features found in Excel versions 2007 and newer.

More Information

Webcast
Information Technology
8

Need assistance to find the right mix of CPE to meet your CPE requirements and to fit your professional development needs? Contact the ASCPA to assist you in planning your CPE schedule at (602) 324-6042 or by email.