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…

Using Excel efficiently

Using Excel efficiently

A couple of posts ago I wrote about helping someone learn how to do VLOOKUPS and during that training, I learned how her peers at work were using Excel. Now, I do not know how many people in relative terms do not know how to use Excel: a lot of people or very few people…