• Training Products


    Error Checking for Excel BI Solutions

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


    How much could one spreadsheet error cost? Well, it cost one bank almost $1b. ...
    by Published on 2017-06-28 10:34 PM

    Course Description

    The sad reality is that not all data we need for our reports is stored in nicely curated databases. While some of the data may be, the reality is that we also need to piece together data provided in text files, Excel files, web pages and even the body of emails in order to build the complete business intelligence solutions we need. Until now this has been a ...
    by Published on 2016-12-01 01:00 PM

    Course Description

    For years, Excel has been the business intelligence tool of choice for accountants and business analysts around the world. In July 2015, however, Microsoft released a free software package that has become the hottest software commodity in the business intelligence landscape: Power BI Desktop.

    Join us for an intensive three-day, hands-on boot camp that will allow you to hit the ground running with Power BI. Geared specifically towards Excel users who have never used Power BI, this course takes you from opening the Power BI Desktop for the first time to publishing live, ...
    by Published on 2015-10-22 06:42 PM     Number of Views: 114119 

    M is for (Data) Monkey:
    The Excel Pro's Definitive Guide to Power Query
    In August 2021, we published the second edition of this book under the name Master Your Data for Excel and Power BI. Click here to learn more about it.

    Add to Cart
    (Note that the image above will redirect you to the Master Your Data with Excel and Power BI, the 2nd Edition of this book which is now available for sale.

    It may have a funny title, but this will be one of the most important Excel books you ever buy in your career.

    The Excel book that will change YOUR life...
    Written BY Excel pros FOR Excel pros, this book has been designed to guide you through learning how to master the new "Get and Transform" data experience in Excel. Released as a free add-in from Microsoft for Excel 2010 and 2013, Power Query technology is now built in to Excel 2016 and the Power BI Desktop application. This technology is a game changer, and will revolutionize the way you work with your data forever.

    Way back when this book was nothing more than a concept, we knew that it needed to be approached in a specific way. It had to speak to Excel users, the problems that they face on a daily basis, and ways to solve those problems both effectively and efficiently. It had to be written to keep you engaged, and to take you on a guided journey, learning from someone who understands you as an Excel pro, how you work, and what you face on ...

    Course Description

    In this hands-on course we are going to look at the most important Excel features that will turn you into a quick and efficient data master in Excel.

    Most users missed the implementation of the Excel Tables feature that happened in Excel 2007. It stealthily slid its way into the product with very little fanfare, yet it is one of the most important architectural features that you can implement to enforce data integrity in your solutions. Itís with that feature weíll start, showing you how and why this little feature should form the foundation of every solution you build.


    The Magic of PivotTables

    Add to Cart

    Excel PivotTables: Itís a polarizing term. People who use PivotTables absolutely love them. For those who donít, the term is mysterious and encourages the fear of powerful features that are the domain of geeks and Excel junkies, and out of reach to the common man. But nothing could be further from the truth.

    Why You Should Take This Course:

    If youíve never created, or donít regularly use PivotTables in your work, let me show you that you are missing out on one of the most useful, impressive and easy-to-use tools in Microsoft Excel.

    Excel PivotTables are an amazingly powerful feature that can be used to very quickly summarize and slice and dice data with ease. And contrary to many usersí fears, they are actually VERY easy to use once youíve been shown how.

    So why donít you let me do just that? In this one hour video training course, I will teach you how to build your first PivotTables. Youíll see first hand just how easy they are to create, how fast they work, and how easy it is to change them to display your data the way you want to see it. ...