Excel Shortcuts

Last time I posted, I had learned about the formula auditing tools in Excel.

Today I learned several new-to-me shortcuts that are going to be very useful.

CTRL + Home/End

CTRL + .

CTRL + PgUp/PgDn

I also learned how to use the data validation tool to specify what can be inserted into cells and create drop down lists to select information from. Included with that was how to create your own custom error messages! That could be fun.

I finished up the Excel 101 section of the Maven Analytics Excel: Formulas and Functions course, and I look forward to deepening my knowledge of logical operators in the upcoming section.

Honestly, I'm moving a little slower than I intended, but I have decided that while I have the opportunity, if I feel the need to focus more on home, that's a-ok.