Mark Foeller
I'm an engineer who uses Excel every day, for many different tasks. I love working with Excel, and I love teaching others about Excel.
Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry. These dropdowns are created using the data validation feature to specify a list of allowable entries. To set […]
Named ranges are a useful, but often underutilized, feature of Microsoft Excel. Named ranges can make formulas easier to understand (and debug), simplify the creation of complicated spreadsheets, and simplify […]