Moving Beyond the Basics of Excel Webinar
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
March 1 | 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
...
Feb. 6 | Webinar
This
course
dives
into
the
powerful,
but
potentially
under-utilized,
capabilities
of
Microsoft
Excel.
Designed
for
sophisticated
users
willing
to
approach
spreadsheets
from
a
unique
perspective,
this
program
encourages
users
to
...
Feb. 7 | 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
...