12/2/15

Introduction to MS Excel

In this tutorial you will learn about introduction to MS excel.

MS Excel is application software. It is used for calculation and data analysis such as pivot table, analysis, goal seek & scenarios, that all made excel a powerful & useful tool. You can also insert graphs or charts and perform complex calculations. Data is stored in rows and columns format. By default excel workbook contain 3 sheets.

Various components of excel spreadsheet are illustrated below.

Title Bar :-  Its display the name of the excel spreadsheet. By default spreadsheet name is Document1 or Book1.

Menu Bar :- It is a primary function of any application. Menu Bar is a thin rectangle, which is typically located at the top of the screen and below the title bar, containing drop down menu.

Button Bar :- It is a set of multiple buttons joined into a separate control. In Button Bar every Button has a text label or icon or both.

Formula Bar :- When we use any formula in an excel spreadsheet then it is displayed in the formula bar. 

Sheet tab :-  When we open excel, we always see that excel automatically selects sheet 1 for us. If we want, we can rename, delete, move and change colour of the sheet by right clicking on it. We can also hide and protect the sheet.

Use shortcut key Alt+Shift+F1 to create a new sheet.

Name box :- It display the name of the currently selected cell. For example H6, A5, B3, etc. In H6, H is the column name an 6 is the row number.

Other Important MS Excel Information

1 Excel file = 1 Workbook = 255 sheets

Total Number of rows = 65536

Total Number of columns = 256

Total Number of cells = Rows * Columns 
65536 * 256 = 16777216 Total Cells.

Rows are numeric and columns are alphabetical.


Above image shows that we are working in excel using cell address. They are made up of the combination of rows and columns. For creating cell address, first column name and then row name is written. 

A2, H5, B2, C4, D5, these are cell addresses. A is Column and 2 is Row. All type of calculations are performed using cell address. Cell address can be viewed in Name box.

If you have found any mistake or have any doubt related to above introduction to MS excel tutorial then comment below.

