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,

1. we have too much data
2. too many buzz words (big data, data science, business intelligence, predictive analytics etc.) but no instruction on how to do
3. everyone (customers, bosses, regulatory authorities etc.) expect us rely on data to take actions
4. 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!)

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.