Tag: <span>Microsoft Excel</span>

Shortcuts for Formatting Peoples’ Names in Your Excel Spreadsheets

Nov 17th, 2015 / Data Analysis

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 like first and last names.

The Absolute Beginner’s Guide to Microsoft Excel Spreadsheets

Sep 8th, 2015 / Data Analysis

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!) and in each session, there’s one person who’s enthusiastically eager to learn but has almost zero experience with spreadsheets. Spreadsheet novices, rejoice! This one’s for you.

How to Format Months, Days, and Years in Excel

Jul 28th, 2015 / Data Analysis

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.

How to Quickly Visualize Patterns with Microsoft Excel’s Data Bars

Jul 14th, 2015 / Data Analysis, Data Visualization

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 the key patterns.

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Jun 16th, 2015 / Data Analysis

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 any of the numbers in your Excel file.

How to Adjust Your Bar Chart’s Spacing in Microsoft Excel

Jun 2nd, 2015 / Data Visualization

Why are the bars and columns in Microsoft Excel’s graphs so far apart?! Learn how to widen your bar charts by minimizing the “Gap Width” between bars/columns.

Blog