Wednesday, December 2, 2015

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.


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

  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


  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


  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

  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. סיינטולוגיה

  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.

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

  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

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

  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

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

  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

  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.

  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.

  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


Like us on facebook

blogger templatesblogger widgets

Follow on Twitter



Contact Form


Email *

Message *

Mad About Computer. Powered by Blogger.