How To Dominate Excel Formatting & Charting

Name: How To Dominate Excel Formatting & Charting
Rating: 3.5 (160 reviews)

Former Top Strategy Consultant Reveals How to Master the #1 Skill Every Employer Wants, Almost Overnight

Created bySandor Kiss, Matthias Bellmann

Last updated 10/2018

English

What you'll learn

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!

Course content

5 sections • 19 lectures • 1h 39m total length

What You Will Learn - Excel Formatting Secrets by Top Consultants3: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!
Why Your Work Has To Look Professional: The Secrets To Advance Your Career1:12
In this short lesson, I’ll provide insights to advance your career with Excel. Are you ready? Let’s go!
Data Made By The Average Joe Vs. Data Formatted The McKinsey Way - Part 11: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.
Charts made by the Average Joe vs. Charts Formatted The McKinsey Way - Part 24: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.

What Is A Cell? - The Key Element Of Excel0: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!
What Is Data? - The Origin Of Awesome4:06
Did you know that there are 3 types of data? Here’s how you can use these types in Excel!
What Is A Chart? - Your Means To Success1: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.
What Is Formatting? - The Secret Sauce To Make You Look Awesome2:02
Do you know what formatting is, including Excel number and date formats? In this lesson, you’ll learn it!

Cell Formatting Secrets4: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.
Conditional Formatting Secrets5: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.
McKinsey Data Formatting Secrets25: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.

Chart Types3:06
In this lesson. you’ll discover McKinsey’s most used chart types and learn how to build them.
Chart Formatting And Design Essentials16: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.
McKinsey Chart Formatting Secrets6: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.
Congratulations & Conclusion2: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!

Never Loose Overview On Your Data - Freeze Panes Vs. Split Windows3: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.
How To Show Only Key Data - Hiding, Unhiding, Grouping4:35
Before I say goodbye, I’d like to show you my best practice tutorial on hiding, unhiding, grouping data.
Let Others Only Fill In Data You Want - Drop Down Menus5: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!
Bonus Lecture: Get Any of Sandor's Course for Up to 95% OFF!3:03
This lecture contains some amazing discounts to all my other courses.

Requirements

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

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!

Who this course is for:

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

How To Dominate Excel Formatting & Charting

What you'll learn

Explore related topics

Course content

Getting Started4 lectures • 11min

The Foundation4 lectures • 8min

McKinsey Cell And Data Formatting Secrets3 lectures • 36min

McKinsey Chart Formatting Secrets4 lectures • 28min

Bonus Secrets4 lectures • 16min

Requirements

Description

Who this course is for: