You can create a list of days of the week or months of the year in Excel—but there's more. This is part of the Custom Lists feature, and you can use it to add your own lists. It's easier than you probably thought.
Excel doesn't have a MAXIF function, but you can easily adapt the MAX function. Learn how to write a special type of formula known as an array formula that will do the trick instead. Just take it step by step.
Building complex spreadsheets without lookup formulas, such as VLOOKUP, is akin to putting a screw in the wall with a hammer. It’s possible, but the results aren’t pretty, and most probably won’t maintain integrity.