Microsoft Excel: Moving Beyond the Basics

This course explores the increasingly complex features of Excel that facilitate efficient data analysis. We will introduce numerous analytical methods and techniques by using practical examples to illustrate how to unleash the power of Excel when manipulating, analyzing and reporting information.

Learning Objectives

Apply a variety of advanced formulas to analyze and manipulate data
Identify solutions to data analysis problems
Identify how Excel can be used as a tool to address data analysis problems you encounter in your professional and personal endeavors

Major Topics

Using formulas to manipulate and transform data
Using formulas and reference formulas such as =VLOOKUP
Using pivot tables
Understanding Solver to perform multivariate analysis

CPE Credits Available

2 CPE

2: Other

Things to Know About This Course

Course Level

Intermediate

Prerequisites

Basic familiarity with Microsoft Excel

Advanced Preparation

None

Intended Audience

Practitioners, members in industry and other accounting professionals seeking a broader understanding of Microsoft Excel

Provider

ACPEN