Excel Basics: Tables

After a bit more content in the previous post, it’s a shorter one today but also the first bit of Excel work. Really simple first step: making tables.

1200px-Microsoft_Excel_2013_logo.svg

So theres one last step to take before we can leave the Basic Information file, both sets of data should be in a “Table” format. This is a really quick and simple step to take if you haven’t done so before.open the sheet you wish to change to table format

  • Click on any cell with data in it
  • Click on the insert tab at the top of the page
  • Click insert table
  • All the data should be automatically selected, ensure box for “My table has headers” is ticked, click OK
  • Table made
  • Repeat for the other sheet
*****Instead of step 3 above, press ctrl+t (Windows) or CMD+t (Mac)********

Now can can quickly filter the data in the tables: if you only want max velocities for one position, use a position filter; if you only want Away, European Cup games, use the venue and competition filters etc.

Next up, how to to make sure you can access both PowerQuery and PowerPivot on your version of Excel.

PS – It’s worth checking if the option to automatically extend tables is ticked or not in your Excel. If you’re adding data regularly, having it checked is best. Prevents you having to alter table dimensions regularly. Plus it helps with auto-populating cells as new data is added.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Blog at WordPress.com.

Up ↑

%d bloggers like this: