• 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

    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 Today, 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 Today, 03:05 PM Go to last post
    Mr_E_Man

    Updated sheet with manual counts

    AliGW,

    Thank you for the quick response to my question! Please find attached the updated sheet with the manual count inserted for the first...

    Mr_E_Man Today, 02:46 PM Go to last post
    AliGW

    Complex counting help

    Please mock up the expected results for the first 5 sites on your list - do this manually so we can see the numbers you are expecting....

    AliGW Today, 07:53 AM Go to last post
    Mr_E_Man

    Complex counting help

    HI. I am, a new user trying to figure out how to count text items in a database of thin client peripheral device details using Excel 2016. The database...

    Mr_E_Man Today, 02:54 AM Go to last post