Tag archive for Microsoft Excel - page 4

How to Place Labels Directly Through Your Line Graph

How to Place Labels Directly Through Your Line Graph

I recently discussed four options for labeling line graphs. A personal favorite is to place the labels directly on top of the data points, like this: There’s been a lot of interest in this labeling technique, so here’s your step-by-step tutorial!   First, set up…

Continue reading →

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 →

Page 4 of 7 ← First ... 2 3 4 5 6 ... Last →