Archive for Time-saving strategies

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Shortcuts for Formatting Peoples’ Names in Your Spreadsheets

Have a spreadsheet full of employee contact information? Demographic data for people in your community? A list of classmates attending that upcoming reunion? Most of our spreadsheets contain peoples’ names at some point in the project lifecycle. Here are a few shortcuts for dealing with text…

Continue reading →

Formatting Months, Days, and Years in Excel

Formatting Months, Days, and Years in Excel

Does your file include any dates? If so, check out these simple formatting tips so that your dates are displayed in the style you want. Selecting Your Preferred Date Format If your spreadsheet contains dates, you can select either the Short Date or Long Date…

Continue reading →

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

I bet you’ve got better things to do than fiddle with your spreadsheet for hours on end. And why rely on Excel’s default settings when you can easily format your spreadsheet to fit your exact preferences? There are numerous formatting adjustments you can make to…

Continue reading →