Advanced Microsoft Excel
This course will teach you in-demand Excel techniques that will allow you to do more sophisticated data manipulation in Excel. You will learn how to build nested functions, how to use new keyboard shortcuts to be even faster in Excel, and how to format sheets and charts professionally. We will also show you several hidden Excel tips and tricks that you usually don't find in textbooks.
2 hours 
18 exercises 
3 assignments 
58 downloadables
Sign up to
preview the program
for FREE!
Create a free account and start learning data science today.
create free account
Our graduates work at exciting places:
Section 1
Proficient Excel formatting
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!
Why Excel and why modeling
Let's start from scratch and create a P&L sheet
Cell styles allows you to be faster
Pasting values, formulas, and formats with Paste Special
Formatting Cells Part I - Working with data in Excel
Formatting Cells Part II - Customize numbers the way you like
Highlight key data with Excel Conditional Formatting
Filter by color
Section 2
How to be 3.0x faster than average users
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
F1 to F12 - Using Excel's function keys
How to select visible cells only
Grouping Excel rows and columns - The correct way to do it!
Working on multiple sheets at the same time
Section 3
Excel mechanics
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
A great way to apply Find & Replace
What Are Circular References in Excel
Circular References - An example
Trace precedents - Display the relationship between formulas and cells
Section 4
Not so simple Excel functions
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
Advanced Excel functions Index; Match; Index & Match
Advanced Excel functions Index, Match, Match
Advanced Excel functions Indirect; Vlookup & Indirect
Advanced Excel functions Rows; Columns; Vlookup & Columns
Advanced Excel functions Vlookup & Match
Advanced Excel functions Choose; Vlookup & Choose
Advanced Excel functions Offset; Offset & Match
Date functions
Section 5
Excel tips & tricks
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
Excel tips & tricks Part 2
Excel tips & tricks Part 3
Excel tips & tricks Part 4
Data Science Fundamentals
This course is part of Module 1 of the 365 Data Science Program. The complete training consists of four modules, each building upon your knowledge from the previous one. Whereas the other three modules are designed to improve upon your technical skill set, Module 1 is designed to help you create a strong foundation for your data science career. You will understand the core principles of probability, statistics, and mathematics; you will also learn how to visualize your data.
See All Modules
Why Choose the 365 Data Science Program?
Practice
Real-life project and data. Solve them on your own computer as you would in the office.
Q&A Hub
Our expert instructors are happy to help. Post a question and get a personal answer by one of our instructors.
Certificates
Earn a verifiable certificate after each completed course. Celebrate your successes and share your progress with your professional network!
Trust the other 500,000 students
The course is in-depth and is delivered at a steady pace with eye catching visuals. The instructors go through all the basics really well. They try not to over-simplify the material, you get a good sense аof how deep Data Science is in the course. Great job!!!
This course is amazing! After watching the video carefully and doing all the exercises, I am even capable of having discussions with Machine learning major Master’s students! High standard course with reasonable pricing.
Very clear and in-depth explanation of data science and how all the inter-related concepts apply in real life business environment. Absolutely great for beginners! Best data science course I have come across so far!
I would highly recommend the course to any beginner who wants to venture into the world of Data Science. The concepts are very well explained and there is an emphasis on practical application which really helps create a better understanding of the concepts.
Ready to start?
Sign up today for FREE!
