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


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

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

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