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

AutoCAD for dummies

The popular program AutoCAD

from AutoCAD 2004 till 2009 (book / edition)

AutoCAD 2004 for dummies

























Publisher: For Dummies
Number Of Pages: 408
Publication Date: 2003-05-02
Sales Rank: 155957
ISBN / ASIN: 0764540459
EAN: 9780764540455


AutoCAD 2005 for dummies



Publisher: For Dummies
Number Of Pages: 432
Publication Date: 2004-05-14
Sales Rank: 94908
ISBN / ASIN: 0764571389
EAN: 9780764571381


AutoCAD 2006 for dummies



Publisher: For Dummies
Number Of Pages: 432
Publication Date: 2005-05
ISBN-10 / ASIN: 0764589253
ISBN-13 / EAN: 9780764589256


AutoCAD 2007 for dummies



Publisher: For Dummies
Number Of Pages: 432
Publication Date: 2006-05-08
Sales Rank: 18628
ISBN / ASIN: 0471786497
EAN: 9780471786498


AutoCAD 2008 for dummies



Publisher: For Dummies
Number Of Pages: 432
Publication Date: 2007-04-30
ISBN-10 / ASIN: 0470116501
ISBN-13 / EAN: 9780470116500


AutoCAD 2009 & AutoCAD LT 2009 All-in-one Desk Reference for dummies

























Publisher: For Dummies
Number Of Pages: 792
Publication Date: 2008-05-12
ISBN-10 / ASIN: 0470243783
ISBN-13 / EAN: 9780470243787



Download link :

http://rapidshare.com/files/335394425/AutoCAD_books_English.rar

or

http://www.filefactory.com/file/a2ge5ab/n/AutoCAD_books_English.rar

Enjoy !

C programming books

Some books takes you from start level to professional level

books names , descriptions, download link :

Names :

C for Dummies_2nd edition_2004
beginning-programming-for-dummies-4th-ed-2007 Beginning_C_from_novoice_to_profissional2006_4th_ed
c advanced
c tutorial

Descriptions

C for Dummies 2nd edition 2004































Publisher: For Dummies
Number Of Pages: 408
Publication Date: 2004-05-07
Sales Rank: 114573
ISBN / ASIN: 0764570684
EAN: 9780764570681
Contents at a glance:

Introduction .................................................................1
Part I: Introduction to C Programming............................7
Chapter 1: Up from the Primordial C ...............................................................................9
Chapter 2: C of Sorrow, C of Woe....................................................................................19
Chapter 3: C Straight........................................................................................................29
Chapter 4: C What I/O ......................................................................................................39
Chapter 5: To C or Not to C .............................................................................................55
Chapter 6: C More I/O with gets() and puts()..........................................................65
Part II:
Run and Scream from Variables and Math ........73
Chapter 7: A + B = C..........................................................................................................75
Chapter 8: Charting Unknown Cs with Variables .........................................................93
Chapter 9: How to C Numbers ......................................................................................107
Chapter 10: Cook That C Variable Charred, Please....................................................121
Part III:
Giving Your Programs the Ability to Run Amok ............................................................131
Chapter 11: C More Math and the Sacred Order of Precedence ..............................133
Chapter 12: C the Mighty if Command.......................................................................147
Chapter 13: What If C==C? .............................................................................................165
Chapter 14: Iffy C Logic..................................................................................................175
Chapter 15: C You Again ................................................................................................185
Chapter 16: C the Loop, C the Loop++.........................................................................201
Chapter 17: C You in a While Loop...............................................................................215
Chapter 18: Do C While You Sleep................................................................................225
Chapter 19: Switch Case, or, From ‘C’ to Shining ‘c’...................................................239
Part IV:
C Level ........................................................251
Chapter 20: Writing That First Function......................................................................253
Chapter 21: Contending with Variables in Functions.................................................265
Chapter 22: Functions That Actually Funct ................................................................275
Chapter 23: The Stuff That Comes First ......................................................................293
Chapter 24: The printf() Chapter .............................................................................305
Chapter 25: Math Madness!...........................................................................................313
Chapter 26: The Old Random-Number Function........................................................325
Part V:
Part of Tens ..................................................337
Chapter 27: Ten More Things You Need to Know about the C Language................339
Chapter 28: Ten Tips for the Budding Programmer...................................................347
Chapter 29: Ten Ways to Solve Your Own Programming Problems .........................353
Appendix A:
The Stuff You Need to Know before You Read All the Other Stuff in This Book.........................359 Appendix B:
ASCII Table ...........................................371
Index .......................................................................377


beginning programming for dummies 4th ed 2007






























Publisher: For Dummies
Number Of Pages: 384
Publication Date: 2006-11-06
Sales Rank: 31918
ISBN / ASIN: 0470088702
EAN: 9780470088708

Beginning C from novice to professional 2006 4th ed





























Publisher: Apress
Number Of Pages: 640
Publication Date: 2006-10-19
Sales Rank: 323051
ISBN / ASIN: 1590597354
EAN: 9781590597354


Table of contents

	Introduction
	Cheat Sheet
	Part I - Programming a Computer
	Part Overview
	Chapter 1	-	Learning Computer Programming for the First Time
	Chapter 2	-	All About Programming Languages
	Chapter 3	-	How to Write a Program
	Chapter 4	-	The Tools of a Computer Programmer
	Part II - The Building Blocks of Programming
	Part Overview
	Chapter 5	-	Getting Started
	Chapter 6	-	The Structure of a Computer Program
	Chapter 7	-	Variables, Constants, and Comments
	Chapter 8	-	Crunching Numbers and Playing with Strings
	Chapter 9	-	Making Decisions with Branching Statements
	Chapter 10	-	Repeating Yourself with Loops
	Chapter 11	-	Dividing a Program into Subprograms
	Chapter 12	-	Storing Stuff in Arrays
	Chapter 13	-	Playing with Object-Oriented Programming
	Part III - Advanced Programming Topics
	Part Overview
	Chapter 14	-	Sorting and Searching Algorithms
	Chapter 15	-	Debugging Programs
	Chapter 16	-	Optimizing Your Code
	Chapter 17	-	Creating a User Interface
	Part IV - Internet Programming
	Part Overview
	Chapter 18	-	Playing with HTML
	Chapter 19	-	Making Interactive Web Pages with JavaScript
	Chapter 20	-	Using Java Applets on Web Pages
	Part V - The Part of Tens
	Part Overview
	Chapter 21	-	Ten Additional Programming Resources
	Chapter 22	-	Ten Cool Programming Careers
	Appendix A	-	Common Loop and Branching Structures
	Appendix B	-	Free Language Compilers and Interpreters
	Appendix C	-	Common Programming Terms
	Appendix D	-	Installing the CD Compilers
	Index
	List of Figures
	List of Tables
	List of Listings
	List of Sidebars

c tutorial

programming with

lcc-win32

by
Jacob Navia and Friedrich Dominicus


c advanced

Advanced programming with

lcc-win32

by
Jacob Navia and Friedrich Dominicus


Download Link :

http://rapidshare.com/files/335942930/C_Books_English.rar