Moving Beyond the Basics of Excel Webinar
Back to Search

Moving Beyond the Basics of Excel Webinar

CPE

When
Oct. 26
9:30 - 11:30 a.m.

CPE Credits
2-Other

Details

 Pricing

PICPA Member: $79 | Nonmember: $104


 More Information

Course No.
CHCHMBB2
Level
Intermediate
Prerequisites
Basic familiarity with Microsoft Excel
Note
This webinar is hosted by PICPA's partner, CPA Crossings, LLC. After registering, you will receive an email from messenger@webex.com with the log-in information.

Description

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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.

Learning Objectives:

After attending this presentation you will be able to...

  • 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

Highlights

The major topics covered in this class include:

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


Speaker(s)


You May Also Like

Moving Beyond the Basics of Excel Webinar
Dec. 30 | Webinar
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 ...
Practical Excel Topics for CPAs Webinar
Dec. 8 | Webinar
This program will introduce useful features of Excel, with a focus on workbook structure, navigating within workbooks, understanding how to use formulas, formatting, and other introductory concepts. This event ...
Analytical Procedures: Practical Applications and Standards Webinar
Dec. 15 | Webinar
This session explores the nature of analytical procedures, with significant emphasis placed upon professional standards involving the use of analytical procedures in audit and review engagements. Practical examples to illustrate ...