# Excel-easy.com

Do you own excel-easy.com? You're Missing Out on High Value Audience with Lower Cost-per-Click & Great ROI! Get Started Today.

Actived: 7 days ago

URL: go.microsoft.com

### Percentage Formula in Excel (Easy Calculations)

To calculate the percentage change between two numbers in Excel, execute the following steps. 1. Enter an old number in cell A1 and a new number in cell B1. 2. First, calculate the difference …

Category:  coupon codes

### Excel Functions and Formulas (In Easy Steps)

2 Logical: Learn how to use Excel's logical functions, such as IF, AND, OR and NOT. 3 Cell References: Cell references in Excel are very important. Understand the difference between …

Category:  coupon codes

### Count and Sum Functions in Excel (Easy Tutorial)

Sumifs. To sum cells based on multiple criteria (for example, circle and red), use the following SUMIFS function (first argument is the range to sum). General note: in a similar way, you can …

Category:  coupon codes

### 300 Excel Examples

300 Examples. Complete this section and become an Excel pro! The examples and features on this page can also be found on the right side of each chapter. Trisha - Boise, United States - …

Category:  coupon codes

### SUM formulas in Excel (Easy Tutorial)

AutoSum. Use AutoSum or press ALT + = to quickly sum a column or row of numbers. 1. First, select the cell below the column of numbers (or next to the row of numbers) you want to sum. …

Category:  coupon codes

### Two-column Lookup in Excel (Easy Tutorial)

This example teaches you how to perform a two-column lookup in Excel. See the example below. We want to look up the salary of James Clark, not James Smith, not James Anderson. 1. To …

Category:  coupon codes

### How to Print Sheets in Excel (Easy Tutorial)

First, select the range of cells you want to print. 2. Next, under Settings, select Print Selection. 3. To print the selection, click the big Print button. Note: you can also print the active sheets (first …

Category:  coupon codes

### Rounding Times in Excel (Easy Tutorial)

Times are handled internally as numbers between 0 and 1. Simply apply a Time Format to display a time. 2. The formula below rounds a time to the nearest 30 minutes. 3. The formula below …

Category:  coupon codes

### How to Split Cells in Excel (Easy Tutorial)

First, split the contents of one cell into multiple cells. 2. Select cell B1 and press CTRL + E (flash fill shortcut). 3. Select cell C1 and press CTRL + E. 4. Select cell D1 and press CTRL + E. …

Category:  coupon codes

### Dependent Drop-down Lists in Excel (Easy Tutorial)

To create these dependent drop-down lists, execute the following steps. 1. On the second sheet, create the following named ranges. 2. On the first sheet, select cell B1. 3. On the Data tab, in …

Category:  coupon codes

### Check Box in Excel VBA (Easy Macros)

To create a check box in Excel VBA, execute the following steps. 1. On the Developer tab, click Insert. 2. In the ActiveX Controls group, click Check Box. 3. Drag a check box on your …

Category:  coupon codes

### Substring in Excel (Easy Tutorial)

To extract the rightmost characters from a string, use the RIGHT function in Excel. To extract a substring (of any length) after the dash, add LEN and FIND. Explanation: the LEN function …

Category:  coupon codes

### Turn off Scroll Lock in Excel (Easy Tutorial)

Click Start > Settings > Ease of Access > Keyboard > Use the On-Screen Keyboard (or press the Windows logo key + CTRL + O). 3. Click the ScrLk button. Note: to turn on scroll lock, simply …

Category:  coupon codes

### How to use the Excel SWITCH function (Easy Tutorial)

This example teaches you how to use the SWITCH function in Excel 2016 or later instead of the IFS function. 1a. For example, the IFS function below finds the correct states. Explanation: cell …

Category:  coupon codes

### Tax Rates in Excel VBA (Easy Macros)

Taxable income. Tax on this income. 0 - \$6,000. Nil. \$6,001 - \$35,000. 15c for each \$1 over \$6,000. \$35,001 - \$80,000. \$4,350 plus 30c for each \$1 over \$35,000

Category:  coupon codes

### How to Move Columns in Excel (Easy Tutorial)

First, select a column. 2. Right click, and then click Cut. 3. Select a column. The column will be inserted before the selected column. 4. Right click, and then click Insert Cut Cells. Note: in a …

Category:  coupon codes

### Chop off Decimals in Excel (In Easy Steps)

Conclusion: the INT function only chops off decimals from positive numbers. Trunc. The TRUNC (Truncate) function always chops off decimals. The TRUNC function can keep any number of …

Category:  coupon codes

### How to Freeze Panes in Excel (Easy Tutorial)

To freeze the first column, execute the following steps. 1. On the View tab, in the Window group, click Freeze Panes. 2. Click Freeze First Column. 3. Scroll to the right of the worksheet. …

Category:  coupon codes

› Bbq