Head First Excel : A Learner's Guide to Spreadsheets

Whether you're completely new to Excel, or an experienced user looking to make the program work better for you, this book helps you incorporate Excel into the various aspects of your workflow, from a scratch pad for data-based brainstorming, to exploratory analysis with PivotTables, and presenting your conclusions with data visualizations.

Do you use Excel for simple lists, but get lost when it comes to actually doing something useful with all that data, like functions? Revolutionize the way your use the information in your life! "Head First Excel" helps you move from a spreadsheet dabbler into a savvy user in just a short time. Whether you're completely new to Excel, or an experienced user looking to make the program work better for you, this book will help you incorporate Excel into every aspect of your workflow, from a scratch pad for data-based brainstorming, to exploratory analysis with PivotTables, optimizing outcomes with Goal Seek, and presenting your conclusions with sophisticated data visualizations. Organize and present information clearly in a spreadsheet. Make calculations across a number of worksheets. Change your point of view with sorting, zooming, and filtering. Manipulate numerical and data to extract and use the data you need. Leverage Excel as a grid-based layout program. Get the most out of writing the right formulas for the right functionality. Nest formulas for more complex operations. Create sophisticated data visualizations with charts and graphs. Use Goal Seek to optimize possible outcomes based on different assumptions. Create summaries from large data sets for exploratory data analysis with PivotTables. We think your time is too valuable to waste struggling with new concepts. Using the latest research in cognitive science and learning theory to craft a multi-sensory learning experience, "Head First Excel" uses a visually rich format designed for the way your brain works, rather than a text-heavy approach that will put you to sleep.