Excel is more than a brand everyone knows: it is powerful data visualization and analysis software, which uses spreadsheets to store, organize, and track data sets with formulas and functions..
Where Excel is used?
Microsoft Excel is the most widely used software by businesses.
Excel is used by Students, Faculties , Industry person , marketers .
Almost Excel user does not know enough about Excel.
So, TCCI has tried to give some tips to the Excel user.
- Use Cntrl + R
To do Copy & Paste data both at a time.
- How to separate data from given text?
Use Left Formula to extract character/text from left side easily.
for example , "mili shah" is given text and want to separate mili then use =left("mili shah",4), mili will
Will be separated in new cell.
- How to separate data from given text?
Use Right Formula to extract character/text from right side easily.
for example , "mili shah" is given text and want to separate shah then use =right("mili shah",4), shah
Will be separated in new cell.
- Use alt + 7 / alt+ 8/alt+9 to insert Bullets in Cell.
- Use Series: To enter date in series enter first date in cell, then drag that cell until last date . You
can use this for weekdays and month also.
6.Use series: To enter number in order, enter first 2 numbers , select them and drag + sign until last
number.
7.How to remove blank rows?
Select all data, press cntl+G, select special ,choose blank , press cntl -(minus),choose entire
row, all blank rows will remove.
- How to convert number to word in Excel?
- Use =NumToWord(cellreference) ,you will get result instant.
- Add Multiple Rows
Probably one of the most frequently carried out activities in spreadsheeting. Ctrl Shift + is the shortcut, but
actually it takes longer than just right-clicking on the row numbers on the left of the Excel display. So Right
Click is our recommendation. And if you want to add more than one, select as many rows or columns as you'd
like to add and then Right Click and add.
- Auto fit column and rows:
Select all of the data then press alt+ H+ O+ I then alt + alt + H + O + A
To learn more Excel in detail Join TCCI and grow your knowledge.
TCCI Computer classes provide the best training in all computer courses online and offline through different learning methods/media located in Bopal Ahmedabad and ISCON Ambli Road in Ahmedabad.
For More Information:
Call us @ +91 98256 18292
Visit us @ http://tccicomputercoaching.com/
No comments:
Post a Comment