# Exceldemy.com how to use exel, tips & tricks excel

### 102+ Useful Excel Formulas Cheat Sheet PDF + Free …

**Details: ****Excel** Formulas with Examples in an **Excel** Sheet (Free Download .xlsx File) I have documented all the above **Excel** formulas in a single **Excel** sheet so that you can tweak the formulas to understand and practice it better. Click here to download the .xlsx file 102 Most Useful **Excel** Formulas with Examples A. IS FUNCTIONS 1. ISBLANK =ISBLANK(value)

› Verified *2 days ago*

› Url: https://www.exceldemy.com/wp-content/uploads/2021/09/Excel-Functions-List-v1.0.pdf Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to pull/extract data from a website into Excel

**Details: ****Excel** gives you the opportunity to collect data from a web page. Yes, **Excel** is awesome like that!! Let’s dive into the process of helping you out. But first, a word of caution: the web page must have data in collectible formats like Table or Pre-data format. Otherwise, it would be another battle to convert it to a readable or **excel**-able format.

› Verified *1 days ago*

› Url: https://www.exceldemy.com/extract-data-from-website-to-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Count Number of Occurrences of Each Value in a Column

**Details: **ExcelDemy is a place where you can learn **Excel**, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide **Excel** solutions to your business problems. ExcelDemy.**com** is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program.

› Verified *6 days ago*

› Url: https://www.exceldemy.com/excel-count-number-of-occurrences-of-each-value-in-a-column/ Go Now ^{}

› Get more: GuideGo Now ^{}

### Excel Compare Two Cells Text (9 Examples)

**Details: **ExcelDemy is a place where you can learn **Excel**, Data Analysis, and other Office related programs. We provide tips, how to guide and also provide **Excel** solutions to your business problems. ExcelDemy.**com** is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program.

› Verified *5 days ago*

› Url: https://www.exceldemy.com/excel-compare-two-cells-text/ Go Now ^{}

› Get more: GuideGo Now ^{}

### Using Excel to get data from another sheet based on cell …

**Details: **In 1 **excel** – sheet 3 is where formula is to go, reference by name is in column A, sheet 1 is where to retrieve information from, Column A is name, Column B is date, Column C is Distance – so on across 20 columns. Name by latest date, 2nd latest date, & third latest date.

› Verified *Just Now*

› Url: https://www.exceldemy.com/excel-get-data-from-another-sheet-based-on-cell-value/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Make FOR LOOP in Excel Using Formulas

**Details: **These are not that tough to understand. All these four modifications are working as FOR LOOPS of **Excel** VBA but I’ve built them with **Excel** Formulas. So you got the ways how the general formula works for the cells from A2: A31. So we were talking about Looping in **Excel** spreadsheets. This is a perfect example of looping in **Excel**.

› Verified *4 days ago*

› Url: https://www.exceldemy.com/make-for-loop-in-excel-using-formulas/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Solving equations in Excel (polynomial, cubic, quadratic

**Details: **Solving Polynomial Equations in **Excel**. A polynomial equation/function can be quadratic, linear, quartic, cubic, and so on. The Polynomial equations don’t contain a negative power of its variables. Different kind of polynomial equations example is given below. 1) Monomial: y=mx+c.

› Verified *3 days ago*

› Url: https://www.exceldemy.com/solving-equations-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using FORMAT & TEXT Functions in Excel (68 Easy …

**Details: **And **Excel** will give you a prompted message like “Sub or function not defined” if you use TEXT function in VBA. Figure 4 [click on the image to get a full view] Download working file. Download the working file from the link below. …

› Verified *1 days ago*

› Url: https://www.exceldemy.com/text-and-format-functions-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to calculate years of service in Excel (3 easy ways

**Details: **There is a built-in function in **Excel** that can give you the present date. This function is the TODAY function. It is written in **Excel** as, =TODAY (). This function is categorized as Date/Time function in **Excel**. It can be used in a formula also. Like, in the previous examples we worked with some random dates.

