Divide in Excel Example-1 | Example-2 | Example-3 In Excel, you can divide a number by another by typing in a formula. Unfortunately, there is no built-in divide function in Excel. Below are a few examples of this operation. Example-1 1. Select cell F3. 2. Type in an equal sign (=) and then divide D3 […]
How to Divide in Excel Read More »
Multiply in Excel Example-1 | Example-2 | Example-3 In Excel, you can multiply two or more numbers by using a formula, function, or paste specials. Below are a few examples of this operation. Example-1 1. Select cell F3. 2. Type in equal sign (=) and then multiply D3 and E3. = E3*D3 Note: Similarly, you
How to Multiply in Excel Read More »
Subtract in Excel Example-1 | Example-2 | Example-3 In Excel, you can subtract a number from another by typing in a formula. Unfortunately, there is no built-in subtract function in Excel. Below are a few examples of how to subtract in Excel. Example-1 1. Select cell D6. 2. Type in equal sign (=) and then
How to Subtract in Excel Read More »
Most Used Functions in Excel Functions in Excel make your calculation a lot easier. In this lesson, we are going to show the ten most widely used functions in Excel- COUNT, SUM, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP, MIN, MAX, and SUMPRODUCT. 1. COUNT COUNT function in Excel counts the number of cells containing numeric values.
Most Used Functions in Excel Read More »
Using Formulas and Functions in Excel Enter Formula | Edit Formula | Copy & Paste Formula | Insert Function A formula in Excel is an expression of an equation to calculate a value whereas a function is a pre-defined formula. One good thing is that we can use functions in our formula. To be specific,
Using Formulas and Functions in Excel Read More »
Insert Check Mark in Excel You can insert a check mark (aka. tick mark) in Excel by using the font “Wingdings 2” or inserting a symbol. These static symbols are useful to make an eye-catching to-do list. 1. Select cell D3 and press SHFT + P on your keyboard. 2. Select Font “Wingdings 2” on
How to insert a Check Mark in Excel Read More »
Superscript and Subscript in Excel Superscript and subscript in Excel are formatting styles wherein a character is slightly above and below the baseline, respectively. Here is an example: (a) superscript- B2 (b) subscript- B2. 1. Double-click cell B2 to get the cursor inside the cell. 2. Select the value 2, right-click, and then click “Format
Using Superscript and Subscript in Excel Read More »
Strikethrough Text in Excel Keyboard Shortcut | Partial Strikethrough | Add a Button Strikethrough text in Excel is a formatting option that draws a horizontal line through a value in a cell. This style is used to indicate the deletion of an error or the removal of text in a draft. This is an extra
How to Strikethrough Text in Excel Read More »
Merge Cells in Excel If you like to put a label representing more than one cell, you need to merge multiple cells into one. By default, Excel will keep the information of the first cell and the rest of the cells’ information gets deleted. To merge cells, follow the steps below. In the table below,
How to Merge Cells in Excel Read More »
Wrap Text in Excel Using Line Break Wrap text in Excel is a useful command to display long text in a single cell. In this lesson, we will show two ways to wrap text – automatic wrapping and using a line break. Wrap Text Automatically 1. Select cell B4. 2. Click “Wrap Text” on the
How to Wrap Text in Excel Read More »
