Content Provider
Excelceo logo

Middlebanner trn101521
Self-Study CPE
QUICKBOOKS ONLINE PAYROLL: PART 1
View Details/Register
Exceltips

EXCEL TIPS & TRICKS: BEYOND THE BASICS

Available Date(s)
Tuesday, November 02, 2021: 2:00PM EDT
Tuesday, November 16, 2021: 2:00PM EST
Tuesday, December 07, 2021: 2:00PM EST
Tuesday, December 14, 2021: 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
Course Description

When interviewing a job candidate for their technical skills in Excel, most interviewers ask, “Can you do a VLOOKUP?” One more skill set they should be asking for is, “Do you know how to do nested logic?” With these skill sets, an analyst can do amazing things with Excel. 

This course will go over examples of each of these skill sets and introduce you to spinner buttons. 

Spinner buttons are rarely utilized 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 building these analyses, you should know of these capabilities in Excel.

Learning Objectives:


  • Recall various examples of nested logic

  • Identify how to use and build a spinner button

  • Determine how to perform functions beyond a VLOOKUP

Jim Cline

ExcelCEO
Owner and Developer
jim.cline@excelceo.com
(713) 481-6515

Excelceo logo

Our concept is that anyone can learn the easy things, but the people that have unique skill sets are the ones that will shine. To get such a unique 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
Beginning workbook
Webinar FAQs
Frequently Asked Questions
  • To receive CPE credit, you must register for the webinar before it starts.
  • CPE is available to all eligible participants within 24 hours of each webinar.
  • To receive CPE for multiple attendees, at least one person must sign up for the webinar. The post-webinar email contains a link to instructions for the proctor letter. Alternatively, you may log in to your account following the webinar and click on the MY ACCOUNT button to find a link to instructions. For paid courses, payment needs to be made for each attendee before credit will be issued.
Handout Materials
Presentation Slides
Nasba

NASBA Approved

CPAacademy.org (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: www.nasbaregistry.org.

CPAacademy.org 1685 S. Colorado Blvd, Suite #205, Denver, CO 80222

About Our Presenter

Excelceo logo