Stokrat
Модератор
Модератор
Stokrat
Модератор
Модератор
- Сообщения
- 11,900
- Реакции
- 1,539
Материал на английском языке
Former Top Strategy Consultant Reveals How to Master the #1 Skill Every Employer Wants, Almost Overnight
Чему вы научитесь
Требования
Описание
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:
Take The Best Seats In The House & Discover How To Succeed At The Modern Workplace With Excel:
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!
Для кого этот курс:
Материалы курса
Развернуть все 19 лекций01:39:03
–Getting Started
10:39
What You Will Learn - Excel Formatting Secrets by Top Consultants
Предварительный просмотр03:47
Why Your Work Has To Look Professional: The Secrets To Advance Your Career
Предварительный просмотр01:12
Data Made By The Average Joe Vs. Data Formatted The McKinsey Way - Part 1
Предварительный просмотр01:23
Charts made by the Average Joe vs. Charts Formatted The McKinsey Way - Part 2
Предварительный просмотр04:17
–The Foundation
08:05
What Is A Cell? - The Key Element Of Excel
00:45
What Is Data? - The Origin Of Awesome
04:06
What Is A Chart? - Your Means To Success
01:12
What Is Formatting? - The Secret Sauce To Make You Look Awesome
02:02
–McKinsey Cell And Data Formatting Secrets
35:51
Cell Formatting Secrets
04:52
Conditional Formatting Secrets
05:50
McKinsey Data Formatting Secrets
25:09
–McKinsey Chart Formatting Secrets
28:23
Chart Types
03:06
Chart Formatting And Design Essentials
16:03
McKinsey Chart Formatting Secrets
06:50
Congratulations & Conclusion
02:24
–Bonus Secrets
17:29
Never Loose Overview On Your Data - Freeze Panes Vs. Split Windows
03:01
How To Show Only Key Data - Hiding, Unhiding, Grouping
04:35
Let Others Only Fill In Data You Want - Drop Down Menus
05:25
Bonus Lecture: Get Any of Sandor's Course for Up to 95% OFF!
04:28
Скачать (ссылка со встроенным купоном)
Former Top Strategy Consultant Reveals How to Master the #1 Skill Every Employer Wants, Almost Overnight
Чему вы научитесь
- 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!
Требования
- Excel 2003, 2007, 2010, 2011, 2013, 2015 or 2016
- Following the step-by-step instructions of this training
Описание
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!
Для кого этот курс:
- Beginner & intermediate Excel users
- Skilled office workers who want to advance their career
Материалы курса
Развернуть все 19 лекций01:39:03
–Getting Started
10:39
What You Will Learn - Excel Formatting Secrets by Top Consultants
Предварительный просмотр03:47
Why Your Work Has To Look Professional: The Secrets To Advance Your Career
Предварительный просмотр01:12
Data Made By The Average Joe Vs. Data Formatted The McKinsey Way - Part 1
Предварительный просмотр01:23
Charts made by the Average Joe vs. Charts Formatted The McKinsey Way - Part 2
Предварительный просмотр04:17
–The Foundation
08:05
What Is A Cell? - The Key Element Of Excel
00:45
What Is Data? - The Origin Of Awesome
04:06
What Is A Chart? - Your Means To Success
01:12
What Is Formatting? - The Secret Sauce To Make You Look Awesome
02:02
–McKinsey Cell And Data Formatting Secrets
35:51
Cell Formatting Secrets
04:52
Conditional Formatting Secrets
05:50
McKinsey Data Formatting Secrets
25:09
–McKinsey Chart Formatting Secrets
28:23
Chart Types
03:06
Chart Formatting And Design Essentials
16:03
McKinsey Chart Formatting Secrets
06:50
Congratulations & Conclusion
02:24
–Bonus Secrets
17:29
Never Loose Overview On Your Data - Freeze Panes Vs. Split Windows
03:01
How To Show Only Key Data - Hiding, Unhiding, Grouping
04:35
Let Others Only Fill In Data You Want - Drop Down Menus
05:25
Bonus Lecture: Get Any of Sandor's Course for Up to 95% OFF!
04:28
Скачать (ссылка со встроенным купоном)
Для просмотра скрытого содержимого вы должны войти или зарегистрироваться.
