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

### Common Excel Functions

**Details: **Common **Excel** Functions This page is a glossary of all of the **Excel** terms we have defined on this site. It’s certainly not an exhaustive list of all **Excel** functions, but rather a working list of those terms you’re almost sure to run into as a beginner to intermediate **Excel** user.

› Verified *9 days ago*

› Url: https://excelnerds.com/microsoft-excel-functions/ Go Now ^{}

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

### Min and Max Functions in Excel

**Details: **Alternative to MIN and MAX: Filters. If you didn’t already know the MIN and MAX functions, you can get to the right answer using filtering. Simple select your data set and click the filter button in the menu bar. You can choose from A-Z (lowest to highest) or Z-A (highest to lowest). This feature works with numbers even though the buttons are

› Verified *Just Now*

› Url: https://excelnerds.com/excel/min-and-max-functions-in-excel/ Go Now ^{}

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

### Excel Tutorial for Beginners (Run Time ~30 Minutes

**Details: ****Excel** Tutorial for Beginners (Run Time ~30 Minutes) This is a crash in Microsoft **Excel** for total beginners. We’ll start by introducing ourselves to the workbook, slowly working our way up to more advanced features and eventually analyzing small data sets.

› Verified *9 days ago*

› Url: https://excelnerds.com/videos/excel-tutorial-for-beginners-run-time-30-minutes/ Go Now ^{}

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

### 100 Essential Excel Functions (Intermediate)

**Details: **100 Essential **Excel** Functions **(Intermediate**) In this course we’ll go over 100 different functions in **Excel** you should know if you want to work as a analyst, better contribute to your current organization, or just understand the true power of **Excel**.

› Verified *8 days ago*

› Url: https://excelnerds.com/courses/100-essential-excel-functions-course/ Go Now ^{}

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

### Using SUMIFS in Excel to Analyze a Budget

**Details: **Creating a budget in **Excel** can be a painstaking process. Auditing what you spend on groceries, entertainment, rent, utilities, etc.. every month is a sobering exercise. However, if you know your way away some common functions in **Excel** in addition to Pivot Tables, the process will feel less like a burden.

› Verified *1 days ago*

› Url: https://excelnerds.com/excel/using-sumifs-in-excel-to-analyze-a-budget/ Go Now ^{}

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

### How to Calculate the Rate of Change in Excel (Shortcut

**Details: **In this post I’ll show you a quick **excel** shortcut for calculating a rate of change. Rate of change is defined as the “rate at which one quantity changes in relation to another”. You may be looking at spending over time, changes in prices, website traffic, social media engagements, or any number of different metrics.

› Verified *3 days ago*

› Url: https://excelnerds.com/excel/how-to-calculate-the-rate-of-change-in-excel-shortcut/ Go Now ^{}

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

### Using SUBSTITUTE and CHAR to remove a block

**Details: **This formula is close, but CHAR(10) is what **Excel** knows to mean a paragraph break. Using the ampersand sign is a quick way to concatenate two values together. So instead of looking for the url by itself, we’re looking for two paragraph breaks followed by the url , …

› Verified *9 days ago*

› Url: https://excelnerds.com/excel/using-substitute-and-char-to-clean-text/ Go Now ^{}

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

### The IF Function in Excel & Boolean Logic

**Details: **If new to **Excel** and building formulas, there’s a concept I think is very important to understand before learning to build formulas using IF, SUMIF, COUNTIF, etc.. It’s called Boolean Logic. Don’t let the name throw you! Underneath the hood of this concept is the simple reality that all you’re doing is building statements that equate to […]

› Verified *8 days ago*

› Url: https://excelnerds.com/excel/the-if-function-in-excel-boolean-logic/ Go Now ^{}

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

### Comparison Operators

**Details: **Comparison operators are very helpful in **Excel** to force a Boolean result from a formula. Once we test two values against each other, we can return a desired result based on whether the outcome is TRUE or FALSE. Here is a list of the most common comparison operators: Equal Sign (=): Checks if …

› Verified *6 days ago*

