Excel 2007 Data Analysis For Dummies

From the Back Cover
Unleash the power of Excel to make sense of your data
The fun and easy way to gain new insights into your data

This handy guide helps you analyze the information you work with in your job to make better decisions. From grabbing external data to working with PivotCharts, database functions, and regression analysis, it shows you step by step how Excel can turn raw data into intelligible information.

Discover how to
Import data into Excel
Work with PivotTables
Use database and statistical functions
Customize PivotCharts
Set up a Solver worksheet
Perform regression analysis calculations
–This text refers to an out of print or unavailable edition of this title.

About the Author
Stephen L. Nelson is the author of more than two dozen best-selling
books, including Quicken For Dummies and QuickBooks For Dummies (Wiley
Publishing, Inc.). In fact, Nelson’s books have sold more than 4,000,000 copies
in English and have been translated into more than ten other languages.
Nelson is a certified public accountant and a member of both the Washington
Society of CPAs and the American Institute of CPAs. He holds a Bachelor of
Science in Accounting, magna cum laude, from Central Washington University,
and a Masters in Business Administration in Finance from the University of
Washington (where, curiously, he was the youngest person ever to graduate
from the program), and a Master of Science in Taxation from Golden Gate

Nelson’s work experience includes stints as a book publisher and packager,
as the chief financial officer, treasurer, and controller of a high-technology
manufacturer, and as a senior consultant with one of the Big Five public
accounting firms.

Nelson lives in the foothills east of Redmond, Washington with his wife, two
daughters, and an indeterminate number of mice.

Related Articles

Microsoft Office Excel 2007 Data Analysis For Dummies

– Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization’s critical financial and statistical information, and put together compelling data presentations
– Now revised with over 30 percent new content to cover the enhancements in Excel 2007, including the completely redesigned user interface, augmented charting and PivotTable capabilities, improved security, and better data exchange through XML
– Provides thorough coverage of Excel features that are critical to data analysis-working with external databases, creating PivotTables and PivotCharts, using Excel statistical and financial functions, sharing data, harnessing the Solver, taking advantage of the Small Business Finance Manager, and more

QuickBooks 2007 AIO Desk Reference For Dummies

8 books in 1- your key to QuickBooks 2007 success!
Your one-stop guide to managing your small business finances more efficiently

QuickBooks is the leading accounting program for small businesses, and this book gives you a handy reference to all its parts. Set up QuickBooks for your business, load your files, create invoices, pay vendors, understand job costing and capital budgeting, and even get tips on writing your business plan. It all adds up to success!

Discover how to

Install and set up QuickBooks
Track your inventory and items
Prepare financial statements and reports
Set up project and job costing systems
Protect your data
Save on business taxes

QuickBooks AIO Desk Reference For Dummies 2nd Edition

One of the principles of good business and good money management is to make the most of what you have. QuickBooks All-In-One Desk Reference For Dummies helps you make the most of QuickBooks business accounting software. Updated to cover changes and enhancements to the software, it combines eight quick reference guides:
– An Accounting Primer that covers basic principles, double-entry bookkeeping, and special accounting problems
– Getting Ready to Use QuickBooks with information on setting up QuickBooks, loading the master file lists, and fine-tuning QuickBooks
– Bookkeeping Chores, covering invoicing customers, paying vendors, tracking inventory, and more
– Accounting Chores including financial statements, reports, and budgets, using activity-based costing, and setting up project and job costing systems
– Financial Management such as ratio analysis, economic value-added analysis, and capital budgeting
– Business Plans, featuring profit-volume-cost analysis, forecasting, and writing a business plan
– Care and Maintenance, with information on protecting data, troubleshooting, and more
– Additional Business Resources including a crash course in Excel, a glossary, and more

Written by veteran Dummies author Stephen L. Nelson, MBA, CPA, and author of more than 100 books with more than four million copies in print, QuickBooks All-In-One Desk Reference For Dummies goes beyond the basics of how to use QuickBooks and provides expert advice on accounting chores, financial management, business planning, and much more. With a comprehensive index, it’s your instant, at-your-fingertips reference for everything from how to handle everyday accounting tasks to long-term planning for your business.

– Fine-tune QuickBooks for your business and your accounting systems
– Calculate breakeven points
– Budget for capital expenditures
– Take advantage of online banking

There’s even a companion Web site where you can take advantage of a sample business plan workbook and download a profit-volume cost analysis workbook. You won’t find a more comprehensive, authoritative, yet understandable guide to QuickBooks.

QuickBooks 2007 for Dummies

Keep your small business finances in tip-top form
Manage your business accounting and financial management tasks—quickly and accurately

If you’re like most small-business people, accounting is the last thing you want to spend lots of time on. That’s where this handy guide comes in. Written by a CPA, it quickly walks you through bookkeeping basics — and shows how QuickBooks can put your accounts in order so you can spend less time with the books and more time on business.

Discover how to

Build the perfect budget
Prepare customer invoices and record sales
Produce common financial statements
Manage inventory
Simplify tax return preparation
Balance accounts

Excel Formulas and Functions for Dummies 2nd Edition

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.