› Verified *9 days ago*

› Url: https://www.exceldemy.com/how-to-calculate-years-of-service-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel formula to find difference between two numbers

**Details: ****Excel** formula to calculate the percentage of the grand total (4 Easy Ways) Percentage Difference Between Two Numbers In **Excel** (Using Formula) Conclusion. Calculating the difference between two positive or negative numbers in **Excel** is actually very simple.

› Verified *4 days ago*

› Url: https://www.exceldemy.com/excel-difference-between-two-numbers-positive-or-negative/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using Excel to Lookup Partial Text Match [2 Easy Ways

**Details: ****Excel** lookup partial text match (using VLOOKUP) In cell G3, we use this formula: =VLOOKUP (“*”&F3&”*”,company,1,0) And then copy-paste the formula for other cells in the column. And this is what we get.

› Verified *8 days ago*

› Url: https://www.exceldemy.com/excel-lookup-partial-text-match/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Separate Words in Excel Using Formula (Ultimate Guide)

**Details: **Microsoft **Excel** – Data Analysis with **Excel** Pivot Tables (Affiliate link) Related Articles. How to Split Cells in **Excel** (The Ultimate Guide) Text to Columns in **Excel** (Split Column, Text, Date, …) Separate, Split & Remove Substring & Number from Text with **Excel** Functions & VBA; Splitting Text in **Excel** Using Flash Fill

› Verified *1 days ago*

› Url: https://www.exceldemy.com/how-to-separate-words-in-excel-using-formula/ Go Now ^{}

› Get more: GuideGo Now ^{}

### Reduce Large Excel File Size by 40-60% (12 Proven Methods)

**Details: **Saving the **excel** file from a .xlsx format to an **excel** binary format (.xlsb), reduces the size of your file by around 40%. This is the easiest and most efficient way of reducing your file size. The procedure is given below. We will be saving our sample **excel** file in .xlsx format and then in XLSB format to check whether the file size is reduced

› Verified *9 days ago*

› Url: https://www.exceldemy.com/reduce-excel-file-size/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Opposite of Concatenate in Excel (4 Options)

**Details: **4 Methods That Work As Opposite of Concatenate in **Excel** 1. Split Text into Multiple Cells with Formula. In the following table, Column B contains five distinct cells, each of which has three random names separated by a common delimiter ‘Comma’ (,).Under three headers named Part 1, Part 2 and Part 3 will occupy the names separately from each cell in …

› Verified *9 days ago*

› Url: https://www.exceldemy.com/opposite-of-concatenate-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Exponential Notation E in Excel & How to Turn Off Auto

**Details: **So, **Excel** automatically turns a number in scientific notation if the cell width is not sufficient for the number. Sometimes, you might want to stop this auto converting of numbers into scientific notation.

› Verified *1 days ago*

› Url: https://www.exceldemy.com/excel-exponential-notation-and-turn-off-auto-scientific-notation/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to create a database in Excel (make in 8 easy steps

**Details: ****Excel** on the other hand is a little more familiar and easier to handle. If you design your **Excel** workbook correctly, you can use it as a database easily. The main key point is: you have to design your workbook correctly. You can sort data in many different ways; you can filter the database to see only the data that matches some specific

› Verified *9 days ago*

› Url: https://www.exceldemy.com/create-database-excel-easy-steps/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to apply same formula to multiple cells in Excel (8

**Details: ****Excel** formula to compare two columns and return a value (5 examples) **Excel** Formula to Calculate Hours Worked Minus Lunch; Conclusion. Well, this is all I know about applying the same formula to multiple cells in **Excel**. If you know any other methods discussed in this tutorial, let us know in the comment box. Thanks for reading our **Excel** tutorials.

› Verified *2 days ago*

› Url: https://www.exceldemy.com/apply-same-formula-to-multiple-cells-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Make a Frequency Distribution Table & Graph in Excel

