Microsoft Excel

2.1 Opening Microsoft Excel 2.2 Microsoft Excel Startup Screen 2.4 Introduction to the Excel Interface 2.5 Customizing the Excel Quick Access Toolbar 2.6 More on the Excel Interface 2.7 Understanding the Structure of an Excel Workbook 2.8 Saving an Excel Document 2.9 Opening an Existing Excel Document 2.10 Common Excel Shortcut Keys 3.1 Entering Text to Create Spreadsheet Titles 3.2 Working with Numeric Data in Excel 3.3 Entering Date Values in Excel 3.4 Working with Cell References 3.5 Creating Basic Formulas in Excel 3.6 Relative Versus Absolute Cell References in Formulas 3.7 Understanding the Order of Operation 4.1 The structure of an Excel Function 4.2 Working with the SUM() Function – Excel 4.3 Working with the MIN() and MAX() Functions 4.4 Working with the AVERAGE() Function 4.5 Working with the COUNT() Function 4.6 Adjacent Cells Error in Excel Calculations 4.7 Using the AutoSum Command 4.8 Excel’s AutoSum Shortcut Key 4.9 Using the AutoFill Command to Copy Formulas 5.1 Moving and Copying Data in an Excel Worksheet 5.2. Inserting and Deleting Rows and Columns 5.3. Changing the Width and Height of Cells 5.4 Hiding and Unhiding Excel Rows and Columns 5.5 Renaming an Excel Worksheet 5.6. Deleting an Excel Worksheet 5.7 Moving and Copying an Excel Worksheet 6.1 Working with Font Formatting Commands 6.2. Changing the Background Color of a Cell 6.3. Adding Borders to Cells 6.4. Formatting Data as Currency Values 6.5. Formatting Percentages 6.6. Using Excel’s Format Painter 6.7. Creating Styles to Format Data 6.8. Merging and Centering Cells 6.9. Using Conditional Formatting 7.1 Inserting Images and Shapes into an Excel Worksheet 7.2 Inserting Shapes In Excel 7.3 Formatting Excel Shapes 7.4. Working with Excel SmartArt 8.1. Creating an Excel Column Chart 8.2. Working with the Excel Chart Ribbon 8.3. Adding and Modifying Data on an Excel Chart 8.4. Formatting an Excel Chart 8.5. Moving a Chart to another Worksheet 8.6. Working with Excel Pie Charts 9.1. Viewing your Document in Print Preview 9.2. Changing the Margins, Scaling and Orientation 9.3 Adding Header and Footer Content 9.4 Printing a Specific Range of Cells 10.1. Intro to Excel Templates 10.3. Opening an Existing Template 10.4. Creating a Custom Template 13.1 Understanding Excel List Structure 13.2 Sorting a List Using Single Level Sort 13.3 Sorting a List Using Multi-Level Sorts 13.4 Using Custom Sorts in an Excel List 13.5 Filter an Excel List Using the AutoFilter Tool 13.6 Creating Subtotals in a List 13.7 Format a List as a Table 13.8 Using Conditional Formatting to Find Duplicates 13.9 Removing Duplicates in Excel 14.1 Excel DSUM Function Single Criteria 14.2 Excel DSUM Function with OR Criteria 14.3 Excel DSUM Function with AND Criteria 14.4 Excel Function: DAVERAGE() 14.5 Excel Function: DCOUNT() 14.6 Excel Function: SUBTOTAL() 15.1 Creating an Excel Data Validation List 15.2 Excel Decimal Data Validation 15.3 Adding a Custom Excel Data Validation Error 15.4 Dynamic Formulas by Using Excel Data Validation Techniques 16.1 Importing Data from Text Files into Excel 16.2 Excel 2019

13.3 Sorting a List Using Multi-Level Sorts

The second technique that I want to talk about here in sorting the list deals with a multilevel sort, I want to sort this list by multiple columns. Now this one is is very quick as well but a few extra steps. I want to get into this list. Same employee records list and I want to sort it not just by last name but I now want to sorted by Last Name and First Name, I want to do two levels here.

First I’m going to click into my lists. Now at this point because I’m doing multiple columns it really doesn’t matter which. I’m going to go back into the sorting filter area but this time I’m go to the big Sort button. This opens up my custom sort window now with then here I can do several things.

Sorting a List Using Multi-Level Sorts 1

You’ll notice that I currently have one sort order and here I can see that I’m sorting my column last Name, I’m going to sort on the values meaning the values within that column the last name values and I’m in a sort in ascending and in order. Now this is just one level I want to add a secondary level a secondary sort up in the top left corner or hit the ADD level button, this adds My second level sort. Now here I’m going to go grab first name or continue to sort on values I’ll continue to do an ascending in order sort and I’ll hit OK. And I’ve now sorted my list first primary sort by Last name secondary sort by First name.

Sorting a List Using Multi-Level Sorts 2

Now if I scroll through this list it may not look like first name is sort of the kind of all over the place but what’s happening here is it’s creating groups. Last name was sorted first, now I’ve got A B C and so on. We go I’ve sorted two levels last name and then first name. Simple quick in your list head up to your data tab go to the big sort button you got your custom sorter your multi-levels sort window open and you can add levels. Here’s an app for you now. Ever since 2007 of Excel you can sort up to 64 levels.

For me personally two three maybe four levels occasionally. Try it out.