Spreadsheets

Instructional resources for constructing spreadsheets on various programs. Featured programs will be MS Excel. Future tutorials to follow: OpenOffice Calc, Google Sheets and Mac Numbers. You will find real world projects, built step by step. I will demonstrate how these projects can be constructed using a variety of both paid and free programs


Spreadsheet Logical IF Error Traps

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

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

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

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

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

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

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