Skip to main content

Shopping Cart

You're getting the VIP treatment!

Item(s) unavailable for purchase
Please review your cart. You can remove the unavailable item(s) now or we'll automatically remove it at Checkout.
itemsitem
itemsitem

Recommended For You

Loading...
  • Cleaning Excel Data With Power Query Straight to the Point

    by Oz du Soleil ...
    Series series Straight to the Point
    Author Oz Du Soleil's area of frustration with Excel is cleaning data. From his earliest days with Excel, he has found himself constantly needing to fix names that are ALLCAPS, peel addresses away from phone numbers, and fixing all the many other things that prevent data from being useful. In this intro to Power Query, Oz shows you five core techniques in Excel Power Query: Splitting data, Filling ... Read more

    $6.95 CAD or Free with Kobo Plus

  • Guerrilla Data Analysis Using Microsoft Excel

    2nd Edition Covering Excel 2010/2013

    This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These tips have been honed by Oz du Soleil, a former financial analyst charged with taking mainframe data and turning it into useful information quickly, and "Mr. Excel" himself, Bill Jelen. Topics include data quality, validation, perfectly sorting with one click, matching ... Read more

    $17.99 CAD or Free with Kobo Plus

  • Excel Data Cleansing Straight to the Point

    by Oz du Soleil ...
    Series series Straight to the Point
    This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy. Data cleansing can include the following tasks: Deleting unnecessary headers Deleting summary rows Filling in gaps Flattening a report Merging and ... Read more

    $6.95 CAD or Free with Kobo Plus

  • Guerrilla Data Analysis Using Microsoft Excel

    Overcoming Crap Data and Excel Skirmishes

    This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as a financial analyst charged with taking mainframe data and turning it into useful information quickly. Topics include data quality, validation, perfectly sorting with one click every ... Read more

    $19.99 CAD or Free with Kobo Plus