Chandoo – Excel School + 50 Ways Course

Description

Chandoo – Excel School + 50 Ways Course download, Chandoo – Excel School + 50 Ways Course review, Chandoo – Excel School + 50 Ways Course free
Chandoo – Excel School + 50 Ways Course
50 Ways to Analyze your Data
Become an awesome analyst
Problem: Too much data, too little action
This is the age of big data. Alas, what we need is big insights, not big data. Unfortunately, finding even small insights buried in heaps of data is hard. And as analysts & managers, we are expected to spot trends before they are obvious, raise red flags early on and prompt action backed by solid insights. But how?
The challenge is complicated due to,

we have too much data
too many buzz words (big data, data science, business intelligence, predictive analytics etc.) but no instruction on how to do
everyone (customers, bosses, regulatory authorities etc.) expect us rely on data to take actions
the results are expected NOW, not after 6 weeks of analysis

Answer: Analyze data to make better decisions
The answer is obvious. We need to analyze data in agile fashion and derive results that prompt us towards better decisions.
What we need is not the answer. We need the solution.
A solution to help you take any raw data and uncover the story it is hiding. This is where 50 ways to analyze data course can help you.
Reality: 80% of highest paying business jobs require advanced Excel & analysis skills
Preparing you for a deep dive in to the data ocean
Here is one question you should not be afraid to hear.
“Can you analyze this data and tell me what is going on?”
Time for a short story from my past. Rewind to June 2006. Right after my MBA, I became a business analyst with one of the largest technology companies in world. Everything was smooth until my first assignment. My boss called me to her cabin and said, “Can you analyze our top 100 clients and tell me what you find?”
It was the kind of open ended question that has many answers. And I knew none. After several days of frantic analysis (in Excel, of course), I came up with several charts only to be shot down. It is as if I am shooting in dark and hoping to hit the insight my boss wanted.
Only when I applied structured thinking and proper analysis did I find the right insights that helped us take better decisions.
After 13 years, 1,000s of spreadsheets later, I am very happy to create a detailed program to help you attack such opened ended questions confidently.
50 lessons, hundreds of examples
Lesson plan

As the name suggests, 50 ways to analyze data contains 50 video lessons, each exploring one analysis technique or situation.

You can consume these lessons in any order. The only requirement is that you should be good with Excel. If you are a beginner, I suggest enrolling for the option – Advanced Excel + 50 Ways course package.Let’s see the lesson plan.
General Analysis techniques (25 lessons): 

Moving averages
Weighted averages
Top 5 / bottom 5 analysis (2 lessons)
Trend analysis (4 lessons)
Descriptive statistics
Visual analysis of distribution (2 lessons)
Budget vs. Actual analysis (3 lessons)
How many items are due?
Overlapping dates & times
Monthly totals from daily data
Quarterly totals & reporting from data (2 lessons)
Unique & duplicate data analysis
Panel charts
XY Relationship analysis & charts
Indexed charts
Word frequency & sentiment analysis

Marketing & Operations analysis techniques (11 lessons):

Pareto analysis & charting
Us vs. competition analysis & charts
Solver & optimization techniques (2 lessons)
Planning a project
FIFO inventory analysis
BCG matrix analysis
Random allocation & scheduling (2 lessons)
Analytical charts
Segmentation & Cluster analysis using K-means technique
Finding outliers using K Nearest Neighbors technique

Financial analysis techniques (8 lessons):

Break-even analysis
Buy vs. Rent analysis
Time value of money
Cost benefit analysis
2 way data tables & what if analysis
Internal rate of return
Circular calculations & scenarios
Simulation using Data tables

Case studies (6 lessons):

Case studies on detailed analysis reports, dashboards & articles featured on chandoo.org hall of fame.

Bonus material:

Introduction to Excel
Techniques on working with raw data (clean up techniques, connecting to external databases)
Example workbooks for each lesson
Bonus: Cust. complaints case ($99 value)
Uber vs. Your Car – Bonus Model & Video
Forecasting time series data – interactive chart – XLS & Video

Lessons for Advanced Excel (Excel School) module:
This is an optional module you can sign-up for. It includes 32 hours of training on beginner to advanced Excel concepts and dashboard reporting. This module has below lessons:

