Log in Try for free

Follow us

This website uses cookies

We use cookies to improve user experience. Choose which cookies you allow us to use. You can read more about our Cookie Policy in our privacy policy

See Cookies Details
Categories Corporate
Professional eBook

Tables

In Excel

by Anne Walsh
77
Language:  English
Tables are one of the most powerful yet least utilised features in Excel. They make formula entry faster and more user friendly. They look great and work well with large data sets.
Professional Plus subscription free for the first 30 days, then $6.99/mo
Access this book on our eReader, no adverts inside the book
Description
Content
book.tabs.learning objectives

This book shows you how to utilise the power of tables to create formulas that are easy to read, maintain and update. You will learn how to use tables to automate data capture and create and easily refresh pivot tables. There is also a section on how to name and manage ranges and how to use them in formulas so that they are easy to read and maintain.

About the Author

The author is Anne Walsh, a freelance trainer based in Ireland, who has been working with Excel since it was Excel 5.0. She is a MOS Master Instructor and a former MCT (Microsoft Certified Trainer). She is the author of “Your Excel Survival Kit: Your guide to surviving and thriving in an Excel world” (2nd edition).

  • 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.

Write a review
About the Author
Anne

Anne Walsh

Discover Author
Related Content