Tag archive for Microsoft Excel - page 5

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 →

Let Spreadsheets Do the Heavy Lifting: Number Formatting Tips

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

How to Adjust Your Bar Chart’s Spacing in Excel

How to Adjust Your Bar Chart’s Spacing in Excel

Let’s pretend you’re graphing age distributions for a given county. You carefully formatted your histogram: you removed the border, lightened the grid lines, wrote a descriptive title and subtitle, selected customized RGB color codes, and called attention to a section of the graph with the saturated action…

Continue reading →

How to Make a Heat Table in Excel

How to Make a Heat Table in Excel

Just because I adore graphs doesn’t mean that I shun tables. I insert the occasional table inside the body of my report. Every report’s appendices are full of tables, tables, and more tables. When creating traditional tables, I follow the Dark Horse Analytics guide. When I’m…

Continue reading →

Developing a One-Page Annual Report

Developing a One-Page Annual Report

At a recent Board of Directors meeting: “I think I’ll design a one-page annual report for the Washington Evaluators!”   Draft 1 At the meeting: “Which metrics would we include? Maybe stats about the number of members, number of events held, brown bag topics….?” Look closely,…

Continue reading →

Page 5 of 7 ← First ... 3 4 5 6 7