› Url: https://excelnerds.com/excel/comparison-operators-excel/ Go Now ^{}

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

### Using AUTOFILL in Excel

**Details: ****Excel** can pick up a variety of different patterns when you want to use autofill to your advantage. For number sequencing, all you have to do is type in a pattern that will increase by one number in each cell, as shown above. Next, select both B1 and B2 and drag the autofill handle down. Now that it recognized our sequence, it will continue

› Verified *Just Now*

› Url: https://excelnerds.com/excel/using-autofill-in-excel-part-1/ Go Now ^{}

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

### Essentials of Microsoft Excel (Beginner)

**Details: **27 Ways to Clean Data in MS **Excel** (Advanced) Working as a data analyst can present you with a large variety of data sets. It’s very important to know how to clean . Courses. Pivot Tables and Lookup Formulas (Intermediate)

› Verified *8 days ago*

› Url: https://excelnerds.com/courses/essentials-of-microsoft-excel-course/ Go Now ^{}

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

### How to use Paste Special in Excel

**Details: **By leaving in formulas that have already yielded their desired result, we risk slowing down **Excel**. Also, if you want to paste these values into another sheet or workbook, **Excel** will still try to calculate “=C2/B2” on the new workbook, when you only want to paste the result. …

› Verified *3 days ago*

› Url: https://excelnerds.com/excel/how-to-use-paste-special-in-excel/ Go Now ^{}

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

### Manipulating Text in Excel

**Details: **There are many times in **Excel** when you only need to extrapolate or evaluate PART of a cell. For this, the following functions will come in very handy: LEN () Used to find the length of a string/integer within a cell Example: The ID of students at ACME Community College all have 9 digits. A […]

› Verified *5 days ago*

› Url: https://excelnerds.com/excel/manipulating-text-in-excel-len-right-left-mid/ Go Now ^{}

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

### Using AUTOFILL in Excel

**Details: **Merging cells in **Excel** is easy. 99% of the time this is done for formatting improvements. Below we’ll learn how to . **Excel**. How to Use the SUMIF Function. The Sum formula is one of the most common formulas that you’ll use in **Excel**. This formula allows you to add up the . **Excel**.

› Verified *Just Now*

› Url: https://excelnerds.com/excel/using-autofill-in-excel-part-2/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to use INDEX and MATCH together

**Details: **To use them together, one must first understand how they operate independent of each other. The INDEX () Formula – Returns a value from an array given the row and column number. The MATCH () Formula – Returns the row number of a match to a given argument. **Excel**.

› Verified *5 days ago*

› Url: https://excelnerds.com/excel/how-to-use-index-and-match-together/ Go Now ^{}

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

### Data Analysis in Microsoft Excel (Beginner)

**Details: **Learn Microsoft **Excel** – Functions, Formulas, and Pivot Tables What you’ll learn How to create Pivot Tables to quickly summarize data How to use VLOOKUP and INDEX/MATCH to pull out specific info from large data sets How to use basic math/statistical functions like SUM, AVERAGE, COUNTIFS, and more… How to build conditional statements using the […]

› Verified *1 days ago*

› Url: https://excelnerds.com/courses/data-analysis-in-microsoft-excel-course/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Clean Large Text Strings (LEN, CHAR

**Details: **The CHAR function is an amazing function to get familiar with if you’re cleaning up text data at all. Every OS has a character set (hence “CHAR”) used to classify characters in **Excel**. Here is the link to the Windows List. Capital ‘A’ is character 65. Lower case ‘g’ is 103.

› Verified *1 days ago*

› Url: https://excelnerds.com/excel/how-to-clean-large-text-strings-len-char-concatenate-and-more/ Go Now ^{}

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

### How to Use CONCATENATE in Microsoft Excel

**Details: **CONCAT – This function is new beginning in the 2016 version of **Excel**. It provides a very simple update to the same formula, and that is the ability to select an entire range of strings all at once in order to concatenate them. Example: Combining Five Values together.

› Verified *1 days ago*

