Course ID: EEIDA2

Excel Essentials & Intro to Data Analysis For Accounting and Finance: Part 2 – Formulas and Functions: Best Practices and Top Functions To Understand

About & Customize

Popular Options

  • Live Webcast

After completing this course, you will be able to:

  1. Understand many Excel functions are used in data analysis specific to accounting and finance
  2. Explain what Dynamic Array functions are and how they are different from standard Excel functions
  3. Utilize different functions to more effectively complete your work, many of which you have not seen before
  4. Explain best practices for formula development, nesting functions and “error trapping”

Microsoft Excel is a ubiquitous tool in accounting and finance, and developing your Excel and data analysis skills is a simple way to keep your skills relevant in the data driven world we now live in. This course is Part 2 of the 4-part series of how accounting and finance professionals can accelerate their Excel skills and more effectively perform data analysis with Excel.

There are an overwhelming number of functions available in Excel, and being aware of the most frequently used functions for accounting and finance professionals and how to apply them will greatly enhance Excel effectiveness.

You will learn how to

  • develop complex functions with a simple “step” approach,
  • understand nesting of functions in formula writing, and
  • solve the inevitable “error” signals that will occur (“error trapping”).
  • The new Dynamic Array functions available in Microsoft 365 will also be covered.
Designed For

All accounting and finance professionals, whether a new professional getting started or a seasoned professional looking to stay current and build on existing Excel capabilities and use in the profession, will benefit from this course.

Field of Study
Computer Software & Applications
Prerequisites

Experience using functions and formulas in Excel is helpful.

Advance Preparation

None

Course Producer
Business Learning Institute
CPE Credits
2
Level
Intermediate
Available Formats
Live Webcast
Types
Seminars

This course, like all courses in the BLI catalog, is customizable for your organization. Format, length, and content customizations are available.

To get started, contact BLI:
(888) 777-7077
team@blionline.org