MS Excel

 MS Excel 


  1.  Type Serial Number in Seconds






  2. Autofit Day 1 to Day 365 in Excel.
    Formula: =    "Day "sequence(365,1)












  3. Merge First name & Last Name: 
    i. First write Full Name and Manually in the Full Name Box
    ii. Then in the Second box Press CTRL + E, Done




  4.  How to write Automatically Date in Excel






  5. Show Today Date on Excel: =today()
  6. Get Date format: CTRL + Shift + # 
  7. Design Below Table on Excel





  8. Design the Below Table on Excel:





  9. Design the Below excel Table:

















Comments

Post a Comment

Popular posts from this blog

HTML

1. Hello World Program         <! DOCTYPE html >         < html >         < head >         < title > Hello Page </ title >         </ head >         < body >         < h1 > Hello, World! </ h1 >         < p > This is my first HTML program. </ p >         </ body >         </ html > 2. Simple Web Page with Headings     <! DOCTYPE html >     < html >     < head >     < title > Heading Example </ title >     </ head >     < body >     < h1 > Main Heading </ h1 >     < h2 > Sub Heading </ h2 >     < h3 > Small Heading </ h3 >     </ body ...
Read more

CSS

 1. Colored Headings and Paragraph     <! DOCTYPE html >     < html >     < head >     < title > Colored Text </ title >     < style >         h1 {         color : red ;         }         p {         color : green ;         }     </ style >     </ head >     < body >     < h1 > This is a Red Heading </ h1 >     < p > This is a Green Paragraph </ p >     </ body >     </ html > 2. Centered Text     <! DOCTYPE html >     < html >     < head >     < title > Centered Text </ title >     < style >         h2 {         text-align : cen...
Read more