Excel basics – 3 lessons
Excel formulas – 11 lessons
Advanced formulas – 7 lessons
Formatting & presentation of data – 3 lessons
Conditional formatting – 3 lessons
Excel charting basics – 4 lessons
Advanced charting in Excel – 2 lessons
Interactive & dynamic charts in Excel -2 lessons
Using data validation, sorting & filtering features –
Excel Pivot tables – 2 lessons
Working with external data – 5 lessons
Excel Dashboards – 12 lessons

Skills you will gain
In the 50 ways to analyze data course:

How to analyze data & present results
How to model & solve business problems
Multiple approaches to analyze data
Creating interactive analysis outputs
Core analysis concepts on statistics, operations & finance
Obtaining, cleaning & structuring data for analysis
Speeding up analysis process
Making your analysis flexible & easy to change
Simulations and what-if analysis

In the Advanced Excel & Dashboards module:

Using Excel faster & better
Creatively using & combining Excel formulas
Making awesome workbooks
Creating stunning visualizations & interactive charts
Bringing outside data to Excel for analysis
Unlocking the mysteries of Pivot Tables
Preparing amazing dashboard reports & automating them
Becoming productive in Excel

What do you get? 
Over 50 hours of training

24 hours of Basic to Adv. Excel

20 hours of Data analysis

8 hours of Dashboard training

100+ example workbooks

Bonus: Excel Basics videos

Bonus: Uber vs. your car model

Bonus: Cust. complaints case

Bonus: Forecasting time series data

Bonus: Excel Formula course
Tim Pearce – DCAM 2.0 Aesthetics Marketing & Social Media
Course Contents
Video Modules

Get Their Attention

Become Their Bestie

Become Their Hero

Trigger Them To Book

Save Time

Tech Tutorials
Downloads

Downloads
Video Introduction by Miranda Pearce
Did you know that a shocking 69% of Injectors are only getting 0-1 booking per week from social media?

And what’s worse… they’re spending up to 5+ hours creating content every week… but getting almost no results from it.
I hear Injectors struggling with this every day…
“The time it takes to create content doesn’t reflect the revenue that should come from my efforts”.

I get it… it’s like adding a full-time job on top of everything you already have on your plate as a Practitioner.
You put your heart and soul into creating the perfect post, you spend ages on it, you hit publish… and… nothing. Crickets. Or maybe a few views from other Practitioners, your mum and your grandma.
But no real engagement from potential clients.
And definitely not enough bookings to make it worth your while.
You get so tempted to throw in the towel because it feels like it’s all a waste of time.
But on the other hand, you also know that social media can be a GOLDMINE.
And you also know that if you just rely on word of mouth, you’ll get left behind.
You know others are having success with social media… you see those Injectors that get huge engagement, lots of bookings.
They’re posting content online and laughing all the way to the bank.
So why is it just not happening for you??
What are they doing that you’re not doing?
Do they know something you don’t?
The truth is… they DO know something you don’t.

And they ARE doing something you’re not.

Over the past few months I’ve had more and more Injectors telling me they’re in the same situation…
And if you’re stuck there too,
IT’S NOT YOUR FAULT!
Reach, views and engagement have dropped for everyone. It’s the algorithm’s fault.
But I know it’s not the answer you want to hear.
I’ve helped thousands of Injectors tap into the power of social media over the past XX years and I noticed something curious happening lately…
While a lot of Injectors are struggling to get consistent engagement and bookings from social media…
There’s another group of Injectors that are absolutely crushing it.
And I wanted to know why.
I wanted to figure out what that successful group of Injectors were doing that was helping them to get 6+ bookings per week from social media.

So I set out on a mission.
I surveyed over 870 Injectors and audited hundreds of social media accounts and a pattern started to emerge…
And I realised that the Injectors missing even ONE of these things, were struggling to get any results from social media.
So that’s when I put all my findings together to create a simple framework ANYONE could follow to get amazing results.
I call it… The Stairway To Bookings
Just imagine…
No more wasting time and energy wondering what to post or creating content for the sake of it. You know exactly what to share, and best of all, every post feels like a direct conversation with your ideal client – it never feels like wasted effort.

