Publisher's Synopsis
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