25 Books to Read Before You Die
 
 

Recently Viewed clear list


The Powell's Playlist | August 6, 2014

Graham Joyce: IMG The Powell’s Playlist: Graham Joyce



The Ghost in the Electric Blue Suit is set on the English coast in the hot summer of 1976, so the music in this playlist is pretty much all from the... Continue »
  1. $17.47 Sale Hardcover add to wish list

spacer

Head First Excel: A Learner's Guide to Spreadsheets

by

Head First Excel: A Learner's Guide to Spreadsheets Cover

 

Synopses & Reviews

Publisher Comments:

Do you use Excel for simple lists, but get confused and frustrated when it comes to actually doing something useful with all that data? Stop tearing your hair out: Head First Excel helps you painlessly move from spreadsheet dabbler to savvy user.

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 clearly present information in a spreadsheet
  • Make calculations across a number of worksheets
  • Change your point of view with sorting, zooming, and filtering
  • Manipulate numerical data to extract and use just what you need
  • Leverage Excel as a grid-based layout program
  • Write formulas for optimal 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.

Book News Annotation:

Are you afraid to try something different? Then this book is not for you. However, if you prefer stimulating dinner party conversation to dull academic lectures, welcome home. With b&w photos, screen shots, thought balloons, and illustrations, this guide to Excel employs an unusual visual layout based on the latest cognitive science, and incorporates humor and a conversational tone. Information is presented in different ways for different learning styles, with emphasis on word-picture relationships, stories, and open-ended questions. The book covers beginning and advanced skills for new and experienced Excel users, with material progressing from formulas through data types, text functions, pivot tables, Booleans, and segmentation. The book ends with brief instructions for installing the Excel add-in called Solver. Milton is a programmer. Annotation ©2010 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Whether completely new to Excel or an experienced user looking to make the program work better, this book can help users incorporate Excel into every aspect of their workflow, from a scratch pad for data-based brainstorming to exploratory analysis with PivotTables.

About the Author

Michael Milton is a Head First fanatic. He has a degree in philosophy from New College of Florida and one in religious ethics from Yale University.

Table of Contents

Advance Praise for Head First Excel Praise for other Head First books Author of Head First Excel How to Use This Book: Intro Chapter 1: Introduction to Formulas: Excel's real power Chapter 2: Visual Design: Spreadsheets as art Chapter 3: References: Point in the right direction Chapter 4: Change your Point of View: Sort, zoom, and filter Chapter 5: Data Types: Make Excel value your values Chapter 6: Dates and Times: Stay on time Chapter 7: Finding Functions: Mine Excel's features on your own Chapter 8: Formula Auditing: Visualize your formulas Chapter 9: Charts: Graph your data Chapter 10: What if Analysis: Alternate realities Chapter 11: Text Functions: Letters as data Chapter 12: Pivot Tables: Hardcore grouping Chapter 13: Booleans: TRUE and FALSE Chapter 14: Segmentation: Slice and dice Leftovers: The Top Ten Things (we didn't cover) Install Excel's Solver: The Solver

Product Details

ISBN:
9780596807696
Author:
Milton, Michael
Publisher:
O'Reilly Media
Subject:
Spreadsheets - General
Subject:
Spreadsheets - Excel
Subject:
Business -- Computer programs.
Subject:
Electronic spreadsheets
Subject:
Personal Computers-Applications
Subject:
Personal Computers-Desktop Applications-Spreadsheets
Subject:
Excel;Head First;Microsoft;Office;desktop application;formulas;pivot table;spreadsheet;worksheets
Subject:
CourseSmart Subject Description
Copyright:
Edition Description:
Print PDF
Series:
Head First
Publication Date:
20100331
Binding:
TRADE PAPER
Language:
English
Illustrations:
Y
Pages:
448
Dimensions:
9.25 x 8.00 in

Other books you might like

  1. 1,000 Places to See before You Die
    Used Trade Paper $1.50
  2. The Know-It-All: One Man's Humble...
    Used Trade Paper $0.95

Related Subjects

Computers and Internet » Operating Systems » Microsoft Windows » Applications
Computers and Internet » Operating Systems » Microsoft Windows » Windows 95 » General
Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets
History and Social Science » Military » General History

Head First Excel: A Learner's Guide to Spreadsheets Used Trade Paper
0 stars - 0 reviews
$16.95 In Stock
Product details 448 pages O'Reilly Media - English 9780596807696 Reviews:
"Synopsis" by , Whether completely new to Excel or an experienced user looking to make the program work better, this book can help users incorporate Excel into every aspect of their workflow, from a scratch pad for data-based brainstorming to exploratory analysis with PivotTables.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.