Our site will be undergoing maintenance from 6 a.m. - 6 p.m. ET on Saturday, May 20. During this time, Bookshop, checkout, and other features will be unavailable. We apologize for the inconvenience.
Cookies must be enabled to use this website.
Book Image Not Available Book Image Not Available
Book details
  • Genre:COMPUTERS
  • SubGenre:Business & Productivity Software / Spreadsheets
  • Language:English
  • Pages:84
  • Paperback ISBN:9781543991796

Dirty Data

Excel techniques to turn what you get into what you need

by Melissa Esquibel

Book Image Not Available Book Image Not Available
Overview

50 tips to help you turn ugly spreadsheet data into something you can use to get valuable insights into your business and processes in Microsoft® Excel®. Applicable to versions 2007 through 2019. There are tips for any level users from absolute beginners through advanced Excel users. Some of the problems Dirty Data offers solutions for include: duplicates, non-date date data, connecting multiple related datasets, resolving time zones, and more. The book is chock full of examples in pictures and sprinkled with humor throughout.

Description

Just because it's Microsoft® Excel®, it doesn't mean it can't be funny! This is the funniest Excel book you never knew you absolutely needed. Turn your ugliest data into something that helps you make good decisions. From figuring out just how dirty your data is, to uncovering the right tools to clean up the kind of dirt you have, Dirty Data will have you saying, "What the...? I didn't know I could do THAT!" Learn tips and tricks for every skill level, for all recent versions, including 2010, 2013, 2016, 2019, and Office 365 Desktop. (Many techniques also work in Google Sheets!)

About the author

Melissa Esquibel was in the thick of early business technology when hardware and systems were kept in a virtual black box, and IT gatekeepers doled out functionality within a rigid systems architecture. She has applied her passion for technology to efforts that educate, inform and mobilize people to conduct business operations efficiently, effectively, and with an eye toward data integrity and business continuity. A professional management and technology consultant, trainer and speaker, Melissa is a Chicago native, attended the University of Illinois at Chicago and DePaul University majoring in Accounting and Business Management. She graduated summa cum laude from Strayer University with a Bachelor of Business Administration, majoring in Legal Studies. She earned a CBCP (Certified Business Continuity Professional) from the Disaster Recovery Institute and held certifications in Lotus Notes Administration and Development. Now, as a certified Microsoft Office Specialist Master and Microsoft Certified Trainer, Melissa focuses on helping people feel empowered by technology, rather than intimidated by it. She conducts webinars through her own company, Sawbuck Seminars (https://sawbuckseminars.com), as well as several other producers. Demystifying the bits and bytes for people who just want to get their work done is the driving force behind her teaching style. Melissa's unique experience as the conduit between the gatekeepers and the gate stormers paints her unique perspective as "bridge builder" for her clients. In addition to facilitating peace between people and technology, all over the world, Melissa Esquibel is a mother, grandmother, painter, guitarist, singer, songwriter, recording artist, and author. She has jumped out of perfectly good airplanes over 200 times and is always looking for the next great experience to have.