Audit & Analytical uses for Filters and Tables in Excel (Excel 2007) (Course Id 353)

Registry

Author :	Patricia McCarthy, MBA
Course Length :	Pages: 25 \|\|\| Review Questions: 10 \|\|\| Final Exam Questions: 10
CPE Credits :	2.0
IRS Credits :	0
Price :	$17.95
Passing Score :	70%
Course Type:	Text - NASBA Registry
Technical Designation:	NonTechnical
Primary Subject-Field Of Study:	Computer Software & Applications - Computer Software & Applications for Course Id 353

Overview :	Who is this course for? This course is intended for individuals needing Continuing Professional Education (CPE), specifically CPAs and other professionals seeking to enhance their Excel skills for audit and analytical purposes. What is this course about or what problem does this course solve? The course introduces Excel 2007 features, focusing on filters and tables, to help users effectively audit and analyze large volumes of data. How can the knowledge from this course be used? Learners can apply Excel features such as AutoFilter, Tables, and Pivot Tables to conduct more efficient and structured data analysis and auditing processes. Why is this course important to a CPA, Accountant, or IRS Enrolled Agent? This course equips accounting professionals with practical Excel tools to enhance data review and auditing efficiency, which are critical for accurate financial analysis and reporting. When is this course relevant or timely? This course remains relevant whenever professionals need to analyze substantial datasets using Excel, particularly useful after its recent revision in March 2024. How is a course like this consumed or used? The course is delivered via self-study with text-based materials, practice exercises, and a final exam, all accessible online with no additional materials required.
Description :	This Excel CPE course online provides a brief introduction to some the Excel 2007 features that can assist you in auditing and analyzing large volumes of data. It is an overview level course. This Filters and Tables in Excel CPE course provides step by step instruction and Excel practice exercises as well as answer files.
Usage Rank :	13333
Release :	2011
Version :	1.0
Prerequisites :	Basic file management skills (open/close) are assumed. Basic Excel skills of navigating and understanding cell references is assumed.
Experience Level :	Intermediate
Additional Contents :	Complete, no additional material needed
Additional Links :	External: Audit Analytical uses for Filters and Tables in Excel Excel 2007 External: IRS — General requirements for the Annual Filing Season Program (AFSP) Internal: Excel Logic Functions (Video) — Course Id 2637 Internal: Decision‑Making Functions in Excel — Course Id 354
Advance Preparation :	None
Delivery Method :
Intended Participants :	Anyone needing Continuing Professional Education (CPE)
Revision Date :	01-Mar-2024
NASBA Course Declaration :	Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :	Text - NASBA Registry - 353
Keywords :	Computer Science, Audit, Analytical, uses, Filters, Tables, Excel, Excel, 2007, cpe, cpa, online course
Learning Objectives :	Course Learning Objectives To apply Excel 2007 features to audit and analytical review of data.
Course Contents :	Chapter 1 - Audit & Analytical uses for Filters and Tables in Excel Get Started with AutoFilter Adding Subtotals to Filtered Data Working with Multiple Filters Other Cool AutoFilter Options Getting Started with Tables Excel Table Tools Remove Duplicates Pivot Tables Review/Feedback Questions Glossary

Click to go to: Excel Courses for Accountants | Excel CPE Courses for CPAs

Click to verify BBB accreditation and to see a BBB report.

Christopher B. from CA bought 1 subscription 2 hours ago. ||| New User Discount - Click Here ||| Grace K. from CA bought 1 course 6 hours ago. ||| New User Discount - Click Here ||| Lina X. from TX bought 1 course 9 hours ago. ||| New User Discount - Click Here ||| JOHN W. from CO bought 1 subscription 10 hours ago. ||| New User Discount - Click Here ||| Jerry C. from OK bought 1 subscription 10 hours ago. ||| New User Discount - Click Here ||| Jenn A. from SC bought 1 course 10 hours ago. ||| New User Discount - Click Here ||| John S. from TX bought 1 course 14 hours ago. ||| New User Discount - Click Here ||| Michael D. from CA bought 1 course 14 hours ago. ||| New User Discount - Click Here ||| Michael D. from CA bought 1 course 15 hours ago. ||| New User Discount - Click Here ||| Zachary M. from PA bought 1 course 1 day ago. ||| New User Discount - Click Here |||

Audit & Analytical uses for Filters and Tables in Excel (Excel 2007) (Course Id 353)

Computer Software & Applications - Computer Software & Applications for Course Id 353

Text - NASBA Registry - 353