Catalog Search Results
Author
Description
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 appending data from multiple sources. Pulling data from...
Author
Description
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 time, matching lists of data, data consolidation,...
Author
Description
In this book one can find many artworks created by Picasso between 1881 and 1914. The first style of the artist was influenced by the works of El Greco, Munch and Toulouse-Lautrec, artists that he discovered when he was a student in Barcelona. Picasso, fascinated by the psychological expression during his Blue period (1901-1904), expresses his own mental misery: his genre paintings, still-lifes and portraits were full of melancholy. Later, Picasso...
Author
Description
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 blanks, Joining data sets, grouping and summarizing,...
Didn't find it?
Can't find what you are looking for? Try our Materials Request Service. Submit Request