12/11/15

The Home function of Microsoft Excel.

In this tutorial we learn about the Home function of Microsoft Excel.

Clipboard Group :- In this group we can see some command like Cut, Copy and Paste.When we using this command use remove text one area sheet to another Microsoft Excel Spreadsheet. When we use the cut option it removes the selected text after the using command we can insert the clipboard text into the new location.
Using this command we can also copy this formula text one are sheet to another Microsoft Excel Spreadsheet.

Font Group:-When we see font group, we can control the font properties of our text.  In this group we can see the drop down list to the change font type and font changes. We also see more commands just like Bold, Italic, Text underline. If we need more setting to improve wer font setting press ctrl + D and change setting as we wish.
 Original image






We can see explanation about font group in below image.



Alignment group:- Using the group, we can control the position and lawet the text in our worksheet.

Top Alignment-It aligns text to top left.
Middle Alignment- It centered the text between the top and bottom of the cell.
Bottom Alignment-it align text bottom of the left.





Align Text Left:- Using this function, we can do align text to left. Shortcut key
Align Centre:- Using this function, we can do align text to centre.
Align Text Right:- Using this function, we can do align text to right.

Decrease Indent:-  When we enter any text into the cell and after we want to indent the text on left side, each time we  click the button each time, the selected text will nudge to the left.
Use shortcut key to decrease Indent ctrl+alt+shift+tab

Increase Indent:- When we enter any text into the cell and after we want to indent the text on right side, each time we click the button each time, the selected text will nudge to the right.
Use shortcut key to Increase Indent ctrl+alt+tab
Orientation:- In this option when we rotate the cell content use orientation option and the select rotation as given in option. Angle counterclockwise, Angle clockwise, Vertical text, Rotate text up and Rotate text down.

Wrap Text:-  Wrap text is the feature that wrap the text within a cell. We can also used to described word wrap or any text that goes to the next line without pressing the enter or return key. Below image shows that how to use Wrap text?



Merge and center :- It combines two or more cells in a spreadsheet or a table into one cell, and then centres the contents of the new cell.

How to use merge and centre?
1.      First select the range of the cell, which we want to merge.
2.      Click the Home tab, and go to alignment group
3.       And press merge and centre option and we see the selected range of the cell make a new cell.
Below sheet shows how to use merge and center?


Number Format:- Now we are going to Number group in Home tab and when we see the group we see drop down list. First of all we discuss about dropdown list. When we click on drop down list in number format group then we see various option like Number, Currency, Accounting etc.
Below image shows that the Number Format drop down list.





































Number:-  we see drop down list we see top of the list is Number, the number of decimal places, whether or not the thousands separator is used, and the format to be used for negative numbers.

Currency :- If we enter a financial value complete with the dollar sign and two decimal places, Excel assigns a Currency number format to the cell along with the entry.

Accounting:- The Accounting format is used for monetary values. But, this format aligns the currency symbols and decimal points of number in a column.

Long date:- Long date option convert a number into date. Such as 10-11-15 shows as  10-November-2015.

Time:- Time option convert a number into Time Format.

Percentage:- If we enter a value representing a percentage as a whole number followed by the percent sign without any decimal places, Excel assigns to the cell the Percentage number format that follows this pattern along with the entry.

Short date:- Short date option convert a number into date. Such as 10-November-2015 shows as 10-11-15.

Fraction:- Fraction option convert a number into fraction. Such as when we enter 12/15  shows as 4/5.

Increase Decimal:- In this option we already entered number in cell or worksheet, we can increase the  number of places that are displayed after the decimal point by using the Increase Decimal buttons.

 Decrease Decimal:- In this option we already entered number in cell or worksheet, we can decrease the number of places that are displayed after the decimal point by using the decrease Decimal buttons.

Use the keyboard shortcut Ctrl+1 to open the Format Cells dialog box.

Styles Group:- In this group we can see some command like Conditional formatting, Format as table and cells style.

we will learn about Style Group next tutorial.











 




