Learn Basics of Microsoft excel

Name: Learn Basics of Microsoft excel
Rating: 4.4 (19 reviews)

You will learn about the important features such as screen protection, goal seek and Vlookup with pivot table.

Created byFahad Ali

Last updated 10/2022

English

English [Auto],

What you'll learn

Able to learn and Save Excel files
Able to learn about the rows and column
Able to learn about the rules of addition, subtraction, division and multiplication
Able to learn about some advanced rules of excel accounting.

Course content

1 section • 19 lectures • 2h 5m total length

Opening and saving an excel file?6:32
Open a blank workbook in Excel, explore the interface, and learn to save your file with save as to a chosen location, including basics of sheets, columns, and rows.
How to do addition function in excel?6:19
Explore how to perform addition in Excel by entering numbers in cells, selecting cells, and using the = sign to create a sum, then press enter to view the result.
How to perform subtraction function in excel?6:21
Learn the subtraction function in Excel by using a formula with an equals sign to subtract one cell from another, with examples like 20 minus 10 and 30 minus 40.
How to perform multiplication in excel?6:01
Master Excel multiplication by starting formulas with = and using the star symbol to multiply values in selected cells across columns and rows.
How to perform Division in Excel?6:03
Learn to perform division in Microsoft Excel by starting formulas with equals, using the slash operator, and referencing cells by column and row to compute results.
Performing Addition+ Subtraction simaltenously6:29
Performing Multiplication and Division simaltenously6:04
If Condition?6:58
Learn to use the if function in excel to categorize results as good or bad using a threshold of 80%, with practical steps for logical tests and comparing percentages.
Sum if Condition and Conditional Formatting7:43
Learn to use the count if technique and count ifs in Excel to tally occurrences and apply conditional formatting to highlight values greater than one.
How to use Sum if condition?5:49
Learn how to use the sum if condition in Excel to sum yearly sales by criteria, with practical examples for years like 2000, 2005, and 2003.
Linking and making the model of income statement7:08
Learn to build a dynamic income statement in Excel using a linking model with data assumptions, cost of sales and appreciation, and expenses, and automatic updates as inputs change.
Linking and making the model of Statement of financial position6:40
Link the balance sheet model in Excel by setting up non-current and current assets, equity and liabilities, and linking figures with sum functions for dynamic, balanced statements.
Linking and making the model of statement of cashflow position6:32
How to perform goal seek in excel?6:22
How to protect sheet?, use data validation? and Use Vlookup?6:15
Learn how to use VLOOKUP to retrieve sales data, apply data validation to control inputs, and protect sheets with passwords to secure Excel workbooks.
How to make a pivot table?5:29
Learn to create and use pivot tables in Excel to summarize data for management, with steps to insert, select data, and drill down for details.
Forecasting techniques of income statement7:38
Master forecasting techniques in Excel to build a year-by-year income statement, linking data, calculating gross and net profit, and using absolute references to project sales and expenses.
Forecasting techniques of statement of financial position7:52
Forecast the balance sheet by applying 10% changes to current liabilities while keeping capital, drawings, non-current liabilities, and profits fixed, and balance the statement of financial position in Excel.
How to do conditional formatting bar graphs7:06
This video will help you learn the excel conditional formatting, how to use bar graphs.
How to get the prices of different products?

Requirements

Just a person should have basic computer operating skills

Description

In this Course you will be able to start the excel from a very basic level as you will learn how to open a workbook, save a workbook. How to perform small functions such as addition, subtraction, multiplication and division. Apart from this you will also learn how to make a pivot table, how to lock the sheet so that no one should be able to write anything your sheet without your permission. You will learn how to put data validation. You will learn to make models based on the data and you can sell those models online and in the market and make a living out of it.

Apart from this, you will also learn how to link the data an deal with complex models, how to use VLOOKUP, how to make a model of 10 years or more than that. How to use Goal seek where you will be able to get the desired results within seconds without waiting for hours to make a fresh model and do it with the help of trial and error.

This way you will be able to enjoy the course and use it in the official world and in your assignments too

Who this course is for:

Beginners