Dave Bruns

In this video we'll look at the best way to select function arguments in a formula: the function screen tip window...

In this video we'll look at several ways to enter Excel functions...

One of the cool things you can do with Paste Special is make "in place" changes to numbers. This is a handy way to quickly change things like dates, prices, and times without using formulas...

In this video we'll look at how to use a mixed reference (part relative, part absolute) to create a running total...

In this video we look at how to create a mixed reference that is part relative and part absolute; useful when you want only part of a cell reference to change.

In this video we'll look at how to create 3D references; an elegant way to analyze multiple worksheets with simple formulas...

In this video we'll look at how to create formulas that reference cells on different worksheets, or even in different workbooks...

Sometimes you want to reference a worksheet dynamically in a formula so that it can be changed on the fly. In this video, we'll look at how to create a dynamic reference to a worksheet in a formula...

In this video we'll look at the Name Manager; a tool Excel provides for managing named ranges...

Named ranges make formulas easier to read and understand, and reduce errors. In this video we'll show you how to create a named range...