From the course: Excel 2016: Managing and Analyzing Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Using formulas in tables
From the course: Excel 2016: Managing and Analyzing Data
Using formulas in tables
- [Voiceover] There's one aspect of working with tables that for some people is not a plus. It's how we work with formulas. Now there are some advantages to the method we'll be seeing here, and potentially some disadvantages. This worksheet's called Table Formulas. This data has been converted to a table, I have turned off the filter arrows, we don't need them in this movie, but I'm about to add a new field to the right to calculate a new compensation. And as we start to work with formulas in tables you'll see some unusual notation pop up. I'm going to zoom in by holding down Control, using the mouse wheel, and as I put a heading in here if you work with tables you know that immediately this heading and the remainder of column K down to the bottom of the list will automatically become part of the table. We've got compensation amounts in column J, the heading here is gonna be called New Comp. And as I press Enter you see what's happening, the column is automatically part of the table…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.