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.2 Sorting a List Using Single Level Sort

Here’s the first tool that I want to get into within working with a list inside of Excel. And this is perhaps one of the most common tools that are used inside of a list.

Now think about this what’s the purpose of a list. I’ve got a list of employee records, I got to put those someplace where I store the data there. Why are you storing the data while I’m storing the data so that later on I can find it. The purpose of a list is so that you can work with the data. You can find the data. One of the most effective ways of finding data is organizing it properly sorting the lists.

I want to sort this list to make it easier to find specific records. Let’s think about this for a moment what might be something you would sort this list by so that you can more easily make this the mist list more accessible so that you can find that data, think about that for a moment. Look at those column headers. What would you sort this list on to make it easier to find, you might think well it depends on what you’re looking for.

If I’m just looking for specific employees may be I’ll sort this list by last name right or sort of my last name so I get it in a sense in order A to Z and I can skim through the list to find those specific employees with specific last names. You know what I want to find employees that work in a specific location.

We’ll sort the list by location. We’ll put it in the proper order to make it easier to find things.

Think about this. Anybody use a phone book any more, do you still get one of those on your doorstep. I got one a few months back and I thought what am I going to do with that. Right, to the recycle bin. I don’t use them anymore but think about this what if a phone book wasn’t sorted would you find anything you might find something it would take you forever to find it, because it’s not organized properly in an accessible way. So we sort the list to make it easier to find.  Here’s the first method on sorting a list really simple.

Sorting a List Using Single Level Sort 1

I want to start my list by Last Name so I click into the Last Name column, doesn’t matter where just anywhere in the column and I’m going to perform what I call a quick sort. I want to sort by Last Name identify that by clicking into it I’m going to go to Data tab on my Data I got a place called sort filter. And then there I got three sort buttons but the first two are my quick sorts. I can sort descending, ascending A to Z. I’ll give that a click, And I’ve now sorted my life list by a last name and a send in order.

Sorting a List Using Single Level Sort 2

You can see A B C D F G and so on really simple click into the column you want to sort on.

I wanted to do my Last Name go up the data make your selection a sending or descending order whatever is going to make it easier for you to find the data. try this out identify how you want to sort of this list what’s going to make it easier to find specific records, why did my last name you might do it by department, you might do it by location you might do by higher date.

Whatever it is I read up to the date of time select your order. You’ve now sort of your list and made it more accessible.