How To Dominate Excel Formatting & Charting

Former Top Strategy Consultant Reveals How to Master the #1 Skill Every Employer Wants, Almost Overnight
3.1 (34 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
7,540 students enrolled
$19
$150
87% off
Take This Course
  • Lectures 18
  • Length 1.5 hours
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

Excel is a key skill for virtually every office employee today, but because the software provides what seems like an infinite number of functions, it can become confusing.

If you struggle with Excel, know that you're not alone. Even though Excel is designed to make your life easier, 82% of users report that Excel causes them stress.

This course is for you if you:

  • Struggle to find online tutorials that make using Excel formulas easy
  • Make mistakes in Excel and feel disappointed with the results
  • Become angry and frustrated because Excel actually reduces your productivity


Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:

  • Work in Excel in a simple yet professional way
  • Create Excel spreadsheets that are clear and uncluttered
  • Make elaborate charts that even average workers will understand


Content & Overview

First, we’ll cover the foundations of Excel formatting and charting. You’ll discover the basics of cells, data and charting, which includes a comprehensive tutorial on how to build charts.

Next comes how to format cells and data the McKinsey way. I’ll explain 8 Excel cell formats with practical examples and how to effectively navigate large data sheets. Plus, you’ll learn how to never lose overview by using five uncommon shortcut functions.

Moreover, I’ll show you step-by-step how to build a chart the McKinsey way and combine stacked column charts with normal column charts to enable advanced data labeling techniques.

Last but not least, I included three bonus tutorials covering freeze panes vs. split windows, techniques to show key data only and drop down menus.

By the time you complete this class, you’ll learn the renowned McKinsey way of formatting charts and tables, from basic to advanced.

This training is 100% job-focused and contains only practical knowledge of Excel to format data and charts. In contrast to books and 36-hour Excel courses, you won't waste your time with 500 irrelevant Excel features that you'll never use. Instead, you can put these new skills to use right away!

What are the requirements?

  • Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
  • Following the step-by-step instructions of this training

What am I going to get from this course?

  • How to dominate Excel formatting & charting in less than 4 days
  • No theory, but 100% job-focused knowledge of Excel with lots of practical examples & shortcuts!
  • How to analyze and understand data, without the need for a complex mathematical background
  • Visualize data in a clear & appealing data, and gain a competitive advantage!
  • Shortcut Excel strategies that are uncommon in the everyday workplace yet incredibly useful and powerful!
  • Stand out from the crowd: Produce professional work like a McKinsey consultant
  • Excel strategies you won’t find in any book
  • Become comfortable with day-to-day operations, and dominate common Excel hurdles instantly
  • Become dramatically more productive and simplify your daily workflow by learning simple shortcuts to tackle virtually every formatting problem
  • … and much more!

What is the target audience?

  • Beginner & intermediate Excel users
  • Skilled office workers who want to advance their career

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Getting Started
03:47

Welcome to our brand new course! I really appreciate your presence! In this training, you’ll learn Excel formatting secrets by top consultants in three easy steps!

01:12

In this short lesson, I’ll provide insights to advance your career with Excel. Are you ready? Let’s go!

01:23

In this lesson, you’ll discover what good data is and how it compares to average data. By understanding this, you will immediately improve the quality of your work.

04:17

Learn what good charts are and how they compare to average charts. By understanding this, you will immediately improve the quality of your work.

Section 2: The Foundation
00:45

In this lesson, you’ll discover what a cell is, what to do with it and how a cell builds up an Excel spreadsheet!

04:06

Did you know that there are 3 types of data? Here’s how you can use these types in Excel!

01:12

Excel provides a wide range of possibilities to create charts. Let me show you chart essentials on how to build a chart with just a very few clicks.

02:02

Do you know what formatting is, including Excel number and date formats? In this lesson, you’ll learn it!

Section 3: McKinsey Cell And Data Formatting Secrets
04:52

Are you ready for McKinsey cell and data formatting secrets? In this lesson, you’ll learn 8 Excel cell formats explained with practical examples to make your data easily understandable.

05:50

Are you ready to learn conditional formatting secrets? Here’s how to do it including data bars, color scales, icon sets (directional, shapes, indicators, ratings), and a tutorial to create custom rules by using the conditional formatting rules manager.

25:09

I’d like to show you McKinsey Data Formatting hacks that will help you converting your average data to superstar data in a comprehensive 20 step-by-step guideline and files to format a table the McKinsey way.

Section 4: McKinsey Chart Formatting Secrets
03:06

In this lesson. you’ll discover McKinsey’s most used chart types and learn how to build them.

16:03

Are you ready to dramatically improve Excels standard charts? Here’s how to do it in a comprehensive step-by-step guideline and files to build a dynamic chart the McKinsey way: with secondary axis, invisible point label diagrams.

06:50

Before I say goodbye, I’d like to show you McKinsey Chart Formatting Secrets that will help you to build amazing charts that almost no one else can build, combining stacked column chart with normal column charts to enable McKinsey data labelling techniques.

02:24

Congratulations, you made it until the end of this training! Now it’s important that you don’t sit on what you just learned. Take action today!

Section 5: Bonus Secrets
03:01

In this course, we didn’t cover how to work with freeze panes and split windows. However, I included a step-by-step practice tutorial on how to freeze panes and split windows vertically and horizontally.

04:35

Before I say goodbye, I’d like to show you my best practice tutorial on hiding, unhiding, grouping data.

05:25

Congratulations, you made it until the end of this training! As a final lesson, I want to share my best practice tutorial on how to work with data validations, a.k.a. drop down menus. Now it’s important that you don’t sit on what you just learned. Take action today!

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sandor Kiss, Teaching 99,000+ Students, Performance Marketer

Hi, I'm Sandor!

I am passionate entrepreneur and performance marketer with ten thousands happy students.

Let me tell you my story...

At the age of 16, I founded my first online business. After being a full-time CPA marketer for more than 5 years, I decided to shift gears and use my skills to build companies.

Ever since, I have been lucky enough to do what I love the most: entrepreneurship, travelling the world, pushing my comfort zone and discovering things that I couldn't learn in the classroom.

One year ago, I decided to take the next step and share my knowledge with those who are ready to start their own business. This decision brought me to Udemy, where I am able to combine my biggest talents: entrepreneurship, marketing and teaching.

My teaching philosophy on Udemy is simple: I am crafting trainings that I wish I had available to me when I started my first company.

My courses serve a very important goal: helping you to transform your life and becoming a successful entrepreneur and marketer.

I've seen the impact a solid business can have on someone's life. That's why I can only encourage you not to miss out on this opportunity.

As of today, I've sold more than 250,000 trainings, established multiple successful online businesses and coached hundreds of students.

So, that's my story. But now, I just want to ask you a simple question.

Do you want some help?

Do you want to establish your own business, become an entrepreneur or simply generate more revenue from your current business?

Great, because I am sure I am going to be able to help you. Feel free to check out my course portfolio and let's see if we can work together.

Best Regards,

Sandor Kiss

Instructor Biography

Matthias Bellmann, Start-up generalist and former consultant

Hi, I’m Matthias!

I am an entrepreneur, former top strategy consultant, Excel nerd, and web developer.

Let me tell you my story:

After graduating from university in Germany and Sweden, I worked for Roland Berger Strategy Consultants, a leading German Strategy Consultancy. Following my experience with Roland Berger, I worked for Volkswagen Consulting, where I was mentored by a McKinsey partner and delivered Excel trainings to hundreds of employees company-wide, ultimately becoming known as “Mr. Excel.”

Over the last eight years, I have gained valuable experience in founding and scaling Internet businesses in Europe. Today, I consult startups and corporations to help them achieve operational excellence through the use of effective, data-driven, and comprehensible communications – starting with simple and easy to access tools such as Excel.

My Excel specialties include the creation of comprehensible reports and presentations, all built the McKinsey way. Having founded three Internet companies in the last few years, I have raised several million in funds from investors with my Excel models.

Another passion of mine is Coding. When I first started to learn about web development, I built ten websites over the course of a few weeks. I discovered that most people could realize their ideas and dreams easily if they would be just a little bit more confident and walk the first steps in web development. I also realized the second hardest part of learning web development is having the motivation to stick with it.

From this experience sprang the idea of teaching others how to achieve their dreams through building actual websites from from day 1 while learning the basics of web development at the same time. All the course requires is a commitment of three weeks and not more than 30 minutes of your time a day. By the end of the course, you’ll be building your dream website yourself without any of my help.

Ready to start learning?
Take This Course