You would love to get that promotion, or maybe you’re in search of that elusive raise. Maybe you simply want to secure your career in this down economic time. But whatever the reason, you are looking for ways to impress your boss.
Well, you could use Excel. Excel is a very powerful program; there is a lot to learn. We are not going to discuss all you can do with Excel here, but you will learn a few methods to boost your efficiency and perhaps get some recognition as well.
- Hiding Information: There might be a time when you wish to hide certain information when printing an Excel spreadsheet. For example, maybe your spreadsheet contains confidential salary information. Luckily, you can tell Excel not to print certain rows or columns by concealing them before you hit print. To hide rows or columns, click the corresponding number or letter then right-click on a highlighted row or column and click the Hide option. You can then choose the Unhide option to bring these columns and rows back into view.
- Timestamping: If you’d like to attach a date to your spreadsheet, you can use the Timestamp function. 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: Give your spreadsheet a fresh look by using Excel’s Themes option. You can find this in the Excel Ribbon, at the top. Click it, and you will be given a huge variety of fonts, and color schemes that you may apply to your spreadsheet. You can also design your own!
- Tracking Trends: The newest version of Excel includes a feature called Sparklines. By using this feature, you can create small charts that show trends in information. For example, you could use Sparklines to instantly determine how many software bundles each of your company’s salespeople sold in the first half of 2011.
- Conditional Formatting: This allows you to format only certain cells, you can decide on a criteria, and any cells that fall within it will be a certain color. This feature can be helpful to get a quick visual read of your spreadsheet.
