Microsoft Office Excel 2007 Formulas & Functions For Dummies

Microsoft Office Excel 2007 Formulas & Functions For Dummies
























Publisher: For Dummies
Number Of Pages: 366
Publication Date: 2007-01-30
ISBN-10 / ASIN: 0470046554
ISBN-13 / EAN: 9780470046555


Contents at a Glance
Introduction .................................................................1
Part I: Putting the Fun in Functions ...............................5
Chapter 1: Tapping into Formula and Function Fundamentals ....................................7
Chapter 2: Saving Time with Function Tools ................................................................37
Chapter 3: Saying “Array!” for Formulas and Functions..............................................53
Chapter 4: Fixing Formula Boo-Boos..............................................................................63
Part II: Counting on Your Money..................................79
Chapter 5: Calculating Loan Payments and Interest Rates .........................................81
Chapter 6: Appreciating What You’ll Get, Depreciating What You Got .....................97
Chapter 7: Using Basic Math Functions.......................................................................113
Chapter 8: Advancing Your Math .................................................................................131
Chapter 9: Throwing Statistics a Curve.......................................................................149
Chapter 10: Using Significance Tests ...........................................................................185
Part III: Doing the Math............................................195
Chapter 11: Rolling the Dice on Predictions and Probability ..................................197
Chapter 12: Dressing Up for Date Functions...............................................................215
Chapter 13: Keeping Well-Timed Functions ................................................................233
Chapter 14: Using Lookup, Logical, and Reference Functions .................................241
Chapter 15: Digging Up the Facts .................................................................................269
Part IV: Working with Data .......................................283
Chapter 16: Writing Home about Text Functions .......................................................285
Chapter 17: Playing Records with Database Functions.............................................311
Part V: The Part of Tens ............................................323
Chapter 18: Ten-Plus Tips for Working with Formulas ..............................................325
Chapter 19: Ten-Plus Functions You Really Should Know.........................................339
Index .......................................................................347


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 Just the Steps For Dummies

Excel 2007 Just the Steps For Dummies























Publisher: For Dummies
Number Of Pages: 234
Publication Date: 2007-02-12
Sales Rank: 67614
ISBN / ASIN: 0470039213
EAN: 9780470039212



Contents at a Glance
Introduction............................................1
Part I: Putting Excel to Work ...................3
Chapter 1: Working with Excel Files ..............................................5
Chapter 2: Entering Spreadsheet Data.........................................15
Chapter 3: Building Formulas ......................................................27
Chapter 4: Protecting Excel Data ................................................37
Part II: Sprucing Up
Your Spreadsheets.................................45
Chapter 5: Formatting Cells ........................................................47
Chapter 6: Applying Additional Formatting Options.................55
Chapter 7: Designing with Graphics............................................63
Chapter 8: Managing Workbooks ................................................73
Part III: Viewing Data
in Different Ways..................................81
Chapter 9: Changing Worksheet Views ......................................83
Chapter 10: Sorting Data...............................................................91
Chapter 11: Creating Charts ........................................................101
Chapter 12: Printing Workbooks................................................113
Part IV: Analyzing Data with Excel ......123
Chapter 13: Working with Outlines ..........................................125
Chapter 14: Filtering Data..........................................................135
Chapter 15: Creating PivotTables...............................................145
Chapter 16: Building Simple Macros.........................................157
Chapter 17: Saving Time with Excel Tools ................................163
Part V: Utilizing Excel with Other
People and Applications ......................169
Chapter 18: Collaborating in Excel ...........................................171
Chapter 19: Integrating Excel into Word...................................177
Chapter 20: Blending Excel and PowerPoint ............................185
Chapter 21: Using Excel with Access ..........................................191
Part VI: Practical Applications
for Excel .............................................199
Chapter 22: Designing an Organization Chart .........................201
Chapter 23: Creating a Commission Calculator.......................209
Chapter 24: Tracking Medical Expenses.....................................215
Chapter 25: Planning for Your Financial Future.......................223
Index..................................................227


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 For Dummies Quick Reference

