Real-World Education for Modern Marketers

Join Over 600,000 Marketing Professionals

Start here!
N E X T
Text:  A A

10 Time-Saving Tips and Tricks for Using Excel [Infographic]

by   |    |  2,522 views

What marketer doesn't rely on Excel? The Microsoft spreadsheet tool is loved—and sometimes hated—by everyone from students to CEOs.

It's easy to get stuck using the features that you know the best. An infographic from training provider Seven Institute offers 10 functions that you may not be using.

The graphic includes the basics (such as wrapping text) and more complex features (such as slicing pivot tables).

Here's a list of what you'll learn how to do in this infographic:

  1. Identify duplicate entries
  2. Start a number with a zero
  3. Wrap text
  4. Prevent some rows or columns from moving when you scroll (freeze panes)
  5. Use the TEXT function, which is useful for extracting day of the week from dates
  6. Set limits for data entered into cells and provide error messages if data entered is outside the allowed range
  7. Make sure your worksheet secure and protected
  8. Split cells to extract only part of the data (such as the name part of an email address)
  9. Use pivot tables to analyze data without the use of complex functions
  10. Use the slicer to make your pivot table analysis even easier

Check out the full infographic, below, or tap or click for a larger version. And be sure to bookmark this page for a quick return when you need Excel help!



Join over 600,000 marketing professionals, and gain access to thousands of marketing resources! Don't worry ... it's FREE!

WANT TO READ MORE?
SIGN UP TODAY ...
IT'S FREE!

We will never sell or rent your email address to anyone. We value your privacy. (We hate spam as much as you do.) See our privacy policy.

Sign in with one of your preferred accounts below:

Loading...

Laura Forer is the manager of MarketingProfs: Made to Order, Original Content Services, which helps clients generate leads, drive site traffic, and build their brands through useful, well-designed content.

LinkedIn: Laura Forer

Rate this  

Overall rating

  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
  • This has a 5 star rating
1 rating(s)

Add a Comment

MarketingProfs uses single
sign-on with Facebook, Twitter, Google and others to make subscribing and signing in easier for you. That's it, and nothing more! Rest assured that MarketingProfs: Your data is secure with MarketingProfs SocialSafe!