Generic selectors
Exact matches only
Search in title
Search in content
Search in posts
Search in pages
Filter by Categories
Add-Ins
Excel
Features
Functions
Keyboard Shortcuts
Techniques
Training
VBA
Student Login Course List View Cart

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
  • Reddit
  • Tumblr

Learn Excel

Excel Course List
Live Workshops
Free Sample Course
Free Webinar

Subscribe to Blog (free)

  • This field is for validation purposes and should be left unchanged.

Resources

  • Video Library
  • Download Library

Post Categories

  • Add-Ins (16)
  • Excel (185)
  • Features (114)
  • Functions (73)
  • Keyboard Shortcuts (9)
  • Techniques (35)
  • Training (33)
  • VBA (8)

Post Topics

  • Breakout
  • Chart
  • CONCATENATE
  • Conditional Formatting
  • Data Model
  • Data Validation
  • Dynamic Arrays
  • EOMONTH
  • Exact Match
  • External Data
  • FlashFill
  • flatten data
  • Format
  • Get & Transform
  • Hacks
  • Hyperlink
  • IFERROR
  • Impossible PivotTables
  • INDEX
  • INDIRECT
  • Interactive
  • Macro
  • Mapping
  • MATCH
  • MAX
  • Named Ranges
  • Named References
  • Names
  • Online
  • PivotTable
  • Power Pivot
  • Power Query
  • QAT
  • Spill
  • styles
  • SUBTOTAL
  • SUMIFS
  • Tables
  • TEXT
  • VALUE
  • VLOOKUP
  • Web Browser
  • Web Data
  • Web Query
  • worksheet protection
About
  • Overview
  • Author
  • Testimonials
  • Scholarship
  • Sponsor
  • Privacy Policy
Book
  • Overview
  • Video Library
  • Download Library
Online Training
  • Overview
  • Student Login
  • Course List
  • Affiliate Program
Stay Connected
  • Blog
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-2019 ◦ All rights reserved