For the first example, the idea is that I would want to be able to quickly correct "m" to "n" for the SUMIFS formula.

 

I was mostly interested in learning navigation with Excel shortcuts, but I learned a few other things that will be helpful at work, thanks!