Excel 2007 Advanced Report Development
- 8h 19m
- Timothy Zapawa
- John Wiley & Sons (US)
- 2007
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
About the Author
Timothy Zapawa (Saline, Michigan) obtained a baccalaureate in Accounting and Arabic from the University of Michigan in Ann Arbor in 1997. Prior to that, he served four years in the United States Navy, specializing in electronic communications. He has completed several certifications and professional examinations in a variety of financial and technical fields, including the Certified Public Accountant (CPA), Certified Management Accountant (CMA), Certified Financial Manager (CFM), Project Manager Professional (PMP), Microsoft Certified Systems Engineer (MCSE), and Microsoft Certified Database Administrator (MCDBA). Tim is currently an implementation director at Advantage Computing Systems, Inc., a company that produces enterprise software for publishing companies and service bureaus. He leads teams of engineers, developers, and managers through software implementation projects. He has also developed several technical training courses for his company’s clients, including modules on Business Intelligence, Crystal Reports, SQL programming for Oracle and SQL Server, and Excel PivotTable Reporting.
In this Book
-
Taking a First Look at Excel’s Reporting Tools
-
Getting Started with PivotTable Reports
-
PivotTable Essentials and Components
-
Working with External Data Sources
-
Looking at the Get External Data Tab
-
Retrieving External Data Using Microsoft Query
-
Using the Query Wizard
-
Getting Started with Microsoft Query
-
Working with SQL in Microsoft Query
-
Designing PivotTable Reports
-
PivotTable Report Formatting
-
Managing PivotTable Data
-
Analyzing Data in a PivotChart
-
Creating and Using Spreadsheet Reports
-
Building Report Solutions
-
Spreadsheet Report Formatting
