Excel for Accounting Professionals Session 6: List Comparisons and Indenting
This webcast opens with how to use Excel's lookup functions to perform list comparisons. 和, how to perform multicolumn list comparisons without first combining several columns into a single lookup column.
格式
网络直播
日期
2024年8月13日
NASBA研究领域
专业知识
水平
中间
CPE学分
2
教练
杰夫•莱恩
可用性
产品编号
VCL2EXAP6240813
This session opens with how to use Excel's lookup functions to perform list comparisons. 和, 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. 会议期间, 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. 最后, 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.
学习成果
Upon completion of this webcast, you will be able to:
- 执行比较
- 使用ISERROR函数
- Perform multicolumn list comparisons with COUNTIFS
- 使用SUMIFS执行查找
- Indent with the Increase Indent command.
Group ordering for your team
2至5名注册人
Save time with our group order form. We’ll send a consolidated invoice to keep your learning expenses organized.
开始的订单6 +注册者
We can help with group 折扣. 电子邮件 客户端.support@aicpa-cima.com
美国客户来电 1-800-634-6780 (选择 1)
The Association is dedicated to removing barriers to the accountancy profession and ensuring that all accountancy professionals and other members of the public with an interest in the profession or joining the profession, including those with disabilities, have access to the profession and the Association's website, 教育材料, 产品, 和服务.The Association is committed to making professional learning accessible to all product users. This commitment is maintained in accordance with applicable law. For additional information, please refer to the Association's Website 可访问性 Policy. As part of this commitment, this product is closed-captioned. For additional accommodation requests please contact adaaccessibility@aicpa-cima.com and indicate the product that you are interested in (title, etc.) and the requested accommodation(s): Audio/Visual/Other. A member of our team will be in contact with you promptly to make sure we meet your needs appropriately.