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 O R G A N I C S C O M P A N Y 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 O R G A N I C S C O M P A N Y 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 O R G A N I C S C O M P A N Y 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 O R G A N I C S C O M P A N Y 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) Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You O R G A N I C S C O M P A N Y SimpleBillStatement 8 Simple Bill statement Note: Press Ctrl + ` to display the formula. Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You O R G A N I C S C O M P A N Y SimpleReportStatement 9Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

BEST FOR You O R G A N I C S C O M P A N Y 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 O R G A N I C S C O M P A N Y 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) Bikal Shrestha || Roll No-4 || BICTE 1st Sem || ICT || Excel Spread sheet||21st December,2018

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