Free Webinar—Analyzing Your Data With Excel:
Simple Steps for Actionable Results

Recorded August 22nd, 2013

Do what you can with what you have where you are.
Cowboy, soldier, historian and
26th President of the U.S.

Answer everyday business questions like an analyst with Microsoft Excel. This webinar is based on a selected set of techniques from The 7C’s of Data Analysis, as covered in our book, The Accidental Analyst: Show Your Data Who’s Boss. An abbreviated case study will be used to demonstrate common techniques that can start you on the course to analyzing data with Microsoft Excel 2007, 2010 or 2013.

This presentation is approximately 1 hour and 15 minutes in length.

The webinar video

Internet Explorer requires compatibility mode to view the videos at Freakalytics. On newer versions of Internet Explorer, click the IE gear icon in the upper-right for menus, select Compatability View settings. A dialog appears where you should add to your Websites you’ve added to Compatability View list.

On older versions of IE,
click the broken page icon at the far right of the address bar

Video Index

01:02 – The 7 C’s of Data Analysis

02:59 – The case study for this webinar

03:33 – The 1st C – Choose the question

06:10 – The 2nd C – Collect the data
08:19 – 2nd C – Collect and merge the data in
Excel – the power of VLookup

16:00 – Circle back and write down the 1st C

17:30 – The 3rd C – Check out the data
19:29 – 3rd C – investigate important data items
with pivot tables and pivot charts

32:44 – The 4th C – Clean up the data
33:26 – 4th C in Excel

42:14 – The 5th C – Chart your analysis
42:56 – 5th C in Excel – make a highlight table
51:22 – 5th C – adjust highlight table
for color blindness (particularly red/green)
54:36 – 5th C in Excel – make a line chart
59:07 – 5th C – findings from the highlight table
59:22 – 5th C – findings from the line chart

60:05 – The 6th C – Customize your analysis
62:09 – 6th C in Excel – calculated data items
and slicers in pivot charts

71:07 – The 7th C – Communicate results
71:25 – 7th C – compile key findings in
PowerPoint slide deck

76:32 – More resources for visual analytics

The presentation from this webinar

Use the controls to navigate. On touch-screens, you can swipe to navigate. Click on the slide to advance, click the four squares in the controls for the thumbnails to appear and click the four-way arrows for full-screen viewing. While in full-screen viewing mode, you can use the right/left arrow keys to advance/go back or simply swipe right and left on touch-screens. Use the ESC key or x in bottom control-bar to exit full-screen mode.

[portfolio_slideshow include=”10284,10285,10286,10287,10288,10289,10290,10291,10292,10293,10294,10295,10296,10297,10298,10299,10300,10301,10302,10303,10304,10305,10306,10307,10308,10309″]

Enjoyed this? Please subscribe to our newsletter and share it!
We are a two-person, independent analytics company. Creating great content takes an enormous amount of time! You can support us by subscribing below and sharing this webinar with friends and colleagues. Thanks!

Subscribe to our newsletter


We promise to:

– Send exclusive content quarterly,

– Never share your info,

– Offer a simple way to unsubscribe

The webinar is past. Watch the recording and view the slides above.
Your attendance is complimentary thanks to sponsorship by The Accidental Analyst. Attendees with a US shipping address can optionally order a discounted copy of The Accidental Analyst with your ticket (shipping inclusive). Please allow two weeks after the webinar for the book to arrive.

A recent webinar attendee, inquiring about their book order timing, wrote:


Share the power of R shiny apps across the entire team with YakData
The team at Freakalytics has built YakData brightRserver, our new cloud platform.

Securely share R shiny apps
Develop R shiny apps
All on one dedicated, secure and powerful platform.

Subscribe and keep in touch with us!