Nonprofit Data Vi...
Follow
Find tag "Excel"
5.0K views | +0 today
Nonprofit Data Visualization
Resources for both data visualization and infographics, with examples from the non-profit sector
Your new post is loading...
Your new post is loading...
Scooped by Amanda Dahlquist
Scoop.it!

The Easiest Way to Make Bullet Charts in Excel

The Easiest Way to Make Bullet Charts in Excel | Nonprofit Data Visualization | Scoop.it
@evalu8r, shares excel tips for making bullet charts that might make your life a little easier. http://t.co/ZMHr60Ahh7
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Sort the data on an Excel chart

When a new chart is created, the order of the data is the same as on the worksheet. In many cases it would be helpful to see the data in ascending or descending order. In this article we would like to show you how you could avoid sorting the original data, and create a dynamic, sortable chart using named formulas
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Excel Tutorials

"A few years ago, I realized there are a ton of Excel tutorials on the internet—great!—but they were only geared towards accountants and economists. For people trying to create a home budgeting spreadsheet, they had tons of tutorials to choose from. But there weren’t any tutorials for those of us trying to analyze data from research or evaluation projects. So, I set out to create my own tutorials for people like us."

Amanda Dahlquist's insight:

Fantastic resource from Ann K Emery -- Excel tutorials on data cleaning,  pivot tables, descriptive stats, and more.

more...
No comment yet.
Rescooped by Amanda Dahlquist from Nonprofit Technology
Scoop.it!

Preparing for Your Data Import: Some Useful Excel Tips and Tricks | Cloud for Good

Preparing for Your Data Import: Some Useful Excel Tips and Tricks | Cloud for Good | Nonprofit Data Visualization | Scoop.it
Many Excel tips and tricks for preparing your data for a Salesforce nonprofit import.

Via steve heye
more...
No comment yet.
Rescooped by Amanda Dahlquist from desktop liberation
Scoop.it!

Monopoly in Excel | Tableau Zen

Before Tableau I had a passion for Excel. I loved it because it was a canvas where almost anything was possible. To prove it, I set out to make one of my favorite games in it...Monopoly. It was pretty challenging and I never ...

Via brucemcpherson
Amanda Dahlquist's insight:

This is an amazing use of Excel's potential. The author's insight about Tableau is also interesting, though.

 

Credit: @brucemcpherson

more...
Scooped by Amanda Dahlquist
Scoop.it!

Visualize small change in large number

Visualize small change in large number | Nonprofit Data Visualization | Scoop.it
Dynamic Excel chart to visualize small change in large values
Amanda Dahlquist's insight:

This blog post taught me how to insert photos into graphs (as in the example).

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Easy Dot Plots in Excel | Evergreen Data

Easy Dot Plots in Excel | Evergreen Data | Nonprofit Data Visualization | Scoop.it
Amanda Dahlquist's insight:

Stephanie Evergreen gives step-by-step instructions on dot plots; the final product demonstrates why, when it comes to graphs, simple is better.

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

How to Make a Diverging Stacked Bar Chart in Excel | Evergreen Data

How to Make a Diverging Stacked Bar Chart in Excel | Evergreen Data | Nonprofit Data Visualization | Scoop.it
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Katherine S. Rowell & Associates | Healthcare Data Experts | Blog – Visualizing Data

Katherine S. Rowell & Associates | Healthcare Data Experts | Blog – Visualizing Data | Nonprofit Data Visualization | Scoop.it
Amanda Dahlquist's insight:

Step-by-step instructions for visualizing data on Excel dashboards

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Microsoft launches GeoFlow for Excel, a tool for visualizing time-stamped 3D data built on Bing Maps

Microsoft launches GeoFlow for Excel, a tool for visualizing time-stamped 3D data built on Bing Maps | Nonprofit Data Visualization | Scoop.it
Microsoft has released a public preview of GeoFlow today, a new 3D visualization tool for Excel which allow users to create, navigate and interact with time-sensitive data applied ...
Amanda Dahlquist's insight:

