Cover of Excel 2007 PivotTables and PivotCharts
Read Time: ~5.3 hr

Excel 2007 PivotTables and PivotCharts

by Peter Aitken (2007)

About this book

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You'll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and--most importantly--you'll discover what these tools can do for you.

Setting / LocationGlobal
Story EraModern Era
Protagonist / CoreExcel 2007 PivotTables and PivotCharts Lead Character

Readers who enjoyed this also loved

Cover of Quickbooks all-in-one desk reference for dummies

Quickbooks all-in-one desk reference for dummies

Stephen L. Nelson

One of the principles of good business and good money management is to make the most of what you have. QuickBooks All-In-One Desk Reference For Dummies helps you make the most of QuickBooks business accounting software. Updated to cover changes and enhancements to the software, it combines eight quick reference guides: An Accounting Primer that covers basic principles, double-entry bookkeeping, and special accounting problems Getting Ready to Use QuickBooks with information on setting up QuickBooks, loading the master file lists, and fine-tuning QuickBooks Bookkeeping Chores, covering invoicing customers, paying vendors, tracking inventory, and more Accounting Chores including financial statements, reports, and budgets, using activity-based costing, and setting up project and job costing systems Financial Management such as ratio analysis, economic value-added analysis, and capital budgeting Business Plans, featuring profit-volume-cost analysis, forecasting, and writing a business plan Care and Maintenance, with information on protecting data, troubleshooting, and more Additional Business Resources including a crash course in Excel, a glossary, and more Written by veteran Dummies author Stephen L. Nelson, MBA, CPA, and author of more than 100 books with more than four million copies in print, QuickBooks All-In-One Desk Reference For Dummies goes beyond the basics of how to use QuickBooks and provides expert advice on accounting chores, financial management, business planning, and much more. With a comprehensive index, it's your instant, at-your-fingertips reference for everything from how to handle everyday accounting tasks to long-term planning for your business. Fine-tune QuickBooks for your business and your accounting systems Calculate breakeven points Budget for capital expenditures Take advantage of online banking There's even a companion Web site where you can take advantage of a sample business plan workbook and download a profit-volume cost analysis workbook. You won't find a more comprehensive, authoritative, yet understandable guide to QuickBooks.

Cover of SAP NetWeaver portal technology

SAP NetWeaver portal technology

Rabi Jay

Your Hands-on Guide to SAP NetWeaver Portal TechnologyMaster SAP NetWeaver Portal with the most comprehensive, step-by-step reference available on the entire portal implementation life cycle. Written by SAP architect Rabi Jay, this book provides everything you need to plan, design, install, configure, and administer SAP NetWeaver Portal, including SAP NetWeaver Application Server Java.SAP NetWeaver Portal Technology: The Complete Reference is filled with detailed descriptions, numerous illustrations, and hundreds of expert tips. Design and deploy portals with high availability, scalability, and performance. Implement single sign-on to backend systems and integrate SAP and non-SAP applications. Configure reliable J2EE engine and portal security, and devise a flawless portal backup and restore strategy. Improve performance using portal workload, GC, thread dump, and HTTP analysis.Plan futuristically using PAM, release planning, and maintenance strategy Design global portals using federated portal networks and external-facing portalsImplement self-registration and delegated user and content administrationEnable authorization using security zones, UME actions, and ACL permissionsManage users centrally using LDAP, UME, and Identity ManagementImplement user-, type-, and attribute-based authenticationBrand your portal using portal desktop rules, themes, and framework pages Configure portal transports, and deploy patches and business packages using JSPMMonitor your portal using CCMS and GRMG Availability MonitoringManage your portal centrally using NWA and maintain systems using SLD

Cover of The upgrader's guide to Microsoft Office System 2003

The upgrader's guide to Microsoft Office System 2003

Mike Gunderloy, Susan Sales Harkins

Microsoft Office 2003 is the sixth version of Microsoft's best-selling Office suite. As such, most of the audience is comprised of people who have used previous versions of Office and are quite familiar with most of the features. Upgraders do not need a 800-page book that covers every aspect of every Office application. They need a book that's focused only on what's new, so that they can move forward with a minimum of fuss. That's what this book is all about.

Cover of SQL Server 7

SQL Server 7

Anil Desai

Protect your organization's most valuable asset--its data. Develop and implement a thorough data protection solution for your SQL Server 7 database environment. SQL Server 7 Backup & Recovery is your one-stop resource for planning, developing, implementing, and managing backup and restore procedures. Learn to execute data protection strategies, implement a backup solution, and handle data recovery before potentially disastrous data loss occurs. You'll get details on the latest methods for increasing database uptime and improving performance. The case studies included show you how to apply the techniques described in the book in your own environment. Evaluate business requirements and develop a data protection strategy. Configure Windows NT/2000 for the secure and efficient use of SQL Server 7. Select the best hardware, software, and network technologies for your backup plan. Handle SQL Server 7 backup procedures involving files and filegroups, transaction logs, concurrency, locking, and other database issues. Increase database uptime and optimize performance. Develop and practice restore plans for various scenarios--from minor data loss to complete hardware failures. Increase reliability, availability, and performance through the use of standby servers and clustering. Distribute data throughout your enterprise with SQL Server 7's replication features. Follow case studies to learn about the application of data protection best practices in various environments.

Excel 2007 PivotTables and PivotCharts by Peter Aitken | Literally Just Books