Skip to main content

Excel for Accounting Professionals Session 4: Conditional Summing and Lookups

-

Add to Calendar

Online/Webcast

2.00 Credits

Member Price $89.00

Non-Member Price $109.00

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

Overview

Excel strategies for efficient workbooks plus a detailed exploration of organizing and managing worksheet data designed for accounting professionals.

Highlights

  • Excel shortcuts
  • Conditional summing
  • Removing duplicate values
  • VLOOKUP function

    Prerequisites

    Working knowledge of Excel

    Designed For

    Accounting and finance professionals who’d like to improve their mastery of Microsoft Excel

    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.
  • Non-Member Price $109.00

    Member Price $89.00