Confidently waving goodbye to your public health sector job knowing you’re on your way to building a wildly successful business. You open up your booked-out calendar every morning, all thanks to the magnetic pull of your social media presence.

No longer hoping for word-of-mouth referrals. Instead, you can rely on your social media to act as your unstoppable, 24/7 ambassador, bringing in clients even while you sleep.

Clients walking into your clinic fully trusting you and your expertise. They’ve seen your content and they’re already convinced they’re in the right hands. No hard selling, just genuine connections.

Having a reliable and proven strategy to grow a thriving clinic that gives you the financial freedom you dream of and deserve. You know how to get clients consistently and you can finally focus on your dreams, passions, and maybe even that dream holiday you’ve been putting off.

This is all possible when you follow a PROVEN system to turn social media into your own goldmine.
Introducing…

Dream Customer Attraction Method 2.0

Dream Customer Attraction Method (DCAM) 2.0 is an online marketing course designed specifically for Aesthetic Clinicians who are serious about growing their business. Updated for what’s working NOW in social media and based on evidence-backed strategies that TRULY WORK.
Everything you need to know from top to bottom and beginning to end is inside, so that you can:
Easily create social media posts that get ENGAGEMENT and CONSISTENT BOOKINGS, instead of wasting time creating content that gets ignored.

Set up a proven step-by-step system to convert scrollers into clients, so you can create financial freedom for your family.

Stop trying to attract patients with discounts, and instead, attract the RIGHT kind of patients by establishing trust and genuine connections. Get people to see you as the expert and as their trusted friend, so that they don’t want to book with anyone but YOU.

Do all this with a tribe of like-minded clinicians to cheer you on.

All delivered in a clear, easy to use way, and not just from some random marketing generalist. This course is 100% bespoke to aesthetics based on myself and Tim’s success in this industry…
Founders of a multi-million pound clinic

Trained 20k Practitioners in our training academy and online

Combined social media following of over 290,000

Here’s What’s Included:
Video Masterclasses

You’ll learn how to:
Set yourself apart and get attention from the right kind of followers.

Create content that makes people online gravitate towards you and want to book with YOU and no one else.

Create content that shows off your knowledge and expertise so that patients come to you already trusting you and ready for treatment.

Trigger people to actually book in, so that they’re not just seeing your content and scrolling on.

Plus 6 incredible bonuses:
The Purple Book

This is the marketing bible! This gorgeous book will be delivered to your home and includes all the course material from the video masterclasses in a book. And it’s got space for reflections in there so you can use it like a journal as well and it’s also a great accountability tool.
Content Cheat Cards

These cards are designed to make content creation feel FUN instead of feeling like a chore. There are 52 cards with step-by-step instructions and content ideas you can use. No more overthinking what to create – each content card gives you the hook, instructions about what to do, a call to action, and some fun tips to make your post even better.
30 Days Of Done-For-You Canva Templates

You don’t even have to think about what content to share – we’ve created one month’s worth of content that you can just plug and play easily with these beautiful templates. You can add your own touches to the templates using Canva and you’ve got an entire month of content ready to publish. And you get to reuse these forever.
Canva Mastery Course

Canva is an amazing and free online software you can use to easily create professional-looking content, even if you have absolutely no experience designing graphics. We’ve worked with a Canva expert and this course walks you through everything step by step, including editing the templates & designing your own content. You’re never going to need a graphic designer again after this.
Time-Saving Bible

I know that creating content can be really time-consuming, so this is a print-out you can refer to any time with 7 hacks that professionals use to save time when creating content. You’ll learn how to use ChatGPT to make creating content so much easier and faster, and some amazing apps you can use to save time.
Meet Miranda Pearce
​Expert Marketing Advisor for thousands of Aesthetic Clinicians

​Founded SkinViva Clinic in 2008 with husband Dr Tim Pearce (over 1,000 5 star reviews)

Successfully grew the business to over £3 million per year

​Took Dr Tim brand from 5,000 – 37,000 Instagram followers in 18 months

Co-hosts the UK’s number 1 aesthetics podcast

Founded ‘Medical Aesthetics Mindset Warriors’ Facebook Group with 4,500+ members

DCAM 2.0 Aesthetics Marketing & Social Media By Tim Pearce, What Is It Included (Content Proof: Watch Here!)