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.

125 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
  75. Awesome! Its genuinely awesome paragraph, I have got much clear idea on the
    topic of from this paragraph. 온라인카지노

    ReplyDelete
  76. 카지노사이트 Wow, fantastic blog layout! How long have you been blogging for?
    you make blogging look easy. The overall look of your site
    is wonderful, let alone the content!

    ReplyDelete
  77. 스포츠토토 Great beat ! I wish to apprentgice at tthe same time as you amend yor site, how can i subscribe for a blog website?
    Thee account aided mee a applicable deal. I have been a little bit familiar of this your broadcast provided bright clear concept

    ReplyDelete
  78. 토토사이트 Nice post. I was checking constantly this weblog and I’m inspired!

    Very helpful info particularly the remaining section 🙂 I maintain such info a lot.
    I used to be looking for this particular information for a very long time.
    Thank you and good luck.

    ReplyDelete
  79. I read this article. I think You put a lot of effort to create this article. I appreciate your work. Accounts

    ReplyDelete
  80. 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
  81. I got too much interesting stuff on your blog. I guess I am not the only one having all the enjoyment here! Keep up the good work.

    토토사이트

    ReplyDelete
  82. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info.

    한국야동

    ReplyDelete
  83. I am always searching online for articles that can help me. There is obviously a lot to know about this. I think you made some good points in Features also. Keep working, great job!

    토토사이트

    ReplyDelete
  84. You have a real ability for writing unique content.I like how you think and the way you represent your views in this article.I agree with your way of thinking.Thank you for sharing. Black hat forum

    ReplyDelete
  85. This is really a nice and informative, containing all information and also has a great impact on the new technology. Check it out here:토토커뮤니티

    ReplyDelete
  86. We Can Fix Any Laptop Device - iPhone, iPad, MacBook Pro, MacBook Air Repair, Computer, Laptop, Networking, Data Recovery, IT Support, At Very Reasonable Rates. Our Trained and Expert Technicians Can Fix Any Faults in Your Apple Device. Call Expert Engineer 9594423645 laptop repair service at home

    ReplyDelete
  87. just about any planking. Our own wales can easily compilation of calculated forums those thickness analysts could be the 토토사이트

    ReplyDelete
  88. most people because can play when you free time. can play or home, office or drive you can play all day all night. 안전놀이터

    ReplyDelete
  89. Can you make your own phone apps? Where can you go to do it? This article answers these questions 토토검증사이트

    ReplyDelete
  90. I'm surprised there's such a wonderful article This blog is a very informative place. I'll come by often..보증업체추천

    ReplyDelete
  91. Thank you for sharing your thoughts. 먹튀 that will help me grow.

    ReplyDelete
  92. look forward to it.It's always coming 먹튀 glad to see such a good comment

    ReplyDelete
  93. Advances in interchanges and innovation have carried with it an off-shoot marvel that has significantly affected the manner in which people and organizations interface and manage one another. pe file header

    ReplyDelete
  94. The redeveloped site received praise from its users, who find it to be easier to use, informative, and modern in its look and feel.
    interaction design firm

    ReplyDelete
  95. Thanks For sharing this Superb article.I use this Article to show my assignment in college.it is useful For me Great Work.

    ReplyDelete
  96. I like the helpful info you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite sure I’ll learn plenty of new stuff right here! Good luck for the next. 스포츠토토

    ReplyDelete
  97. I am extremely impressed with your writing skills and also with the layout on your blog.
    Is this a paid theme or did you modify it yourself?
    Anyway keep up the nice quality writing, it’s rare to see a nice blog like this one today.
    온라인섯다

    ReplyDelete
  98. This website is known as a stroll-via for all of the information you needed about this and didn't know who to ask. Glimpse right here, and also you definitely uncover it.
    스포츠토토

    ReplyDelete
  99. It’s enormous that you are getting ideas from this article
    as well as from our argument made at this time
    성인웹툰

    ReplyDelete
  100. I’m very happy to find this web site. I wanted to thank you for ones time just for this fantastic read!!
    I definitely savored every part of it and i also have you bookmarked to look at new things in your website.
    안전놀이터

    ReplyDelete
  101. hi!! Extremely intriguing exchange happy that I ran over such useful post. Keep doing awesome. Happy to be a piece of your net group 토토커뮤니티

    ReplyDelete
  102. There is so much in this article that I would never have thought of on my own. Your content gives readers things to think about in an interesting way . Excellent blog here! This is really fascinating informatic article. Thanks for sharing your thoughts. I truly appreciate individuals like you! "Pretty! This has been an extremely wonderful post. Thank you for providing this information. " I really enjoy simply reading all of your weblogs. Simply wanted to inform you that you have people like me who appreciate your work. Definitely a great post. Hats off to you! The information that you have provided is very helpful. 토토패밀리

    ReplyDelete
  103. If you want to be successful in weight loss, you have to focus on more than just how you look. An approach that taps into how you feel, your overall health, and your mental health is often the most efficient. Because no two weight-loss journeys are alike, we asked a bunch of women who’ve accomplished a major weight loss exactly how they did it . I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here! keep up the good work. Great post I would like to thank you for the efforts you have made in writing this interesting and knowledgeable article. 토토서치

    ReplyDelete
  104. an high-quality proportion! I’ve certainly forwarded this onto a co-worker who've been doing some homework in this. And he surely ordered me dinner due to the truth that i discovered it for him… lol. So allow me to reword this…. Thanks for the meal!! However yeah, thanx for spending the time to speak approximately this problem proper here in your net web page. It feels accurate to pay attention the gratifying thud of a poker chip once you toss it down the table. Now there is 1 different tip you need to make use of in case you need to discover ways to carry out. He began taking component in the game pretty regularly on nearly each weekend. What does depend is which you manage that money simply so your bankroll will boom over the years. So, the extra you rake the more you get once more once more! Having a buddy or to help provides interesting and pride. 메이저놀이터

    ReplyDelete
  105. Your web site is great. I was extremely touched by this write-up. I'm so pleased to discover the short article I have actually been searching for a very long time. I covet the amount of individuals sympathize with your writing. You find out a great deal of understanding from my writing. click through the up coming web page

    ReplyDelete
  106. CSGO Prime Accounts is a paid or a premium model of CSGO. You could both purchase it or gather it when you reach the 21 ranges of the Private Rank in-game. You have got specific blessings attached to this account. Other than that, you’re most effective matched with other top players when you gain high status in the game. you have got a few high-unique souvenirs to accumulate in the sport, unique sport modes, and many others.

    ReplyDelete
  107. I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Google. You have made my day! Thank you again.
    고스톱

    ReplyDelete
  108. Really appreciate you sharing this article post. Really thank you! Really Cool.
    토토

    ReplyDelete
  109. It as really a great and helpful piece of info. I am glad that you shared this helpful info with us. Please keep us up to date like this. Thank you for sharing!
    성인웹툰

    ReplyDelete
  110. I like this website its a master peace ! Glad I found this on google .
    I must say, as a lot as I enjoyed reading what you had to say, I couldn't help but lose interest after a while.
    토토사이트

    ReplyDelete

Like us on facebook

blogger templatesblogger widgets

Follow on Twitter

Linkedin

Categories

Mad About Computer. Powered by Blogger.