Advanced Microsoft Excel

with Ned Krastev and Martin Ganchev
4.8/5
(1350)

Teaching you how to set up pivot tables and analyze data with filters and calculated fields, as well as advanced Excel tools like function keys, multiple sheets, and circular references.

3 hours 32 lessons
Start course
32 High Quality Lessons
3 Practical Tasks
3 Hours of Content
Certificate of Achievement

Course Overview

This course will teach you in-demand Excel techniques for more sophisticated data manipulation in Excel. Some of these include building nested functions, using new Excel keyboard shortcuts for more efficiency, formatting sheets and charts professionally, and more. You will also learn several hidden Excel tips and tricks that you usually don’t find in textbooks.

Topics covered

Excelfinancial analysisTheory

What You'll Learn

The Advanced Microsoft Excel course will provide you with the necessary skills to implement more sophisticated data manipulation. With our help, you will:

Apply professional formatting in Excel 
Become fast and efficient 
Work with advanced functions  
Master Excel tips and tricks 

Curriculum

Student feedback

4.8/5

1350 ratings
5 stars
1121 (83%)
4 stars
176 (13%)
3 stars
42 (3%)
2 stars
6 (0%)
1 star
5 (0%)
Filter by rating
  • 5 stars
  • 4 stars
  • 3 stars
  • 2 stars
  • 1 stars
Sort
  • Newest
  • Oldest
27.11.2023
Coming from the completion of the "introduction to excel" course, the content seem really digestible. I really like how the preveiously cemented skills are getting developed. straightforward application with implementation of previously laid skills as a starting point. The delivery is really good as always, great choice of words and timing, impossible to get lost in Ned's words.
29.12.2022
As a advanced Google Sheet user I learn a lot from this lesson, but I know Excel capable of a lot more. Advanced Excel course should covers (power) queries and many complex functions combo like nested iferror + ifs +if, or sort + unique, and how to import from other sheets
24.03.2023
I think, If the instructor focus more in the formulas dealing with data, not to reference data, it would be better. but to be honest still the best course contents, cover the most important functions of the Excel
13.09.2022
Need some examples of sales or Marketing data, I am not in finance and I found some challenges to understand some examples in the videos. Other than this point it is a fantastic structured course
07.07.2022
The course doesn't take into consideration of mac users. Would be nice to mention shortcuts for mac excel or mention that Alt shortcut functions aren't available for mac users.
  • 1
  • 2
  • 3
  • ...
  • 17
  • ...
  • 33
Ned Krastev

“The depth and breadth of Excel topics we’ve selected for this course is challenging and rewarding, providing a 360-degree approach to data modeling in Excel. Our strong focus on real-world examples ensures a super hands-on Excel experience. ”

Ned Krastev

CEO at 365 Data Science

Advanced Microsoft Excel

with Ned Krastev and Martin Ganchev

Start Course