Formulas Search Results

How To: Use names in formulas and functions in Microsoft Excel

Looking for a primer on how to create and work with names in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 1st installment in his series of Excel name tricks, you'll learn to use names in formulas and functions as well as how to edit them. See how to name a cell or range of cells with this free video lesson.

How To: Understand polyatomic chemical formulas

This is a video tutorial in the Education category where you are going to learn how to understand polyatomic chemical formulas. When writing the formula using polyatomics, the same cross-over rule applies. 1st identify the metal and non-metal. Then you write the symbols, write the charges, cross-over the charges from top to bottom, remove the charge and simplify the numbers and remove the 1s. for example, iron (II) phospahate. The "ate" ending implies that phosphate is polyatomic. The symbol ...

How To: Sum & count with array formulas in Microsoft Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel array formula series, you'll learn how to create array formulas for summing and counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate when there are multiple conditions.

How To: Use Boolean logic for AND & OR formulas in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to create Boolean Logic formulas for AND and OR Logical Formulas. See Logical Truth Tables for AND and OR. Also see how to create array formulas in two different ways: the SUMPRODUCT function (DON'T have to use Ctrl + Shift + ...

How To: Create linkage formulas in Microsoft Excel 2007

Learn how to create linkage formulas in MS Excel 2007. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started using linkage formulas in your own 2007 workbooks, watch this free video guide.

How To: Create dynamic ranges for formulas with Excel's OFFSET

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 584th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the OFFSET function and defined names to create dynamic ranges for formulas so formulas update each period when a new data dump (copy and paste) is completed.

How To: Create nested unique lists in Excel via array formulas

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 251st installment in their series of digital spreadsheet magic tricks, you'll learn how to create a unique list of customers within a unique list of sales reps using a series of standard formulas in tandem with a few array formulas.

How To: Reference worksheets and workbooks in Excel formulas

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 6th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to create worksheet and workbook references in formulas.

How To: Cross tabulate categorical data with formulas in Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 17th installment in his "Excel Statistics" series of free video lessons, you'll learn how to cross tabulate & do percentage cross tabulation for categorical data using formulas rather than pivot tables.

How To: Increment numbers in formulas in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increment numbers in formulas to get 2,2,2,2,4,4,4,4 or 1,1,1,1,3,3,3,3 or 1,2,3,4,1,2,3,4 or 11,22,33,44 using the ROWS, INT, MOD and COLUMNS functions.

How To: Use VLOOKUP function formulas in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:

How To: Evaluate vendors with array formulas in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 63rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an array formula to find the vendor with the maximum rating and the lowest cost Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Look up formulas in Excel with the CHOOSE function

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.

How To: Force text formulas to wrap with Excel's CHAR function

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHAR (10) function to add hard line returns (forced wrapped text) to a text formula created with the ampersand (&) and concatenation tools.

How To: Build and use array formulas in Microsoft Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Speed up calculations with custom Excel formulas

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the very first installment in his "Excel Formula Efficiency" series, you'll learn how a custom function (i.e., a user-defined function) can speed up calculations.

How To: Use functions and formulas in Microsoft Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 2nd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to get started using functions and formulas in MS Excel. Specifically, you'll see the different elements of formulas (the equal sign, cell references, math operator...

How To: Use conditional IF formulas in Microsoft Office Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.

How To: Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, delete the contents of the cell. Press Alt + F11.

How To: Use comparative operators & logical formulas in Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 11th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use comparative operators; logical TRUE/FALSE formulas, IS functions (ISTEXT, ISNUMBER, ISBLANK, ISERROR, ISNONTEXT); IF functions (1 of 2 words in a cell, 1 of...

How To: Create simple formulas with cell references in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the very first installment in their series of digital spreadsheet magic tricks, you'll learn how to build your spreadsheet smartly, so it updates automatically by creating formulas with cell references!

How To: Apply names to formulas & replace cell ranges in Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 226th installment in their series of digital spreadsheet magic tricks, you'll learn how to apply names to formulas and replace existing cell ranges as well as how to name ranges from selections.

How To: Name cell ranges and use names in formulas in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 3rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to name a range of cells; how to use names in formulas;

How To: Create simple math formulas in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 2nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to create math formulas in MS Excel using addition, subtraction, multiplication, division, exponents, and parentheses. See how 2+2*2 is not equal ...

How To: Grade test responses with formulas in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula to grade student answers where more than one possibility exists using the IF and OR functions.

How To: Input values & formulas into a cell in Excel macros

This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "Item" & "Amount", and the summery field as "Total Expenses", as well as the formulas located at the respective cells. Now, we're going to use two keyboard shortcuts i.e. "Alt + F11" to open-up the VBA window and "Alt + F8...

How To: Use Boolean math formulas in Microsoft Office Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 651st installment in their series of digital spreadsheet magic tricks, you'll learn see how to replace your IF function with a shorter Boolean Math formula! TRUE = 1, FALSE = 0, TRUE*2000 = 2000 and FASLE*2000 = 0.

How To: Make calculations in Excel with formulas & references

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 2nd installment in his "Excel Statistics" series of free video lessons, you'll learn how to make calculations in Excel using formulas and cell references. Learn about the different Excel Math operators and func...

How To: Create fast formulas for huge Excel spreadsheets

Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.

How To: Create array formulas for stock returns in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 14th installment in his series of Excel array formula series, you'll learn how to create array formulas for individual stock return and standard deviation given different assumed states of the future economy.

Prev Page