# Excel-easy.com how to use, tutorial

### Basics of Excel - Easy Excel Tutorial

**Details: **This section explains the basics of Excel.. 1 Ribbon: Excel selects the ribbon's Home tab when you open it.Learn how to use the ribbon. 2 Workbook: A workbook is another word for your Excel file.When you start Excel, click Blank workbook to create an Excel workbook from scratch.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/basics.html Go Now ^{}

› Get more: How to useGo Now ^{}

### How to Split Cells in Excel - Easy Excel Tutorial

**Details: **Text to Columns. To split the contents of a cell into multiple cells, use the Text to Columns wizard.For example, let's split full names into last and first names. 1. Select the range with full names. 2. On the Data tab, in the Data Tools group, click Text to Columns.

› Verified *1 days ago*

› Url: https://www.excel-easy.com/examples/split-cells.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Excel Functions - Easy Excel Tutorial - Excel Easy

**Details: **Discover how functions in Excel help you save time. If you are new to functions in Excel, we recommend you to read our introduction to Formulas and Functions first.. 1 Count and Sum: The most used functions in Excel are the functions that count and sum.You can count and sum based on one criteria or multiple criteria.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/functions.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Pivot Tables in Excel - Easy Excel Tutorial

**Details: **Insert a Pivot Table. To insert a pivot table, execute the following steps.. 1. Click any single cell inside the data set. 2. On the Insert tab, in the Tables group, click PivotTable. The following dialog box appears.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/data-analysis/pivot-tables.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to Multiply in Excel - Easy Excel Formulas

**Details: **To multiply numbers in Excel, use the asterisk symbol (*) or the PRODUCT function. Learn how to multiply columns and how to multiply a column by a constant. 1. The formula below multiplies numbers in a cell. Simply use the asterisk symbol (*) as the multiplication operator.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/multiply.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the IF function - Easy Excel Formulas

**Details: **Simple If Examples | And/Or Criteria | Nested If | More about If. The IF function is one of the most used functions in Excel.This page contains many easy to follow IF examples. Simple If Examples. The IF function checks whether a condition is met, and returns one value if true and another value if false.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/if.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to Subtract in Excel - Easy Excel Formulas

**Details: **Take a look at the screenshot below. To subtract a number from a range of cells, execute the following steps. 5a. First, subtract the value in cell A8 from the value in cell A1.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/subtract.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the COUNTIF function - Easy Excel Formulas

**Details: **Numeric Criteria | Text Tricks | Count Booleans | Count Errors | And Criteria | Or Criteria | More about Countif | Count Magic. The powerful COUNTIF function in Excel counts cells based on one criteria. This page contains many easy to follow COUNTIF examples. Numeric Criteria. Use the COUNTIF function in Excel to count cells that are equal to a value, count cells that are greater than or equal

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/countif.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Add or Subtract Time in Excel - Easy Excel Tutorial

**Details: **Add Up Times. To add up times in Excel, simply use the SUM function. To display a total of more than 24 hours, change the Time format. 1. For example, task A requires 8 hours to complete, task B requires 4 hours and 30 minutes to complete, etc.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/add-subtract-time.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the SUMIF function - Easy Excel Formulas

**Details: **2. The following SUMIF function gives the exact same result. The & operator joins the 'less than or equal to' symbol and the value in cell C1.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/sumif.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the CONCATENATE function - Easy Excel Formulas

**Details: **2. Use the & operator to produce the exact same result. 3. The CONCATENATE function below concatenates the string in cell A1, the string " and " (enclose text in double quotation marks) and the string in cell B1.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/concatenate.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the IFS function - Easy Excel Formulas

**Details: **Use the IFS function in Excel 2016 or later when you have multiple conditions to meet. The IFS function returns a value corresponding to the first TRUE condition. Note: if you don't have Excel 2016 or later, you can nest the IF function.. 1a. If the value in cell A1 equals 1, the IFS function returns Bad.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/ifs.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### SUM formulas in Excel - Easy Excel Tutorial

**Details: **Sum Every Nth Row. The SUM formula below uses SUM, MOD and ROW to sum every nth row.Change the 3 to 4 to sum every 4th row, to 5 to sum every 5th row, etc. Note: the formula bar indicates that this is an array formula by enclosing it in curly braces {}.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/sum.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Lookup & Reference Functions in Excel - Easy Excel Tutorial

**Details: **Vlookup | Hlookup | Match | Index | Choose. Learn all about Excel's lookup & reference functions, such as VLOOKUP, HLOOKUP, MATCH, INDEX and CHOOSE.. Vlookup. The VLOOKUP (Vertical lookup) function looks for a value in the leftmost column of a table, and then returns a value in the same row from another column you specify.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/functions/lookup-reference-functions.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Import Access Data into Excel - Easy Excel Tutorial

**Details: **This example teaches you how to import data from a Microsoft Access database.In Excel, when you import data, you make a permanent connection that can be refreshed.. 1. On the Data tab, in the Get & Transform Data group, click Get Data.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/import-access-data.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Substring in Excel - Easy Excel Tutorial

