What Are the Basics of Using Microsoft Excel?

The basics of using Microsoft Excel 2013 include knowing how to create a new workbook, how to enter data in worksheet cells, how to create simple formulas and how to use the AutoSum function. Additionally, the basics include the application of different number formats and modifying data in a table.

Workbooks are Microsoft Excel documents that contain one or more worksheets. To create a new workbook, start Microsoft Excel 2013, click on the File button, click New, and select the Blank Workbook option. After creating a new workbook, add or remove worksheets by right-clicking on them and selecting the Insert or Delete options. To enter data in a cell, click on it, type the desired content, and then press Enter or Tab to switch to a different cell.

To create a formula in a cell, type the equal sign, and then type the desired numbers and calculation operators. Once you press Enter, Microsoft Excel automatically runs the calculation. To use numbers from other cells, type their cell designations instead of the numbers while creating the formula. To modify the number format, click on a cell, open the Home tab, open the drop-down menu in the Number section, and select the option that corresponds to the type of data contained in the cell. To modify or filter the data in a table, select it, click on the Quick Analysis button that appears in the bottom right corner, and choose the desired options.