Best Excel Tips and Tricks = Professional In Excel

Now let's get started.

Number 1 - Quick Analysis Tool. Most people aren't aware of the Quick Analysis tool. When you highlight any table, in the bottom right-corner is an icon. This is the Quick Analysis tool menu. If you click on that it gives you a wealth of options you can choose from. To modify your table for example, I can click on Totals. Click Sum and it shows the sum of the columns. You can click this sum and it sums the rows. You can also do formatting on the table, add icons, create charts and insert them into your spreadsheet, turn it into a table, and add sparklines. There's so much available here and it makes it quick and easy to avoid going through the menus and manually inserting each one of these different options onto your table.

Number 2 - Filter. if you're not using filter you should be. It's very simple. Just click anywhere inside of a table of data, go to the Data tab, click this Filter icon, and it creates a filter at the top of each one of the columns. When you click on one of these it shows you all the unique values listed anywhere in that column and you can turn them off. Select one in particular or two or three or as many as you like. Hit OK and it filters out only those rows of data that matched that filter. It's a great way to manage large lists of information.

Number 3 - Drop-Down Lists. Say you want to select a list of values like 1 2 3 4 and you want it to be selectable from this column right here. Go to the Data tab, click on Data Validation, and choose List from the menu choice. In the source select the choices that you want to make available and hit Enter. Make sure this in cell drop-down checkbox is checked and hit OK. Now when you're in this column and you hit the down arrow it gives you those four choices to choose from. If you try to type something that is outside of that range it gives you a warning that the value doesn't match the list.

Houstonexcelclasses offers Microsoft Excel training. Enroll today to learn tips & tricks & enhance your skills with spreadsheets & formulas.