Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 110 Excel data analysis techniques, including:
* Identifying trends in your data
*
Sorting, filtering, and identifying lists
*
Creating, editing, and checking formulas
*
Calculating interest rates and depreciation
*
Performing simple sorts and filters
*
Hiding rows or columns in a PivotTable
*
Adding and removing chart data
*
Querying an Access database
*
Assigning digital signatures
*
Solving a formula with a data table
"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
-Rob L. Meerscheidt(The Woodlands, TX)
* High-resolution screen shots demonstrate each task
*
Succinct explanations walk you through step by step
*
Two-page lessons break big topics into bite-sized modules
*
"Apply It" and "Extra" sidebars highlight useful tips
* Identifying trends in your data
*
Sorting, filtering, and identifying lists
*
Creating, editing, and checking formulas
*
Calculating interest rates and depreciation
*
Performing simple sorts and filters
*
Hiding rows or columns in a PivotTable
*
Adding and removing chart data
*
Querying an Access database
*
Assigning digital signatures
*
Solving a formula with a data table
"I was stuck on an Excel problem for two days. Finally, I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
-Rob L. Meerscheidt(The Woodlands, TX)
* High-resolution screen shots demonstrate each task
*
Succinct explanations walk you through step by step
*
Two-page lessons break big topics into bite-sized modules
*
"Apply It" and "Extra" sidebars highlight useful tips
