As an entrepreneur, you’re always looking for ways to save time and be more productive. Excel can be a powerful tool for managing your business and start-ups, but it can also be time-consuming to learn and use effectively.
Here are 20 Excel productivity tips that can help you get more done in less time:
- How to auto-sum adjacent cell
Alt + =
- How to create a waterfall chart?
Insert > Chart > Waterfall
- How to insert a new worksheet?
Shift + F11
- How to track changes in a workbook?
Review > Track Changes > Highlight Changes
- How to insert a new column?
Ctrl + Shift + “+”
- How to change the theme of a workbook?
Page Layout > Themes
- How to create a drop-down list in a cell?
Data > Data Validation > List
- How to create conditional formatting rules?
Home > Conditional Formatting > New Rule
- How to remove duplicate rows?
Data > Remove Duplicates
- How to switch data from rows to columns or vice versa?
Transpose (found in: home > paste > transpose)
- How to sort data in ascending or descending order?
Home > Sort & Filter > Sort A to Z or Sort Z to A
- How to create a custom number format?
Right-Click > Format Cells > Number > Custom
- How to adjust text orientation in cells?
Home > Alignment >Text Contro l> Orientation
- How to start a new line in a cell?
Alt + Enter
- How to find the current date?
“TOADY()
- How to generate a random number?
“RAND()
- How to show a value if the cell has an error?
“IFERROR(Value, value_if_error)
- How to solve equations by changing cell values?
Goal Seek (Found in: Data > what-if Analysis > Goal Seek)
- How to count cells with any date?
“COUNTA(range)
- How to create a custom autofill list?
File>Options > Advanced > Edit Custom List
Small business owners who need to track any kind of data will find Microsoft Excel, a part of the Office software suite, to be an indispensable tool.
By following these tips, you can use Excel to be more productive and efficient in your business.