Contextures Blog Excel Tips and Tutorials

Interactive Excel Chart 0

Create an Interactive Excel Chart

If you add a chart to a dashboard, it’s helpful to let people choose what they’d like to see in the chart. In this example, you’ll choose a date range, and select other criteria,...

Close All Your Excel Files 6

Quickly Close All Your Excel Files

First, I’ve got two quick announcements, and then there’s a handy Excel trick for you. Are you ready for Spreadsheet Day 2016? Quick, close all your Excel files, and bake a cake!

Excel Holiday Meal Scheduler 0

Create a Schedule in Excel

This weekend is our Canadian Thanksgiving, and we’ll have 16 people here for dinner. To make sure that all the dishes are ready on time, I’ll create a schedule in Excel for everything that...

contextures blog theme update 8

Contextures Blog Update

After having all kinds of problems on the blog last week, I’ve installed a new theme. Everything looks different, including the header image. It’s a photo that I took on a vacation, and the...

Excel sing-along 4

Excel Sing Along

It was a busy and stressful week, with all kinds of computer fun – plugin updates that killed my blog, a touchpad that refused to turn off, all my Outlook contacts disappearing into the...

how to plan a pivot table 3

How to Plan a Pivot Table in Excel

Setting up a pivot table is a bit like news reporting – you can give a quick summary of the Who, What, When, Where and How (Much) of your data. After you’ve been using...

lotus 123 release 4 3

Good Old Days of Spreadsheets

A couple of things happened this week that reminded me of the good old days of spreadsheets. There are some good memories, but I really don’t want to go back to those days. How...