Zapawa T. - Excel® 2007 Advanced Report Development [2007, PDF, ENG]

Книги и журналы » Компьютерная литература » Программы от Microsoft

Excel® 2007 Advanced Report Development

Год: 2007
Автор: Timothy Zapawa
Издательство: Wiley
ISBN: 0470046449
Язык: Английский
Формат: PDF
Качество: eBook (изначально компьютерное)
Количество страниц: 542
Описание: Create powerful, innovative reporting solutions with Excel 2007
In this new book, significantly updated from his bestselling Excel 2003 version, Timothy Zapawa has provided you with in-depth coverage of Excel 2007's enhanced reporting capabilities. Discover what you can do with PivotTable and Spreadsheet reports, enhanced conditional formatting and filtering functions, improved data access and management tools, and expanded OLAP features. With notes, tips, warnings, real-world examples, and how-to videos in every chapter, you'll soon be an expert on Excel report development!

Understand and use key features of PivotTable® and Spreadsheet reports
Access data from SQL and Oracle databases, Web sites, OLAP cubes, and text files

Build sophisticated SQL queries using the Microsoft Query program

Link several Excel reports together to develop a larger, automated report solution

Discover the enhanced Excel 2007 tools for filtering, sorting, and grouping data

Companion Web site
At www.wiley.com/go/excelreporting/2007, you'll find sample query files and report examples you can download, up-to-the-minute materials on Online Data Processing, and video walkthroughs of steps explained in the book.
[spoiler="Примеры страниц"]

[/spoiler]