Showing posts with label MS Excel. Show all posts
Showing posts with label MS Excel. Show all posts
Thursday, May 15, 2025
Chart Makers
Here are three options:
As always: user beware! Some of these 'free' ones / tiers can suddenly disappear or turn commerical.
Tuesday, April 1, 2025
Big Data
What is Big Data? Here is a nice & practical 'definition': Big data is a dataset that is too big to be processed using MS Excel. The term 'big' can mean a variety of things: size/volume (of course), but also update frequency (real-time maybe), containing a variety of data types, and dimensionality.
Tuesday, September 24, 2024
Thursday, August 1, 2024
Thursday, August 24, 2023
Thursday, June 15, 2023
Monday, October 10, 2022
Dashboards in MS Excel
Well, maybe not exactly, but Anne Emery here shows some simple and effective way to quickly visualize a table using sparklines, data bars, color scales, and more: How to Make a Not-So-Scary Starter Dashboard in Excel.
Saturday, September 18, 2021
Painting in ArcGIS Pro
This is cool: Painting in Pro. Reminds me a little of this: MS Excel Art.
Saturday, December 19, 2020
Data Organization in Spreadsheets
Data Organization in Spreadsheets is a great little (open-access, thanks!) paper with all kinds of useful tips - perfect for helping students get better with MS Excel.
Friday, September 18, 2020
MS Excel / Google Sheets Tutorial Videos
There are 1,000s of such videos, but I like Vertex42 a lot.
- They are short and complete.
- They often use the same data set for both MS Excel and Google Sheets so it's easy to compare how these two different tools work.
- The data sets are available for download or just require some quick tying and you can follow along step-by-step.
Saturday, August 15, 2020
How to prepare your data for analysis and charting in Excel & Google Sheets
Good stuff: How to prepare your data for analysis and charting in Excel & Google Sheets. Too often I find that students have no sense of basic data formatting in a table and this is a nice and concise tutorial. And that's our problem: our students tend to be incapable of the basics and therefore we never get to the 'advanced' = the dumbing-down on higher education. Thanks K-12!
Add this: How to split and extract text from data columns in Excel & Google Sheets
Saturday, June 20, 2020
Making Music with MS Excel
This is awesome at some many levels:
Wednesday, February 19, 2020
Wednesday, November 27, 2019
Common Online Data Analysis Platform (CODAP)
This looks great: Common Online Data Analysis Platform (CODAP): a web-based and free data exploration and analysis tool.
Tuesday, November 26, 2019
Superfund Sites and Climate Change
Superfund Sites and Climate Change (from the GAO!) is just a simple interactive web map and the data are provided as an MS Excel spreadsheet.
Wednesday, October 23, 2019
MS Excel and Google Sheets on Steroids!
I admit: I use MS Excel a lot and I'm still amazed how much more there is 'under the hood' in terms of functions, analysis options, and charting tricks - here are a few good ones I came across recently:
- An Empty Bar (Ann K. Emery)
- Removing the Double Y Axis (Ann K. Emery)
- VLookup (Ann K. Emery)
- From Data to Charts in 5 minutes (Ann K. Emery)
- Excel Elbow Grease (great tricks by Ann K. Emery)
- Muted Grid Lines and Area Charts (Ann K. Emery)
- Number Formatting / Conditional Formatting (Ann K. Emery)
- Formatting Months, Days, and Years in Excel (Ann K. Emery)
- Label Axis and/or Data? (Ann K. Emery)
- Formatting Names (Ann K. Emery)
- Sorting and Filtering your Spreadsheets (Ann K. Emery)
- Place Labels Directly On Line Graph (Ann K. Emery)
- Custom Color Codes in Excel (Anne K. Emery)
- Categorize values with =IF() and =VLOOKUP() (Ann K. Emery)
- How to Use Vlookup in MS Excel (Anne K. Emery)
- How to match data with VLOOKUP in Excel & Google Sheets (Lisa Charlotte Muth)
- Sparklines and Data Bars (Ann K. Emery)
- Add Dotted Lines to Line Graphs (Ann K. Emery)
- Direct Labeling in Excel (Stephanie Evergreen)
- Make a Pictogram in Excel (Stephanie Evergreen)
- Fast Small Multiple Graphs (Stephanie Evergreen)
- Easy Dot Plots in MS Excel (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel I (Stephanie Evergreen)
- Dumbbell Dot Plots in MS Excel II (Stephanie Evergreen)
- Dumbbell Dot Plots Way Easier (Stephanie Evergreen)
- Make a Slopegraph in Excel (Stephanie Evergreen)
- How to make a scatter plot in Excel (Storytelling with Data)
- Adding a Benchmark Line (Stephanie Evergreen)
- Customizing Colors (Stephanie Evergreen)
- Showing Standard Deviation (Stephanie Evergreen)
- Confidence Intervals to Dot Plots (Stephanie Evergreen)
- Margin of Error in Excel with “Slider Plots” (Andrew Forsman)
- Directly Labeling Excel Charts (Jonathan Schwabish)
- Edit a ledgend in Excel (Storytelling with Data)
- Swimmer Plots (Jon Peltier)
- Pivot Tables (Jon Peltier)
- Interactive data dashboards (Ben Collins)
- Supercategory axis labels (Cole Nussbaumer Knaflic)
- Plotting value within range (Cole Nussbaumer Knaflic)
- Embedding a vertical reference line in Excel (Elizabeth Ricks)
- How to do it in Excel: a shaded range (Elizabeth Ricks)
- How to do it in Excel: adding data labels (Elizabeth Ricks)
- Data prep for MS Excel / Google Sheets (Chartable)
- Extract Text from Data Columns (Chartable)
- Create a dot plot (Storytelling with Data)
- Save As Template (Stephanie Evergreen)
Thursday, October 3, 2019
Saturday, August 3, 2019
The Humanitarian Data Exchange
The Humanitarian Data Exchange looks great and Joe Kerski tried it here.
Sunday, July 28, 2019
Subscribe to:
Posts (Atom)

