Connexion Testez gratuitement

Follow us

Bienvenue sur Bookboon

Afin de vous proposer nos services, nous nous reposons sur des cookies. Ceux-ci sont essentiels pour accéder à nos fonctionnalités.

Lire les détails relatifs aux cookies
Catégories Corporatif
Livre électronique professionnel

Tables

In Excel

par Anne Walsh
77
Langue:  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.
Abonnement Pro Plus gratuit pour les 30 premiers jours, puis $6.99/mois
Lisez ce livre avec notre eReader, sans pubs
Description
Contenu
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.

Ecrire un commentaire
A propos de l'auteur
Anne

Anne Walsh

Découvrir l'auteur
Contenu associé