Cookies must be enabled to use this website.
Book Image Not Available Book Image Not Available
Book details
  • SubGenre:Desktop Applications / 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

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.


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 (, 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.

Thanks for submitting a review!

Your review will need to be approved by the author before being posted.

See Inside
Front Cover

Loading book cover...

Book Image Not Available Book Image Not Available
Session Expiration WarningYour session is due to expire.

Your online session is due to expire shortly.
Would you like to extend your session and remain logged in?

Session Expired

Your session has expired.We're sorry, but your online session has expired.
Please log back into your account to continue.