Rand between ,to bring in random numbers .
Minimum marks 0 and max marks 100in suffix
=randbetween (min,max)
These numbers are not fixed, in order fix then , copy the text and hten we will use paste special
option OR to Ctrl+a lt+v
Agar right side me data laana hai toh ctrl+r
Sigma in home tab to find sum, Alt = or =sum(Cell: cell)
For percentage . total marks/ total full makrs* 100
NESTED IF ,
Attendance sheet:
Select all cells u need to write H in, H likho and control enter daba do
Press control and select all ur Ps . Type a and control enter .
Conditional formatting ,highlight cell rule, text that contains..accordingly kar lo
Condition ke sath count karna ho toh COUNT IF
CTRL SHIFT BACK ARROW, TO SELECT PEECHE TAK
Total payable days SUM OF PRESENT AND HOLIDAYS .
We are doing control enter after selecting all cells jinme we want formula.
DAY 2 :
Spark line- select the column jaha ke cells me aapko bar chahiye
Tap on insert and then column
DAY 3 :
Ctrl A for selecting the whole workbook.
Select whole column or row then type ur formula and then alt =
Ctrl ~ for showing or hiding formulas
Count se only numbers count. CountA se saare alphabet and numbers sab seletct
If count if hai toh .if number lena hai toh put =countif(select range , number likho)
If count if alphabet chahiye toh
Don’t give extra space
If we need to get the sum of sales in rupee that ram did, so
=SUMIF(K19:K25,"ram",M19:M25)
That is =sumif(name range, “name”, row of sales in rupee)
CTRL SHIFT 1 SE dot ayega
Crtl shift 2 se time format
Ctrl shift 3 se date then 4 se currency etc
Instad of using format cells, we can use =SUBSTITUTE(C5:C10,"units", "")+0
We put 0 taaki excel units ko number na samjhe
=SUM(SUBSTITUTE(C5:C10,"units", "") +0)
=SUM(SUBSTITUTE(C5:C10,"units","")+0) & " units" taaki answer me units likha hua aaye
DAY 4 :
ALT=D+L DATA VALIDATION ( ONE BY ONE)
ALT+DOWN ARROW DROP DOWN LIST OPEN
CTRL+0 COLUMN HIDE
ALT+O+C+U COLUMN UNHIDE
CTRL+9 ROW HIDE
CTRL+SHIFT+9 ROW UNHIDE
Data validation me ,if ek baar data validation tool daal diya .tab baad me agar data
text change akroge toh data validation me change nai ayega
Text ka drop down dikhta hai number ka nai
VLOOKUP:
If vertical then v look uo
If horizontal data hai then h lookup
If cell likha hai v llookup formula me first , se pehele toh good if name text me likhna
hai toh =VLOOKUP("madhur",C2:F18,2, 0)
New day- Pivot table
Alt ctrl grater than symbol for increasing or decreasing size f axis text
1. Select the table and short cut key is alt F1, or F11 for new sheet me chart.
2. U can edit the chart type from chart design,quick layout OR you can also change chart type
Chart
Right click on chart
Select data
1. Contrl minus for removing all damn content in the selected area
2. TEXT TO COLUMN :
Select the column and then tap on data or ALT A E D
Text box opens, then tap on next,then select on other, and space and finish
1. 11:30 start studying till 12 30
2. If class is at 12 30 toh lunch rakhke jao and come eat at 1:35
3. If nai hai class toh direct padho till 1 :10 and then go have lunch and then take class 1 hr till
2:30 .
4. GOALS of the day:
WE NEED TO FINISH SECURITY ANALYSIS
Complete gst schedules
Ho sake toh FRA ka bhi dekh lena syllabus
