When you think of number-crunching and spreadsheets, you think of Excel, right? After Word, it’s the most popular program in the Microsoft Office suite. But if technical jargon isn’t your first language, you may have found Excel just a teeny bit frustrating. It can be really hard to pick your way through the many features and make Excel do what you need for it to do. Once you know how, you can use Excel to Create fill-in-the-blank forms Prepare expense reports and invoices Manage all sorts of data Keep sales and inventory records Analyze financial data and create forecasts Present information in charts and graphs Excel 2003 All-in-One Desk Reference For Dummies tames the Excel monster. Nine minibooks break things down into manageable, logical sections covering the basics, worksheet design, formulas and functions, worksheet collaboration, charts and graphics, data management, data analysis, working on the Web, and tweaking Excel with a programming language called Visual Basic for Applications, or VBA. In the friendly, plain-English For Dummies style, this book makes it easy to find what you’re looking for and get instructions for doing what you need to do. You’ll be able to Find your way around Excel’s menus, toolbars, and dialog boxes, and access online help Format a professional-looking spreadsheet that presents data the way you choose Edit an existing spreadsheet without disturbing its design or contents Build Excel formulas and use built-in functions to produce the calculations you want Share spreadsheet data with other people and programs, and collect comments Create great-looking charts and find out how to choose the right format to display your data effectively Use Excel to maintain large amounts of data, then filter the data to extract the information you need Publish spreadsheets and charts on the Web in HTML format Explore ways to customize Excel with VBA Best of all, it’s easy to find what you need in Excel 2003 All-in-One Desk Reference For Dummies. Before you know it, you’ll discover you’ve developed a friendship with Excel that will make your life easier, boost your business, and impress your friends!

Master the Ribbon, powerful graphics capabilities, and more! Your one-stop guide to great-looking spreadsheets that actually mean something Create colorful spreadsheets and charts, use Live Preview, and maximize everything Excel 2007 has to offer! Find just what you need to know about using the new Ribbon, designing spreadsheets that communicate, editing and printing them, working with formulas, protecting your data when you collaborate, turning out cool charts, and much more. The included four-color insert highlights the Ribbon, new graphics features, and more! Discover how to Create dynamic spreadsheets with style galleries Work with more than 40 new cell styles Automate formatting with Live Preview Share Excel data with other programs Use VBA to write custom Excel functions

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.

If you're setting up a network at home or creating and managing one for business, there are dozens of things to consider. Networking All-In-One Desk Reference For Dummies, 2nd Edition replaces a whole shelf full of reference books with one handy volume that covers just what you need to know. And with technology changing faster than the colors in a rock band’s light show, you'll be glad this updated edition includes the latest information. Written by Doug Lowe, who's been managing corporate networks for more than 20 years, this helpful guide shows you how to work with all Windows XP service packs as well as Fedora Linux. It's made up of nine minibooks that cover Networking basics Building a network Network administration and security Troubleshooting and disaster planning TCP/IP and the Internet Home networking Wireless networking Windows 2003 server reference Linux reference If you're a networking newbie, the first two minibooks gives you all the startup information to get your network up and running. If you've already done that, you're probably interested in keeping it running at peak performance. Book IV is loaded with information about finding, diagnosing, and fixing problems you might encounter. Looking for the scoop on keeping your network safe from online bad guys? Check Book III. Want to go wireless? Book VII tells you what you need to know. In these pages, you’ll find out how to Plan your network, select interface cards, hubs, and routers, and install all the hardware and software Set up your network so it’s easy to use but hard to break into Create a disaster recovery plan Understand IP addresses, subnetting, routing, DHCP, DNS, and other TCP/IP protocols and tools Incorporate other gadgets into your home network, including VoIP Internet-based telephone service Take advantage of the economical Linux networking alternative Best of all, it's easy to locate what you need. There's even a handy "cheat sheet" that puts really important information about cabling rules, private IP address ranges, valuable network administration tips, and helpful Web sites at your fingertips. With this book on hand, you’ll experience a net increase in your networking prowess!

Nine minibooks filling more than 800 pages provide the world's five million-plus Java developers with a basic all-in-one programming reference Covers the recent release of the Java 2 Platform Standard Edition 5.0 and the new J2SE Development Kit 5.0 Starts with beginner topics including getting started with Java, using the Java development platform, and Web programming Expands into more advanced Java fundamentals such as object-oriented programming, working with arrays and collections, and creating user interfaces with Swing

"The fun and easy way to decipher the predictions of this 16th-century prophet"--Cover subtitle.

Improve your efficiency -- and bring in big profits! Need help implementing or understanding Six Sigma? Want to take this powerful problem-solving methodology and apply it to your business? Six Sigma isn't just for Fortune 500 companies anymore; it's for every business, even yours, no matter how big or small. This hands-on workbook provides the knowledge, insight, and practical exercises you need to master Six Sigma and put it to work in your business. Perfect as a companion workbook for Six Sigma For Dummies -- or any other Six Sigma book -- Six Sigma Workbook For Dummies gives you a wealth of examples, problems, and other tools you need to turn Six Sigma theory into practice -- today! Discover * How to form and lead a Six Sigma initiative * Project alignment with business objectives and strategy * How to create process flow maps and models * Chart and graph plotting for analysis and interpretation * Methods for calculating Sigma scores * How to quantify variable relationships

Hands-on exercises help you boost your verb proficiency Get the hang of French verbs and get over verb hang-ups! French verbs can drive anyone crazy who's trying to keep track of all the regular and irregular types. Fortunately, this book is here to help you make sense of confusing rules and drill you on the exceptions. Each chapter is packed with examples, exercises, and conjugation charts - just what you need to master even the toughest French verbs. Discover how to Review regular verbs in the present tense Cope with common exceptions Conjugate all simple tenses, from present indicative to past subjunctive Tackle the trickiest irregular verbs Conjugate compound tenses

Find out how to manage your telecom services and save your company money! Worldwide telecom spending was over $4 trillion in 2004, and virtually all 12 million businesses in the U.S. buy phone and other telecom services Our book shows people at small and medium-sized businesses how to make sense of telecom lingo and get the best deals Includes an overview of the major players in the telecom industry and an easy-to-understand explanation of the existing telecom infrastructure Helps people pinpoint the telecom services best suited to their business needs, understand billing, and troubleshoot problems Covers emerging industry trends, such as Voice over Internet Protocol (VoIP), and how they can help businesses cut costs

Do you have a grasp of Algebra II terms and concepts, but can't seem to work your way through problems? No fear - this hands-on guide focuses on helping you solve the many types of Algebra II problems in an easy, step-by-step manner. With just enough refresher explanations before each set of problems, you'll sharpen your skills and improve your performance. You'll see how to work with linear and quadratic equations, polynomials, inequalities, graphs, sequences, sets, and more!