New Year Readiness: Automation & Analytics Launchpad

Many business professionals consider PivotTables the most powerful feature in Excel, yet most accounting and financial professionals do not use them in their day-to-day activities. If you are ready to learn how to take advantage of PivotTables or extend your existing knowledge, then this course is for you! In this dynamic and engaging session, you'll master how to: • Build PivotTables from scratch • Group data inside PivotTables, including options for fiscal periods • Create user-defined calculations in your PivotTables We start with the fundamentals and quickly move to advanced techniques, including: • Building PivotTables that consolidate data from multiple ranges • Connecting PivotTables dynamically to external databases and financial accounting systems • Leveraging other Excel features associated with PivotTables, such as Slicers, Power Query, and Power Pivot This...

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

Most business professionals have used Excel for years, often without the benefit of any formal training. Thus, they don't know about key features in the application and, therefore, don't use them. Of course, this leads to inefficiencies and errors. Isn't it time to stop this madness? This session is for you if you're ready to become more efficient and effective with Excel! You will learn ten critical features that can help you get more work done in less time and improve your accuracy. We encourage you to make plans to join us for this session to learn the best ways of working with Excel!

Taught by Brian Tankersley · ★ 4.5

In this course, accounting professionals and technology enthusiasts will explore advanced home networking concepts to support remote work and modern digital needs. Learn to select prosumer-grade hardware, configure multi-SSID networks, and integrate functionalities like VPNs, media servers, and remote file access to boost productivity and security. Discover cutting-edge technologies, including SPF+ (10G networking), to future-proof your setup for data-intensive workflows. With practical demonstrations and relevant use cases, this session equips you with the tools to optimize your home network for efficiency, security, and scalability.

Taught by Brian Tankersley · ★ 4.5

We're all familiar with PDF documents. However, it's safe to say that most professionals use only a tiny fraction of their features. This circumstance is unfortunate, considering all you can do with PDF documents. Therefore, isn't it time to take another look at PDF documents and all you can do with them? Participate in this session to learn more about PDFs and how and why they should be a cornerstone technology in most organizations. Collaboration options, long-term storage and archival, and fillable forms are just a few features you will learn about in this session. This session is for you if you're ready to elevate your PDF productivity!

Taught by Brian Tankersley · ★ 4.5

Business Intelligence (BI) is perhaps the hottest topic in most professional circles in today's business climate. Increasingly, organizations of all sizes are seeking to take advantage of the data available to them to identify previously undiscovered insights and gain competitive advantages thought to be out of reach just a few short years ago. A growing array of tools – from Excel add-ins to dedicated solutions such as Power BI – now allow you to leverage your existing knowledge and skills to create powerful, interactive dashboards and analyses unthinkable until recently. This program will teach you to implement “do-it-yourself business intelligence” using a variety of techniques and tools. First, you will learn to use advanced Excel data query and summarization features to create Excel-based dashboards. You will then learn how to leverage that knowledge to build even more...

Taught by Brian Tankersley · ★ 4.5