Excel Power User Module 3: Six Critical Excel Functions

The item(s) you are attempting to remove has already been removed from your cart.

Overview

Earn CPE credits while mastering fraud detection with Red Flag Mania’s When We Prey Bundle! Level up your professional development and anti-fraud expertise with this comprehensive self-study program for busy professionals. This CPE credit-eligible bundle offers an immersive learning experience, allowing you to earn valuable continuing professional education credits while becoming a fraud-fighting champion. The When We Prey Bundle combines the power of Red Flag Mania’s top-rated on-demand programs: Culture Dash : Sharpen your ethical compass and confidently navigate real-world ethical dilemmas through a whodunnit mystery. Audit Challenge : Step into the shoes of a real auditor, investigate a fraud case, and gain practical experience in control testing. Fraud Scheme Hunt : Develop a keen eye for identifying and understanding how to unravel different fraud schemes. Here’s what you’ll gain: In-depth knowledge of fraud schemes and detection strategies. Hone your skills in recognizing ethical issues within a scenario. Enhanced audit and investigative skills through gamified learning. CPE credits to fulfill your professional development requirements. The When We Prey Bundle is your one-stop shop for mastering fraud prevention and ethical decision-making. Invest in your professional growth and become a valuable asset to your organization. Enroll today and earn CPE credits while becoming an ethical leader, audit pro, and fraud fighter! These courses are produced by Red Flag Mania.

Highlights

Conditional summing basics with SUMIFS
Remove duplicates
Lookup basics
Improving VLOOKUP with MATCH
Improving VLOOKUP with VALUE and TEXT
Moving beyond VLOOKUP with INDEX

Prerequisites

Excel Power User Modules 2 or knowledge of the topics covered.

Designed For

Accounting professionals that use Excel for Windows.

Objectives

Identify the keyboard shortcut for evaluating formula text.
Recall the arguments for the SUMIFS function.
Recognize the Excel feature that removes duplicate values within a range.

Preparation

None.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.