Excel for Accounting Professionals Session 6: List Comparisons and Indenting (111W159A15)

Date: August 26, 2015 Time: 3:00 pm - 5:00 pm EST CPE: 2 Format: Webcast
EVENT 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.
Topics Discussed: Lookup functions and list comparisons Multiple
condition functions

LEARNING OBJECTIVES
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
EVENT DETAILS
CPE FIELD OF STUDY
Specialized Knowledge and Applications (2 Credits)
PREREQUISITES
Working knowledge of Microsoft Excel
COURSE LEVEL
Intermediate
LOCATION
Online Webcast
Loading