Student Login Course List View Cart
Powered by Ajaxy

Excel University

Microsoft Excel Training for CPAs and Accounting Professionals

Excel University

Menu

Skip to content
  • Training
  • Book
  • Testimonials
  • Articles
  • Blog
  • Author
  • Contact

errorck

webpageBuild a Better ErrorCk

By: Jeff Lenning
For: CalCPA Magazine
If you’d like to work along, please download the sample file:
ErrorCk

Share this:

  • Facebook
  • Twitter
  • LinkedIn
  • Google
  • Reddit
  • Tumblr

Learn Excel

Training Overview
Excel Course List
Free Sample Course

Resources

  • Video Library
  • Download Library

Post Categories

  • Add-Ins (3)
  • Excel (127)
  • Features (72)
  • Functions (50)
  • Keyboard Shortcuts (7)
  • Techniques (28)
  • Training (26)
  • VBA (7)

Post Topics

Breakout CHOOSE Comparison Formulas CONCATENATE Conditional Formatting Data Validation EOMONTH Exact Match External Data Filters FlashFill flatten data Format Fuzzy Lookup Get & Transform Hidden Sheets Hyperlink IF IFERROR INDEX INDIRECT Interactive Lookup Macro Mapping MATCH MAX Named Ranges Named References Names Online PivotTable Power Query QAT styles SUBTOTAL SUMIFS SUMPRODUCT Tables Very Hidden Sheets VLOOKUP Web Browser Web Data Web Query worksheet protection

Recent Posts

VLOOKUP Hack #1: Sort Order

VLOOKUP Hack #1: Sort Order

October 18th, 2017

VLOOKUP is one of the most popular Excel functions. It can do amazing things and help save time. But[...]

Beyond Numbers CalCPA Article

Beyond Numbers CalCPA Article

October 11th, 2017

Often when we use Excel, we think of its ability to operate on numbers. But, Excel is also good at o[...]

Get & Transform: An Alternative to Simple PivotTable Reports

Get & Transform: An Alternative to Simple PivotTable Reports

September 27th, 2017

I love PivotTables, and use them all the time. But, when our needs are simple, we can easily summari[...]

About
  • Overview
  • Author
  • Testimonials
  • Scholarship
Book
  • Overview
  • Video Library
  • Download Library
Online Training
  • Overview
  • Student Login
  • Course List
  • Affiliate Program
Stay Connected
  • Blog
  • rss
  • linkedin
  • facebook
  • google
  • twitter
Contact
  • Form
949-200-7688
info@excel-university.com
Excel University
307 E Willow St #3, Harrisburg, SD 57032
Excel University
Excel University ◦ Copyright © 2012-2017 ◦ All rights reserved