• Error Checking for Excel BI Solutions

    Error Checking for Excel BI Solutions

    Say GOODBYE to Excel ERRORS for GOOD. Finally, your guide to creating clean & error free workbooks.



    COURSE DESCRIPTION

    How much could one spreadsheet error cost? Well, it cost one bank almost $1b. Research suggests over 90 percent of spreadsheets contain one or more errors. This course will show you how to deal with errors and how to fix them.

    So many courses focus on how to do new things in Excel. This course will show you how to improve your current models and PivotTables. If you're the person in the office who creates clean spreadsheets - and can handle errors on the spreadsheets of others - you'll become indispensable. Learn how to build right the first time and quickly apply your knowledge to future work.

    So, if you work with spreadsheets, you (and your company) need this course. Error Checking for Excel BI Solutions is the quickest way to start building error free work. Learn QUICKLY from 10 comprehensive lessons with over 1.5 hours of video content.

    REGISTRATION

    This course is produced in conjunction with ExcelTV. Visit the ExcelTV site for full details and registration.

     

    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!

     

    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • MVP Logo
  • Recent Forum Posts

    p45cal

    Complex counting help

    The table in the latest file needs refreshing - I should have done that myself - sorry....

    p45cal Today, 05:45 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - I think there is still some error in the logic but your suggestion of using Power Query has been invaluable. I have been researching that...

    Mr_E_Man Today, 05:35 PM Go to last post
    p45cal

    Complex counting help

    Attached adjusted accordingly....

    p45cal Yesterday, 11:31 PM Go to last post
    Mr_E_Man

    Complex counting help

    Hi p45cal - the specific "DT" function is the only one that does not get counted for the keypad on the 2nd or 3rd reference, it is different...

    Mr_E_Man Yesterday, 05:55 PM Go to last post
    p45cal

    Complex counting help

    The attached contains a table at cell I6, which agrees with your totals except for the keypad count of the first site (1185) where I have counted the...

    p45cal Yesterday, 03:05 PM Go to last post