Monthly archive for July2015

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 →