89 comments:

  1. i think you create a new website and this is your startup in this topic
    hey i want home tab in ms excel

    ReplyDelete
  2. UFC puts out TUF 26 throwing call for three weight classes. The UFC issued a throwing call Wednesday for contenders in three weight classes for the most recent period of the FS1-communicated arrangement: ladies. 'TUF 26' tryouts slated for May 23; male and female UFC hopefuls. UFC on FOX 24's "Jacare" Souza won't down from unsafe battles. RIO DE JANEIRO, Brazil – Ronaldo Souza wasn't shocked when the UFC reacted to his demand for a battle with the name of rising.
    UFC 210
    UFC 210 Live , UFC 210 Fight Card , UFC 210 Fight , UFC 210 Card , UFC 210 Live Stream , UFC 210 PPV



    Two years into UFC title rule, Daniel Cormier as yet battling for regard Meanwhile, after a long keep running as the prevalent belt in the UFC, light ... Daniel Cormier, the current UFC light heavyweight champion, is set to. UFC 210 early say something comes about and live video stream (9 am ET Predictions for each battle on the UFC 210: Cormier versus Johnson 2. UFC 210 Odds And Best Bets For The Biggest Fights And Bonuses.
    UFC 210
    UFC 210 Live , UFC 210 Fight Card , UFC 210 Fight , UFC 210 Card , UFC 210 Live Stream , UFC 210 PPV

    ReplyDelete

  3. For complete protection of UFC Fight Night 136, take a look at the UFC Events section of the site.

    The Blue Corner is MMAjunkie's website area. We do not take it too seriously, and neither should you. Should you come whining to us that something which you just read isn't hard-hitting news, expect to have the previous sentence replicated in ALL CAPS.
    UFC 229 Live Stream

    ReplyDelete

  4. Fast forward to the conclusion of Jedrzejczyk's scrum alongside a reporter circled back into asking her for a prediction. When Jedrzejczyk revealed she was 50/50, the reporter subsequently altered to asking her about McGregor's behavior.
    UFC 229 Live Stream Online

    ReplyDelete
  5. They're produced by the very best degree developers who will be distinguished for your polo dress creating. You'll find polo Ron Lauren inside exclusive array which include particular classes for men, women. סיינטולוגיה

    ReplyDelete
  6. SW1030A IN A 2U 19IN RM Really I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post.

    ReplyDelete
  7. Is it okay to post part of this on my website basically post a hyperlink to this webpage? buy instagram likes cheap instant

    ReplyDelete
  8. The learning curve for computer software has often been solely dependent on the ease of use from the software's interface. In the past with bad interfaces we have spent too long reading through manuals that come with the product to find out how to do a certain function. Learn How to tutorials here

    ReplyDelete
  9. During this website, you will see this shape, i highly recommend you learn this review. scrap motherboards for sale

    ReplyDelete
  10. Outstanding blog, in my opinion site owners should acquire a great deal out of this blog its very user welcoming.
    website design firms San Francisco

    ReplyDelete
  11. It’s amazing to visit again n again coming to your blogs the superb effort is here.
    web design agency San Francisco

    ReplyDelete
  12. I was reading some of your content on this website and I conceive this internet site is really informative ! Keep on putting up. ms office 2016 free download full version

    ReplyDelete
  13. Get quite safe and secure relevant backlinks for your site to boom your Rank on Google and another search engines.

    you get 80 Niche relevant backlinks on your keywords relevant website

    Quality and affordable SEO service in good price. help your site to visible in search engine through our quality relevant seo backlink blog comments.

    ReplyDelete
  14. If you want to increase your Domain rating DR 50+ increase , Then you are at the very right place. I will increase your website Domain Ranking DR in 30 days with my white hat Seo Strategies.

    ReplyDelete
  15. I read your blog frequently, and I just thought I’d say keep up the fantastic work! It is one of the most outstanding blogs in my opinion. 2ms office 2016 product key

    ReplyDelete
  16. Personally I think overjoyed I discovered the blogs.
    top digital agencies in the us

    ReplyDelete
  17. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. cell phone hackers for hire

    ReplyDelete
  18. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post. limitlessreferrals

    ReplyDelete
  19. Leader in developing embedded system projects, providing Engineering and SCADA solutions using Raspberry pi, Arduino and more.... transistors

    ReplyDelete
  20. Would you have a myspace buff page? I seemed to get one-on-one twitter But could not locate it, I would like to develop into an enthusiast! envy 7640 troubleshooting

    ReplyDelete
  21. big data Leader in developing embedded system projects, providing Engineering and SCADA solutions using Raspberry pi, Arduino and more....

    ReplyDelete
  22. i was looking at a number of your posts in this website and i conceive this net web site is in imply of fact advisory! hold setting taking vicinity.. Poker Online Indonesia

    ReplyDelete
  23. awesome article, it's miles especially beneficial! I quietly commenced in this, and i am becoming more acquainted alongside amid it higher! Delights, refrain take leisure motion greater and tallying superb! That Time I Got Reincarnated As A Slime Shion

    ReplyDelete
  24. 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
  25. This will open a window containing the HTML source code of the page. Inspect an HTML Element: Right-click on an element basic HTML CODE

    ReplyDelete
  26. URL Encoder. Enter text to URL encode or decode. Converts the text into a percent encoded string URL CODE

    ReplyDelete
  27. Very beautiful written article. it'll be in settlement to all people who utilizes it, such as me. hold accomplish what you're put it on canr wait to recognition extra posts. Lambingan

    ReplyDelete
  28. that is truely intellectual content material and written thinking about ease for a regulate. it's best to peer that some human beings but put taking region as soon as a way to write a man or woman nation.! 먹튀검증 안전놀이터 스포츠중계 꽁머니 먹튀검증 토토사이트 안전놀이터 꽁머니

    ReplyDelete
  29. Wow, cool post. I'd like to write like this too - taking time and real hard work to make a great article... but I put things off too much and never seem to get started. Thanks though. personal budget template

    ReplyDelete
  30. i'm every percentage of lots deferential in the look of the contents you've got cited. I wanted to thank you for this deafening article. Pinoy Tambayan

    ReplyDelete
  31. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained! bitmain

    ReplyDelete
  32. 와우, 나는 여드름을 자연적으로 치료하는 방법이 궁금했다. Google에서 사이트를 찾은 후 많은 것을 배웠습니다. 이제 조금 명확합니다. 귀하의 사이트를 즐겨 찾기에 추가하고 RSS를 추가했습니다. 우리를 계속 업데이트하십시오. 토토

    ReplyDelete
  33. i'm every percentage of lots deferential in the look of the contents you've got cited. I wanted to thank you for this deafening article. Lambingan

    ReplyDelete
  34. Thanks in support of sharing such a good thought, piece of writing is
    fastidious, thats why i have read it entirely

    Also visit my web page - 만남사이트



    ReplyDelete
  35. Your work is great and I value you and jumping for some more educational posts. Much obliged to you for sharing incredible data to us. Macbook Pro gebraucht

    ReplyDelete
  36. The innovative assets related with a ITBizTek business should be continually kept up.

    ReplyDelete
  37. We should now examine what you need to play those games. On the off chance that you need to play computer games on the web, you need to have an excellent Internet association. Free pc games

    ReplyDelete
  38. Solid post! I actually wasn’t aware of this. It’s refreshing to read because I get so annoyed when writers put no thought into their work. It’s obvious that you know what you’re writing about. I shall definitely visit again! help with excel spreadsheet

    ReplyDelete
  39. A record utilized by Microsoft Excel to by and large sort out worksheets, diagrams, charts and other related Excel objects into one single area. Help with Excel

    ReplyDelete
  40. At the point when Microsoft Excel is utilized to build huge and complex spreadsheets containing numerous worksheets, it can turn out to be very hard for somebody to explore, not to mention track or follow numbers through the spreadsheet with the entirety of the qualities and equations contained inside it.excel spreadsheet consultant

    ReplyDelete
  41. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article. sell my toner

    ReplyDelete
  42. So-called computer technicians these days think that just by owning and running a computer shop and being around a lot of PC's everyday makes them great technicians. Brian

    ReplyDelete
  43. 이것을 우리 모두와 공유 해주셔서 감사합니다. 실제로 당신이 말하는 것을 깨닫습니다! 북마크 됨. 먹튀검증

    ReplyDelete
  44. 이것은 종종 우리 중 많은 사람들이 탐색을 진지하게 즐겼던 좋은 선물입니다. 내가 무언가를 확인할 가능성을 제공하는 것은 매일이 아닙니다. 먹튀검증

    ReplyDelete
  45. I found your this post while searching for some related information on blog search...Its a good post..keep posting and update the information. 슈어벳

    ReplyDelete
  46. Thank you very much for this useful article. I like it. Bixolon thermal printer dealers Kenya

    ReplyDelete
  47. Thanks for your post. I’ve been thinking about writing a very comparable post over the last couple of weeks. I’ll probably keep it short and sweet and link to this instead if thats cool. Thank 먹튀

    ReplyDelete
  48. "Hi there colleagues, its fantastic piece of writing
    concerning tutoringand fully defined, keep it up all the time." 토토사이트

    ReplyDelete
  49. "Everything is very open with a really clear clarification of the challenges. It was definitely informative. Your site is very helpful. Thanks for sharing!

    " 먹튀폴리스

    ReplyDelete
  50. "Thanks a bunch for sharing this with all of us you really know what you are speaking approximately!
    Bookmarked. " 토토검증

    ReplyDelete
  51. This article gives the light in which we can observe the reality. This is very nice one and gives indepth information. 안전놀이터

    ReplyDelete
  52. Good info and right to the point. I am not sure if this is actually the best place to ask but do you people have any thoughts on where to get some professional writers? Thank you 🙂 토토사이트

    ReplyDelete
  53. "Everything is very open with a really clear clarification of the challenges. It was definitely informative. Your site is very helpful. Thanks for sharing!

    " 메이저사이트

    ReplyDelete
  54. I enjoy each of the perform that you have placed into this. I’m sure that you will be making a really useful place. I has been additionally pleased. Good perform! 토토사이트

    ReplyDelete
  55. I have been checking out a few of your stories and i can state pretty good stuff. 파워볼사이트

    ReplyDelete
  56. Amazing website sir. A great information given by you in this blog. It really informative and very helpful. Thank you. Istanbul property

    ReplyDelete
  57. We absolutely love your blog and find a lot of your post’s to be precisely what I’m looking for. digital marketing malta

    ReplyDelete
  58. Wow, wonderful blog layout! How long have you ever been blogging for? you made running a blog glance easy. The full look of your website is great, let alone the content! windshield repair san diego

    ReplyDelete
  59. Hello to all, for the reason that I am truly eager of reading this weblog’s post to be updated regularly. motorcycles for sale san diego

    ReplyDelete
  60. Hello to all, for the reason that I am truly eager of reading this weblog’s post to be updated regularly. yamaha dealer

    ReplyDelete
  61. I went over this website and I believe you have a lot of wonderful information, saved to my bookmarks paginas web tijuana

    ReplyDelete
  62. Very informative post ! There is a lot of information here that can help any business get started with a successful social networking campaign Real estate agent West Carleton

    ReplyDelete
  63. Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained 6 logement a vendre

    ReplyDelete
  64. It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about! Thanks outdoor patio seating

    ReplyDelete
  65. It’s hard to find knowledgeable people on this topic, but you sound like you know what you’re talking about! Thanks courtier immobilier Candiac

    ReplyDelete
  66. It is a great website.. The Design looks very good.. Keep working like that!. yoga gatineau

    ReplyDelete
  67. Interesting topic for a blog. I have been searching the Internet for fun and came upon your website. Fabulous post. Thanks a ton for sharing your knowledge! It is great to see that some people still put in an effort into managing their websites. I'll be sure to check back again real soon. buy website traffic

    ReplyDelete
  68. Interesting topic for a blog. I have been searching the Internet for fun and came upon your website. Fabulous post. Thanks a ton for sharing your knowledge! It is great to see that some people still put in an effort into managing their websites. I'll be sure to check back again real soon. shipping from china to usa

    ReplyDelete
  69. i am for the first time here. I found this board and I in finding It truly helpful & it helped me out a lot. I hope to present something back and help others such as you helped me. Pest control near me

    ReplyDelete
  70. Hello
    Thank you for giving me useful information.
    Please keep posting good information in the future
    I will visit you often. 토토사이트Thank you.
    I am also running the site. 메이저놀이터 This is a related site, so please visit once.안전놀이터
    Have a niceday!

    ReplyDelete
  71. excellent post, very informative. I wonder why the other specialists of this sector don’t notice this. You must continue your writing. I’m sure, you have a great readers’ base already!바둑이사이트

    ReplyDelete
  72. I’m still learning from you, as I’m trying to achieve my goals. I definitely love reading everything that is written on your site.Keep the aarticles coming. I liked it!카지노사이트

    ReplyDelete
  73. I like this site very much, Its a very nice spot to read and find info .카지노사이트

    ReplyDelete
  74. Great blog! Do you have any tips for aspiring writers? I’m hoping to start my own blog soon but I’m a little lost on everything. 카지노사이트

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Contact Form

Name

Email *

Message *

Mad About Computer. Powered by Blogger.