الدخول جرب مجانًا

Follow us

مرحبًا بك في Bookboon

لكي نتمكن من توفير خدماتنا، نعتمد على سلسلة من ملفات تعريف الأرتباط الأساسية التي تساعد مستخدمينا على الاستفادة من على المزايا التي نقدمها.

عرض بيانات ملفات تعريف الارتباط
الفئات الشركات
كتب Professional الإلكترونية

Tables

In Excel

بواسطة Anne Walsh
77
اللغة:  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 ‏‎‎مجاني‎‎ لأول ‎30‎ ‏يوم‎‎ ثم ‏ $6.99 شهريًا بعد ذلك
الوصول إلى هذا العنوان على منصة bookboon
الوصف
المحتوى
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.

اكتب تعليقًا
نبذة عن المؤلف
Anne

Anne Walsh

تعرف على المؤلف
محتوى مُشابِه