**Details: **By default, **Excel** will not display the values below 21 and above 100 as we have set Starting at value as 21 and Ending at value as 100. But you can force to display the empty bins. To display empty items, you have to right-click on any cell under Row Labels and choose Field Settings from the shortcut menu.

› Verified *6 days ago*

› Url: https://www.exceldemy.com/frequency-distribution-excel-make-table-and-graph/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Compare Two Columns in Excel For Finding Differences

**Details: **Read More: How to Compare Two Columns in **Excel** Using VLOOKUP. Compare Two Columns in **Excel** & Returns the Difference. Here we will be using IF, ISERROR, and MATCH functions to compare two columns. We will compare List-1 with List-2. The formula will calculate the two lists and will return the fruit’s name which is only in List-1.

› Verified *2 days ago*

› Url: https://www.exceldemy.com/how-to-compare-two-columns-in-excel-to-find-differences/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### SUMIFS Multiple Columns in Excel (5 Types of Application

**Details: **SUMIFS function is an **Excel** function that adds all values based on multiple criteria. This function was introduced in 2007. From its initiation, it’s becoming popular day by day. =SUMIFS (sum_range, range1, criteria1, [range2], [criteria2], ) There are the following arguments in the function.

› Verified *Just Now*

› Url: https://www.exceldemy.com/sumifs-multiple-columns/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Reference PivotTable Data in Excel Formula with

**Details: **If you feel uneasy with the auto implementation of GETPIVOTDATA function in the **Excel** formulas, you can stop it! After you have created a pivot table, you may want to create formulas that will reference one or more cells within that pivot table. Here is the way how you can do that. Related: **Excel** Pivot Table Tutorials for Dummies [Step by Step]

› Verified *1 days ago*

› Url: https://www.exceldemy.com/how-to-reference-a-cell-within-a-pivot-table/ Go Now ^{}

› Get more: Step by stepGo Now ^{}

### Using Excel to Round to Nearest 1000 (7 Easy Ways)

**Details: ****Excel** Round to Nearest 1000 using the MROUND function. Another useful function that can be used to round number is the MROUND function. The syntax of the MROUND function is =MROUND (number, multiple). Here the number is the desired number which is rounded up/down. The multiple arguments are used here to round up or down the number to …

› Verified *4 days ago*

› Url: https://www.exceldemy.com/excel-round-to-nearest-1000/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel If Function with Multiple Conditions (Nested IF

**Details: **In **Excel** 2007 – 2016, a total of 64 conditions can be nested up while working with multiple ifs. You have to maintain a proper order while working with multiple ifs. If your formula contains too many ifs, it’s better to use OR and AND functions with that. The OR and AND functions usually reduce the formula size.

› Verified *4 days ago*

› Url: https://www.exceldemy.com/excel-if-function-multiple-conditions/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to add secondary axis in Excel (2 easy ways)

**Details: **1) Add secondary axis to **Excel** charts (the direct way) You can add the secondary axis to an **Excel** chart from the beginning when you’re making the chart. Here is the step-by-step procedure. 1) In this way, at first, select all the data, or select a cell in the data. You see, we have selected a cell within the data that we shall use to make the

› Verified *1 days ago*

› Url: https://www.exceldemy.com/how-to-add-secondary-axis-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to divide columns in Excel (Top 8 easy & quick ways)

**Details: ****Excel**’s Quotient function returns only the integer portion of a division. Here is the syntax of **Excel**’s QUOTIENT function: QUOTIENT(numerator, denominator) Check out the differences between the result done with the general **Excel** formula and …

› Verified *7 days ago*

› Url: https://www.exceldemy.com/how-to-divide-columns-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Lookup with Multiple Criteria in Excel (Both AND or