41 comments:

  1. Replies
    1. Great Article Cloud Computing Projects

      Networking Projects

      Final Year Projects for CSE

      JavaScript Training in Chennai

      JavaScript Training in Chennai

      The Angular Training covers a wide range of topics including Components, Angular Directives, Angular Services, Pipes, security fundamentals, Routing, and Angular programmability. The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  2. wait for next tutorial in next tutorial i will explain in conditional formatting

    ReplyDelete
    Replies
    1. please explain in easy form because my english is weak so put images more to learn your next tutorial

      Delete
  3. how make profit and loss projection in microsoft excel

    Microsoft Excel tutorial

    Visit this channel Microsoft tips

    ReplyDelete
  4. I read your post.gained some knowledge. Thanks for sharing. ckeckout here

    ReplyDelete
    Replies
    1. Thanks to leave your Feedback, it encourage me to do Hard work.
      Regarding
      Mad About Computer

      Delete
  5. We have sell some products of different custom boxes.it is very useful and very low price please visits this site thanks and please share this post with your friends. zippered mattress protector

    ReplyDelete
  6. Thanks for sharing this valuable content. In my view, if all webmasters and bloggers made good content as you did, the web will be a lot more useful than ever before. 2ms office 2016 product key

    ReplyDelete
  7. Your website is terribly informative and your articles are wonderful.
    top website design company

    ReplyDelete
  8. It was wondering if I could use this write-up on my other website, I will link it back to your website though.Great Thanks. click here

    ReplyDelete
  9. Hi! This is my first comment here so I just wanted to give a quick shout out and say I genuinely enjoy reading your blog posts. Can you recommend any other Beauty Guest Post blogs that go over the same topics? Thanks a ton!

    ReplyDelete
  10. If truth be told informative and valuable detail is here.
    click now

    ReplyDelete
  11. We Create And Install Bespoke Fitted Wardrobes, Walk-In Wardrobes, Built-In Wardrobes & Storage Solutions. Unique Design And Fascinating Quality. Based In Nottingham. Built-In Wardrobes

    ReplyDelete
  12. I have been browsing online more than three hours today, yet I never found any interesting article like yours. It’s pretty worth enough for me. In my opinion, if all web owners and bloggers made good content as you did, the web will be a lot more useful than ever before. excel spreadsheet company

    ReplyDelete
  13. My spouse and i go through this information. I do think Anyone placed quite a lot of exercise to generate this information. I favor your hard work. [pii_email_8079047078567379049d]

    ReplyDelete
  14. The insides of a house can be given an unmistakable yet appealing look with the utilization of collectible and vintage material like old photograph casings, screens and numerous different things. Alex

    ReplyDelete
  15. Pretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon! visit this page

    ReplyDelete
  16. One of the main areas of do-it-yourself pest control, is early detection. This really is very important. The trick would be to catch the pests before they turn into a real problem. Termite Treatment Orlando

    ReplyDelete
  17. They impressed us with their designs on previous projects, and they delivered similar work for us.
    website designer company

    ReplyDelete
  18. I really loved reading your blog. It was very well authored and easy to understand. Unlike other blogs I have read which are really not that good.Thanks alot! theconsumer.guide

    ReplyDelete
  19. I can set up my new idea from this post. It gives in depth information. Thanks for this valuable information for all,.. phuket property

    ReplyDelete
  20. I do accept as true with all the concepts you’ve offered
    on your post. They are very convincing and can definitely work.
    Nonetheless, the posts are very quick for starters. May just you please lengthen them a bit from next time?
    고스톱

    ReplyDelete
  21. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up.
    스포츠토토

    ReplyDelete
  22. Furthermore, one more consequence of the ascent in accessible properties is that an ever increasing number of individuals are turning out to be first-time property holders.hollywood hills homes for sale

    ReplyDelete
  23. The term Microsoft Excel Database has never really sat very well with me since my primary role in the IT world has been in developing database and what is used by the spreadsheeting fraternity is what I consider an over glorified list. However, for the sake of peace, I want to outline some of the principles you must follow in building what is known as the Microsoft Excel Database. ppt translator

    ReplyDelete
  24. Looking forward to reading more. Great post. Really thank you! Want more.cambodia real estate market

    ReplyDelete
  25. Home improvement loans are meant any kind of home improvement projects from simple home repairs to large scale remodeling and major restructuring. Home improvement loans should target both adding value to your home and comfort. spend time in searching for Foundation crack repair in Reno loans. Your effort will be rewarded in the form of better interest rates and terms. Look for low interest rates and monthly installments that......

    ReplyDelete
  26. After reading your article I was amazed. I know that you explain it very well. And I hope that other readers will also experience how I feel after reading your article. Security

    ReplyDelete
  27. An evaporative cooler enjoys a great deal of upper hands over a standard air conditoner in light of the fact that it has a lower cost of establishment, requires less support and works with less energy. Since they are more uncommon in certain pieces of the country, it appears as though a many individuals don't have a clue how an evaporative cooler functions. air conditioning repairs, Germantown
    Install heating system

    ReplyDelete
  28. Get a great rush of decorating enthusiasm to create a home decor that stretches your imagination.buy cushion covers online in Pakistan

    ReplyDelete
  29. Microsoft and its set-up of items are utilized worldwide and as a rule organizations rotate around Microsoft Office. https://onohosting.com/

    ReplyDelete
  30. buy twitch followers Gaming is one of the productive activities that ensure the personal developments of individuals for them to impact favorably on the development of their societies. Unfortunately, this creatively designed applications better known as electronic or video games that function on consoles such as X-box and play station on computers, mobile devices, and other electronic gadgets have been negatively branded as evil by some critics. There is the urgent need to offer a convincing reply to these unfair critics who dwell solely on the unkempt disadvantages of gaming to plunge its whole benefits into disrepute.

    ReplyDelete
  31. Thank you because you have been willing to share information with us. we will always appreciate all you have done here because I know you are very concerned with our. VoIP Telecoms

    ReplyDelete
  32. https://www.visualaidscentre.com/service/eyes-specialist-delhi/ There's no denying that video games have become an integral part of the millennial life. This is probably because they allow the gamer to lead an alternate life, full of adventure and challenges. Gaming is a truly global industry today- a $60 billion one.

    ReplyDelete
  33. https://hostinglelo.in Car games come with in all types and sizes. Gaming companies are constantly renovating their game strategies to find better and bigger buyers for their products. With action and war games attaining new levels of popularity, car game manufacturers are trying equally hard to keep up with the market standards. Some of the popular car game categories are listed below.

    ReplyDelete
  34. https://onohosting.com A video game is more than just the sum of all of its pieces. A game contains a unique synergy in that after it is finished, it becomes more unique. Creating this distinct 'synergy' involves excellent computer skills, technical knowledge, and also a sense of art & design. This article describes ways to improve the game development process.

    ReplyDelete
  35. Create financial freedom, through smart property investment with George Markoski. passive income Australia

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.