D.P. T-Shot Reference Blog

Welcome to another session of our Microsoft Excel Tutorial.  Today we will be covering two simple but very useful topics: alphabetizing and averaging.  Knowing how to do both of these can efficiently speed up your spreadsheet productivity by almost 50%.  Before we begin, always remember everything we discussed can found in Excel’s help section.  All your questions can be answered there. Take the time to read it for reference.

First up, we will answer the question: “how do i alphabetize in excel?”

Enter values or names on the spreadsheet.  If you wrote the values left to right, then select all rows with values.  If you wrote from top to bottom, then select all columns with values.  After doing so, go to the Data drop-down menu and select Sort.  From the Sort window, select whether you want to sort the values in ascending order or descending order.

Now, we move on to the second question: “how do i average in excel?”

Input values on your desired cells.  After all values are in place, select an empty cell and click Insert from the drop-down menu and choose Function.  After choosing Function, you will be given a list of all available functions, choose Average.  The Average window will now open and will prompt you to select cells to be averaged.  You can select the desired cells by highlighting them.  When you are done highlighting, click OK.  After doing this, you can now see the average on the empty cell that you selected.

That is all the time we have today.  We hope you have learned something from this lesson.  Before we all go, do not forget to send us your feedback and suggestions.