Absolute and Relative Referencing – advanced

Absolute and Relative Referencing – Advanced This quick video explains the Advanced Absolute and Relative Referencing in Excel. Learn how to create row and column absolute references and learn additional features of keeping cells absolute or relative to each other –...

IFERROR

IFERROR This quick video explains how to remove and avoid IFERROR in Excel. Learn how to manage and handle errors gracefully in Excel – to avoid displaying error messages when you know a function cannot properly work. [et_social_follow icon_style="slide"...

Locking and Protecting Cells in Excel

Locking and Protecting Cells in Excel Locking and Protecting Cells in Excel. There are times when working in Excel that you want to protect an entire worksheet from someone making changes to it, without protecting the entire workbook. Excel allows you to protect a...