You may want to wow your boss because you want a promotion, or a raise, or you just want to differentiate yourself from the crowd. No matter the reason, the initial question is how?
What about Excel? Many of us, regardless of our position, use spreadsheets in Excel. This program is a very powerful business tool; here are some tips to enhance your efficiency, which is certain to impress your boss.
- Hiding Information: Did you know that you can hide columns, instead of deleteing them, when printing a spreadsheet? This can come in handy, for example, if the spreadsheet has private information such as salary. In order to hide rows or columns, select the related number or letter of the row or column to highlight it, then right-click on the highlighted row or column and select the Hide option. It is possible to Unhide a row or column in the same manner 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 want the current date and time hold down the Ctrl and Shift keys while pressing the semicolon.
- A Better-Looking Spreadsheet: Perk up your spreadsheet by utilizing Excel’s Themes option. This is found at the top on the Excel Ribbon. This feature gives you a large variety of color schemes and fonts, or you could design your own and apply it to your spreadsheet.
- Tracking Trends: This is known as Sparklines and is only available in the latest version of Excel. It lets you create charts that show trends in the data in your spreadsheet. This can be helpful, for instance, if you need to quickly see how many software bundles your company’s salespeople sold in the first half of last year.
- Conditional Formatting: This feature allows formatting only in cells that meet the requirements that you select. For instance you could decided to have any dollar amount over 1,000 be a distinct color.