Closing the Books with Better Tech Tools

QuickBooks Online’s (QBO) reporting capabilities represent the gold standard in financial software, yet most professionals only scratch the surface of its potential. This course reveals how to transform QBO into a reporting powerhouse, making any organization more efficient and accountants more valuable to their clients. Participants will discover how to customize standard reports, build sophisticated management reports that automatically update, and create tailored solutions that deliver exactly what clients need. The course demonstrates how professionals can automate routine reporting tasks, saving hours of manual work while delivering more insightful financial analysis. Beyond core functionality, participants will master advanced features like Spreadsheet Sync, QBO’s powerful Excel integration tool that brings QuickBooks data directly into spreadsheets for unlimited analysis...

Taught by Stephen Yoss · ★ 4.7

In today's digital age, databases have become the backbone of every business technology, application, platform, and service. Every system relies on databases to store and organize information, from financial records in Quickbooks and Xero to sales efforts in Salesforce and Hubspot. Popular reporting tools like Power BI and Excel utilize databases to create beautiful, insightful dashboards. Despite the widespread use and importance of databases, many financial professionals lack a basic understanding of how they operate. Traditionally, working with databases has been delegated to an organization's IT department, leaving the accounting team out of scope. However, in today's technology-driven environment, accountants need to have a basic understanding of how databases work and the ability to query data independently. Our database basics course focuses on the knowledge most helpful...

Taught by Stephen Yoss · ★ 4.7

Every business professional today needs to know how to work with data. We are all generating more and more data every day. However, only some of us know how it can be effectively leveraged. There are many new opportunities for people who can effectively work with data. From helping their organizations make better decisions to working more effectively on projects to creating integration between applications and automating workflows. This course will take a longer and more in-depth look at how to use databases, structure data for optimum workflow, and share data between applications. This course teaches you how to effectively use Excel, Power BI, SQL, and other data-related technologies. You'll also discover how to integrate and share data between different applications. By the end of this course, you'll be able to utilize databases more effectively and make better decisions based...

Taught by Stephen Yoss · ★ 4.7

We will take a deep look into setting up a QuickBooks Online Accountant (QBOA) account. We will examine all the various firm, staff, and client configuration options for getting this to work inside your organization. This class is going to specifically focus on the configuration options for this application. QBO is a big application and it is important to ensure you've properly set up your firm and client files. Additionally, we will look at the various import/export functionality for getting your data into or out of QBO. Participants will leave this class supercharged with the knowledge of how to set up their QBO accounts correctly for long-term success.

Taught by Stephen Yoss · ★ 4.7

Many organizations have implemented Microsoft 365/Office 365 at a basic level, but few have truly explored the breadth and depth of tools included with their subscriptions. Some less commonly known apps help you manage shared email boxes, create and use web forms, schedule appointments, trade shifts, create real-time closed captions, and translate presentations. Attend this session and learn more about the hidden features in Microsoft 365 that you can use to level up your productivity.

Taught by Lawrence A. "Mac" McClelland · ★ 4.5

Enhance your productivity and streamline your accounting practices with ideas learned in this course. This dynamic program, designed specifically for accountants seeking a competitive edge, delves into the practical applications of ChatGPT in your daily workflow. From conducting comprehensive research and crafting compelling correspondence to swiftly addressing technical inquiries and optimizing Excel formulas, you will gain invaluable skills to expedite your tasks and improve overall efficiency. Furthermore, we will delve into the power of ChatGPT plugins, equipping you with the knowledge to process PDF documents seamlessly and efficiently navigate the vast expanse of the web. Join us on this transformative journey and unlock your potential as a proficient and empowered accountant.

Taught by Lawrence A. "Mac" McClelland · ★ 4.5

In today's business environment, automation is no longer just a buzzword but a critical component for enhancing efficiency and accuracy. This session provides practical insights on automating your organization using advanced tools from Zoho, Zapier, Microsoft, and others. We will focus on real-world applications, demonstrating how to automate key accounts payable, banking, and approval workflows. You will also learn to recognize and avoid common pitfalls in automation projects. This course is essential for accounting and financial professionals seeking to leverage automation to achieve greater efficiency, reduce errors, and foster a more productive work environment.

Taught by Lawrence A. "Mac" McClelland · ★ 4.5

New features in Excel provide tremendous opportunities to improve Excel-based operational and financial reports. For example, Data Models, Power Query, Data Analysis Expressions, Power Pivot, and many others can help you create more powerful summaries and schedules in less time than ever. Bundle these tools with some of Excel's “legacy” features, and you have significant new opportunities to improve your Excel-based reporting environments. In this fast-paced seminar, you will learn about the importance of using Power Query to link data into Excel data models and how you can manage these data models to facilitate better and more efficient reporting. Additionally, you will learn how to incorporate Key Performance Indicators, Slicers, and Timelines into your reports to enhance the analytics and understandability of the data. Further, you will learn best practices to format your...

Taught by Lawrence A. "Mac" McClelland · ★ 4.5