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.








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.


Welcome to Advanced Excel

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.


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 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.