• Data Visualization Training
    • Online Courses
    • Group Training
    • Conference Keynotes
  • Blog
  • About
  • Contact
Depict Data Studio
Depict Data Studio
  • Data Visualization Training
    • Online Courses
    • Group Training
    • Conference Keynotes
  • Blog
  • About
  • Contact
  • Data Visualization Training
    • Online Courses
    • Group Training
    • Conference Keynotes
  • Blog
  • About
  • Contact

Blog

All | Dashboards | Data Analysis | Data Visualization | Presentations | Reports

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.
More »

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.
More »

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.
More »

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.
More »

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.
More »

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.
More »
Page 6 of 8« First«…45678»

Sign up for our newsletter.

Join 5,000 colleagues who have committed to soaring beyond the Dusty Shelf Report.
  • Online Courses
  • Group Training
  • Blog
  • About
  • Contact
Copyright © 2021 | All Rights Reserved | Web Design by Kicks Digital Marketing