: Excel for Accounting Professionals Session 6: List Comparisons and Indenting (11W028A-15)

Description

This session opens with how to use Excel’s lookup functions to perform
list comparisons. And, how to perform multicolumn list comparisons
without first combining several columns into a single lookup column. We
discuss how a minor detail like how we indent can produce major
efficiency gains. We end the session by comparing traditional lookup
functions to Excel’s multiple condition summing function. The session is
designed with time for you to work along. This hands-on workshop is an
effective way to learn Excel, since you’ll be completing the same
exercises demonstrated by the instructor. A link will be provided so you
can download the necessary Excel files. During the session, the
instructor will provide time for you to complete the exercises using
your Microsoft Excel for Windows. For each topic presented, the
instructor explains the topic and demonstrates it with Excel exercises.
Then, the instructor provides time for you to complete many of the same
exercises. Finally, the instructor demonstrates the solutions for all of
the exercises in the practice workbook, and then moves to the next
topic. This format allows you to work along rather than just watch
passively, enabling you to immediately practice the skills demonstrated.

Learning Objectives
  1. Upon completion of this course, you will be able to: Perform list comparisons Use the ISERROR function Perform multicolumn list comparisons with COUNTIFS Perform lookups with SUMIFS Indent with the Increase Indent command
Course Level
Intermediate
CPE Field of Study
Specialized Knowledge and Applications*
2
Prerequisites
Working knowledge of Microsoft Excel
Location
Online
Event Information
When
Mar 17, 2015
3:00 pm - 5:00 pm EST
Location
Online
Total CPE Credits
2
Format
Webcast Replay

MEMBER


$ (% off)
$105.00

NON-MEMBER


$ (% off)
$145.00
Become A Member

Register for this Event

: Excel for Accounting Professionals Session 6: List Comparisons and Indenting (11W028A-15)


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×