**Details: **There's no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel to extract substrings.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/substring.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Create Hyperlinks in Excel - Easy Excel Tutorial

**Details: **3a. To create a hyperlink to an existing file, select a file (use the Look in drop-down list, if necessary). 3b. To create a hyperlink to a web page, type the Text to display, the Address, and click OK.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/hyperlinks.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Microsoft Query in Excel - Easy Excel Tutorial

**Details: **This example teaches you how to import data from a Microsoft Access database into Excel by using the Microsoft Query Wizard. With Microsoft Query, you can select the columns of data that you want and import only that data into Excel.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/microsoft-query.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Create a Line Chart in Excel - Easy Excel Tutorial

**Details: **Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use Scatter with Straight Lines to show scientific XY data. To create a line chart in Excel, execute the following steps.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/line-chart.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the SUMPRODUCT function - Easy Excel Formulas

**Details: **Advanced Use. The SUMPRODUCT function is an extremely versatile function and can produce the same result as many built-in functions in Excel and even array formulas!

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/sumproduct.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Count and Sum Functions in Excel - Easy Excel Tutorial

**Details: **Count | Countif | Countifs | Sum | Sumif | Sumifs. The most used functions in Excel are the functions that count and sum.You can count and sum based on one criteria or multiple criteria.. Count. To count the number of cells that contain numbers, use the COUNT function.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/functions/count-sum-functions.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Group Pivot Table Items in Excel - Easy Excel Tutorial

**Details: **Group Dates. To create the pivot table below, instead of the Product field, add the Date field to the Rows area. The Date field contains many items. 6-Jan, 7-Jan, 8-Jan, 10-Jan, 11-Jan, etc.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/group-pivot-table-items.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Closest Match in Excel - Easy Excel Tutorial

**Details: **To find the closest match to a target value in a data column, use INDEX, MATCH, ABS and MIN in Excel.Use the VLOOKUP function in Excel to find an approximate match.. 1. The ABS function in Excel returns the absolute value of a number.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/closest-match.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Absolute Reference in Excel - Easy Excel Tutorial

**Details: **2. This is what happens when we copy the formula in cell C2 to cell C3.. 3. Fix the reference to cell E2 by placing a $ symbol in front of the column letter and row number. 4. To quickly copy the formula in cell C2 to the other cells, select cell C2, click on the lower right corner of cell C2 and drag it down to cell C7.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/absolute-reference.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Create Charts in Excel - Easy Excel Tutorial

**Details: **Create a Chart | Change Chart Type | Switch Row/Column | Legend Position | Data Labels. A simple chart in Excel can say more than a sheet full of numbers. As you'll see, creating charts is very easy. Create a Chart. To create a line chart, execute the following steps. 1. Select the range A1:D7.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/data-analysis/charts.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Comparison Operators - Equal to, Greater than, Less than

**Details: **Greater than or equal to. The greater than or equal to operator (>=) returns TRUE if the first value is greater than or equal to the second value.. 1. For example, take a look at the formula in cell C1 below.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/comparison-operators.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### t-Test in Excel - Easy Excel Tutorial

**Details: **This example teaches you how to perform a t-Test in Excel.The t-Test is used to test the null hypothesis that the means of two populations are equal. Below you can find the study hours of 6 female students and 5 male students.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/t-test.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### How to use the VLOOKUP function - Easy Excel Formulas

**Details: **2. The value 4 (third argument) tells the VLOOKUP function to return the value in the same row from the fourth column of the red table. Note: the Boolean FALSE (fourth argument) tells the VLOOKUP function to return an exact match.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/vlookup.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Calculate Time Difference in Excel - Easy Excel Tutorial

**Details: **2. Change the number format of the values in cell A2, B2 and C2 to General. Note: times are handled internally as numbers between 0 and 1. For example, 6:00 AM is represented as 0.25 (quarter through the day).

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/time-difference.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### CAGR formula in Excel - Easy Excel Tutorial

**Details: **There's no CAGR function in Excel. However, simply use the RRI function in Excel to calculate the compound annual growth rate (CAGR) of an investment over a period of years.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/cagr.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### NPV formula in Excel - Easy Excel Tutorial

**Details: **Net Present Value | Understanding the NPV function. The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.. Net Present Value. For example, project X requires an initial investment of $100 (cell B5). 1. We expect a profit of $0 at the end of the first period, a profit of $50 at the end of the

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/npv.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Prevent Duplicate Entries in Excel - Easy Excel Tutorial

**Details: **This example teaches you how to use data validation in Excel to prevent users from entering duplicate values.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/prevent-duplicate-entries.html Go Now ^{}

› Get more: How to useGo Now ^{}

### AVERAGEIF function in Excel - Easy Excel Tutorial

**Details: **The AVERAGEIF function in Excel calculates the average of cells that meet one criteria. AVERAGEIFS calculates the average of cells that meet multiple criteria. 1. For example, the AVERAGEIF function below (two arguments) calculates the average of all values in the range A1:A7 that are greater than 0.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/averageif.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### AutoFit in Excel - Easy Excel Tutorial

