You’d love to get that promotion, or perhaps you’re in search of that elusive raise. Maybe you simply want to secure your career in this down economic time. But whatever the motive, you’re looking for ways to impress your boss.
Why not look into Excel? This spreadsheet program might appear to be just a basic, albeit essential, business tool, but the truth is that there are several lesser-known Excel tricks that enable you to work more efficiently.
- Hiding Information: You may wonder why you would want to hide specific information in a spreadsheet. Well, suppose the spreadsheet that has all your data with regards to the company also has everyone’s salary. That is confidential information that you don’t want to reveal at the meeting. Simple hide the column or row by clicking the related number or letter to highlight it, then right-click on that highlighted row or column and select the Hide option in the popup menu. You may then Unhide the row or column in the same manner when the meeting is finished.
- Timestamping: You are able to attach a fixed date and time — which will never change — to your Excel spreadsheets thanks to your computer’s “Ctrl” key. To put a fixed date into a spreadsheet cell, hold Ctrl while you press your computer’s semicolon key. To put the present time into a cell, hold down your computer’s Ctrl and Shift keys while pressing the semicolon.
- A Better-Looking Spreadsheet: Jazz up your spreadsheet with the use of Excel’s Themes option. This is located at the top on the Excel Ribbon. This feature offers you a large variety of color schemes and fonts, or you could create your own and apply it to your spreadsheet.
- 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 determine how many software bundles each of your company’s salespeople sold in the first half of 2011.
- Conditional Formatting: With conditional formatting, you can instantly affect the look of spreadsheet cells that meet certain criteria. For example, a cell showing that product sales rose by more than 100 percent in a given month could take on a different color so that it quickly sticks out.






