Content Provider
Excel u logo

Self-Study CPE
6 STEPS TO AN EXTRA 100K FOR YOUR BOOKKEEPING FIRM
View Details/Register
UNLOCKING FINANCIAL EFFICIENCY WITH RAMP
View Details/Register
INTRODUCTION TO FIRMTAMER PRACTICE MANAGEMENT SOFTWARE: LIVE DEMO
View Details/Register
BILL SPEND & EXPENSE: THE POWER OF CLIENT ADVISORY SUCCESS AT PARABLE ACCOUNTING
View Details/Register
BILL DEMO: STREAMLINE CASH FLOW WITH INSIGHTS & FORECASTING
View Details/Register
Free cpe webinars
Data Reconciliation in Excel: Go From Slow to Fast

DATA RECONCILIATION IN EXCEL: GO FROM SLOW TO FAST

Cost Free
CPE Credits 1.0 hour
CE Credits 0.0 hours
Course Level Basic
Instructional Method Group Internet Based
Prerequisites None
Advanced Preparation None
Course Description

Reconciliation is a common task performed by Excel users, and there are many ways to accomplish this task. All ways, however, are not equal: some ways are faster and more efficient than others. When first learning Excel, people often do things manually—wasting valuable time. Yet, power users know there are tips and tricks to reclaim that time. 

Join this webinar with Microsoft Certified Trainer Jeff Lenning, CPA, and accelerate your Excel journey. In this session, Jeff will teach you how conditional formatting, lookup functions, and Power Query will help you complete your reconciliations in a fraction of the time.

Learning Objectives:


  • Identify how to use conditional formatting to increase efficiency in reconciliation

  • Determine how lookup functions can be used for longer lists, on separate sheets, when reconciling in Excel

  • Recall how Power Query will make reconciliation faster when doing repetitive tasks

Linkedin

Jeff Lenning, CPA, CITP

Excel University
Author of Excel University
jeff@excelu.com
(949) 200-7688

Excel u logo

Award-winning instructor Jeff Lenning has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.

User-added image

Additional Materials
Exercise files - zipped
Conditional Formatting
Lookup
Power Query
Webinar Technical 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

Excel u logo
If you could learn Excel simply and easily at your pace and could learn the features and functions that are relevant and practical to accounting professionals – would you want to? If you are an accounting professional and have taken Excel classes before, you know the pace can be too fast or too slow, and the content may not be relevant to your work. Excel University explores relevant features that allow you to get your work done quicker, in a self-paced, fun, and engaging way. Become more efficient, streamline processes, and save time with Jeff Lenning’s Excel University. Designed by a CPA for CPAs and accounting professionals, this series covers functions you need, and skips those you don’t. The content has been written from scratch integrating everything Jeff knows about Excel training learned over the past decade of providing continuing professional education.