If you’re unfamiliar with the elements of a pivot table, see the upcoming sidebar, “Pivot Table Terminology.” It’s not at all uncommon to experiment with various layouts until you find one that you’re satisfied with. Creating a pivot table is an interactive process. In this section, I describe the basic steps required to create a pivot table, using the bank account data described earlier in this chapter. Reviewing the Available ActiveX ControlsĬhapter 34: Introducing Pivot Tables Creating a Pivot Table.Understanding the Different Web Formats.Working with External Reference Formulas.Using Formulas for Data Validation Rules.Types of Validation Criteria You Can Apply.Displaying a Sparkline for a Dynamic Range.User Interface Choices for Modifying Chart Elements.Understanding the Dimensions of an Array.Conditional Sums Using Multiple Criteria.Conditional Sums Using a Single Criterion.Creating Custom Views of Your Worksheet.Preventing Certain Cells from Being Printed.Copying Page Setup Settings across Sheets.Adding a Header or Footer to Your Reports.Using Named Styles for Easier Formatting.Adding a Background Image to a Worksheet.Entering Dates and Times into Your Worksheets.Entering Text and Values into Your Worksheets.