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
Showing posts with label Excel. Show all posts
Showing posts with label Excel. Show all posts
Drawn from actual excel conundrums posted on the author's website, www.mrexcel.com, this high-level resource is designed for people who want to stretch Excel to its limits. Tips for solving 100 incredibly difficult problems are covered in depth and include extracting the first letter of each word in a paragraph, validating URL's, generating random numbers without repeating, and hiding rows if cells are empty. The answers to these and other questions have produced results that have even surprised the Excel development team.
Don't miss this book.
Don't miss this book.
