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

Related topics