Excel 2007 For Dummies Quick Reference

























Publisher: For Dummies
Number Of Pages: 224
Publication Date: 2007-01-10
Sales Rank: 545945
ISBN / ASIN: 0470046716
EAN: 9780470046715


Contents at a Glance
Part 1: Getting to Know Excel 2007 ................................................................1
Part 2: Managing Workbooks ........................................................................21
Part 3: Working with Worksheets ................................................................37
Part 4: Entering and Editing Worksheet Data ..............................................49
Part 5: Using Formulas and Functions..........................................................77
Part 6: Creating and Using Names ................................................................87
Part 7: Auditing Your Work ..........................................................................97
Part 8: Formatting Your Data ......................................................................113
Part 9: Printing Your Work..........................................................................135
Part 10: Charting Your Data ........................................................................151
Part 11: Working with Tables......................................................................169
Part 12: Goal Seeking and What-If Analysis ..............................................185
Part 13: Analyzing Data with PivotTables..................................................193
Glossary: Tech Talk......................................................................................207
Index ............................................................................................................215


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 All-In-One Desk Reference For Dummies

Excel 2007 All-In-One Desk Reference For Dummies




















Publisher: For Dummies
Number Of Pages: 777
Publication Date: 2007-01-03
Sales Rank: 74813
ISBN / ASIN: 0470037385
EAN: 9780470037386



Contents at a Glance
Introduction .................................................................1
Book I: Excel Basics....................................................11
Chapter 1: The Excel 2007 User Experience .................................................................13
Chapter 2: Getting Help, Tips, and Updates..................................................................47
Chapter 3: Customizing Excel .........................................................................................57
Book II: Worksheet Design ..........................................77
Chapter 1: Building Worksheets .....................................................................................79
Chapter 2: Formatting Worksheets ..............................................................................123
Chapter 3: Editing and Proofing Worksheets..............................................................179
Chapter 4: Managing Worksheets.................................................................................229
Chapter 5: Printing Worksheets....................................................................................267
Book III: Formulas and Functions...............................295
Chapter 1: Building Basic Formulas.............................................................................297
Chapter 2: Logical Functions and Error Trapping......................................................335
Chapter 3: Date and Time Formulas ............................................................................355
Chapter 4: Financial Formulas ......................................................................................371
Chapter 5: Math and Statistical Formulas ...................................................................385
Chapter 6: Lookup, Information, and Text Formulas.................................................407
Book IV: Worksheet Collaboration and Review ............433
Chapter 1: Protecting Workbooks and Worksheet Data ............................................435
Chapter 2: Linking Workbooks with Hyperlinks.........................................................457
Chapter 3: Sending Workbooks Out for Review .........................................................467
Chapter 4: Sharing Worksheets and Worksheet Data ................................................497
Book V: Charts and Graphics .....................................521
Chapter 1: Charting Worksheet Data ...........................................................................523
Chapter 2: Adding Graphic Objects .............................................................................559
Book VI: Data Management.......................................587
Chapter 1: Building and Maintaining Data Lists .........................................................589
Chapter 2: Filtering and Querying a Data List ............................................................613
Book VII: Data Analysis ............................................653
Chapter 1: Performing What-If Scenarios ....................................................................655
Chapter 2: Generating Pivot Tables .............................................................................679
Book VIII: Excel and VBA ..........................................699
Chapter 1: Building and Running Macros....................................................................701
Chapter 2: VBA Programming.......................................................................................711
Appendix: Using XML File Formats ..............................................................................737
Index .......................................................................739


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 Dashboards and Reports For Dummies

Excel 2007 Dashboards and Reports For Dummies
























Publisher: For Dummies
Number Of Pages: 336
Publication Date: 2008-03-04
ISBN-10 / ASIN: 0470228148
ISBN-13 / EAN: 9780470228142


