A new skill I learned during this section was in 5.7.3. I learned how effective it is to use named cells and ranges in an Excel spreadsheet. By simply highlighting the desired range and adding a tittle to the name box on the top left of the ribbon, you're able to refer to that particular range by the name you assigned it to. This tool comes in handy when you are trying to refer to a cell range further down in the same Excel sheet or in different sheets among the same workbook. I actually started to utilize this tool at work. It's a small technique that helps make your sheet look cleaner and more professional.
Named cells and ranges are quite convenient :-)
ReplyDeleteVery glad to hear you are using this new skill outside of IS101-3010, Spring 2022 ^_^
Well said about small techniques can make one's spreadsheet look more cleaner and professional!
There are so many little tricks with Excel...and the more of them you learn, the easier it gets to use.
ReplyDeleteIt really is a nice skill to know.
ReplyDeleteIt does look cleaner and professional
ReplyDeleteMakes it so much easier to find things in a big workbook too.
ReplyDeleteDid not realize how useful this is until I had to use it myself!
ReplyDeleteI think you meant to say "title", but I got excited because "tittle" is the word for the dot in the lowercase letters of i, and j for example.
ReplyDeleteNice. It sounds like you learned a lot.
ReplyDeleteI find it very useful and handy.
ReplyDeleteVery useful tricks to make Excel easier to use and navigate.
ReplyDeleteName cells and range is a cool feature.
ReplyDeleteI like how it enables finding things faster in an excel sheet.
ReplyDelete