Are you gunning for a raise or a promotion? Maybe you only want to stand out for job security. Regardless, this can be achieved by impressing your boss, but how?
What about Excel? Many of us, despite our job, use spreadsheets in Excel. This program is an extremely powerful business tool; here are some tips to increase your efficiency, which is certain to impress your boss.
- Hiding Information: Did you know that you can hide columns, rather then 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. It is possible to Unhide a row or column in the same manner after you have printed or displayed your spreadsheet.
- Timestamping: You can attach a fixed date and time to your Excel spreadsheets utilizing your computer’s “Ctrl” key. In order to do this, hold Ctrl as you press the semicolon key. For the current date and time merely hold down the Ctrl and Shift keys while pressing the semicolon.
- A Better-Looking Spreadsheet: You can enhance a dull 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 boring spreadsheets.
- Tracking Trends: The latest version of Excel includes a feature called Sparklines. With this feature, you can create small charts that show trends in information. For instance, you could use Sparklines to instantly figure out how many software bundles each of your company’s salespeople sold in the first half of 2011.
- Conditional Formatting: This lets you format only specific cells, you can decide on a criteria, and any cells that fall within it will be a certain color. This feature will be helpful to get a quick visual read of your spreadsheet.