Contents at a Glance
Introduction .................................................................1
Part I: Making the Move to Dashboards..........................7
Chapter 1: Getting in the Dashboard State of Mind .......................................................9
Chapter 2: Building a Super Model.................................................................................23
Part II: Building Basic Dashboard Components .............49
Chapter 3: The Pivotal Pivot Table.................................................................................51
Chapter 4: Excel Charts for the Uninitiated ..................................................................85
Chapter 5: The New World of Conditional Formatting ..............................................109
Chapter 6: The Art of Dynamic Labeling .....................................................................135
Part III: Building Advanced Dashboard Components....151
Chapter 7: Components That Show Trending ............................................................153
Chapter 8: Components That Group and Bucket Data ..............................................177
Chapter 9: Components That Display Performance against a Target......................195
Part IV: Advanced Reporting Techniques ....................209
Chapter 10: Macro-Charged Reporting ........................................................................211
Chapter 11: Giving Users an Interactive Interface .....................................................227
Part V: Working with the Outside World .....................249
Chapter 12: Using External Data for Your Dashboards and Reports .......................251
Chapter 13: Sharing Your Work with the Outside World ...........................................265
Part VI: The Part of Tens ...........................................279
Chapter 14: Ten Chart Design Principles ....................................................................281
Chapter 15: Ten Questions to Ask Before Distributing Your Dashboard ................293
Index .......................................................................299



Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 Workbook For Dummies

Excel 2007 Workbook For Dummies


























Publisher: For Dummies
Number Of Pages: 408
Publication Date: 2007-09-04
Sales Rank: 329593
ISBN / ASIN: 0470169370
EAN: 9780470169377


Contents at a Glance
Introduction .............................................................................1
Part I: Creating Spreadsheets ....................................................7
Chapter 1: Getting Familiar with the Excel 2007 Interface ...............................................................9
Chapter 2: Entering the Spreadsheet Data .......................................................................................19
Chapter 3: Formatting the Spreadsheet............................................................................................37
Chapter 4: Printing Spreadsheet Reports .........................................................................................57
Chapter 5: Modifying the Spreadsheet..............................................................................................77
Part II: Using Formulas and Functions ...................................101
Chapter 6: Building Formulas...........................................................................................................103
Chapter 7: Copying and Correcting Formulas................................................................................123
Chapter 8: Creating Date and Time Formulas ................................................................................145
Chapter 9: Financial Formulas and Functions................................................................................153
Chapter 10: Using Math Functions...................................................................................................163
Chapter 11: Using Common Statistical Functions .........................................................................175
Chapter 12: Using Lookup Functions ..............................................................................................183
Chapter 13: Using Logical Functions ...............................................................................................193
Chapter 14: Text Formulas and Functions......................................................................................205
Part III: Working with Graphics.............................................213
Chapter 15: Charting Spreadsheet Data..........................................................................................215
Chapter 16: Adding Graphics to Spreadsheets ..............................................................................229
Part IV: Managing and Securing Data....................................251
Chapter 17: Building and Maintaining Data Lists...........................................................................253
Chapter 18: Protecting the Spreadsheet .........................................................................................275
Part V: Doing Data Analysis..................................................287
Chapter 19: Performing What-If Analysis........................................................................................289
Chapter 20: Generating Pivot Tables...............................................................................................303
Part VI: Macros and Visual Basic for Applications ..................319
Chapter 21: Using Macros.................................................................................................................321
Chapter 22: Using the Visual Basic Editor ......................................................................................329
Part VII: The Part of Tens......................................................343
Chapter 23: Top Ten Features in Excel 2007...................................................................................345
Chapter 24: Top Ten Tips for Using Excel Like a Pro ....................................................................349
Appendix: About the CD........................................................357
Index...................................................................................365


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 Data Analysis For Dummies

Excel 2007 Data Analysis For Dummies


























Publisher: For Dummies
Number Of Pages: 356
Publication Date: 2007-02-20
Sales Rank: 51890
ISBN / ASIN: 047004599X
EAN: 9780470045992




