Content Provider

Self-Study CPE
View Details/Register
View Details/Register


Available Date(s)
Tuesday, March 03, 2020: 2:00PM EST
Tuesday, April 21, 2020: 2:00PM EDT
Tuesday, May 05, 2020: 2:00PM EDT
Tuesday, June 02, 2020: 2:00PM EDT
Tuesday, July 07, 2020: 2:00PM EDT
Tuesday, August 04, 2020: 2:00PM EDT
Tuesday, September 01, 2020: 2:00PM EDT
Tuesday, October 06, 2020: 2:00PM EDT
Tuesday, November 03, 2020: 2:00PM EST
Tuesday, December 01, 2020: 2:00PM EST

Cost Free
CPE Credits 1.5 hours
CE Credits 0.0 hours
Course Level Basic
Instructional Method Group Internet Based
Prerequisites None
Advanced Preparation None
Series: Excel
Course Description

When interviewing a job candidate for his/her technical skills in Excel, most interviewers ask “Can you do VLOOKUP and PivotTables?” One more skillset that they should be asking for is “Do you know how to do nested logic?” With these three skill sets, an analyst can do amazing things with Excel. In this course, we will go over examples of each of these skillsets, as well as introduce you to Spinner Buttons. Spinner Buttons are rarely used but are very easy to set up and use, particularly when you want to see immediate changes in your spreadsheet when changing variables. Even if you are not the one building these analyses, you should know of these capabilities in Excel.

Jim Cline

Owner and Developer
(713) 481-6515


Our concept is that anyone can learn the easy things, but the people that have exceptional skill sets are the ones that will shine. And to get such an exceptional skill set takes work -- a lot of work and study. We're not going to tell you that this course is so easy that a six-year old can do it. We've designed the courses that way to teach phenomenal skills, not just ordinary skills.

Additional Materials
Special excel promotion for CPAacademy members
Webinar FAQs
Frequently Asked Questions
  • To receive CPE credit for the event, you must register for the webcast prior to the start of each program.
  • CPE is available to all eligible participants within 24 hours of each webinar.
  • Multiple attendees: In order to receive CPE for multiple attendees, ensure that at least one person signs up for the webinar. At the completion of the webinar a proctor form is provided. Alternatively, you may also login to your account following the webinar and click on the MY ACCOUNT button where you will find a link to the proctor letter.
Handout Materials
Presentation Slides

NASBA Approved (Sponsor Id#: 111889) 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: 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222

About Our Presenter