Excel Weekly Challenge: Tables & Hyperlinks
Excel is more than formulas and pivot tables. There's a lot that we can do in Excel to customize our experience.
Hyperlinks, Hyper-Annoyance
In this video, first we deal with the annoyance of Excel creating hyperlinks as the default when an email address is entered. We want to prevent future hyperlinks and get rid of the existing hyperlinks.
Tables
It's been said that just 1% of Excel users use tables. 😢 They should be of more widespread use because tables maintain data integrity and keep us out of trouble.
This challenge gets into the finer aspects of using tables: naming tables and easily creating a totals row.
Beyond the Challenge
Why name a table?
Naming tables can make formulas easier to read. In the example below, the table is named Finals.
Cells E4 and E7 have formulas calculating the Max Score.
E4: =MAX(C4:C10)
E7: =MAX(Finals[Score])
Same result but E7 is stating that it's taking the maximum of the Score column in the Finals table. We don't have to go look and see what the heck is C4:C10. 🧨
Finally
Go ahead! Make your own data. Play with tables.
Incorporate tables into everything you do in Excel.
Where to find Oz
List of Courses by Oz du Soleil in the LinkedIn Learning Library
YouTube: Excel on Fire
Tables and establishing hyperlink approach - these two are amazing time saving tricks 🙂🙂🙂
Graet stuff, Ozual style!
Yeah. you bet!
Coverting data to Tables - Ctrl T is amazing. Incorporate tables into everything you do in Excel. Thanks Oz du Soleil for sharing.
Good One Oz! I was using CTRL + T for a long time to create Excel Tables. Few days back, I found out that CTRL + L also does the same. Thanks to Meni Porat