You may have to Search all our reviewed books and magazines, click the sign up button below to create a free account.
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.
Excel is the most popular tool for number crunching on the PC, but the challenge is in putting a meaningful face on those raw numbers. That’s where Excel Charts For Dummies comes in. Ken Bluttman will show readers how to professionally display data in presentation-quality charts. But he’ll go beyond showing readers how to create attractive charts—he’ll explain why to use specific charts in particular circumstances. Lots of real-world examples will show “the good, the bad, and the ugly” of Excel charts. He will cover the whole range of charts in step-by-step tutorials—whether it’s pies, scatter plots, or PivotCharts. He’ll show how to embed graphics and pictures into charts; then use them in impressive PowerPoint presentations or Microsoft Word documents. He’ll also show how to use charts for statistical analysis—and how charts can skew the stats and deceive. This book will feature a 16-page full-color insert of the best Excel charts “works of art.”
As part of the Microsoft Office suite, Access has become the industry's leading desktop database management program for organizing, accessing, and sharing information. But taking advantage of this product to build increasingly complex Access applications requires something more than your typical how-to book. What it calls for is Access Hacks from O'Reilly.This valuable guide provides direct, hands-on solutions that can help relieve the frustrations felt by users struggling to master the program's various complexities. For experienced users, Access Hacks offers a unique collection of proven techniques and tools that enable them to take their database skills and productivity to the next level....
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel. If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of built-in functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro. For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip a...
If you are designing websites and need an introduction to programming with the scripting language of the Web, Brilliant Javascript will show you how to use basic javascript programming to to improve the functionality and design of your webpages, validate forms, detect browsers, create cookies, and much more. Summary JavaScript is a critical component of nearly all web pages and web applications, and is the most popular scripting language on the internet, working in all major browsers, such as Internet Explorer, Mozilla, Firefox, Netscape, and Opera. It is a very powerful language but often overlooked as such. For years it has been used primarily for two things – validating form entries, an...
If you have large quantities of data in a Microsoft Access database, and need to study that data in depth, this book is a data cruncher's dream. Access Data Analysis Cookbook offers practical recipes to solve a variety of common problems that users have with extracting Access data and performing calculations on it. Each recipe includes a discussion on how and why the solution works. Whether you use Access 2007 or an earlier version, this book will teach you new methods to query data, different ways to move data in and out of Access, how to calculate answers to financial and investment issues, and more. Learn how to apply statistics to summarize business information, how to jump beyond SQL by...
Make Excel do the math and make sense of your data Use the Insert Function dialog box, array formulas and functions, and more Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here's the fun and easy way! Discover how to * Create worksheets to track costs and revenue * Tell the difference among average, median, and mode * Work with statistical functions * Develop forecasts and track trends * Manipulate strings and work with database functions
A brain friendly guide to Excel.