**Details: **AutoFit Row Height. The techniques described above can also be used to change the height of a row. Instead of clicking the right border of a column header, simply click the bottom border of a row header.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/autofit.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Update a Pivot Table in Excel - Easy Excel Tutorial

**Details: **Refresh | Change Data Source. Any changes you make to the data set are not automatically picked up by the pivot table. Refresh the pivot table or change the data source to update the pivot table with the applied changes.. Refresh. If you change any of the text or numbers in your data set, you need to refresh the pivot table.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/update-pivot-table.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Not Equal To Operator in Excel - Easy Excel Tutorial

**Details: **2. The formula in cell C1 below returns FALSE because the value in cell A1 is equal to the value in cell B1. 3. The IF function below calculates the progress between a start and end value if the end value is not equal to an empty string (two double quotes with nothing in between), else it displays an empty string (see row 5).

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/not-equal-to.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Sum Largest Numbers in Excel - Easy Excel Tutorial

**Details: **This example shows you how to create an array formula that sums the largest numbers in a range.. 1. We use the LARGE function. For example, to find the second largest number, use the following function.

› Verified *7 days ago*

› Url: https://www.excel-easy.com/examples/sum-largest-numbers.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Create a Drop-down List in Excel - Easy Excel Tutorial

**Details: **Create a Drop-down List | Allow Other Entries | Add/Remove Items | Dynamic Drop-down List | Remove a Drop-down List | Dependent Drop-down Lists | Table Magic. Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values.. Create a Drop-down List. To create a drop-down list in Excel, execute the following steps.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/drop-down-list.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Create a Macro in Excel - Easy Excel VBA

**Details: **Developer Tab | Command Button | Assign a Macro | Visual Basic Editor. With Excel VBA you can automate tasks in Excel by writing so called macros. In this chapter, learn how to create a simple macro which will be executed after clicking on a command button. First, turn on the Developer tab. Developer Tab. To turn on the Developer tab, execute the following steps.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/vba/create-a-macro.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Move Columns in Excel - Easy Excel Tutorial

**Details: **Shift Key | Insert Cut Cells | Magic Move. To move columns in Excel, use the shift key or use Insert Cut Cells.You can also change the order of all columns in one magic move. Shift Key. To quickly move columns in Excel without overwriting existing data, press and hold the shift key on your keyboard.

› Verified *3 days ago*

› Url: https://www.excel-easy.com/examples/move-columns.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Randomly Sort Data in Excel VBA - Easy Excel Macros

**Details: **1. First, we declare four variables. One variable of type String we call TempString, one variable of type Integer we call TempInteger, one variable of type Integer we call i, and one variable of type Integer we call j.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/vba/examples/randomly-sort-data.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Weighted Average Formula in Excel - Easy Excel Tutorial

**Details: **To calculate a weighted average in Excel, simply use SUMPRODUCT and SUM.. 1. First, the AVERAGE function below calculates the normal average of three scores. Suppose your teacher says, "The test counts twice as much as the quiz and the final exam counts three times as much as the quiz".

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/weighted-average.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Custom Number Format in Excel - Easy Excel Tutorial

**Details: **Excel has many built-in formats that you can use: Currency, Accounting, Date, Time, Percentage, etc. If you cannot find the right format, you can create a custom number format.

› Verified *1 days ago*

› Url: https://www.excel-easy.com/examples/custom-number-format.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Budget Limit in Excel - Easy Excel Tutorial

**Details: **This example teaches you how to use data validation in Excel to prevent users from exceeding a budget limit.

› Verified *1 days ago*

› Url: https://www.excel-easy.com/examples/budget-limit.html Go Now ^{}

› Get more: How to useGo Now ^{}

### Count Characters in Cells - Easy Excel Tutorial

**Details: **Learn how to count the number of characters in a cell or range of cells and how to count how many times a specific character occurs in a cell or range of cells.. 1. The LEN function in Excel counts the number of characters in a cell. Explanation: the LEN function counts 2 numbers, 1 space and 6 letters.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/count-characters.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Excel VBA Userform and Ranges - Easy Excel Macros

**Details: **You can use a RefEdit control in Excel VBA to get a range from a user. The Userform we are going to create colors the minimum value of the range stored in the RefEdit control.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/vba/examples/userform-ranges.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Remove Spaces in Excel - Easy Excel Tutorial

**Details: **The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces.Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.. 1. The TRIM function below removes 2 leading spaces, 3 extra spaces and 2 trailing spaces.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/remove-spaces.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Insert Page Numbers in Excel - Easy Excel Tutorial

**Details: **This example teaches you how to insert page numbers in Excel. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.

› Verified *2 days ago*

› Url: https://www.excel-easy.com/examples/page-numbers.html Go Now ^{}

› Get more: How To UseGo Now ^{}

### Top Categories

### Recently Searched

› Christmas tree minecraft map

› Christmas paper crafts on pinterest

› How to connect canon printer to wifi

› Christmas ornament craft kit

› Christmas craft patterns to sew