Synopses & Reviews
Put the power of Excel formulas and functions to work for you
Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.
You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier. See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well Includes essential coverage of an additional 85 functions
In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.
9780470556801
Visually explore the range of built-in and third-party libraries of Perl and Apache
Perl and Apache have been providing Common Gateway Interface (CGI) access to Web sites for 20 years and are constantly evolving to support the ever-changing demands of Internet users. With this book, you will heighten your knowledge and see how to usePerl and Apache to develop dynamic Web sites.
Beginning with a clear, step-by-step explanation of how to install Perl and Apache on both Windows and Linux servers, you then move on to configuring each to securely provide CGI Services. CGI developer and author Adam McDaniel shows techniques for effectively developing and maintaining dynamic sites and he shares real-world examples describing MySQL database access, PayPal credit-card transactions, and sample Facebook and Twitter interfaces. Apache and Perl have been providing Common Gateway Interface (CGI) access to Internet Web sites for more than two decades, and both products are constantly evolving to support today's user requirements Shows how to install Perl and Apache on Windows and Linux servers and configure each to securely provide CGI services Details techniques for effectively developing and maintaining dynamic Web sites Addresses MySQL database access and PayPal credit-card transactions, and examines sample Facebook and Twitter interfaces
With this book, you'll benefit from a wealth of techniques and resources that you won't find anywhere else.
Synopsis
Put the power of Excel formulas and functions to work for you!Excel is a complex program. Mastering the use of formulas and functions lets you use Excel to compute useful day-to-day information, such as calculating the true cost of credit card purchases or comparing 15-year and 30-year mortgage costs. This fun and friendly book demystifies Excel's built-in functions so you can put them to work.
You'll find step-by-step instructions on 150 of Excel's most useful functions, how they work within formulas, and how to use them to make your life easier.
- See how to use 150 of Excel's most useful functions, with real-world examples showing how each function is used within a formula
- Learn to calculate the costs of leasing versus buying a car, compute classroom grades, create an amortization table, or evaluate investment performance
- Fully updated for Excel 2010, but the principles will work with earlier versions of Excel as well
- Includes essential coverage of an additional 85 functions
In the ever-popular, non-threatening For Dummies style, Excel Formulas and Functions For Dummies, 2nd Edition makes Excel's power accessible to you.
Synopsis
Roll up your sleeves and start working with functions from ABS to ZTESTGet your hands dirty and dig for the nuggets in your data! This book shows you how, walking you through over 150 built-in functions in Excel 2010. Want to calculate a loan payment? How about finding a trend in your data? It's all covered with step-by-step instructions and illustrations, so you can put the power of Excel functions to work.
Put the fun in functions — from using the Insert Function dialog box and array functions to correcting formulas, you'll brush up on Excel
Do the math — create worksheets to track costs and revenue
Simple to sophisticated — take advantage of finance-related functions and learn how to sum and round numbers to get just the answers you need
Statistically speaking — test for central tendencies, analyze deviation, and count items in a data sample
Dive into forecasting — apply statistical functions to develop sound predictions
Make the data work for you — work with dates, times, and strings of text and pluck out pieces of data from a database
What's your function? — get the most from several cool functions, such as the amazing IF and the workhorses HLOOKUP and VLOOKUP
Open the book and find:
Tips for tapping into formula and function fundamentals
How to catch errors and audit formulas
Steps for moving from basic to advanced math functions
How to solve problems with statistics
Best practices for working with data
How to compare, find, and measure text
Ways to use lookup, logical, and reference functions
How to put data into a database structure
Learn to:
Use Excel's built-in formulas to make everyday calculations
Determine what functions to use in your formulas
Create amortization tables, calculate classroom grades, or evaluate investments
Design a database
About the Author
Ken Bluttman has been a software developer for 20 years. He is the author of several books, including
Excel Charts For Dummies.
Peter Aitken has written about computers and programming for over 10 years and has written more than 35 books, including Excel Programming Weekend Crash Course.
Table of Contents
Introduction.Part I: Putting the Fun in Functions.
Chapter 1: Tapping into Formula and Function Fundamentals.
Chapter 2: Saving Time with Function Tools.
Chapter 3: Saying "Array!" for Formulas and Functions.
Chapter 4: Fixing Formula Boo-Boos.
Part II: Doing the Math.
Chapter 5: Calculating Loan Payments and Interest Rates.
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got.
Chapter 7: Using Basic Math Functions.
Chapter 8: Advancing Your Math.
Part III: Solving with Statistics.
Chapter 9: Throwing Statistics a Curve.
Chapter 10: Using Signifi cance Tests.
Chapter 11: Rolling the Dice on Predictions and Probability.
Part IV: Working with Data.
Chapter 12: Dressing Up for Date Functions.
Chapter 13: Keeping Well-Timed Functions.
Chapter 14: Using Lookup, Logical, and Reference Functions.
Chapter 15: Digging Up the Facts.
Chapter 16: Writing Home about Text Functions.
Chapter 17: Playing Records with Database Functions.
Part V: The Part of Tens.
Chapter 18: Ten Tips for Working with Formulas.
Chapter 19: Ten Functions You Really Should Know.
Chapter 20: Some Really Cool Functions.
Index.