Excel from Beginner to Pro

You'll learn the different types of cell referencing in this section. You'll also learn why it is important to reference cells and the tools you need to lock cells.

This is one of the most interesting parts of Excel. Whether you are a student or a professional, understanding how to use Excel formulas help you work smarter on your assigned tasks.

You will learn the various formulas available in Excel software in this section.

You'll learn how to use conditional formatting to analyze data in Excel in this video. At the end of this video, you'll be able to look at a set of data and format accordingly using the conditional formatting tool

Students will learn how to using conditional formatting with formulas in this video. Its a great way to work smarter in this digitalized world.

With conditional formatting with color scales, you'll have a quick understanding of a data set, identifying the highest, median and the lowest numbers in the given data set.

This type of formatting allows you to have a quick understanding of your data with a given icon sets. The icon style and color give you a quick description of what the data is trying to communicate.

Pivot Tables are inbuilt reporting tools in Excel. They are tools used to analyze data without using formulas. It's a drag and drop tool that helps you analyze and visualize your reports in seconds. This is one of the frequently used Excel tools in the business world today. This skill in your resume is enough to get you your dream job at the snap of your fingers.

Charts in Excel helps you create a great visualization for your dataset. It gives you a clearer picture of the values in your columns and rows. It also help you see the meaning behind the numbers and take informed decisions.

In this section, we introduced the current problem to be solved by Jane, a Business Manager. Let's see hoe she goes about it.

Here, we try to format the data we were given to build the dashboard. Watch me format the data set.

Jane needs to create 5 pivot charts to build the dashboard for her report. The first thing she does is to create the table before building the pivot chart.

The first chart we'll build is the Bar Chart. You'll learn how to do this in this video

You need the geographical location to build a map. The algorithm will identify the part of the world you are mapping, based on the data presented and build the map the country. In this example, we have United States data, so the algorithm gave us the US map.

We are going to build the doughnut chart here. Pay close attention to how this was done in this video.

You'll learn how to create the line chart in this video.

The last chart we are creating is the water fall chart. You will learn how to build this from the data set using the pivot charts

This is where we bring all the charts we created earlier together and convert them into "one" interactive dashboard.

Here is the great deal where we make the dashboard interactive. We are going to add the slicers here to make the presentation a lot interesting, all happening on one single dashboard.

Finally, Jane can now copy the dashboard on her presentation and share with her audience.

The VLOOKUP function helps you find the relationships between different columns in Excel. It allows you to look up values from one column in a table (mostly from the right) and return its corresponding value in another table.

The IF statement helps you take decisions based on criteria. To use this statement, you need to set the parameter to test the condition and return one value.

In this section, you'll learn how to run the forecasting model in Excel and also differentiate between Linear and Seasonality Forecasting.