Advanced Microsoft Excel

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.

With Martin Ganchev and Ned Krastev

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.

32 High Quality Lessons

3 Practical Tasks

2 Hours of Video

Certificate of Achievement

Skills you will gain

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

Welcome to Advanced Excel Free

2 Lesson 3 Min

Welcome to the Course Free Why Excel and Why Modeling Free
Proficient Excel Formatting Free

7 Lesson 35 Min

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

5 Lesson 20 Min

Use Multiple Screens Simultaneously Free F1 to F12 - Using Excel's Function Keys Free How to Select Visible Cells Only Free Grouping Excel Rows and Columns - The Correct Way to Do It! Free Working on Multiple Sheets at the Same Time Free
Excel Mechanics Free

5 Lesson 20 Min

Find & Replace - Our Favourite Excel Tool Free A Great Way to Apply Find & Replace Free What Are Circular References in Excel Free Circular References - An Example Free Trace Precedents - Display the Relationship Between Formulas and Cells Free
Not So Simple Excel Functions Free

9 Lesson 45 Min

What is a Nested Function? Free Advanced Excel Functions Index; Match; Index & Match Free Advanced Excel Functions Index, Match, Match Free Advanced Excel Functions Indirect; Vlookup & Indirect Free Advanced Excel Functions Rows; Columns; Vlookup & Columns Free Advanced Excel Functions Vlookup & Match Free Advanced Excel Functions Choose; Vlookup & Choose Free Advanced Excel Functions Offset; Offset & Match Free Date Functions Free
Excel Tips & Tricks Free

4 Lesson 24 Min

Excel Tips & Tricks Part 1 Free Excel Tips & Tricks Part 2 Free Excel Tips & Tricks Part 3 Free Excel Tips & Tricks Part 4 Free

“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

Courses You May Like

40 lessons 2 hours

Introduction to Tableau

With Ned Krastev

44 lessons 2 hours

Introduction to Data and Data Science

With Iliya Valchanov, Martin Ganchev

18 lessons 1 hours

Data Analysis with Excel Pivot Tables

With Ned Krastev

44 lessons 3 hours

With Iliya Valchanov

13 lessons 1 hours

With Iliya Valchanov

83 lessons 4 hours

Introduction to Excel

With Ned Krastev

47 lessons 4 hours

With Viktor Mehandzhiyski

52 lessons 4 hours

Starting a Career in Data Science: Project Portfolio, Resume, and Interview Process

76 lessons 8 hours

With Dimitar Shutev

81 lessons 5 hours

With Bernard Marr

23 lessons 2 hours

SQL for Data Science Interviews

With Tina Huang

58 lessons 4 hours

With Olivier Maugain

Advanced Microsoft Excel

With Martin Ganchev and Ned Krastev

Start Course For Free