JN CPE Courses
JN Productions CPE Courses - PO Box 293024 - Lewisville, TX 75029
Phone (800)479-5636 Fax (443)222-0698
JN Productions is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org.
Delivery Method: Self-Study. Make your purchase through our secure shopping cart. Once your purchase is completed, you will receive download instructions by email.
Format: Online pdf text (Printed book available for addl. $15 plus s/h.)
Prerequisites: Familiarity with Excel
Level: Intermediate
CPE Credit: 3 Hrs. Specialized Knowledge & Application
Price without printed book: $48
Price with printed book: $63 plus s/h
Course expiration: You have one year from date of purchase to complete the course.
Software Requirements: This manual is is based upon Excel 2007 but can be used with Excel 2003. Users of earlier versions will still find many useful tips that they can apply. There are no associated data files.
Course Description:This course covers the tips, tools and some techniques for Excel 2007. The features discussed are geared toward ones that a CPA needs to know. Watch your efficiency and productivity increase.
Prerequisites: Familiarity with Excel
Level: Intermediate
CPE Credit: 3 Hrs. Specialized Knowledge & Application
Price without printed book: $48
Price with printed book: $63 plus s/h
Course expiration: You have one year from date of purchase to complete the course.
Software Requirements: This manual is is based upon Excel 2007 but can be used with Excel 2003. Users of earlier versions will still find many useful tips that they can apply. There are no associated data files.
Course Description:This course covers the tips, tools and some techniques for Excel 2007. The features discussed are geared toward ones that a CPA needs to know. Watch your efficiency and productivity increase.
This is a great course if you are looking for some helpful tips on increasing your efficiency and productivity in Excel.
The manual is set up in a question and answer format by topic.
This course covers:
Quick Overview of Excel 2007 basics
Enhanced Features in Excel 2007
Filter, Conditional Formatting, Sort, IFERROR
Basics
Selecting Data, Navigating Around, Copy/Group Data
Work with Formulas, Printing
Analytical and Productivity Tools
Subtotals, SUMIF, SUMIFS, Index Match, Pivot Tables
Linking Excel Charts into PowerPoint,
Get External Data, Text Commands
Remove Duplicates
Quick Overview of Excel 2007 basics
Enhanced Features in Excel 2007
Filter, Conditional Formatting, Sort, IFERROR
Basics
Selecting Data, Navigating Around, Copy/Group Data
Work with Formulas, Printing
Analytical and Productivity Tools
Subtotals, SUMIF, SUMIFS, Index Match, Pivot Tables
Linking Excel Charts into PowerPoint,
Get External Data, Text Commands
Remove Duplicates
Learning Objectives
Upon completion of this course, a participant should be
Upon completion of this course, a participant should be
|
|
Familiar with the key new features of Excel 2007
|
|
|
Able to navigate and copy more efficiently
|
|
|
Able to link external Excel files into a PowerPoint presentation
|
|
|
Able to import data and then manage it through text commands
|
|
|
Able to lookup data efficiently
|
|
|
Comfortable nesting and copying subtotals
|
|
|
Aware of new functions such as IFERROR and SUMIFs
|
Other Excel courses by this author:
Spreadsheet Controls Under SOX 404
Fraud Audit Techniques Using Excel
***Buy all three and get a 15% discount***
Spreadsheet Controls Under SOX 404
Fraud Audit Techniques Using Excel
***Buy all three and get a 15% discount***
About the Author
Patricia McCarthy has an extensive background in teaching and business. She has doing customized software training for more than 16 years and has had a variety of clients including the Indiana CPA Society. She has also been a contributor to the Journal of Accountancy. Patricia was a full-time Lecturer in Management Information Systems at Butler University’s School of Business for six years and she has also taught at other universities in Indiana. Prior to embarking on a career in software training, Patricia was in the financial analysis and treasury functions for several large corporations. Patricia holds a B.A. degree from the College of the Holy Cross and holds an M.B.A in finance from Babson College. She is also certified as a MOS expert in Excel.
Course #6001b Including Printed Book
$63
$63
No extra charge for online exam
Course #6001 Book ONLY
$15
Course #6001 E-Book ONLY - PDF Download
$10
Order the book only:
-If you do not need CPE credit but are looking for excellent reference material.
-If you have already ordered the online course or the Mega CPE Special and now want to order the printed book. (No CPE credit is available if you have not ordered the complete course).
Order the book only:
-
This course is included in our Mega CPE Special