Below is my presentation from SMX East that will show you how to make your data super sexy in Excel. And I presented in my super fab data dress! I found a DATA DRESS.
Okay, enough estrogen-powered shenanigans. Back to bizniz …
So the presentation covers:
- The psychology behind why data visualization is so important
- Conditional formatting
- Basic charting techniques
- Pivot tables
- Advanced charting techniques, such as interactive charts
- Pivot charts
My Slideshare Deck
View more of my Slideshare presentations.
My Bit.ly Bundle
You can access all the links from my bit.ly bundle here.
Dashboard Course
I spend a lot of time scouring Excel resources to broaden my skills. And when I learn something new and really cool I think will be beneficial for marketers, I massage the techniques a bit and make them palatable for marketers. Although this particular dashboard course isn’t specific to marketers, Mynda’s techniques and teaching style were sublime. If you know me at all, you’ll know I’m not a sales person. But I do believe any marketer wanting to broaden his/her charting skills would benefit enormously from this course.
michellemsem says
You’re no longer the only Mac user who cares about pivot charts. I didn’t even know they existed! Now the challenge is to get Microsoft to be nice to us. No pivot charts. No Bing Ads editor. It’s just rude.
Annie Cushing says
It IS rude! Someone from Microsoft is putting me in contact with someone from the Mac team. Hopefully they’ll take the feedback and improve their next iteration.
George Bounacos says
My new favorite analytics deck. So many actionable items! Great work.
Annie Cushing says
Thanks! Glad you like it. 🙂
Byron Hardie says
Thanks for the slidedeck Annie. Presenting data is often a skill that is glossed over — and as a result many times the data itself is glossed over. I know several executives that would benefit from some advanced Excel training.
Certainly in an agency environment where clients are often flooded with data they don’t understand it is even more important to be able to cut through the numbers and illustrate action steps, show ROI on existing initiatives, visually illustrate the execution of strategic direction, or identify new opportunities.
Annie Cushing says
I couldn’t agree with you more, Byron. I’ve found that sometimes marketers are guilty of inundating decision makers w/ a lot of data to make them look important and busy.