Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data and integrating information from different programs. By default, documents saved in Excel 2010 are saved with the.xlsx extension whereas the file extension of the prior Excel versions are.xls. Essential Fundamentals of EXCEL 2010 Page 4 of 19 What is Excel? Microsoft Excel is a spreadsheet program which allows one to enter numerical values or data into the rows or columns of a spreadsheet, and to use these numerical entries for such things as calculations, graphs, and statistical analysis. Excel is a spreadsheet program that. Microsoft Excel 2010 is one of the most popular software applications worldwide and is part of the Microsoft Office 2010 productivity suite. This course will help you switch to Excel 2010 from a previous version of the software, and will give you a thorough knowledge and understanding of Excel and its applications if you have never used it before. 'Waterfall' Chart in Microsoft Excel 2010 In this article we will learn how we can make waterfall chart in Microsoft Excel 2010. This chart is also known as the flying bricks chart or as the bridge chart. It’s used for understanding how an initial value is affected by a. Start Excel 2007 or Excel 2010. (In this article, we use Excel 2010 for example). Click File, and then click Options. In the Excel Options window, click Save. Under the Save files in this format drop-down menu, select Excel Workbook (.xlsx), and then click OK. Open an Excel file to confirm the issue is fixed.

• MS Excel Basics

• Editing Worksheet

• Formatting Cells

• Formatting Worksheets

• Working with Formula

• Advanced Operations

• MS Excel Resources

• Selected Reading

Row and Column Basics

MS Excel is in tabular format consisting of rows and columns.

• Row runs horizontally while Column runs vertically.

• Each row is identified by row number, which runs vertically at the left side of the sheet.

• Each column is identified by column header, which runs horizontally at the top of the sheet.

For MS Excel 2010, Row numbers ranges from 1 to 1048576; in total 1048576 rows, and Columns ranges from A to XFD; in total 16384 columns.

Excel 2010 &

Navigation with Rows and Columns

Let us see how to move to the last row or the last column.

• You can go to the last row by clicking Control + Down Navigation arrow.

• You can go to the last column by clicking Control + Right Navigation arrow.

Excel 2010

Cell Introduction

The intersection of rows and columns is called cell.

Excel 2010 Shortcuts Cheat Sheet

Cell is identified with Combination of column header and row number.

Excel 2010 Cd

For example − A1, A2.