Cookies must be enabled to use this web application.

To allow this site to use cookies, use the steps that apply to your browser below. If your browser is not listed below, or if you have any questions regarding this site, please contact us.

Microsoft Internet Explorer
  • 1. Select "Internet Options" from the Tools menu.
  • 2. Click on the "Privacy" tab.
  • 3. Click the "Default" button.
  • 4. Click "OK" to save changes.
Chrome Chrome
  • 1. Click the "Spanner" icon in the top right of the browser.
  • 2. Click Options and change to the "Under the Hood" tab.
  • 3. Scroll down until you see "Cookie settings:".
  • 4. Set this to "Allow all cookies".
Firefox Firefox
  • 1. Go to the "Tools" menu and select "Options".
  • 2. Click the "Privacy" icon on the top of the window.
  • 3. Click on the "Cookies" tab.
  • 4. Check the box corresponding to "Allow sites to set Cookies.
  • 5. Click "OK" to save changes.
Opera Opera
  • 1. Click on the "Tools" menu and then click Preferences.
  • 2. Change to the Advanced tab, and to the cookie section.
  • 3. Select "Accept cookies only from the site I visit" or "Accept cookies".
  • 4. Ensure "Delete new cookies when exiting Opera" is not ticked.
  • 5. Click OK.
Netscape and Mozilla Suite Netscape and Mozilla Suite
  • 1. Select "Preferences" from the Edit menu.
  • 2. Click on the arrow next to "Privacy & Security".
  • 3. Under "Privacy & Security" select "Cookies".
  • 4. Select "Enable all cookies".
  • 5. Click "OK" to save changes.
Safari Safari
  • 1. Click on the "Cog" icon in Safari.
  • 2. Click Preferences.
  • 3. Change to the Security tab.
  • 4. Select "Only from sites I visit" or "Allow".
  • 5. Close the dialog using the cross.
Book Image Not Available Book Image Not Available
Book details
  • Genre:COMPUTERS
  • SubGenre:Desktop Applications / Spreadsheets
  • Language:English
  • Pages:84
  • Format:Paperback
  • 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.

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.

This site uses cookies. Continuing to use this site without changing your cookie settings means that you consent to those cookies to enhance site navigation and the overall user experience. Learn more about our privacy policy or learn more about how to turn off cookies.