How To Use Excel Basics

Type 3 in the cell then press enter on your keyboard.

How to use excel basics. Opening a spreadsheet when you first open excel by double clicking the icon or selecting it from the start menu the application will ask what you want to do. A workbook is another word for your excel file. When you start excel click blank workbook to create an excel workbook from scratch. Excel selects the ribbon s home tab when you open it. Excel formulas can be used for basic number crunching such as addition or subtraction as well as more complex calculations such as finding a student s average on test results and calculating mortgage payments.

Each topic includes a step by step example of how to create a formula that carries out one or more of the four basic math operations in excel. Basic formulas in excel excel has a variety of formulas and functions. In an article written in 2018 robert half a company specializing in human resources and the financial industry wrote that 63 of financial firms continue to use excel in a primary capacity. Cell c2 should be selected. Below are useful time links you may click on to skip to the exact type of excel.

This section explains the basics of excel. Granted that is not 100 and is actually considered to be a decline in usage but considering the software is a spreadsheet software and not designed solely as financial industry software 63 is still a. To make this job easier use the sum function. The equal sign is always typed into the cell where you want the answer to appear. If we want to insert a formula in excel then we need to get into the edit mode of the cell where we want to apply and then type equal sign.

Learn how to collapse and customize the ribbon. This process activates all the functions or formulas of excel. This video will demonstrate how to use and navigate through microsoft excel. Open a new excel file and select cell c1 to make it the active cell. Add numbers with the sum function.

If you want to open a new spreadsheet click blank workbook. Adding rows and columns of numbers is one of the most common operations in excel.