Excel Power User Module 2: Fundamental Functions, Concepts, Techniques

Overview

Unleash Your Inner Fraud Fighter with the Fraud Scheme Hunt! Become a crack fraud investigator with Red Flag Mania’s Fraud Scheme Hunt , an immersive self-study program designed for professionals like you. Sharpen your investigative instincts as you hunt down perpetrators and unravel the mysteries behind cunning fraud schemes. This program will take you on a thrilling evidential trail, where you’ll learn to: Classify fraud schemes like a pro: Develop a keen eye for identifying different types of fraud, so you can spot them before they strike. Unmask fraudulent disbursements: Trace the ill-gotten gains and understand how fraudsters steal your hard-earned money. Master the art of bank reconciliations: Ensure your financial records are squeaky clean and identify discrepancies that could signal fraud. Produced by the learning experts at Red Flag Mania, this program is your one-stop shop for mastering ethical decisions, fraud detection and prevention. Don’t wait for fraud to strike - equip yourself with the knowledge and skills to become a fraud-fighting champion! This course is produced by Red Flag Mania. Want the full experience — Purchase the When We Prey Bundle !

Highlights

• Better summing
• Skinny row
• Hide worksheets
• Highlight input cells
• Workbook organization
• Worksheet organization
• Nested functions
• Selection groups
• Workbook design principles

Prerequisites

Excel Power User Module 1 or knowledge of the topics covered.

Designed For

Accounting professionals who use Excel for Windows.

Objectives

• Determine why the SUBTOTAL function is preferred to the SUM function in many situations.
• Identify a technique that helps ensure that a new row inserted between the last data row and the formula row is included in the total row formula.
• Recognize at least three workbook design principles.

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.