Yves S.'s Resources

Word Problem (answer)

This is an old question, but worth some explanation. I had fun reading some of the answers here; the problem statement is obviously a prank!   These types of problems are units of measurement problems and are solved as Daniel did.     The units need to be consistent...


OK, so you’ve been asked to do a Pivot Table for the first time? And just like everyone else, you feel somewhat intimidated; “what’s going to happen to my data if I screw up my Pivot Table?”; “Can I undo my changes?”; “Can I delete my Pivot Table?”; “How long does it take to create a Pivot Table?”; “What is a Pivot Table in the first place?” Let’s give the short answers first: “Nothing”,... read more


While in many tutorial exercises as well as in job interviews, you may be asked to create a VLOOKUP formula, in the real world you will quickly find that INDEX/MATCH is a far better solution. To understand why, let's look at the syntax of each: VLOOKUP(lookup_value, array, col-num, lookup_type) VLOOKUP(what?, where?, which column? , approximate search: yes or no?), just... read more


If you are working in a Microsoft environment, Excel or Word and on a laptop, you may have been frustrated having to select the Fn key together with the primary F1-F12 keys to run the desired command. While the fix is easy on a Mac, it is not so on a PC. Here are the instructions on how to do this on your PC (Windows 10) 1) In your Search Windows Box, type “UEFI”; this will... read more