Microsoft Office Excel

It has two types of Extension .xls and .xlsx. In old version, up to 2003 is .xls and now is .xlsx up to 2013.

An Excel file called Workbook and a Workbook have many Worksheet or Electronic Spreadsheet (256).

Electronic Spreadsheet: An electronic spreadsheet application accepts data values and relationships between the data values in a tabular format consisting of rows and columns. It allows user to perform calculation on these values. If any information is changed the worksheet program automatically recalculates all results.

Create an excel file: Computer>>Local Disk (D:)>>New Folder>>Microsoft Office Excel Worksheet>>Open.

Excel specifications and limits:

  1. First Column Name: A
  2. First Row Number: 1
  3. Last Column Name: XFD
  4. Last Row Number: 1048576
  5. First Cell Name: A1
  6. Last Cell Name: XFD1048576
  7. Total Column Number: A to XFD=16384
  8. Total Row Number: 1048576
  9. Total Cell Number: XFD1048576=16384X1048576=17179869184

Cell Reference: A reference that identifies a cell or a range of a cells on a worksheet that user want to use in a formula. There are three types of cell reference are as follows.

1. Relative Cell Reference: When user copy formula from one cell to another cell, the cell address is changed accordingly. For example:-

2. Mixed Cell Reference: For fixed a column or row in a formula user should to fixed ($) column or row. When user copy formula from one cell to another cell, then one part of cell is fixed and other is relative. For example:-

3. Absolute Cell Reference: For fixed a cell value in a formula user should to fixed ($) column as well as row. When user copy formula from one cell to another cell, then cell address will not be change accordingly. For example:-

Comment: A comment is a note that attach to a cell and separate from other cell content. Comments are useful as remainders.

Filtering Record: Filtering is a quick and easy way to find and work with a subset of data in a range. It displays only the rows that meet the criteria that user specify for a column. There are two types of filtering: a)Auto Filter and b)Advance Filter.

Chart: Chart is a Pictorial representation of data in the worksheet. It give user to represent data in the most effect manner by using any type of chart. There are 11 type of chart in Excel 2007.

Goal Seek: Goal Seek is the part of a suite of commands sometimes called what-if analysis tools. Microsoft Excel use the value in one specific cell until a formula that’s dependent on that cell for return the result which user want.

26 Replies to “Microsoft Office Excel”

  1. Praesent urna velit, auctor nec turpis et, vehicula lobortis sem. Vivamus convallis mi sagittis eleifend laoreet. Praesent vitae venenatis enim. Nulla tincidunt Varys et lectus rhoncus laoreet. Alysia Natal Linkoski

  2. If you are going for best contents like I do, only go to see this web page all the time because it presents feature contents, thanks Florentia Raimundo Dulcy

  3. Thank you for the sensible critique. Me and my friend were just preparing to do a little research about this. We got a book from our local library but I think I learned better from this post. I am very glad to see such fantastic information being shared freely out there. Christine Salem Retha

  4. I think the last time we visited a zoo was in Australia back in 2004. That was a great place to see native Australian animals that we would likely not have seen otherwise. Stormi Ryley Baggs

  5. Hey there. I found your site by means of Google at the same time as searching for a comparable matter, your site got here up. It looks great. I have bookmarked it in my google bookmarks to come back then. Daile Francois Puklich

  6. I simply had to say thanks yet again. I am not sure the things that I would’ve created without the actual concepts shown by you concerning my problem. It previously was a real alarming condition in my circumstances, but understanding your specialised strategy you processed it forced me to weep with joy. I will be grateful for the guidance and hope that you find out what a powerful job you happen to be undertaking instructing most people via your website. I’m certain you’ve never encountered any of us.

  7. Can I just say what a relief to discover somebody
    who really knows what they are discussing online.

    You certainly realize how to bring a problem
    to light and make it important. More and more people ought
    to look at this and understand this side of the story.
    It’s surprising you are not more popular since you surely possess the gift.

  8. I simply wanted to jot down a quick note to be able to thank you for those magnificent guidelines you are sharing here. My time-consuming internet search has now been recognized with professional facts and techniques to talk about with my friends and classmates. I would admit that many of us site visitors are quite lucky to dwell in a decent place with so many marvellous individuals with very helpful plans. I feel truly grateful to have used your entire web pages and look forward to plenty of more enjoyable times reading here. Thanks a lot once again for everything.

  9. I just wanted to develop a small message so as to say thanks to you for the magnificent facts you are showing on this site. My time consuming internet search has finally been honored with excellent tips to go over with my two friends. I ‘d express that many of us site visitors are very much lucky to exist in a useful website with very many lovely individuals with valuable points. I feel truly fortunate to have discovered the web site and look forward to really more entertaining times reading here. Thank you once more for all the details.

  10. Thanks a lot for giving everyone remarkably superb possiblity to check tips from this site. It’s always so pleasing and as well , packed with a great time for me personally and my office acquaintances to search your web site at the least thrice per week to read the fresh issues you have. Of course, I’m just at all times happy for the fantastic secrets served by you. Certain 1 points in this posting are completely the most efficient I have had.

  11. Thank you a lot for giving everyone a very memorable possiblity to check tips from here. It can be so sweet and also stuffed with amusement for me personally and my office colleagues to search your site no less than thrice every week to read through the new things you have got. Not to mention, I’m just at all times astounded with all the wonderful tactics you serve. Certain 4 areas in this post are essentially the simplest we’ve had.

  12. I wish to express appreciation to this writer just for rescuing me from this type of incident. Just after researching throughout the the web and seeing solutions that were not helpful, I thought my life was over. Being alive devoid of the answers to the problems you have fixed through your review is a crucial case, and those that could have badly damaged my career if I hadn’t come across your blog post. Your main talents and kindness in touching every aspect was priceless. I don’t know what I would have done if I had not encountered such a step like this. I’m able to at this point relish my future. Thanks so much for this reliable and effective guide. I will not be reluctant to suggest your web page to any person who needs to have support on this subject.

  13. Excellent blog! Do you have any suggestions for
    aspiring writers? I’m hoping to start my own site soon but I’m a little lost on everything.

    Would you advise starting with a free platform like WordPress or go for a paid option?
    There are so many choices out there that I’m completely confused ..
    Any suggestions? Thanks a lot!

Leave a Reply

Your email address will not be published. Required fields are marked *