Excel has many features that can help you get a lot of work done faster and more efficiently.
Here is a list of 5 excel features you should master to be super productive:
- PIVOT TABLES: Pivot Tables can crunch thousands (or even millions) of data points in a matter of seconds. If you have a data set such as sales records or transaction records, you
can quickly use the drag and drop feature of Pivot Table to create summaries. It can quickly answer management level questions such as which sector is doing better than other or which sales rep
has highest contribution to profit.
Here is a great Pivot Table resource I found online.
- Excel Functions: Excel functions are the life and soul of Excel. You can a great deal of analysis using function. Be it dates, numbers, or text, there are functions for everything. While
there are ~500 Excel functions, you need to know a handful to get a majority of tasks done.
Here is a collection of Excel Functions with Examples and Videos.
- Excel Keyboard Shortcuts: Keyboard shortcuts can save you a lot of time and effort. It saves you time by not requiring you to leave the keyboard and go to mouse for every other thing. There are hundreds of keyboard shortcuts but if you can master the ones you need regularly, you will find a considerable difference in your productivity.
- Excel Table: When working with tabular data, you should always convert it into an Excel table. To do this, select the data that you want to convert into an Excel Table and press Control + T (hold the Control key and then press T). There are many benefits of using Excel Table.
- If you have a data set that expands, Excel Table would automatically account for it in formulas.
- You can use Excel Table column names instead of confusing references when creating formulas
- Conditional Formatting: If your work involves creating reports and analyzing data, you'll find conditional formatting to be a great ally. It helps you visually show the variation in the data. For example, if you have the sales numbers for 10 sales reps, it can visually show the higher ones in green, medium ones in Orange and low ones in red. There are many visual formats you can use including Harvey bubbles, arrows, colors, and bars.
You may also like these Excel Tutorials: