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 may require compatibility mode to view the video,
click the broken page icon at the far right of the address bar
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.
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