https://blab.im/oz-du-soleil-excel-in-the-wild-paige-worthy-data-and-real-talk-2

Trailer: Excel in the Wild Guest – Paige Worthy

/in /by

Paige Worthy is the next guest on Excel in the Wild. Paige is a Content Strategist, Client Services Manager, Writer, Editor … and has a love-hate relationship with data.

It happens here:

Wednesday 25NOV15 @
10:30am Pacific
1:30pm Eastern

We’re going to discuss data, spreadsheets, Excel from a “regular person’s perspective. This isn’t an expert-to-expert conversation where experts assume what non-experts need to be successful.

This will be a fun, insightful conversation about what’s REALLY happening out there in the wild with data and Excel.

My Motivation for Working with Data & Excel

/in /by

There are lots of exciting tools that help us manage data today. Excel 2016 was recently released and the new Get & Transform features are worth upgrading for.

Tonight, however, I stopped to reflect on why my professional life has been devoted to Excel and clean data. It’s not the technology and fancy tricks.

The songs in this video is from the YouTube Audio Library
Mast, by Silent Partner
The Night Falling, by JR Tundra

https://blab.im/oz-du-soleil-excel-in-the-wild-cole-mize-oz-du-soleil

Excel in the Wild: a new video show

/in /by

18NOV15 at 6:05pm Pacific I’m launching Excel in the Wild via ExcelTV!
In the first episode, rapper Cole Mize and I will be discussing rap and music from the perspective of data and how Excel can help.
Join us on Blab at:

Check out Cole Mize at:
http://colemizestudios.com/cole-mize/
https://www.youtube.com/user/ColeMizeStudios/videos
especially his video on structuring lyrics

http://www.excelcampus.com/author/jacampora/

Oz singing Karaoke at the MVP Summit: Disco Inferno

/in /by

Thanks to fellow Excel MVP, Jon Acampora, for recording this.
Check him out at Excel Campus:

https://www.youtube.com/watch?v=V6AxKEVrgVM

Excel 2016’s Get-&-Transform for importing and cleansing Data

/in /by

Can an Excel file be both the source and destination of imported data via Get & Transform? It sure can.

Here I make up for a mistake I made in front of God & e’rbody on ExcelTV. The challenge:

The data looks like a report broken down by State. We want Rep data. So, without writing a single formula, Excel 2016’s Get & Transform feature allows us to reshape the data so that a pivot table is possible.

BTW: Check out the full ExcelTV interview here

It was much fun being back on the air with Rick Jordan and Szilvia.

Using Excel to show future hotel reservations

/in /by

Download the file here: http://datascopic.net/InMyHotel

This video is a though exercise more than a how-to.
Here, we look at a problem that someone described:
“I have a small hotel and don’t have an easy way of knowing who’s going to be here on a particular day.”

In this video I demo a tool that uses
a scroll bar
SUMIFS, and
a bar chart

The idea being, how can we input data, update the chart and minimize scrolling?

Select an image based on a cell value

/in /by

During a workshop someone asked if an image can automatically display based on a cell value. Well, that’s one component of my naughty-nice-o-meter. (https://www.youtube.com/watch?v=fpI3b5ETti8)

In this video we get Excel to show which of 3 pictures has the most votes.

Download 2 picture-pickers here: http://datascopic.net/2picpickers
You get the picker that’s in the video, and a picker that shows the order of 3 different images

How can we tally orders based on partial strings of text?

/in /by

Download the workbook here: http://datascopic.net/salmon_n_goat

Here, we need to look at partial strings of text in order to get totals.
This would be easy if, for example, “Salmon” saw in a cell by itself. But in this drill we have to be able to find “salmon” among other text in a single cell.

3 – Salmon Chowder
1- Ham & Eggs
4 – Curry Goat
7 – Salmon Steak
2 – Deviled Ham

How do we tally the number of Salmon dishes, Ham dishes, Goat dishes and Eggplant dishes?

The method in this video will show how to use the “–” that can seem spooky the first few times you see it. Also used: ISNUMBER and SEARCH.

Oh, and a little Machale Montano at the end. :)

Excel 2016: treemap exploration

/in /by

Excel 2016 includes a treemap option among the chart choices.
What’s a treemap?

That’s what I wanted to know. So, here’s my exploration of the treemap: changing variables, changing the order and noticing when the resulting map is useful or confusing.

One main point for this video is to show behind-the-scenes of exploring and getting to know Excel: come up with some nonsensical data and just play around.