Advanced Microsoft Excel

with Ned Krastev and Martin Ganchev
4.8/5
(1,894)

Таке your Excel skills to the next level with the Advanced Excel Course. Become a proficient Excel user

3 hours of content 28111 students
Start for free

What you get:

  • 3 hours of content
  • 56 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

Advanced Microsoft Excel

Start for free

What you get:

  • 3 hours of content
  • 56 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement
Start for free

What you get:

  • 3 hours of content
  • 56 Downloadable resources
  • World-class instructor
  • Closed captions
  • Q&A support
  • Future course updates
  • Course exam
  • Certificate of achievement

What You Learn

  • Become a certified advanced Excel user
  • Work much quicker in Excel
  • Write advanced Excel functions with ease
  • Learn hidden Excel tips and tricks that will prove invaluable
  • Format your work professionally
  • Understand the core principals of financial modeling

Top Choice of Leading Companies Worldwide

Industry leaders and professionals globally rely on this top-rated course to enhance their skills.

Course Description

Do you want to become an advanced Excel user? Are you passionate about learning skills that can boost your career? If the answer is yes, our Advanced Excel course is the perfect opportunity for you. Invest several hours of your time to boost your Excel efficiency. Most individuals need several years to become truly proficient in Excel. This course is the fast track to achieving Excel mastery, allowing you to become a power user starting tomorrow. In no time, you will learn how to write advanced Excel functions, how to format your work professionally, and how to work much faster than average users. If there's one technical skill that junior analysts should master from the start, it's Excel. You have a chance to invest in your future with a skill that will pay off many times over. When you are proficient in Excel this gives you more time to think (because you are faster), less stress (because you know how to do things), and better career opportunities (because your skills are in high demand and everyone would want to work with you). This Advanced Microsoft Excel course is suitable for graduates and young professionals who already know how to work with Excel (perhaps you have taken our Intro to Excel course). The training is also highly recommended for analysts who have been on the job for a few years but still need to improve their skills and adopt best practices. We expect that you know Excel fundamentals (because these are not covered inside) and will go from there. The ambitious goal that we will achieve is to elevate your Excel skills to an expert level. There are hundreds of Excel courses on the Internet, but few are taught by an instructor who has shared his knowledge with millions of students and has created some of the best-known Excel trainings online. Ned Krastev is a seasoned industry veteran who will give you the Advanced Excel training you have been looking for. His structured approach would allow you to acquire complex skills easily. The course entails several case studies that allow you to apply in practice the formulas and tricks you have learned in the lessons. Ned has gained his work experience in reputed firms like Pwc, Coca-Cola, Infineon Technologies, and many others. You can be confident that he is the right person to teach you real-world Excel skills. Join us on a journey that will teach you how to work very fast in Excel via shortcuts, Quick access toolbar navigation, and fast cell selection. Learn how to work with advanced Excel functions such as INDEX, MATCH, SUMIFS, INDIRECT, OFFSET, and many more. Acquire the skills to format your work professionally and build scalable data analysis models. How is this advanced Excel course different than the rest? 1. Content quality Every step of your advanced Excel training journey has been carefully prepared and thought many times over. The instructor will teach you real-world skills that power users at top firms around the world have. It is very rare to find an advanced Excel course created by an individual with significant practical experience in the corporate world 2. One of the most popular Excel courses online This Excel training has proven itself as a bestseller and student favourite. The reason is that the byte-sized lessons are dynamic, easy to understand, and concise, ensuring that learners can quickly grasp concepts without feeling overwhelmed. Additionally, the practical case studies solved alongside the instructor provide a hands-on learning experience, which reinforces the material and makes the learning process more effective and engaging 3. Downloadable materials The course gives you access to Excel templates that you can download and use as a reference at any moment in the future. Moreover, you will be able to download course notes and use other useful materials such as Excel flashcards 4. Certificate of achievement If you compete the Advanced Excel course and pass successfully its course exam, you will be awarded a verifiable certificate of achievement, which is a testament to your dedication and hard work Click the ‘Buy now’ button and start this amazing learning journey today! Make an investment now that could change your entire career

Learn for Free

Welcome to the Course

1.1 Welcome to the Course

1 min

Why Excel and Why Modeling

1.2 Why Excel and Why Modeling

2 min

Let's Start from Scratch and Create a P&L Sheet

2.1 Let's Start from Scratch and Create a P&L Sheet

7 min

Cell Styles Allow You to Be Faster

2.2 Cell Styles Allow You to Be Faster

7 min

Pasting Values, Formulas, and Formats with Paste Special

2.3 Pasting Values, Formulas, and Formats with Paste Special

3 min

Formatting Cells Part I - Working with Data in Excel

2.4 Formatting Cells Part I - Working with Data in Excel

