1 Table of Contents: “... -- Working with dates and times -- Performing conditional analysis -- Using lookup formulas -- Common...”

2 Table of Contents: “... table -- Controlling the way you view your pivottable -- Performing calculations within your pivot...”

3 Table of Contents: “..., sorting and filtering pivot data -- Performing calculations in pivot tables -- Using pivot charts...”

4 Table of Contents: “... of tens -- Ten ways to improve Power Pivot performance -- Ten tips for working with Power Query...”

5 Table of Contents: “... Performance against a Target -- pt. IV. Advanced Reporting Techniques -- Ch. 10. Macro-Charged Reporting -- Ch...”

6 Table of Contents: “... ; Performing conditional analyses ; The fundamentals of using SQL ; Subqueries and domain aggregate functions...”

7 Table of Contents: “... Calculated Data Type -- Summary -- Chapter 6: Performing Conditional Analysis -- Using Parameter Queries...”

8 Table of Contents: “... -- Looking up an exact value -- Looking up a value to the left -- Performing a case-sensitive lookup...”

9 Table of Contents: “... grid to create your crosstab query -- Customizing your crosstab queries -- Optimizing Query Performance...”

10 “... ... ... ... ... ... 45 4 Controlling the Way You View Your Pivot Data ... ... . .83 5 Performing Calculations Within Your...”

11 “...: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within...”