Ann K. Emery I design information and share my strategies through keynotes and custom workshops. - page 6

Removing Graph Clutter: Don’t Forget the Leader Lines

Removing Graph Clutter: Don’t Forget the Leader Lines

Software typically gets better with time. New graph types are added, more color palettes are available, and editing tools are easier to locate and faster to use. Excel 2013’s leader lines are an exception. Leader lines are those gray or black lines that connect the labels with…

Continue reading →

Formatting Months, Days, and Years in Excel

Formatting 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 →

Quickly Visualizing Patterns with Excel’s Data Bars

Quickly Visualizing 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 →

Rakesh Mohan on Getting the Attention of Your Audiences

Rakesh Mohan on Getting the Attention of Your Audiences

In this photo, everyone, including the baby, appears to be paying attention to the person sitting in the center. Rakesh took this photo in 2007 when he visited his village in India where he spent first two years of his life.  This was his first…

Continue reading →

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

Letting Spreadsheets Do the Heavy Lifting: Number Formatting Tips

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…

Continue reading →

Page 6 of 33 ← First ... 4 5 6 7 8 ... Last →