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.
Tag Archive: excel functions
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 …
