Head First Excel: A Learner's Guide to SpreadsheetsDo 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.
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. |
Contents
Excels real power | 1 |
Income statement | 29 |
The dollar sign is part of your cells formatting | 35 |
Clash of the design titans | 41 |
Expenses | 52 |
Point in the right direction | 59 |
your mouse | 67 |
change your point of view | 89 |
9 | 227 |
Your pie chart isnt going over well with the corporate | 236 |
Youre starting to get tight on time | 247 |
what if analysis | 251 |
Scenarios helps you keep track of different inputs to the same model | 258 |
2 | 263 |
Betty needs you to add complexity to the model | 266 |
Do a sanity check on your Solver model | 272 |
Sorting shows you different perspectives on a large data | 95 |
See a lot more of your data with Zoom | 103 |
An unexpected note from the Main Campaign | 109 |
Donations are pouring | 115 |
Your doctor friend is on a deadline and has broken data | 118 |
The doctor has had this problem before | 125 |
A grad student also ran some statsand theres a problem | 132 |
Now youre a published scientist | 140 |
dates and times | 141 |
Ranges Single References C2 | 149 |
You give the formula your text Coach is happy to have you in her class | 161 |
7 | 169 |
A4 VALUE | 171 |
Jun | 179 |
Visualize your formulas | 197 |
95 | 202 |
The broker has a spreadsheet for you | 205 |
Excels loan functions all use the same basic elements | 212 |
Formulas must be correct and assumptions must be reasonable | 218 |
Your house was a good investment | 225 |
Down | 276 |
12 | 279 |
5 | 294 |
Newcustomers | 305 |
12 | 309 |
Pivot table construction is all about previsualizing where your fields | 316 |
Your editor is impressed | 322 |
Your pivot tables are a big hit | 330 |
TRUE and FALSE | 331 |
Summarize how many boats fall into each category | 343 |
When working with complex conditions break your formula apart | 350 |
Justice for fishies | 356 |
14 | 357 |
Total | 363 |
Mortgage Year 1 | 373 |
Create segments to feed the right data into your analysis | 374 |
Youve enabled Geopolitical Grunts to follow the money trail | 380 |
395 | |
397 | |