Advanced Microsoft Excel
free
Таке your Excel skills to the next level with the Advanced Excel Course. Become a proficient Excel user
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
free
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.
- 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.
Top Choice of Leading Companies Worldwide
Industry leaders and professionals globally rely on this top-rated course to enhance their skills.
Course Description
Learn for Free

1.1 Welcome to the Course
1 min

1.2 Why Excel and Why Modeling
2 min

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

2.2 Cell Styles Allow You to Be Faster
7 min

2.3 Pasting Values, Formulas, and Formats with Paste Special
3 min

2.4 Formatting Cells Part I - Working with Data in Excel
5 min
Curriculum
- 2. Proficient Excel Formatting7 Lessons 35 MinProfessional 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 Sheet7 minCell Styles Allow You to Be Faster7 minPasting Values, Formulas, and Formats with Paste Special3 minFormatting Cells Part I - Working with Data in Excel5 minFormatting Cells Part II - Customize Numbers the Way You Like5 minHighlight Key Data with Excel Conditional Formatting6 minFilter by Color2 min
- 3. How to Be 3.0x Faster than Average Users5 Lessons 20 MinIt 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 ExcelUse Multiple Screens Simultaneously4 minF1 to F12 - Using Excel's Function Keys6 minHow to Select Visible Cells Only3 minGrouping Excel Rows and Columns - The Correct Way to Do It!5 minWorking on Multiple Sheets at the Same Time2 min
- 4. Excel Mechanics5 Lessons 20 MinHere, 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 Tool4 minA Great Way to Apply Find & Replace4 minWhat Are Circular References in Excel5 minCircular References - An Example2 minTrace Precedents - Display the Relationship Between Formulas and Cells5 min
- 5. Not So Simple Excel Functions9 Lessons 45 MinVery 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 minAdvanced Excel Functions Index; Match; Index & Match7 minAdvanced Excel Functions Index, Match, Match5 minAdvanced Excel Functions Indirect; Vlookup & Indirect6 minAdvanced Excel Functions Rows; Columns; Vlookup & Columns5 minAdvanced Excel Functions Vlookup & Match3 minAdvanced Excel Functions Choose; Vlookup & Choose3 minAdvanced Excel Functions Offset; Offset & Match7 minDate Functions6 min
- 6. Excel Tips & Tricks4 Lessons 24 MinThe 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 16 minExcel Tips & Tricks Part 26 minExcel Tips & Tricks Part 36 minExcel Tips & Tricks Part 46 min
Topics
Course Requirements
- Microsoft Excel (any recent version, such as Excel 2019, 2021, or Microsoft 365)
- Completion of an introductory Excel course is recommended.
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 Financial Analyst Course Certificate is an excellent addition to your LinkedIn profile—demonstrating your expertise and willingness to go the extra mile to accomplish your goals.

Meet Your Instructor
Ned Krastev is an entrepreneur and educator who has helped over 1.6 million students worldwide gain business, finance, and data skills. After earning his Master's degree in Finance from Bocconi University in Milan, he built a career with leading companies including PwC Italy, Coca-Cola European Partners, and Infineon Technologies. In 2014, Ned published his first online course on financial modeling and valuation, sparking his passion for online education. Today, as Founder & CEO of 365 Careers and Co-founder of 365 Data Science, he leads one of the most successful global providers of professional training, aiming to bridge the gap between academic theory and real-world business application.
What Our Learners Say
365 Financial Analyst Is Featured at
Our top-rated courses are trusted by business worldwide.
