Videos tagged with Excel
Create formulas using relative, absolute, and mixed references in Excel. Episode 144 will show you how.
Sometimes you need a formula to always point to a particular row but allow the column to change. Or, you might need it to point to a particular column but allow the row to change. This is called Mixed References. Episode 143 will show you both varieties.
Learn Excel Episode 142: How to Have a Cell Reference in a Formula Always Point to a Particular Cell
How to have a cell reference in a formula always point to a particular cell. The concept of relative, absolute and mixed references is the most important concept in Excel. If you've never put a dollar sign in a formula, podcast Episode 142 is a must-watch.
Have Excel copy a formula to other cells using relative references. Episode 141 will show you how.
Have Excel find numbers stored as text. Episode 140 will show you how.
Learn how to insert special symbols into your Excel worksheet. Episode 139 will show you how.
Have Excel talk to you! Excel will read back data from cells as you proofread from original document. Episode 138 will show you how.
Let the Fill Across Worksheets command copy data from current worksheet to any other selected worksheets in your workbook. Episode 137 will show you how.
Track Changes is a fantastic feature in Word. It is disappointing in Excel. Episode 136 explores how this feature works and the limitations.
Typing the same, long word over and over in a report? Use autocorrect to enable a shortcut. Episode 135 will show you how.