› Url: https://excelnerds.com/excel/how-to-use-concatenate-in-microsoft-excel/ Go Now ^{}

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

### How to Use the SUMIF Function

**Details: **The Sum formula is one of the most common formulas that you’ll use in **Excel**. This formula allows you to add up the values within a range or sum a number of values separated by a comma. Either way is fine. Sum() Format: Sum(A1:D4) or Sum(A1,B1) Here we’ve used sum to find the total number […]

› Verified *5 days ago*

› Url: https://excelnerds.com/excel/how-to-use-the-sumif-excel-function/ Go Now ^{}

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

### How to Merge Cells in Excel (with Video)

**Details: **Merging cells in **Excel** is easy. It's usually done for formatting improvements but can serve a variety of purposes. In this post we'll learn how to merge cells and an easy keyboard shortcut you can use to do it.

› Verified *Just Now*

› Url: https://excelnerds.com/excel/merge-and-center-text-across-cells-video/ Go Now ^{}

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

### AVERAGE vs. AVERAGEA vs. AVERAGEIFS

**Details: **The AVERAGE functions in **Excel** are nice set of functions to get under your tool belt if data analysis is at all part of your workflow. Let’s take a look at the data set below and dive in. We have count of sales by make and by month. In this example, we’re trying to assess […]

› Verified *3 days ago*

› Url: https://excelnerds.com/excel/average-vs-averagea-vs-averageifs/ Go Now ^{}

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

### 27 Ways to Clean Data in MS Excel (Advanced)

**Details: **27 Ways to Clean Data in MS **Excel (Advanced**) Working as a data analyst can present you with a large variety of data sets. It’s very important to know how to clean data in **Excel** when you’re presented with something that isn’t structured.

› Verified *8 days ago*

› Url: https://excelnerds.com/courses/how-to-clean-data-in-ms-excel-course/ Go Now ^{}

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

### How to Compare Two Lists in Excel

**Details: ****Excel** searches for each of the values in column C inside of column A. The numbers returned are the ROW in column A where a match was found, while #N/A simply means there was no match found. By wrapping this function in the ISNUMBER function, we can simplify this to only return TRUE (if a row number is found) or FALSE (error, no match).

› Verified *3 days ago*

› Url: https://excelnerds.com/excel/how-to-compare-two-lists-in-excel/ Go Now ^{}

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

### Using IFERROR to trap and handle errors

**Details: **Example 1: Dividing by Zero. In this** example,** we’re diving column A by column B to produce column C. Further down column C, we have some “#DIV/0!” errors, which just means we divided by zero. In this case, we can use IFERROR to change the result of those errors. In this** example,** we’ve simply programmed the formula to spit out the word

› Verified *9 days ago*

› Url: https://excelnerds.com/excel/using-iferror-to-trap-and-handle-errors/ Go Now ^{}

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

### How to Use Excel's COUNT Functions

**Details: **COUNTA (): Returns the number of non-blank** cells** from a given range. Based on the same data set, we get a COUNTA value of 5, because all 5** cells** in our range have some value in them. Let’s see what happens when we extend our range to F3:F10: The value is still 5 because** cells** F8:F10 had nothing in them. COUNTA is a very useful formula for

› Verified *5 days ago*

› Url: https://excelnerds.com/excel/count-counta-countif-countifs-excel-functions/ Go Now ^{}

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

### REMOVE DUPLICATES in Excel

**Details: **Purpose of the Feature: Remove Duplicates is a feature in **Excel** that can removes duplicate values from a set of data, often very useful when creating index tables, cleaning data, and matching up disparate data sets.. Final Result: A list of cells with all of the duplicates removed.. Example: Below we have a list of videos, their categories, and views for this period.

› Verified *3 days ago*

› Url: https://excelnerds.com/excel/remove-duplicates-excel/ Go Now ^{}

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

### DATE vs. DATEDIF Functions

**Details: **It’s no surprise that **Excel** is often used for time based reporting, whether analyzing trends over time, creating a financial model or just analyzing your own personal budget. There are over 20 Date and Time functions in **Excel**’s library to handle every imaginable type of date/time calculation. Here are two of the most important. The […]

