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.
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.
The Advanced Microsoft Excel course will provide you with the necessary skills to implement more sophisticated data manipulation. With our help, you will:
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.
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!
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.
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.
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.
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.
Student feedback
“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. ”
CEO at 365 Data Science
Advanced Microsoft Excel
with Ned Krastev and Martin Ganchev
