SS1: 4TH AND 5TH TOPIC

CREATING AND USING BUILT IN FUNCTIONS
Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data. These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu.
This lesson provides a complete Excel Functions list, grouped by category

1. Text Functions 
2. Logical Functions
3. Information Functions 
4. Date and Time Functions
5. Lookup and Reference Functions 
6. Math and Trig Functions
7. Statistical Functions 
8. Database Functions
9. Financial Functions 
10. Engineering Functions
11. Cube Functions 
12. Web Functions

For more information, visit http://cs.furman.edu/digitaldomain/more/excel/excel_3.htm

SORTING IN EXCEL

In Excel, you can quickly sort your data by using the A-Z and Z-A Sort buttons on the Ribbon's Data tab. But, be careful, or one column may be sorted, while others are not.

Only use this technique if there are no blank rows or columns within the data.

1. Select one cell in the column you want to sort.
2. On the Excel Ribbon, click the Data tab.
3. Click Sort A to Z (smallest to largest) or Sort Z to A (largest to smallest)

4. Before you do anything else, check the data, to ensure that the rows have sorted correctly. If things look wrong, immediately click the Undo button on the toolbar.

Form more information, click https://www.contextures.com/xlSort01.html

FILTERING IN EXCEL

The filter feature applies a drop down menu to each column heading, allowing you to select specific choices to narrow a table. Using the above example, let’s say you wanted to filter your table by Company and Salesperson. Specifically, you want to find the number of sales Dylan Rogers made to Eastern Company.

To do this using the filter you would:

• Go to the Data tab on Excel ribbon
• Select the Filter tool
• Select Eastern Company from the dropdown menu
• Select Dylan Rogers from the Salesperson dropdown menu

For more information, go here https://www.learnexcelnow.com/sorting-and-filtering-data-with-excel/