Excel Data Analysis: Your Visual Blueprint for Creating and Analyzing Data, Charts and Pivottables, 3rd Edition
Advanced techniques for Excel power users
Crunch and analyze Excel data the way the professionals do with this clean, uncluttered, visual guide to advanced Excel techniques. Using numerous screenshots and easy-to-follow numbered steps, this book clearly shows you how to perform professional-level modeling, charting, data access, data slicing, and other functions. You'll find super techniques for getting the most out of Excel's statistical and financial functions, Excel PivotTables and PivotCharts, Excel Solver and BackSolver, and more.
- Provides a clear look at power-using Excel, the world's leading spreadsheet application from Microsoft, and part of the new Microsoft Office 2010 suite
- Expands your Excel knowledge and helps you use Excel data more efficiently
- Demonstrates how to create custom functions; retrieve data from databases; use value chains; cut, slice, and pivot data using PivotTables; use advanced Find; model data and chart data; and use advanced formulas
- Explores all features and functions in friendly, full-color pages packed with screenshots, numbered steps, and other visual graphics that clearly show you how to accomplish tasks
- Includes practical examples, tips, and advice to help you get the most out of Excel's features and functions
Excel at Excel at the highest levels with this practical guide.
Sign up now »
Flash is quickly emerging as the preferred way to overcome the nagging performance limitations of hard disk drives. However, because flash comes at a significant price premium, outright replacement of ...
"Suggesting that people's "purpose is to get information to flow through the ..."
Why change management doesn’t work
"Darn those pesky laws that get in the way of commercial exploitation ..."
Larry Page wants to see your medical records
"Instead of partitioning the device between corporate and personal data, another approach ..."
Dual-Persona Smartphones Not a BYOD Panacea
"Well that's a nice back-handed compliment isn't it? So now, finally, my ..."
After two-year hiatus, EFF accepts bitcoin donations again
"Actually, both Mobile App developers and CIOs should be blamed for it. ..."
CIOs struggle to deliver timely mobile business apps: survey
- AusCERT 2013: Police urge banks to install ATM chip technology
- Twitter aims to become safer with two-step sign-in
- Prevent a hack attack with Twitter's new two-factor authentication
- Rapid-growing mobile payments market is driving a financial fraud marketplace
- AusCERT 2013: Users, cats more likely hack culprits than cyber-espionage: Trustwave