Are you a total beginner who haven't used Excel before? Or a beginner who tried to follow tutorials or books, but got confused by the level of details you need to cover? Or even been using Excel at work for some time, but often get stuck at some tasks due to some gap in your knowledge?
You've come to the right place! This course was designed with everyone in mind! Even if you haven't used Excel before, this course is for you!
This course will start from the beginning, covering the fundamentals, and equip you with the tools you need to get up-and-running working with Excel.
By the end of this course, you'll be able to accomplish most tasks you would face at your work, and at the same time, you will be ready to take more advanced level Excel tutorials should you wish to.
In this lecture let's have a walkthrough around the Excel user interface.
Cells are the building blocks of an Excel worksheet, let's take a look at how to work with it.
In this lecture we will explore the options we have to format cells.
Here we will explore one more quick and powerful formatting tool. It allows us to quickly format a range of data as a table.
In this lecture, we will discover the options to customize the layout of the worksheet.
In this lecture, we will take a quick look at the reviewing and proofing option.
Let's take a quick look at the options available under the View tab in the ribbon.
It's time for formulas and functions! Let's first start by learning how to type simple formulas.
Functions are built-in formulas in Excel which we can use to quickly get calculations done on our data.
Now, let's explore some of the important and very useful functions we have to manipulate text.
If function is a very powerful tool to use in Excel. Let's get started with it!
SUMIF is a function that allows us to calculate the total of some cells in a range only when a certain criteria is met.
Let's now explore the popular and very powerful function VLookup. It allows us to find a value in a column, then return another value in a different column on the same row.
In this lecture, we will learn the difference between a relative reference and an absolute reference in a formula. It's a very important concept that you need to learn in order to work better with formulas and functions.
Now let's explore PivotTables. PivotTable is a nifty tool that allows us to summarize a large dataset into a table that we can customize the way data is summarized and shown in it and at the same time we can get meaningful insights from our data.
In this video, we will explore some of the formatting options we have for PivotTables.
Time to work with Charts! Charts can add a visual representation for your data and a professional touch as well!
Here we will explore some of the formatting options we have for Charts.
Protecting workbooks is very important if you're going to share it with other users. In this lecture, we will explore the options we have in Excel to protect our workbooks.
Filters allows us to narrow down data based on a certain criteria. Let's see how it works!
Another powerful tool to work with data is Sorting. It allows us to rearrange the data based on the criteria we set.
Have you received some data that you copied to Excel only to find that it all appear on a single column/cell? Text to Column gives you the power to break this data into multiple cells.
Congratulations! You've made it to the end of the course!
Hi, my name is Kareem. I’ve been working with Excel for the last 20 years, and I’ve always enjoyed teaching people around me how to work with Excel and helping them get better results out of it.
I'm coming from a financial and accounting background, and Excel have always been a vital part of my everyday work.