Contents at a Glance
Introduction .................................................................1
Part I: Where’s the Beef? ..............................................7
Chapter 1: Introducing Excel Tables ................................................................................9
Chapter 2: Grabbing Data from External Sources ........................................................31
Chapter 3: Scrub-a-Dub-Dub: Cleaning Data .................................................................57
Part II: PivotTables and PivotCharts.............................79
Chapter 4: Working with PivotTables ............................................................................81
Chapter 5: Building PivotTable Formulas....................................................................107
Chapter 6: Working with PivotCharts ..........................................................................127
Chapter 7: Customizing PivotCharts............................................................................143
Part III: Advanced Tools............................................157
Chapter 8: Using the Database Functions ...................................................................159
Chapter 9: Using the Statistics Functions ...................................................................181
Chapter 10: Descriptive Statistics ................................................................................223
Chapter 11: Inferential Statistics ..................................................................................245
Chapter 12: Optimization Modeling with Solver ........................................................263
Part IV: The Part of Tens ...........................................287
Chapter 13: Almost Ten Things You Ought to Know about Statistics .....................289
Chapter 14: Almost Ten Tips for Presenting Table Results
and Analyzing Data ......................................................................................................299
Chapter 15: Ten Tips for Visually Analyzing and Presenting Data...........................305
Part V: Appendix ......................................................319
Glossary of Data Analysis and Excel Terms................................................................321
Index .......................................................................331


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel 2007 For Dummies

Excel 2007 For Dummies

































Publisher: For Dummies
Number Of Pages: 384
Publication Date: 2006-12-26
Sales Rank: 3969
ISBN / ASIN: 0470037377
EAN: 9780470037379


Contents at a Glance
Introduction .................................................................1
Part I: Getting In on the Ground Floor ............................9
Chapter 1: The Excel 2007 User Experience .................................................................11
Chapter 2: Creating a Spreadsheet from Scratch .........................................................51
Part II: Editing Without Tears......................................97
Chapter 3: Making It All Look Pretty ..............................................................................99
Chapter 4: Going through Changes ..............................................................................141
Chapter 5: Printing the Masterpiece............................................................................173
Part III: Getting Organized and Staying That Way ......201
Chapter 6: Maintaining the Worksheet ........................................................................203
Chapter 7: Maintaining Multiple Worksheets .............................................................231
Part IV: Digging Data Analysis..................................253
Chapter 8: Doing What-If Analysis................................................................................255
Chapter 9: Playing with Pivot Tables ...........................................................................269
Part V: Life Beyond the Spreadsheet ..........................285
Chapter 10: Charming Charts and Gorgeous Graphics .............................................287
Chapter 11: Getting on the Data List............................................................................319
Chapter 12: Hyperlinks and Macros.............................................................................343
Part VI: The Part of Tens ...........................................355
Chapter 13: Top Ten New Features in Excel 2007.......................................................357
Chapter 14: Top Ten Beginner Basics ..........................................................................361
Chapter 15: The Ten Commandments of Excel 2007..................................................363
Index .......................................................................365


Download links from here :

http://ubookmark.blogspot.com/2010/02/excel-for-dummies.html

Enjoy !

Excel learning books : For Dummies & more

Download link for all these books :

GROUP 1 :

Excel 2007 Data Analysis For Dummies
Excel 2007 Workbook For Dummies
Excel_2007_Dashboards_and_Reports_For_Dummies
Excel_2007_For_Dummies

GROUP 2 :

Excel 2007 All-In-One Desk Reference For Dummies
Excel 2007 For Dummies Quick Reference
Excel 2007 Just the Steps For Dummies
Microsoft Office Excel 2007 Formulas & Functions For Dummies

The Download links :

Group 1

http://www.4shared.com/file/3-nMHKMb/Excel_books_1.html
OR
http://rapidshare.com/files/346325874/Excel_books_1.rar

Group 2
http://www.4shared.com/file/L04HCDvq/Excel_books_2.html
OR
http://rapidshare.com/files/346347780/Excel_books_2.rar