5 min

Curriculum

  • 1. Welcome to Advanced Excel
    2 Lessons 3 Min

    In these short introductory lectures, we will discuss why you need to master Excel, and which are the key skills you will acquire by taking the course.

    Welcome to the Course
    1 min
    Why Excel and Why Modeling
    2 min
  • 2. Proficient Excel Formatting
    7 Lessons 35 Min

    Professional formatting is one of the most important elements of data analysis, financial modeling and working in Excel in general. In these lessons, you’ll learn how to format spreadsheets in several different ways. And, more importantly, after these lessons, your work will look great!

    Let's Start from Scratch and Create a P&L Sheet
    7 min
    Cell Styles Allow You to Be Faster
    7 min
    Pasting Values, Formulas, and Formats with Paste Special
    3 min
    Formatting Cells Part I - Working with Data in Excel
    5 min
    Formatting Cells Part II - Customize Numbers the Way You Like
    5 min
    Highlight Key Data with Excel Conditional Formatting
    6 min
    Filter by Color
    2 min
  • 3. How to Be 3.0x Faster than Average Users
    5 Lessons 20 Min

    It is time to focus on Excel navigation: how to be fast when selecting cells, rows, columns, and how to work with shortcuts. We will study a number of different techniques that will allow you to be super efficient in Excel

    Use Multiple Screens Simultaneously
    4 min
    F1 to F12 - Using Excel's Function Keys
    6 min
    How to Select Visible Cells Only
    3 min
    Grouping Excel Rows and Columns - The Correct Way to Do It!
    5 min
    Working on Multiple Sheets at the Same Time
    2 min
  • 4. Excel Mechanics
    5 Lessons 20 Min

    Here, we will introduce some indispensable tools, such as find and replace, circular references, and trace precedents. Not only that, but we will also study their practical application.

    Find & Replace - Our Favourite Excel Tool
    4 min
    A Great Way to Apply Find & Replace
    4 min
    What Are Circular References in Excel
    5 min
    Circular References - An Example
    2 min
    Trace Precedents - Display the Relationship Between Formulas and Cells
    5 min
  • 5. Not So Simple Excel Functions
    9 Lessons 45 Min

    Very often the difference between intermediate and advanced Excel users is the number of functions in their arsenal. In this part of the course, we will work with advanced functions that will help you boost your productivity significantly.

    What is a Nested Function?
    3 min
    Advanced Excel Functions Index; Match; Index & Match
    7 min
    Advanced Excel Functions Index, Match, Match
    5 min
    Advanced Excel Functions Indirect; Vlookup & Indirect
    6 min
    Advanced Excel Functions Rows; Columns; Vlookup & Columns
    5 min
    Advanced Excel Functions Vlookup & Match
    3 min
    Advanced Excel Functions Choose; Vlookup & Choose
    3 min
    Advanced Excel Functions Offset; Offset & Match
    7 min
    Date Functions
    6 min
  • 6. Excel Tips & Tricks
    4 Lessons 24 Min

    The tips we will show you in this section of the course will untie your hands in a number of situations. You will become a faster, more prepared, and fully equipped Excel user.

    Excel Tips & Tricks Part 1
    6 min
    Excel Tips & Tricks Part 2
    6 min
    Excel Tips & Tricks Part 3
    6 min
    Excel Tips & Tricks Part 4
    6 min

Topics

Excelfinancial analysisTheory

Tools & Technologies

excel
theory

Course Requirements

  • Highly recommended to take the Intro to Excel course first
  • You will need Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365

Who Should Take This Course?

Level of difficulty: Advanced

  • Intermediate and advanced Excel users
  • Aspiring analysts and analysts who want to become power Excel users
  • Graduate students who want to learn how to work with Excel professionally

Exams and Certification

A 365 Data Science Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Exams and certification

Meet Your Instructor

Ned Krastev

Ned Krastev

CEO at

23 Courses

32181 Reviews

379374 Students

Nedko earned a Master’s degree in Finance from Bocconi University (Milan, Italy) in 2012. Then, he gained valuable working experience with exciting firms like PwC Italy (Financial Advisory and M&A), Coca-Cola European Partners (Financial Analyst), and Infineon Technologies (M&A). In 2014, he published his first online course on financial modeling and valuation when he realized that creating educational materials is his true calling. The amazing students and content creators in the data science community, the 365 team, and the strong desire to build the perfect learning platform drive Nedko to continue on this exciting journey. His goal is to establish 365 Data Science as the learning platform that bridges the gap between theoretical knowledge and practical business application.

What Our Learners Say

18.11.2024
18.11.2024
5
18.11.2024
Good course

365 Data Science Is Featured at

Our top-rated courses are trusted by business worldwide.