2016 Book References

2016 Book References

Chapter 9: Working with Tables, 189

In this chapter, you will explore the tools that you can use with tables in Excel and discover the advantages of creating tables. You will also learn how to create formulas that use structured references and how to insert sparklines for quick and simple data trend analysis.

LEARNING OBJECTIVES   
  1. Manage data using a table
  2. Create a custom filter
  3. Name a table
  4. Use structured references in a formula
  5. Create sparklines

    • Related Articles

    • About By the Book

      Under construction...

    • 122 Switch Between Relative, Absolute, and Mixed References

            .

    • 100 How Excel Champs Works

      Public Access No login required Without logging in, you have access to: Public Access: Our public access pages which contain links to external websites such as, microsoft.com. Be advised, the public pages are offered to provide quick links to topics ...

    • Reference Types

      There are 3 types of cell references in Excel. Relative Reference (default) =A1 Mixed Reference  =$A1+A$2 ​ Absolute Reference  =$A$1+$A$2 Insert the dollar sign in front of the column letters if you are going to copy and paste your formula ...