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

Rowboat

Rowboat is a tool to quickly explore massive data tables (CSV or MS Excel) in your browser window. Sounds a little niche, but whatever works!

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, 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

Tuesday, November 26, 2019

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: