Main Menu
Home / Career / 12 Tips and Tricks for Microsoft Excel

12 Tips and Tricks for Microsoft Excel

Look no further than Maximum PC for twelve handy ways to improve your Microsoft Excel experience:

  1. Use Pivot Table to create tables on the fly.
  2. Use Vlookup to transfer data faster.
  3. Conditional formatting is your friend.
  4. Change the cell listing to jump straight to a cell.
  5. Set up macros.
  6. Format numbers accurately.
  7. Format empty spaces too.
  8. Delete blank rows with Go to.
  9. Use Ctrl+~ to view formulas.
  10. Double-click to automate.
  11. Use Alt+Enter to add multiple lines of text.
  12. Use the RDBEmail to email quickly.

Seamus Bellamy, Paul Lily, and David Murphy make an esoteric world of lines and boxes into something a bit more palpable.


About Matthew Kabik

Matthew Kabik is the former Editor of Computer Aid's Accelerating IT Success. He worked at Computer Aid, Inc. from 2008 to 2014 in the Harrisburg offices, where he was a copywriter, swordsman, social media consultant, and trainer before moving into editorial.

Check Also

The Rise of Botnets in the Age of IoT

One of the greatest dangers to future (and current) cyber security is botnets. This short …

Leave a Reply

Your email address will not be published. Required fields are marked *

Sorry, but this content
is for our subscribers only!

But subscribing to ACCELERATING IT SUCCESS is FREE and only one click away!
Join more than 40,000 IT Professionals and get the best IT management articles to your mailbox with Accelerating IT Success!

Unsubscribe at any time