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.

Download the exercise file

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

LinkedIn

List of Courses by Oz du Soleil in the LinkedIn Learning Library

YouTube: Excel on Fire

OzduSoleil.com