› Verified *5 days ago*

› Url: https://excelnerds.com/excel/date-vs-datedif-functions/ Go Now ^{}

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

### How to Compare Lists in Excel (Video)

**Details: ****Excel** Nerds 0 Comments. In this video we share two methods for comparing two lists: 1. ISNUMBER+MATCH. 2. VLOOKUP. Both can be effective, but I’ll tell you which one I prefer. compare lists **excel**. compare values.

› Verified *6 days ago*

› Url: https://excelnerds.com/videos/how-to-compare-lists-in-excel-video/ Go Now ^{}

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

### How to Use Index & Match (Video)

**Details: ****Excel** Nerds 0 Comments. INDEX & MATCH can be used together as a very powerful combination of functions. This combination is often used in place of VLOOKUP (depending on the type of data you’re working with) Learn how to use them in the video below! Data Analysis. **Excel**. index and …

› Verified *9 days ago*

› Url: https://excelnerds.com/videos/how-to-use-index-match-video/ Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Delete Extra Columns and Rows (Video)

**Details: **Some keyboard shortcuts for deleting extra rows and columns in **Excel** #**excel** #excelnerds #microsoftexcel #microsoft #data #dataanalytics #datascience #spreadsheets #googlesheets #google #instagram #video #shortcut #lifehacks #row #column #learn #elearning. A post shared by **Excel** Nerds (@excelnerds) on Mar 21, 2019 at 11:11pm PDT

› Verified *3 days ago*

› Url: https://excelnerds.com/videos/how-to-delete-extra-columns-and-rows-video/ Go Now ^{}

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

### Common Errors in Excel (Video)

**Details: ****Excel** Nerds 0 Comments. In this video we discuss the most common types of errors in **Excel**, including the N/A error, Value error, divide by zero error, name error, and more. common errors **excel**. Data Analysis. errors. errors in **excel**. **Excel**. formulas. Functions.

› Verified *9 days ago*

› Url: https://excelnerds.com/videos/common-errors-in-excel-video/ Go Now ^{}

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

### Courses Archives

**Details: **In this course we’ll go over 100 different functions in **Excel** you should know if you want to work as a analyst, better . Courses. Data Analysis in Microsoft **Excel** (Beginner) Learn Microsoft **Excel** – Functions, Formulas, and Pivot Tables What you’ll learn How to create Pivot Tables to .

› Verified *Just Now*

› Url: https://excelnerds.com/category/courses/ Go Now ^{}

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

### How to Use Vlookup (Video)

**Details: **How to Use Vlookup **(Video**) **Excel** Nerds 0 Comments. Vlookup is a very useful function for looking up data from a table, comparing two lists, matching data sets, and much more! Learn how to use it in the video below! **Excel** Functions. hlookup. index and match. index formula.

› Verified *5 days ago*

› Url: https://excelnerds.com/videos/how-to-use-vlookup-video/ Go Now ^{}

› Get more: How to useGo Now ^{}

### Pivot Tables (Video)

**Details: **A pivot table is a feature of Microsoft **Excel** that allows a user to quickly summarize and analyze a large set of data. Everything that a pivot table does can be done by hand or by using other **Excel** formulas. However, pivot tables often speed up the process and allow the person receiving the report […]

› Verified *9 days ago*

› Url: https://excelnerds.com/videos/pivot-tables-video/ Go Now ^{}

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

### Functions Archives

**Details: **DAYS – **Excel** Function. What it does: The DAYS() function returns the number of days in between two dates Plain English: In your data cleaning . Functions Informational Functions. ISNUMBER – **Excel** Function. What it does: The ISNUMBER() function checks to see whether the given argument is a number. Plain English: The ISNUMBER

› Verified *9 days ago*

› Url: https://excelnerds.com/category/functions/page/3/ Go Now ^{}

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

### Top Categories

### Recently Searched

› Excel address validation usps

› Microsoft excel object library 16.0

› Download excel 2007 for pc free

### 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