Excel tables | CSE 148 – Excel Exam 2

Still feeling nervous for your exam? Check out the Excel Cram Kit (Exam 2) for practice modules that emulate the difficulty that you'll face on your exam. Each module includes a thorough step-by-step explanation where I walk you through the entire problem solving process!

Excel tables explained

It's summertime, and you've decided you want this next year to be killer. Time to kickstart your Party Planning Committee!

With you taking the lead role, you decided to get a lineup of some potential ideas for this semester:

While this is a good list of parties, the table itself does not look visually appealing. Josie is going to want the table to be her favorite color, green, and Josh is gonna be upset if you don't give him this list of parties in alphabetical order (what an absolute nerd). Not only that, but Mallory is going to want to know which ones she'll need to dress up for, and Jeff will throw a fit if he's dropping too much cash this semester.

To accommodate all these requests, we can utilize an Excel table and easily format/design our table to match specifications!

Excel tables have regular table functionality, but include many features that enable you to customize your table without needing to code more.

Coding a table

Creating Excel tables is the easiest part of using them. To convert our party table above into an Excel table, all I'd need to do is highlight it, then click "Insert" > "Table".

Now, let's start addressing each of our friends' requests.

Selecting a design

First step is to make this table green to that Josie will give it a chance.

With Excel tables, it is extremely easy to change the color scheme. All we need to do is go to "Table" in the ribbon at the top and select a green design that we like!

Perfect, now Josie will be happy with the color scheme!

We can also change the row styles between banded and same-color with the "Banded Rows" checkbox within the "Table" section.

Sorting records

Now, we must alphabetically sort these to make sure that Josh is a happy camper.

To do so, all we need to do is click the arrow beside the "Party Name" column header, and choose "Ascending" order!

Filtering records

When showing Mallory which ones she'll need to dress up for, we can use the arrow next to the "Costume needed?" column header and click through each of the options!

We'll revert this back to no filter so that Jeff can see the total price for all of the parties, and not just the ones that Mallory has to dress up for.

Inserting total rows

For Jeff to see how much all of these parties will cost, we need to add a total row to our table.

To do so, we'll need to click the "Total Row" checkbox within the "Table" ribbon.

Practice problem

Convert the following data into an Excel table with a blue style of your choosing. Then, sort in descending order by "Abbreviation" and remove any hybrid courses from consideration.

Watch the below GIF to see how to format everything!

Excel (Exam 2) Follow-along Guide

It's no secret you retain info better when you write it down. That's why I created the Excel (Exam 2) Follow-along Guide for you!

As you come upon key concepts highlighted in yellow, like this sentence here, you can fill-in-the-blanks on your Follow-along Guide so that you remember all the important stuff for later!

You can obtain the Excel (Exam 2) Follow-along Guide for FREE by entering your email below!

Next, let's learn how to utilize all the features of PivotTables!

Follow-along Guide

Fill-in-the-blanks for highlighted, key points in the concepts below!

Free Resources

Each exam concept broken down in simple, real-world examples!

ToolsExcel (Exam 2) Follow-along Guide
LessonAND vs. OR
LessonHLOOKUP
LessonIFERROR
LessonNested IF vs. IFS
LessonExcel tables
LessonPivotTables
LessonCOUNTIF, SUMIF, AVERAGEIF
LessonSUMPRODUCT
Lesson3D Cell References

Practice Problems

Step-by-step walkthrough for each of the questions you need to be ready for!

"I got this review for my 2nd CSE exam after not doing so well on the first one, and it was so helpful! Will definitely be using again in the future."

Erin Graham
Oct. 26, 2021

Rating: 5 out of 5.

Leave a Comment