2 Simple Excel Tricks: Post-It Notes and +/- Method (or grouping)

2 Simple Excel Tricks: Post-It Notes and +/- Method (or grouping)

Not all Excel tools and functions require complicated math or processes; sometimes it’s just a simple productivity tool. I’m going to show you two that I’ve recently started using, one that appears more productive than the other. First, here’s a full PDF that explains in slightly more details the 2 tricks I’ve been using and…

Simple Data Visualization

Simple Data Visualization

In one of my recent posts, I wrote about simplifying a wall of information into a distilled set of information that your audience needs to understand. It can be just showing a few columns instead of everything. There’s another option for conveying information: visuals, more commonly called charts. I helped out someone who wanted to…

Data Viz in Reporting

Data Viz in Reporting

I once had to do a program presentation using a file that had columns of numbers going out to column AY or something like that – see image below. Somebody didn’t show up due to an emergency, so I had to fill in, even though I had just arrived at the company and knew nothing…

Excel’s Analyze Data

Excel’s Analyze Data

There has been a lot of rush amongst companies to embed some kind of AI intelligence similar to ChatGPT, but it looks like Excel already had something like it for about 2 years. It started out life as “Ideas” and is now called “Analyze Data” and is found on the Home page. You can ask…