Tables

• About the Author
• Introduction

1. Creating Our First Table
   1. What is it and why should you care?
   2. What Excel versions is it available for?
   3. What are they used for?
   4. What sort of data should I use with it?
   5. Let’s do our first table – ooh my pretties
   6. Let’s “tablise” it
   7. Let’s explore our new table
   8. Conclusion
2. Getting to Know Our Table Better
   1. Adding your own bit of style
   2. Adding a Total row (it’s not just for adding…)
   3. Exploring some of the Table Tools
   4. A bit more on Styling…
   5. Conclusion
3. Using Formulas with a Table – Say hello to your (not so little) friend
   1. Add our first structural reference
   2. What happens when I want to refer to this table elsewhere?
   3. Let’s give our table a name – a reminder about this
   4. Conclusion
4. Let’s road test our table
   1. Summarise using a pivot table
   2. “A table has got to know its limitations” – Clint Eastwood in Magnum Force (may not be completely accurate)
   3. Conclusion
5. Home on the Range(s)
   1. What is a range name and how do you create it?
   2. How do we create one?
   3. Using a range in a formula
   4. Deeper Dive into our Name Manager - Name, Scope and Comment
6. Conclusion

Find out how to use formulas with tables for easier data management. Discover how to summarize data using pivot tables. Understand how to apply, manage, and use range names in Excel formulas. Explore the limitations of Excel tables and how to work around them.