5 Ways to Work Efficiently in Excel

5 Ways to Work Efficiently in Excel

Are you gunning for a raise or a promotion? Maybe you just want to get noticed for job security. Regardless, this can be done by impressing your boss, but how?

What about Excel? The majority of us, despite our position, use spreadsheets in Excel. This program is a very powerful business tool; here are some tips to increase your efficiency, which is sure to impress your boss.

  • Hiding Information: Did you know that you can hide columns, instead of deleteing them, when printing a spreadsheet? This can be useful, for example, if the spreadsheet has private information such as salary. In order to hide rows or columns, select the associated number or letter of the row or column to highlight it, then right-click on the highlighted row or column and choose the Hide option. You can Unhide a row or column in the same way once you have printed or displayed your spreadsheet.
  • Timestamping: If you wish to attach a date to your spreadsheet, you can use the Timestamp feature. Just hold Ctrl as you press the semicolon key. If you would like the current date and time hold down the Ctrl and Shift keys while pressing the semicolon.
  • A Better-Looking Spreadsheet: You can improve a boring spreadsheet with Excel’s Themes option. You can find this option in Excel’s Ribbon. Just click on it, and you’ll discover a variety of different fonts and colors that you can use on your formerly uninteresting spreadsheets.
  • Tracking Trends: This is only applicable for those who have a more up to date version of Excel. The feature is called Sparklines and with it you can create charts that relate trends in the information in your spreadsheet. One way you can use this is to quickly and easily figure out how many software bundles your company’s salespeople sold in the first quarter of 2011.
  • Conditional Formatting: This feature allows formatting only in cells that meet the criteria that you decide on. For instance you could decided to have any dollar amount over 1,000 be a distinct color.