Sorting and filtering come next, which lets you manipulate how to view your data. Charts make it easy to see trends and anomalies in your data that you might otherwise miss by just looking at your data.Įxplore your data with sorting, filtering, and pivot tables We then launch into how to visualize your data using charts and conditional formatting. You’ll understand how functions work and how to make sense of other functions not covered in this course, as there are over 500 functions in Excel.

Here too we cover the basics, like how to use the status bar for simple metrics, how to enter a formula by referencing cells, and how to reference cells relatively, absolutely, or with naming.įrom there, we move on to some of the most used Excel functions, like SUM, MAX, MIN, COUNT, AVERAGE, VLOOKUP, and XLOOKUP. Once we save our workbook, you’ll learn all about formulas and functions to help you answer those critical business questions.

We then save the workbook in a way that lets us collaborate with others in real time and gives us access to something called version history so you can easily jump back to earlier versions. Next, we delve into how you can enter data efficiently and format it so that it looks good. To demystify Excel, we begin by walking through the interface and covering how you can easily get back to the controls that you use most often. It may even feel like the cockpit of a jet plane. When you first open Excel, it may appear somewhat intimidating with so many different buttons and controls. This way, you’ll have a strong foundation to start getting insights from your data. digging into every single feature available. Having worked at Microsoft and on Excel, we focus on the core functionality that most people use to make you productive as quickly as possible vs. You’ll learn the essentials of Excel in just 2 hours.

Udemy excel