Course ID: AET

Advanced Excel Topics: Functions & Formulas, Data Analytics, and Automation Tips & Tricks

About & Customize

Popular Options

  • In-Person
  • Live Webcast

After completing this course, you will be able to:
1. Recognize use cases for various Excel functions and their application to creating formulas.
2. Recall methods to learn and document complex functions using Generative AI.
3. Apply various Excel data analytics features and distinguish when they should be utilized.
4. Recall several automation opportunities in Excel and determine when to apply them.

Major topics include:
– Master advanced Excel functions and formulas to create powerful, dynamic spreadsheets
– Learn how to leverage Generative AI to understand, troubleshoot, and document complex functions
– Explore Excel’s data analytics features, including Power Query, Power Pivot, and Pivot Tables, for efficient data management and analysis
– Discover automation techniques, such as macros, VBA, and AI-driven tools, to streamline repetitive tasks
– Acquire the skills and knowledge needed to become a proficient Excel user in today’s data-driven business environment

Designed For

The accounting professional/frequent Excel user interested in taking their skills to the next level.

Field of Study
Computer Software & Applications
Prerequisites

Experience with Excel functions and formulas, tables and pivot tables. Interest in learning more advanced features and capabilities of Excel.

CPE Credits
4
Level
Intermediate
Available Formats
In-Person, Live Webcast

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