MS Excel

Spreadsheet Logical IF Error Traps

This entry was posted in MS Excel

Nesting the ISERROR() function within the first argument of a logical IF() function. A very powerful method of testing for errors and directing the output based on conditions. I call this the Error Trap. This video will show you how to detect and trap errors, displaying an alternative output in place of the error code. When used in conjunction with the VLOOKUP() function, this method will ensure your formulas only return perfectly accurate data. Be sure to view parts 1 through 3 of this series to get the full benefit from

Spreadsheet Logical IF Error Traps
Spreadsheet VLOOKUP Function

Spreadsheet VLOOKUP Function

This entry was posted in MS Excel

Spreadsheet VLOOKUP Function (Price Catalog Mini Project 3 of 4) Vertical Lookup, a simple yet powerful function, will supercharge your spreadsheets. Best used with Named Ranges, this function searches vertically through rows of data to find a matching value. Once the matching value is found it then moves a defined number of rows to the […]

Spreadsheet Named Ranges 1

This entry was posted in MS Excel

Spreadsheet Named Ranges (Price Catalog Mini Project 2 of 4) Examples of creating and modifying named ranges and using them in formulas. Named ranges are very useful in large projects. Especially when dealing with large amounts of data or data in various locations. Named Ranges help streamline your formulas. The proper use of Named Ranges help […]

Spreadsheet Named Ranges
Cell References Relative Versus Absolute

Cell References Relative Versus Absolute 1

This entry was posted in MS Excel

Cell References Relative Versus Absolute (Price Catalog Mini Project 1 of 4) Examples of mixing relative and absolute cell references in a single formula. Using the CONCATENATE() function, learn to control the way formulas behave when copied and pasted to other cells. Depending on your project, sometimes you want to paste cell references that float […]

Resolving Common Spreadsheet Issues 3

This entry was posted in MS Excel

Resolving Common Spreadsheet Issues 3 Avoid the most common spreadsheet issues that rob you of time and energy. Learn to fix issues once they have surfaced. Over a dozen examples demonstrated. This video series will help you build spreadsheets more efficiently, more consistently and more uniform. All in less time. Topics covered in this series: […]

Spreadsheet Tutorials
Spreadsheet Tutorials

Resolving Common Spreadsheet Issues 2

This entry was posted in MS Excel

Resolving Common Spreadsheet Issues 2 Avoid the most common spreadsheet issues that rob you of time and energy. Learn to fix issues once they have surfaced. Over a dozen examples demonstrated. This video series will help you build spreadsheets more efficiently, more consistently and more uniform. All in less time. Topics covered in this series: […]

Resolving Common Spreadsheet Issues

This entry was posted in MS Excel

Resolving Common Spreadsheet Issues Avoid the most common spreadsheet issues that rob you of time and energy. Learn to fix issues once they have surfaced. Over a dozen examples demonstrated. This video series will help you build spreadsheets more efficiently, with a more consistent and uniform feel. All in less time. Topics covered in this […]

Spreadsheet Tutorials