**Details: **Before going to the main point, you can have a glance at the XLOOKUP function of **Excel**. The XLOOKUP formula to find out the employee with an ID greater than 400 and a salary greater than $40,000 will be: =XLOOKUP (1, (B4:B20>400)* (E4:E20>40000),C4:C20) See, we have got the same employee as earlier, Richard Samuelson. Explanation of the Formula.

› Verified *6 days ago*

› Url: https://www.exceldemy.com/lookup-with-multiple-criteria/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to split a single cell in half in Excel (diagonally

**Details: **How to split a cell diagonally in **Excel** using objects (effective in some cases) This is another method of splitting a cell in half in **Excel**. We shall use the Right Triangle Object to split a cell half in this way. Let’s start. Select a cell that you want to split and input one word (Employee) and make it Top Align.

› Verified *3 days ago*

› Url: https://www.exceldemy.com/how-to-split-a-cell-in-half-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Index Match with Multiple Matches in Excel (5 Methods

**Details: ****Excel** provides different functions and ways to fetch matching values. Depending on the situation, users can choose their preferences. This tutorial is going to show you how to gain results using INDEX MATCH with multiple matches in **Excel**. First things first, let’s get to know about today’s workbook.

› Verified *Just Now*

› Url: https://www.exceldemy.com/index-match-with-multiple-matches/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Copy and Paste Multiple Cells in Excel (7 Quick Ways)

**Details: **Copying and Pasting values in **Excel** is a very easy task. You need to know some tricks while applying this for a wide range of cells. Here we discussed many methods that you can choose. Hope this article will be useful for beginners who want to learn the basics of **Excel**.

› Verified *2 days ago*

› Url: https://www.exceldemy.com/how-to-copy-and-paste-multiple-cells-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Switch first and last name in Excel with comma (5 Easy Ways)

**Details: **Select the cells where the names are and then open the Text to Columns wizard of **Excel** ( Data > Data Tools > Text to Columns) Keyboard shortcut to open the Text to Columns wizard: ALT + A + E. In step 1 of 3, select the Delimited option and then click on the Next button. In step 2 of 3, select Space as the Delimiter. And click on the Next.

› Verified *3 days ago*

› Url: https://www.exceldemy.com/switch-first-and-last-name-in-excel-with-comma/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel Formula to Add Percentage Markup [with Calculator

**Details: ****Excel** Formula to Add Percentage Markup to a List of Products. Suppose, you have a list of products and you want to add different Markup % to those products. On one occasion, you can offer your customers one Markup % (say 30%) and on another occasion, you may offer a different Markup % (say 40%). All these pricing can be done in one **Excel** sheet.

› Verified *5 days ago*

› Url: https://www.exceldemy.com/excel-formula-to-add-percentage-markup/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to auto populate date in Excel when cell is updated

**Details: **8) Choose **Excel** Macro-Enabled Workbook (.xlsm) option from the Save as type menu and save the file newly. Choose the **Excel** Macro-Enabled Workbook (.xlsm) from the options. So, this is the whole procedure to auto-populate a cell when a …

› Verified *5 days ago*

› Url: https://www.exceldemy.com/auto-populate-date-in-excel-when-cell-is-updated/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to calculate future value with inflation in Excel

**Details: **Download **Excel** File. Download the **Excel** file that I have used to write this article. Calculate-future-value-with-inflation-in-**Excel**. Calculate future value with inflation in **Excel** (Two Examples) We shall calculate the future value with inflation in more than one way: Example 1: Start with an initial investment and no recurring deposits

› Verified *Just Now*

› Url: https://www.exceldemy.com/how-to-calculate-future-value-with-inflation-in-excel/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Make Excel Spreadsheet Bigger when Printing (Easy

**Details: **How to make an **Excel** spreadsheet look bigger when printing. Before going into the main discussion, let me clear one confusion. Don’t confuse with the phrase “making spreadsheet bigger”.You cannot make a spreadsheet bigger in size by its rows (total rows: 1048576) and columns (total columns: 16384) numbers.

› Verified *Just Now*

