
At the end of this lesson, students should be able to understand basic features in excel
At the end of this lesson, students should be able to input data's in excel
At the end of this lesson, students should be able to format cells using different cell styles.
At the end of this lesson, students should be able to freeze pane in excel
At the end of this lesson, students should be able to find the sum and average of data's in excel
At the end of this lesson, you will be able to auto-fill cells in Excel
At the end of this lesson, you will be able to add your own auto-fill in excel
At the end of this lesson, you will be able to sort data in excel
At the end of this lesson, you will be able to use filters in excel
At the end of this lesson, you will understand more on absolute references
At the end of this lesson, you will be able to perform the if function in Excel.
At the end of this lesson, you will be able to use pivot table to analyse your data
This video is a continuation on how to use pivot table to analyse your data's
At the end of this lesson, you will be able to chart your data with a pivot chart.
At the end of this lesson, students will be able to use the v lookup function in excel
At the end of this lesson, you will be able to use h lookup in excel
At the end of this lesson, you will be able to insert a chart in excel.
At the end of this lesson, you will be able to create a basic line graph in excel
At the end of this lesson, you will be able to create a scattered XY graph in excel
At the end of this lesson, you will be able to create a pie chart in excel
At the end of this lesson, you will be able to create sparklines in Excel.
At the end of this lesson, you will be able to create a basic dropdown list.
At the end of this lesson, you will learn more about how to create a drop-down list in excel
At the end of this lesson, you will be able to use the 3d formula in excel
At the end of this lesson, you will be able to calculate the data you need to create your 3D graph
At the end of this lesson, you will be able to create a 3D graph in excel
At the end of this lesson, students will be able use the speak cell on enter tool in excel
At the end of this lesson, students will be able to use a password for preventing their excel file to be edited
At the end of this lesson, you will be able to use a password to prevent people from viewing your excel file
At the end of this lesson, you will learn how to record a basic macro.
At the end of this lesson, you will learn how to write a basic macro in excel.
At the end of this lesson, you will be able to create a calendar in Microsoft Excel.
At the end of this lesson, you will learn more about how to create a calendar in excel.
Do you want to learn how to improve your excel skills?
You don't have any experience with Microsoft Excell?
Then don't worry this is the right course for you!!
Students who finished this course will be provided with a verifiable certificate of completion. There will be a quiz at the end of each section.
Microsoft Excel 2010 is used in this course. If you have other versions, no problem because they all work the same with the same features.
It is very important you learn how to use Microsoft Excel very well if you want to become one of the following...
Accountant
Financial Manager
Administrative assistant
Retail Manager
Cost Estimator
Financial Analyst
Project Manager
Business Analyst
Data Journalist
Information clerk
Entrepreneur
Anyone who is involved in business and want to be successful
Real estate agent
Financial advisor
Then learning Microsoft Excel is very important.
Why is Microsoft Excell so important?
Every big company out there uses Microsoft excel and if you want to get the excel skills you need in order for you to be valuable by those big companies, you need to start here with this course.
Enrol now!! and start the journey to get your dream job with your new skill which you are going to learn here