KuTenk 2000 - ITOT110118-Excel 2007 Advanced Report Development

by Timothy Zapawa 

2007 (576 pages)

ISBN:9780470046449

With notes, tips, warnings, and real-world examples, this book offers a step-by-step approach and hands-on examples to help you develop powerful and innovative reporting solutions using Microsoft Excel 2007.

Excel 2007 Advanced Report Development

Introduction

Part I - Report Basics

Chapter 1

-

Taking a First Look at Excel’s Reporting Tools

Chapter 2

-

Getting Started with PivotTable Reports

Chapter 3

-

PivotTable Essentials and Components

Part II - External Data

Chapter 4

-

Working with External Data Sources

Chapter 5

-

Looking at the Get External Data Tab

Chapter 6

-

Retrieving External Data Using Microsoft Query

Chapter 7

-

Using the Query Wizard

Chapter 8

-

Getting Started with Microsoft Query

Chapter 9

-

Working with SQL in Microsoft Query

Part III - PivotTable Reporting

Chapter 10

-

Designing PivotTable Reports

Chapter 11

-

PivotTable Report Formatting

Chapter 12

-

Managing PivotTable Data

Chapter 13

-

Analyzing Data in a PivotChart

Part IV - Spreadsheet Reporting

Chapter 14

-

Creating and Using Spreadsheet Reports

Chapter 15

-

Building Report Solutions

Chapter 16

-

Spreadsheet Report Formatting

Part V - Appendices

Appendix A

-

SQL Reference

Appendix B

-

Pop-Up Menus, Clicking Actions, and Tab Functions