Excel

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

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

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

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

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

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

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

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

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