Online Course free
Advanced Microsoft Excel

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

4.9

808 reviews on
31826 students already have enrolled
  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners

Skill level:

Advanced

Duration:

3 hours
  • Lessons (2 hours)
  • Practice exams (48 minutes)
  • Projects (3 hours)

CPE credits:

4
CPE stands for Continuing Professional Education and represents the mandatory credits a wide range of professionals must earn to maintain their licenses and stay current with regulations and best practices. One CPE credit typically equals 50 minutes of learning. For more details, visit NASBA's official website: www.nasbaregistry.org

Accredited:

certificate

What You Learn

  • Become a certified advanced Excel user.
  • Boost your efficiency with Excel best practices and hidden tips and tricks.
  • Write complex Excel functions with confidence.
  • Apply formats and modeling methods for professional use.
  • Understand the core principles of financial modeling.

Topics & tools

excelfinancial analysistheoryspreadsheetsdata analysis

Your instructor

Course OVERVIEW

Description

CPE Credits: 4 Field of Study: Specialized Knowledge
Delivery Method: QAS Self Study
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

Prerequisites

  • Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)
  • Completion of an introductory Excel course is recommended.

Advanced preparation

Curriculum

32 lessons 1 project 4 exams

Free preview

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

Start for free

9 in 10

of our graduates landed a new AI & data job

after enrollment

4.9

Based on 808 reviews

#1 most reviewed

AI and data learning platform on Trustpilot.

96%

of our students recommend

365 Data Science.

ACCREDITED certificates

Craft a resume and LinkedIn profile you’re proud of—featuring certificates recognized by leading global institutions.

Earn CPE-accredited credentials that showcase your dedication, growth, and essential skills—the qualities employers value most.

  • Institute of Analytics
  • The Association of Data Scientists
  • E-Learning Quality Network
  • European Agency for Higher Education and Accreditation
  • Global Association of Online Trainers and Examiners
A LinkedIn profile mockup on a mobile screen showing Parker Maxwell, a Certified Data Analyst, with credentials from 365 Data Science listed under Licenses & Certification. A 365 Data Science Certificate of Achievement awarded to Parker Maxwell for completing the Data Analyst career track, featuring accreditation badges and a gold “Verified Certificate” seal.

How it WORKS

  • Lessons
  • Exercises
  • Projects
  • Practice Exams
  • AI Mock Interviews

Lessons

Learn through short, simple lessons—no prior experience in AI or data science needed.

Try for free

Exercises

Reinforce your learning with mini recaps, hands-on coding, flashcards, fill-in-the-blank activities, and other engaging exercises.

Try for free

Projects

Tackle real-world AI and data science projects—just like those faced by industry professionals every day.

Try for free

Practice Exams

Track your progress and solidify your knowledge with regular practice exams.

Try for free

AI Mock Interviews

Prep for interviews with real-world tasks, popular questions, and real-time feedback.

Try for free

Student REVIEWS

A collage of student testimonials from 365 Data Science learners, featuring profile photos, names, job titles, and quotes or video play icons, showcasing diverse backgrounds and successful career transitions into AI and data science roles.