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.7 Format a List as a Table

Something the next feature I want to introduce you to here was was actually introduced into excel in the 2007 edition of Excel.

Now I’m working this out of 2013 in front of you but three versions ago and the newest version which is 2016 all whole this feature This is called format list as table.

Now looking at my list I’m back into the exercise file, I’m back to the Employee records list.

There are many different things you would do with a list such as what we’re looking at here. We’ve talked about a few you would do sorting. You would do filtering you would do subtotals and there are many more you might do calculations, you might do pivot tables you might format the list to make it more presentable.

Have you ever gone through a list like this and formatted every other row.

These are two things among others that are want to fix as I work with a list such as this, this is where the Format as table comes into play.

Click into my list

I’m going to go to Home tab, I’ve got a style section and in there I got Format as Table.

Format a List as a Table 1

Now it’s just formatting at this point so really doesn’t matter which one I pick. In fact, you know if you’re trying this out whatever you like to your heart’s content, Pick a color I like blue.

A mini window appearance, they want to know where is your data.

I hit OK and I’ve now formatted my list as a table. It alternated row colors. It did it for me I don’t have to do that manually right. It gave me the drop downs for my filters. It built those two things right into my table now. Now what else did it do. It gave me a new tab at the top of my screen table tools with the design tab where there’s all sorts of features you don’t like blue and gray while you can change the colors up here. It gave you remove duplicates that gave you an export command it gave you a bunch of options here for styles.

Format a List as a Table 2

So one the table style options there’s a few things but I’m going to turn on the total row activate, and just check it now down at the bottom of my list. I now have a total row. That’s a count of records like that that if I click in then you give me a dropdown where there are SUM. Maybe I want to sum up the phone extension. It’s a fun extension but just for demonstration I jump in here say SUM. And I’ve now got a sum of all those numeric numbers. There are different calculations that we can use here.

Format a List as a Table 3

You imagine that this list is going to grow in size. People are going to want to add records to this list. You don’t want to add down below because that would be outside of this table in the lower right corner barely see it right. There’s a little little tick mark, if I grab that I’ll get a double headed arrow is going to left click and drag down and I’ve now added more rows to the table.

Format a List as a Table 4

Really simple click into your list. Go to your home tab format The list is a table. Pick your favorite color, it gives you the filters a little jot down arrows, it gives you alternating rows. It gives you the ability to get into some design aspects like the Total row and various other features here, Format list as table one contiguous list.