Welcome to the Excel Basics page. This section is designed to teach you how to use Excel. Included below, are tutorials on how to create Excel formulas, using mathematical and logical operators to perform calculations and evaluate criteria, a description of how to use Excel Cell references, copying and pasting data, and using dates in Excel.
Formulas are equations that perform calculations on values in your worksheet. A formula always starts with an equal sign (=). You can create a simple formula by using numbers you type into a cell or directly into a formula (typed numbers are referred to as constants) separated by calculation operators. Click the link above for more information on creating formulas in Excel.
Excel is not only a great way to store and organize data, it is also a powerful calculation tool that can add, subtract, multiply and divide. Click the link above for more information on performing calculations in Excel.
Excel can also evaluate logical arguments such as greater than, less than, not equal to, equal to, etc. When you enter a logical expression in a formula, Excel will evaluate the equation and will result in either TRUE or FALSE. Click the link above for more information on logical operators in Excel.
The three types of cell references in Excel are relative, absolute, and mixed. The differences among the types are relative references change when a formula is copied to another cell and absolute references remain the same despite where they are copied. In the case of a mixed reference, either the column or row will be absolute while the other is relative. Click the link above for more information and examples of how to create and use relative, absolute and mixed cell references in Excel.
Using the Cut, Copy, and Paste commands in Microsoft Excel, you can move or copy entire cells or their contents. Using the Paste Special menu you can and paste specific content or attributes from the cells. Click the link above for more information on how to cut, copy and paste in Excel.
In Excel, Dates are stored as numbers, which allows for the addition, subtraction, or comparison of dates. Click the link above for more information how enter, format, and to learn how to add and subtract dates.