Makes me wish I had MS Office 2013!

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

From Data Table to Small Multiples in Under 5 Minutes

From Data Table to Small Multiples in Under 5 Minutes | Nonprofit Data Visualization | Scoop.it

When social scientists like me have lots of data, we tend to put it in tables. There's nothing wrong with tables...

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

The Folly of Blaming Excel

The Folly of Blaming Excel | Nonprofit Data Visualization | Scoop.it

 

“The real problem is not whether machines think but whether men do.”

—B. F. Skinner

 

more...
Bhopkins's curator insight, September 9, 2014 1:05 AM

"Intelligent systems and applications contain safeguards, audit trails, and feedback mechanisms. Relying upon manual data entry and copying and pasting, as JPMorgan employees did, only maximizes the chance of user error. Either get people to look at key spreadsheets or build something with greater controls."

Scooped by Amanda Dahlquist
Scoop.it!

Using Excel to do data journalism

Using Excel to do data journalism | Nonprofit Data Visualization | Scoop.it
Amanda Dahlquist's insight:

For beginners, an intro to Excel's capabilities.

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Advanced Excel Skills - What are they & How to become Advanced Excel user?

Now a days, many jobs require advanced Excel skills. Naturally, you are interested to know what are these Advanced Excel Skills? Based on my experience of
Amanda Dahlquist's insight:

Excellent website for Excel techniques and tutorials.

more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

A Visual Explanation of Linear Regression in Excel » Bacon Bits

A Visual Explanation of Linear Regression in Excel » Bacon Bits | Nonprofit Data Visualization | Scoop.it
In the rest of this post, we'll create a Simple Linear regression to test whether or not our Independent variable has a significant effect on our Dependent variable. If there is a significant effect, we can assume that the ...
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Excel: How to create a dual axis chart with overlapping bars and a line

Excel: How to create a dual axis chart with overlapping bars and a line | Nonprofit Data Visualization | Scoop.it
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Advanced Excel Tutorial: Think Like a Programmer and Use Nested IF Statements

Advanced Excel Tutorial: Think Like a Programmer and Use Nested IF Statements | Nonprofit Data Visualization | Scoop.it
If you follow this advanced excel tutorial on IF statements, you can start to see how simple Excel functions can solve complex problems when you use them wisely.
more...
No comment yet.
Scooped by Amanda Dahlquist
Scoop.it!

Good Ol' Excel Is The Ultimate Data Visualization Tool (In Most Cases)

Good Ol' Excel Is The Ultimate Data Visualization Tool (In Most Cases) | Nonprofit Data Visualization | Scoop.it
Excel is the Ultimate Data Visualization Tool
Amanda Dahlquist's insight:

Essential Excel tips

more...
No comment yet.
Rescooped by Amanda Dahlquist from Data Visualization Topics
Scoop.it!

E90E50charts - Excel Charts Gallery

E90E50charts - Excel Charts Gallery | Nonprofit Data Visualization | Scoop.it
Microsoft Excel charts and data visualization tools

Via Siarhei Mardovich
Amanda Dahlquist's insight:

It's hard to believe that all of these were built with Excel.

more...
Kris's comment, August 21, 2013 10:38 AM
Thank you Amanda! On the site we have a Visitor's Book - we would be really happy if you write your comment there too - to have it "forever" :-)
Scooped by Amanda Dahlquist
Scoop.it!

How to make a good looking Excel Dashboard - Part 1: Introduction

This is the first in a series of videos where I'm going to show you how to make a decent looking dashboard in excel. Please feel free to rate, comment or sub...
Amanda Dahlquist's insight:

This 8 part YouTube video series provides step-by-step instructions for creating interactive dashboards in Excel. Highly recommend, as I learned from it myself!

more...
No comment yet.