Chapter 3PowerPivot: In-Depth

This chapter goes a lot further than the previous two introductory chapters. It’s a detailed and comprehensive guide to all of the ribbons: Excel PowerPivot ribbon, PowerPivot Home ribbon, PowerPivot Design ribbon, and PowerPivot Linked Table ribbon. All of the ribbon groups and buttons are discussed, some with step-by-step examples for you to follow. In the course of this chapter, you will become familiar with most of the dialog boxes and menus that are relevant to PowerPivot. This is essentially a grand tour of the PowerPivot graphical user interface. Everything you are likely to meet in a PowerPivot window is covered. The DAX language is introduced only briefly; Chapter 4 is specifically devoted to DAX. Many of ...

Get Practical PowerPivot & DAX Formulas for Excel 2010 now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.