If you work a lot with spreadsheets, you know how difficult they can be once you get beyond simple tables and equations. And you know that data entry can be boring beyond belief. The more complex the table, the more confusing it is to evaluate. Shouldn’t there be quicker and easier way to do some of these tasks?
Microsoft Excel has a lot of nifty shortcuts that can help relieve the tedium of data entry and provide clarity with complex tables. Here are six features built into Excel 2016 that can ease creating spreadsheets and understanding the ones you (and other people) create.
And after those six, I’ll treat you to 20 keyboard shortcuts that – if you can memorize them – will make your jobs lighter.
Some of these tricks will be found in earlier versions of Excel; others are exclusive to Excel 2016. Remember that if you subscribe to Office 365, you currently have Excel 2016.
Tell Me What You Want To Do
Do you always remember how to create a pie chart, freeze the left-hand column, or name a range? I didn’t think so. Excel’s “Tell me what you want to do” can help you complete a chore even while you’re suffering from a brain freeze.