Recent Blogs

Creating College Lists 101: Copying Data-Part 2

Chalkboard with lesson copying data part 2In the last lesson I showed you how to select and copy a column of data from one spreadsheet to another. In this lesson, I’ll go into more ways to copy data in Excel by copying and pasting multiple columns. I also show with how to paste data into a new column of an existing spreadsheet. To complete this lesson, you need to create a work tab as instructed in Part 1. + Read More

5 Financial Aid Strategies Parents of Juniors Need to Know Before the Spring Semester

Happy Couple on couchParents of juniors need to know that their students’ college financial aid awards will be calculated on the base year that starts January 1 of the student’s junior year. This means that the fall semester of the student’s junior year will be the last chance parents have to implement some financial aid strategies that could significantly increase their student’s eligibility for need-based financial aid. + Read More

Creating College Lists 101: Copying Data-Part 1

Lesson title creating college lists on chalkboardChances are that you won’t be using all of the data available in the DIY College Rankings spreadsheets. Once you’ve defined some basic filters, it’s generally a good idea to copy the data you want to work with to a different spreadsheet tab in the Excel workbook. This way you can add to or modify the data without accidentally deleting or creating errors in the original data. In this lesson, I’m going to show you the basics of how to copy data in Excel. + Read More

Page 1 of 56123...510...Last »