› Url: https://www.exceldemy.com/make-excel-spreadsheet-bigger-when-printing/ Go Now ^{}

› Get more: How to makeGo Now ^{}

### Adding and subtracting in Excel in one formula (Easy way

**Details: **In **Excel**, you will not find any function called SUBTRACT that will perform the subtraction operation. You have to use the mathematical operator minus sign (-) to subtract two numbers. Note: But you get SUM function to add numbers or range of cells. Suppose, you want to subtract 50 from 500. Write a formula like the following:

› Verified *3 days ago*

› Url: https://www.exceldemy.com/adding-and-subtracting-in-excel-in-one-formula/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to Use VLOOKUP with COUNTIF (3 Ways)

**Details: **VLOOKUP and COUNTIF are mostly used and powerful functions in MS **Excel**.VLOOKUP is used to find any specific data from any table and the COUNTIF function is for counting elements using conditions.With the combined formula of these two functions, we can search and count any values with conditions from any range. In this article, I will show various …

› Verified *7 days ago*

› Url: https://www.exceldemy.com/vlookup-with-countif/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel formula to compare two columns and return a value (5

**Details: **We have used this formula in cell <code>C2: =IF(A2=B2, “Matched”, “Not Matched”). This is a straightforward **Excel** IF function. If the cells A2 and B2 are the same, “Matched” value will show in cell C2 and if the cells A2 and B2 are not the same, then the “Not Matched” value will show as the output.. This comparison is case-insensitive. “Milk” and “milk” …

› Verified *2 days ago*

› Url: https://www.exceldemy.com/excel-formula-to-compare-two-columns-and-return-a-value/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### How to reference cell in another Excel sheet based on cell

**Details: **Download **Excel** Worksheet. At first, download the working **Excel** file that I have used to write this article. **Excel**-reference-cell-in-another-sheet-based-on-cell-value.xlsx. **Excel** INDIRECT Function. **Excel** INDIRECT function returns the reference specified by a text string. Syntax of INDIRECT Function: INDIRECT(ref_text, [a1]) Here,

› Verified *4 days ago*

› Url: https://www.exceldemy.com/excel-reference-cell-in-another-sheet-based-on-cell-value/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Compound interest excel formula with regular deposits

**Details: ****Excel**’s FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate. Syntax of **Excel** FV function: FV(rate, nper, pmt, [pv], [type]) Here, rate (required) is the interest rate per period. If the yearly interest rate is 6% and payments are made every month per period rate will be 6%/12

› Verified *Just Now*

› Url: https://www.exceldemy.com/compound-interest-excel-formula-with-regular-deposits/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Excel conditional formatting based on another cell text [5

**Details: ****Excel** Conditional Formatting Entire Row Based on One Cell Text. Let`s say you want to highlight the names of the candidate along with the status of the final exam. Let`s work on the students who can sit for a retake. Here we will be using the same formula with a slight change.

› Verified *2 days ago*

› Url: https://www.exceldemy.com/excel-conditional-formatting-based-on-another-cell-text/ Go Now ^{}

› Get more: How To Use ExcelGo Now ^{}

### Using VLOOKUP with IF Condition in Excel (5 Real-Life

**Details: **2) **Excel** VLOOKUP with 2 Tables of Values. In this example, you will see how to use two or more table arrays in the **Excel** VLOOKUP formula. In the following image, you’re seeing how I have made a formula using VLOOKUP and IF …

› Verified *3 days ago*

› Url: https://www.exceldemy.com/excel-vlookup-if-condition/ Go Now ^{}

› Get more: How to useGo Now ^{}

### Top Categories

### Recently Searched

› Excel copy and paste without hidden columns

› Rounddown vba selection excel

› Excel formula to calculate totals

› Least square curve fit excel

### Trending Searches

› How to use the sumif function

› How to use the countif function

› How to use the excel time function

› How to merge data tables in excel

› How to fix a circular reference error

› Mathematical formulas in excel