Tag archive for How-To Tutorials - page 4

How to Sort and Filter Your Spreadsheets

How to Sort and Filter Your Spreadsheets

Have a list of words that need some alphabetizing? Have a list of numbers that you want to arrange from least to greatest or greatest to least? Rather than painstakingly rearranging your rows by hand, let Excel’s Sorting and Filtering features do the heavy lifting…

Continue reading →

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 →

The Absolute Beginner’s Guide to Spreadsheets

The Absolute Beginner’s Guide to Spreadsheets

If you use spreadsheets on a daily basis, this post isn’t for you. Within the past year I’ve led 61 trainings (and counting!) about both data analysis/statistics and data visualization. In each session, there’s one person who’s enthusiastically eager to learn but has almost zero experience…

Continue reading →

How to Format Months, Days, and Years in Excel

How to Format 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 →

How to Quickly Visualize Patterns with Excel’s Data Bars

How to Quickly Visualize Patterns with Excel’s Data Bars

Data bars are miniature within-cell bar charts. I primarily use them to quickly explore patterns in my dataset. Sometimes I decide to make an actual bar chart of the data later on. Other times, I’m simply using these tiny charts to help my brain spot…

Continue reading →

Page 4 of 6 ← First ... 2 3 4 5 6