Description
Boosting productivity with Excel
For those unfamiliar with conditional summing, you're in for a revelation -it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by
Practical hands-on Excel learning exercises taught by highly engaging expert in the field
You'll also deepen your skills and tackle real-world Excel workbooks that address the following:
*Session 4 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions, so you'll want to consider watching [Session 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.*
Highlights
Objectives
- Apply selected shortcuts designed to help with formulas and functions.
- Calculate the sum of values in a range using conditional summing.
- Differentiate between various uses of the remove duplicates feature for creating reports.
- Determine the appropriate use of LOOKUP from a foundational perspective.
Designed For
Accounting and finance professionals who'd like to improve their mastery of Microsoft Excel
Course Pricing
WYOCPA Member Fee
$125.00
Non-Member Fee
$149.00
Your Price
$149.00
Upcoming Courses
-
What If Your Client Didn't Take Reasonable Compensation
May 5, 2025
-
Walter Haig's AICPA Auditing Standards Update
May 5, 2025
-
Managerial Accounting: Your Prescription for Better Decision
May 5, 2025
View all upcoming courses