Microsoft Office Excel 2007 Data Analysis 2024 pdf epub mobi 电子书

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