Tag Archive: excel functions

Excel Tip: How to Make Formulas “Invisible”

Excel Tip: The ability to make your formulas invisible is powerful, especially when you have complex functions. If users can’t see your functions, they can’t try to edit them.

Excel Tip – How to Protect Specific Cells

Wondering how to protect specific cells in Excel? This blog post has the step-by-step instructions.

Excel Tip: How to Make Creating Complex Excel Functions Easy

VLOOKUP, HLOOKUP, SUMIFs – these are all functions that go beyond the basics, and are ripe spots for making errors. Here is a simple trick that I teach my students to help them simplify the process of creating complex and/or nested functions. Instead of typing the functions right into a cell, try using the Insert …

Continue reading »