xxxiii
Contents
Protecting a VBA Project .................................................................................... 777
Related Topics.................................................................................................... 778
Saving a worksheet as a PDF file ................................................................. 778
Marking a workbook as final ....................................................................... 778
Inspecting a workbook ............................................................................... 779
Using a digital signature ............................................................................ 780
Getting a digital ID ........................................................................... 780
Signing a workbook ........................................................................... 780Part V: Understanding Power Pivot.and Power Query 781
Chapter 35: Introducing Power Pivot. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 783
Understanding the Power Pivot Internal Data Model ............................................. 783
Activating the Power Pivot Ribbon ............................................................. 783
Linking Excel tables to Power Pivot ............................................................ 785
Preparing your Excel tables ............................................................... 786
Adding your Excel tables to the data model ........................................ 787
Creating relationships between your Power Pivot tables ....................... 788
Managing existing relationships ........................................................ 790
Using Power Pivot data in reporting ................................................... 792
Loading Data from Other Data Sources ................................................................. 793
Loading data from relational databases ....................................................... 793
Loading data from SQL Server ............................................................ 793
Loading data from other relational database systems .......................... 797
Loading data from flat files ........................................................................ 798
Loading data from external Excel files ................................................ 798
Loading data from text files............................................................... 800
Loading data from the clipboard ........................................................ 801
Refreshing and managing external data connections ................................... 803
Manually refreshing your Power Pivot data ......................................... 803
Setting up automatic refreshing......................................................... 803
Editing your data connection ............................................................. 805Chapter 36: Working Directly with the Internal Data Model. . . . . . . . . . . . . . . . . . . . . . 807
Directly Feeding the Internal Data Model ............................................................. 807
Managing Relationships in the Internal Data Model .............................................. 813
Removing a Table from the Internal Data Model.................................................... 814Chapter 37: Adding Formulas to Power Pivot. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 817
Enhancing Power Pivot Data with Calculated Columns ........................................... 817
Creating your first calculated column .......................................................... 818
Formatting your calculated columns ........................................................... 819
Referencing calculated columns in other calculations ................................... 820
Hiding calculated columns from end users ................................................... 821