Advanced Microsoft Excel
2
Lessons32
Quizzes0
Assignments24
Course description
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.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!
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.
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.
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.