Excel Basics

Creating Formulas 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.

Mathematical Operators:

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.

Logical Operators (Inequalities):

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.

Types of Excel Cell References:

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.

Cut, Copy, Paste and Paste Special

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.

Using Dates 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.


Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 32 bytes) in /home/kingpd/public_html/advancedexcelhelp.com/wp-includes/plugin.php on line 202