Ms Excel Basic to Advance Tutorial

Microsoft Excel
Spreadsheet
Fundamental
Of
ICT
Organize, format and calculate

BEST FOR You
O R G A N I C S C O M P A N Y
We will be talking about
 Introduction
 General Interface of Excel
 Basic Knowledge of Excel
 General Function and
Formula
 Result Calculation
 CurrentYear Calculation
 Export to PDF
2Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You
3
Introduction of MS-Excel
Microsoft Excel is a software program produced
by Microsoft that allows users to organize, format
and calculate data with formulas using a spreadsheet
system. It is also called the spreadsheet software.
Total Number of Columns on 2007 or higher version : 16,384
Total Number of Rows on 2007 or higher version : 10,48,576
Similar to Excel(Spread Sheet): Tabulus, Kspread, IBM Lotus 123, Corel Quattro Pro, Apple Number
File Extension: .xls or .xlsx

BEST FOR You
4
General Interface of MS-Excel
Basic Component of MS-Excel
Cells, Active Cells, Name Box, Formula Box, Columns, Rows, Sheets.

My slide title
My subtitle
AutoFill : AutoFill is a very
useful Excel feature. It
allows you to create entire
columns or rows of data,
which are based on the
values from other cells.

BEST FOR You
Move the cell pointer:
6
Key Definition
→ To next cell
← To previous cell
↑ To one row up
↓ To one row down
End + → To the end of the current row
End +← To the beginning of current row.
End +↑ To the beginning of current column
End +↓ To the end of the current column
Tab To jump across(next cell)
Tab+ Shift Back cells (previous) in a row
Enter To move down a column
Shift+Enter To move up a column
Ctrl +Enter To preserve the position of the current cell
Ctrl + Home To move to the start/end of the data
Ctrl + End To move to end of the data
Home To move to columnA
Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You
GeneralFunctionandFormula
A formula is simple mathematical or logical expressions to
accomplish specific task. It consists sets of operands and
respective operators.
Mathematical Operator
+,-, *, /, %, ^
RelationalOperator
=, >,>=,<,<=,<>(not equal to)
7
General Formula
Sum(no1,no2,…..)
Average(no1,no2,…..)
Power(number, power)
Max(no1,no2,…..)
Min(no1,no2,…..)
Count(no1,no2,…..)
And(logical1,logical2,……)
Or(logical1,logical2,……)
If(Logical_test,value_if_true,value_
if_false)

BEST FOR You
SimpleBillStatement
8
Simple Bill statement
Note: Press Ctrl + ` to display the formula.

BEST FOR You
SimpleReportStatement
9Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You
MarkSheet
10
1. Total = Sum(First sub number : Last sub number)
2. Percentage = Total/ total subject
3. Result = if(min(first subject: last subject) >=32,"Pass","Fail")
4. Division = if(and(result="pass",percentage >=80),"Distinction", if(and(result="pass", percentage >=60),"First",
if(and(result="pass", percentage >=45),"Second", if(and(result="pass", percentage >=32),"Third",
"no division")))
1. Grade =IF(AND(result="Pass", percentage>=90),"A+",IF(AND(result="Pass", percentage >=80),"A",
IF(AND(result="Pass", percentage >=70),"A-", IF(AND(result="Pass", percentage
>=60),"B",IF(AND(result="Pass", percentage >=50),"B-", IF(AND(result="Pass", percentage >=40),"C","E"))))))

BEST FOR You
11
Current Age
DOB Current
Year
Result
Year Months Day Week Age
Calculating the current year
Formula:
DOB =Date(1990,10,10)
Current Date =TODAY()
Year =datedif(DOB,Current year,"Y")
Month =datedif(DOB,Current year,"YM")
Days =datedif(DOB, Currentyear,"MD")
Week =choose(weekday(DOB),"Sun","Mon","Tue","Wed","Thur","Fri","Sat")
Age =DOB&"Yrs."&Currentyear&"Months"&Day&"Days)

Thank You
Fundamental of
ICT
Bikal Shrestha
+977 9846776817
bik.bict@gmail.com
www.bikbict.com.np

Ms Excel Basic to Advance Tutorial

In this document

More Related Content

What's hot

Similar to Ms Excel Basic to Advance Tutorial

Recently uploaded

Ms Excel Basic to Advance Tutorial