# Excel

## 3D Cell References

Imagine we had the following month-to-month financial review in Excel… …and wanted to create a “year-in-review” sheet. To do so, we can use 3D cell … Read More

## SUMPRODUCT

Say you’re going to a concert with your 3 best friends: Drake, Josh, and Megan. Since your hefty paycheck just came in, you decide to … Read More

## Calculated field

Let’s say that we have the total financial aid given to all students each year in a PivotTable. What if we wanted to create a … Read More

## Group records in range of values

Let’s say that we have a PivotTable that shows each Credit Hour and the corresponding sum of Financial Aid number of credit hours that students … Read More

## Percentages for rows / columns

Considering within row / column Above, we created the “Renovated?” column that determined whether or not the student’s information was pre or post Coding for … Read More

## Order rows / columns

With the above example, we ended with the following PivotTable: What if we wanted the order of Primary Focuses to be (1) Excel, (2) Access, … Read More

## Handling no data in row / column

What if we wanted to show the sum of financial aid received for IL students in each Primary Focus, showing all Primary Focuses (even if … Read More

## Place “all other values” in a different column

Let’s say that Coding for Crammers Academy had renovations done to improve the student experience, including a brand new pool, basketball court, zip-line, and mega … Read More

## Filter for records that meet condition

What if we only wanted to include students with a GPA over 3.9 in our PivotTable? To do so, we’d need to place GPA in … Read More

## Top / Bottom results

What if we only wanted to show the Primary Focuses that had the top 3 most students? In other words… how can we make our … Read More