What marketer doesn't rely on Excel? The Microsoft spreadsheet tool is loved—and sometimes hated—by everyone from students to CEOs.
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:
- Identify duplicate entries
- Start a number with a zero
- Wrap text
- Prevent some rows or columns from moving when you scroll (freeze panes)
- Use the TEXT function, which is useful for extracting day of the week from dates
- Set limits for data entered into cells and provide error messages if data entered is outside the allowed range
- Make sure your worksheet secure and protected
- Split cells to extract only part of the data (such as the name part of an email address)
- Use pivot tables to analyze data without the use of complex functions
- 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!
Continue reading "10 Time-Saving Tips and Tricks for Using Excel [Infographic]" ... Read the full article
Subscribe today...it's free!
MarketingProfs provides thousands of marketing resources, entirely free!
Simply subscribe to our newsletter and get instant access to how-to articles, guides, webinars and more for nada, nothing, zip, zilch, on the house...delivered right to your inbox! MarketingProfs is the largest marketing community in the world, and we are here to help you be a better marketer.
You may like these other MarketingProfs articles related to Career Management:
- Don't Just Survive, Thrive: Hacks for High Performance by Cate Murden on Marketing Smarts [Podcast]
- The 3Cs of Marketing Success: Ride the Wave to Go Far in Work and Life
- The Big Challenge for Marketers and Marketing in 2021: Michael Barber on Marketing Smarts [Podcast]
- Tips for Building Career Resilience [Infographic]
- How to Stay Relevant at Your Marketing Organization During a Recession: Christina Del Villar on Marketing Smarts [Podcast]