MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 84 lectures (7h 33m) | Size: 4.23 GB

Do you want to get better at Microsoft Excel, but you're overwhelmed by the amount of effort required and you don't know where to start from

Learn new functions and shortcuts, boost your productivity, gain confidence and become an advanced Microsoft Excel user

Start using Excel like a management consultant

Learn the most powerful tricks, shortcuts, and functions

See the best way to address your everyday Excel problems

Dramatically boost your speed and productivity

Laser-focused lessons on what you will really need, no wasted on functions you'll never use

Microsoft Excel 2007-2019 or Office 365, recommended for Windows operating system

Basic experience with Excel required for easier understanding of the course lessons (this is not an Excel 101 course)

Well, HERE is where you should start from!

I designed this course to give you a complete and yet essential overview of the key functions, formulas, and shortcuts you need to know to master Excel.

By the end of the course, you will be able to:

Customize the Quick Access Toolbar, a very powerful tool often neglected

Use your keyboard and not your mouse to speed up navigating within a sheet and through the sheets

Merge databases with VLOOKUP and INDEX/MATCH

Use dynamic array functions (Excel 365 only)

Create and format Pivot Tables and extract complex data from them, with functions like calculated fields

Manage sensitivities and scenarios (e.g., of a business plan) effectively

Add your own macros to your workbooks without the need to know VBA programming language

Properly print Excel sheets

Use complex text formulas, combining multiple functions

Manage links and hyperlinks

And use many more additional functions and keyboard shortcuts you may not know to boost your productivity

To achieve the above, we will use real-life examples of some of the tasks you could face in your daily job.

I've been working in a top-tier management consulting firm over 10 years. During these years, I've strived to become the fastest and most effective I could in Excel, taking courses and expenting. I've also witnessed the most common struggles and pitfalls with Excel you may suffer from, having worked with dozens of clients and having met hundreds of people. And I designed this course to help you solve them.

The good news is that it's going to be easier than what you expect. Yes, there are hundreds of functions and shortcuts in Excel. But the untold truth is that you'll really need to master only a small subset of those to dramatically boost your performances. And I distilled them for you in this course!

You can consider this course as your best investment. The spent learning is going to be just a tiny fraction of the amount of you'll be saving with your new skillset.

To support your learning, you'll have access to multiple additional resources:

A blank version of the files, to follow the lessons along with me, and the final version of the files, including all the steps done throughout the lessons

A cheat sheet containing the list of my preferred shortcuts

My personal Quick Access Toolbar configuration

A link to join our Facebook community for lifelong learning

Are you ready to revolutionize the way you work

Disclaimer: the content of the lessons was developed by myself specifically for this course, and it does not represent a transposition of any of the trainings created by my employer. Also, the views expressed on this course are mine alone and do not necessarily reflect the views of my employer.

People using Excel on their jobs willing to improve their productivity

Graduating students willing to join a consulting firm or any company with an Excel expertise that will impress their managers

Companies/employers looking for an effective course to improve their staff Excel skills

Anybody using Excel willing to expand their skill set






DOWNLOAD
uploadgig.com