How to use Excel 2007 Tutorial Excel 2013 Tutorial Excel Calculation Formulas

Welcome to maina.in, This post explains you the Basics of Microsoft Excel with Excel Tutorial video concentrating mainly on what is Excel Cell, What is Excel Rows, Columns How to Select the entire Row and Entire Column.Step by Step procedure of setting the Excel Calulation Forumalas like Additions, Substractions, Multiplications, and Calculating Avarage and How to Automatically change the Excel Cell Background Colour based on the Thresold Value.

What is Microsoft Excel? How it is Used in our Day to Day business Operation?

Microsoft Excel is an Excellent Software which comes up with Microsoft office package and it is used for storing the store the data, Creating Tables, Graphs, Charts, and automatically calculate the Many Formulas like additions, Subtraction etc to Function Vlookup, Pivot functionality and became the very popular software for Many official calculation, extractions or other needs for calculation of Data automatically by Formulas and helps to control costs more effectively and obtain business information.

As the name indicates it is really an "Excel" Excellent software from software gaint Microsoft

Microsoft Excel Spreadsheet looks in a Grid Layout consisting of Rows and Columns.


Microsoft Excel is used for extracting the system data to manipulate the data as per our business requirement using auto adjustments, sorting, Filtering and many other options.

Few great uses of Microsoft excel for Home as well as Business users are:
1) Data Storage 2) Calculations 3) Conditional Formating 4) Graphs and Charts 5) Compare critical data more easily

Below Microsoft Excel video tutorial helps you in getting the basic information of what Excel is, How Excel works for Data Storage, Calculations, Conditional formatting etc.

As discussed Excel spreadsheet designed in a grid layout with rows and columns of Cells.

The letters over the top are Column headings. To highlight a whole Column, click on any of the letters. The picture beneath shows the B highlighted Column

In the event that you look down the left half of the framework, you'll see numbers, which begin at number 1 and so on... if you drag down the spreadsheet. These are the Rows. to highlight the entire Row click on Row


Cell number is identified with the Column and Row number where it exist, for example in the above picture the yellow color cell is C6 as it is in Column C and Row 6.

Maximum number of rows and columns

A Microsoft Office Excel spreadsheet contains 65,536 rows and 256 columns. You cannot increase the number of rows or columns beyond the maximum row and column limits. If you want to check it yourself the maximum number of columns in your excel worksheet open your excel and select a cell and click CTRL+Right arrow which takes you to the last Column IV which is 256.

Similarly if you want to see excel last row select a cell and click CTRL + Down arrow which takes you to row number 65,536.


Versions of Excel up to 7.0 were limited to data sets containing up to 16K (2^14) rows. Versions 8.0 through 11.0 could handle 64K (2^16) rows and 256 columns (2^8 as label 'IV'). Version 12.0 can handle 1M (2^20=1048576) rows, and 16384 (2^14 as label 'XFD') columns. In the above sheet, Sheet1 Sheet2, Sheet3 etc are worksheets, you can create "n" number of worksheets and that depends on available resources

0 comments:

Post a Comment