Программы - скачать книги или читать онлайн. Страница 15

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

"The author's humor and his ability to keep the reader's attention are masterful." —Andy Barkl, Technical Reviewer Salve For Your Office Headaches! Covers Office 2003, XP and 2000—And Perfectly Useful for Office 97, Too! Is it the best thing since sliced bread? A bug-riddled piece of junk? Here, best-selling author Dan Gookin skillfully navigates between these two extremes, laying bare the best and worst of Office in order to help you achieve a single, all-important goal: working faster, easier, and smarter. You'll harness the real power of Word, Excel, PowerPoint, and Outlook while avoiding their pitfalls—and you'll discover the ways they actually can be made to work together as a truly integrated suite. Dan Gookin's Naked Office means the end of Office-inspired headaches. (Well, the vast majority of them, anyway. He's not a miracle-worker, after all.) Expert Instruction to Change Office Life as You Know It (for the Better) Making a paragraph look the way you want it to look Understanding how styles work and making them work for you Locking a document to prevent changes, and tracking changes made by others Using Excel as a database–and not just for numbers Unraveling formulas and remembering what goes where Organizing e-mail with Outlook Getting the most out of Outlook's scheduling abilities Unlocking the mechanics and philosophy of PowerPoint presentations Oh, and of course–much, much more

Manage sales, service, and marketing processes all together Find out how to manage customer information to make your business more productive Whether you're completely new to customer relationship management (CRM) software or you just want the scoop on the newest version, this handy guide will get you going. Discover how to set up CRM 3, navigate and customize the system, use it to work with your accounts and contacts, collect leads, forecast sales, run reports, and much more. Discover how to * Develop and manage customer relationships * Implement a sales process * Set up security and access rights * Generate quotes, orders, and invoices * Manage leads and opportunities * Create and use product catalogs

"If you'd like a glimpse at how the next generation is going to program, this book is a good place to start." —Gregory V. Wilson, Dr. Dobbs Journal (October 2004) Build Your Own Automated Software Testing Tool Whatever its claims, commercially available testing software is not automatic. Configuring it to test your product is almost as time-consuming and error-prone as purely manual testing. There is an alternative that makes both engineering and economic sense: building your own, truly automatic tool. Inside, you'll learn a repeatable, step-by-step approach, suitable for virtually any development environment. Code-intensive examples support the book's instruction, which includes these key topics: Conducting active software testing without capture/replay Generating a script to test all members of one class without reverse-engineering Using XML to store previously designed testing cases Automatically generating testing data Combining Reflection and CodeDom to write test scripts focused on high-risk areas Generating test scripts from external data sources Using real and complete objects for integration testing Modifying your tool to test third-party software components Testing your testing tool Effective Software Test Automation goes well beyond the building of your own testing tool: it also provides expert guidance on deploying it in ways that let you reap the greatest benefits: earlier detection of coding errors, a smoother, swifter development process, and final software that is as bug-free as possible. Written for programmers, testers, designers, and managers, it will improve the way your team works and the quality of its products.

Spreadsheets have become the de facto standard for communicating business information and the preferred tool for analyzing business data. In this current climate, the accuracy and clarity of spreadsheets are paramount. However, busy managers have little time to sift through heaps of reference books to extrapolate techniques for making polished spreadsheets. Even with finished spreadsheets in hand, managers and business professionals still need a book which holds up a mirror to their real world situations and reflects hidden flaws; and then takes the next step and guides the reader in specific ways to rework these critical documents. Excel Best Practices for Business enables readers to examine their work and ask critical questions. And once asked, this book also answers with dynamic, practical approaches and provides Take-Aways extrapolated from real situations across a managerial spectrum, making this book more mentor than reference. In this book, a critical need is met. Book Highlights: XML in Microsoft Office Excel 2003: Entirely new to Excel 2003 is major support for XML, making Excel truly web capable and Internet ready. This book provides extensive coverage of these new features from a hands-on perspective. It identifies subtleties, gotchas and problems, and shows you practical solutions and workarounds. SPREADSHEET PORTALS: This book introduces the topic of Spreadsheet Portals, which elevates spreadsheet practices for the Internet-ready software to the next level. Aside from explaining the basic concepts and principles of Desktop Client Portals, best practice techniques for building your portal pages and reference implementations are provided. These reference implementations, sample spreadsheets, and online demos are provided on the book's CD. SPREADSHEET MAKEOVERS: What do you do when your manager or boss asks you to take over a complex, spreadsheet-based application and send out reports every two weeks? The person who created the spreadsheet no longer works for the company. Aside from a few emails, there's no documentation. You look at the spreadsheet and you find it has flaws. Never mind about fixing the old reports; the new ones are going to go out with your name on it. This report is not your prime responsibility. You do not have the time or resources to turn this into a whole project, yet you can't afford to leave it the way it is. Excel Best Practices for Business provides a step-by-step approach to these «Mission Impossible» situations and walks you through the steps with fully worked out examples. ASSISTIVE TECHNOLOGIES: For the first time in a mainstream book, the topic of preparing accessible spreadsheets for individuals with disabilities is addressed. Government agencies needing to make electronic information section 508 compliant and corporations choosing not to alienate communities with special needs will find the techniques presented invaluable. You will learn from a hands-on perspective how to organize and design accessible

Create Powerful Business Applications with Excel 2003 Excel 2003 is an ideal application development platform for all levels of business needs. If you're an advanced Excel user looking to gain programming experience, or a skilled developer new to Excel or the Excel Object Model, this no-nonsense book teaches you how to build custom applications that can generate substantial time and cost savings for you, your employer, and your customers. Written by a professional with nearly a decade of experience producing Excel/VBA solutions, Mastering Excel 2003 Programming with VBA conveys the precise knowledge and techniques you need to be highly productive. You'll master the most critical Excel objects and development practices necessary to create a complete solution, including working with XML data, Smart Document technology, and database integration with ADO. And you can readily apply the practical advice and reusable code examples to your own projects. In his friendly style, author Steven Hansen makes the information easy to grasp and entertaining to read, and he does not shy away from challenging material. You'll learn all about: Ramping up with VBA Debugging tools and tactics that work Mastering the Excel Object Model Developing class modules Customizing Excel UserForms Integrating Excel with other applications Incorporating text files in your solution Coding solutions that leverage a database Using XML in Excel Designing user-friendly toolbars and menus Building Excel 2003 Smart Documents Deploying your solution

Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions Shows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and more Gives explanations and examples of real-world situations Provides an abbreviated discussion of an additional 200 functions Excel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well

Wouldn’t it be a waste to go on a spectacular, exotic vacation abroad and just hang out at the hotel pool? Wouldn’t it be a waste to buy a new iPod, download four favorite songs, and play them over and over? Most people with Office 2003 are wasting a lot of software power and a lot of time. They do the same routine things in the same routine ways and haven’t begun to explore the capabilities of Office 2003. If you’re one of them, Office 2003 Timesaving Techniques For Dummies gets you out of your rut and into action. It provides over 70 timesaving techniques for Word, Excel, Access, Outlook, and PowerPoint. (Most of the tips work with Office 2000 and Office XP, too.) You’ll customize Office to meet your needs and start working like a pro in no time with easy-to-use tricks, tips, and techniques for: Streamlining your toolbars (Word alone has dozens to choose from) Setting up Outlook, searching with folders, organizing with flags, and dealing with spam Taking proper security measures, including using and updating an antivirus package and avoiding potentially dangerous file extensions Editing and laying out impressive Word documents Using keyboard shortcuts Diving into more advanced Office skills such as writing macros, setting up templates, and using multimedia with PowerPoint Using Excel to build self-verifying spreadsheets Running totals and subtotals in Access Combining applications to print holiday greetings and run an electronic newsletter Written by Woody Leonhard, author of Windows XP Timesaving Techniques For Dummies and the bestseller Windows XP All-in-One Desk Reference For Dummies, this guides helps you eliminate extra steps and little annoyances and do things you probably didn’t know you could do, such as: Building e-mail stationery Calculating sales tax with the Lookup Wizard Making professional labels Encrypting messages Recording narration for PowerPoint presentations Complete with an index that lets you find what you want, fast. Office 2003 Timesaving Techniques For Dummies helps you get up to speed and down to work. After all, times a-wastin!

Covers accessing and distilling PDF files; converting Microsoft Office documents; capturing paper documents and Web pages; printing, annotating, editing and securing PDF files; extracting text and graphics; cataloging and distributing PDF files; creating interactive forms; and building multimedia presentations. Readers can convert any document to this universal file format, preserving all the fonts, formatting, graphics, and color of the source document regardless of the application and platform used to create it. PDF files can be published and distributed anywhere: in print, attached to e-mail, on corporate servers, posted on Web sites, or on CD-ROM Adobe PDF is the emerging workflow standard in the $400 billion publishing industry and plays a key role in financial services, regulated industries, and government, with more than 155 agencies worldwide sharing Adobe PDF files.

You too can understand the statistics of life, even if you're math-challenged! What do you need to calculate? Manufacturing output? A curve for test scores? Sports stats? You and Excel can do it, and this non-intimidating guide shows you how. It demystifies the different types of statistics, how Excel functions and formulas work, the meaning of means and medians, how to interpret your figures, and more – in plain English. Getting there – learn how variables, samples, and probability are used to get the information you want Excel tricks – find out what's built into the program to help you work with Excel formulas Playing with worksheets – get acquainted with the worksheet functions for each step Graphic displays – present your data as pie graphs, bar graphs, line graphs, or scatter plots What's normal? – understand normal distribution and probability Hyping hypotheses – learn to use hypothesis testing with means and variables When regression is progress – discover when and how to use regression for forecasting What are the odds – work with probability, random variables, and binomial distribution Open the book and find: Ten statistical and graphical tips and traps The difference between descriptive and inferential statistics Why graphs are good How to measure variations What standard scores are and why they're used When to use two-sample hypothesis testing How to use correlations Different ways of working with probability

Curious about Google Sites and how team collaboration Web sites can help you share documents online from various locations? Curious about Google’s new Chrome browser? Google Sites & Chrome For Dummies has what you want to know! Today, Google is so much more than another word for “search.” Google Sites & Chrome For Dummies shows you how to create great collaborative Web sites with Google Sites and surf the Web with the super-fast Google Chrome browser. Find out how they work with other Google Apps, too. You’ll learn to: Take advantage of free hosting, free tools, and a simple, straightforward interface with Google Sites Set up a Google account or Google Apps account Create wiki sites that let coworkers collaborate on projects or keep family members up to date Use Google gadgets to keep track of projects, manage calendars and documents, or display photos Integrate documents, spreadsheets, presentations, and other Google Apps into your site Work with Contact List, Google Talk, and Google Chat, and handle e-mail with Gmail Download and install the speedy Google Chrome browser Install browser plug-ins, enable offline access to Google Docs, and manage misbehaving tabs You’ll even find instructions and examples to help you plan sites for personal and business use, plus a sample college course site. With advice from Google Sites & Chrome For Dummies, you can make collaboration easy and have the high-speed Web at your fingertips.

Microsoft Exchange Server 2007 was made to help you handle e-mail, meeting management, and other essential office services. Microsoft Exchange Server 2007 For Dummies helps you get a handle on Exchange Server. Pretty slick, huh? Here’s the lowdown on installing and administering Microsoft Exchange Server 2007 and taking advantage of all the enhancements in Service Pack 1. With this handy guide, you’ll be able to maximize the security, reliability, and speed that Exchange Server 2007 provides. Assess your organization’s needs to determine which edition of Exchange Server best meets them Explore what Exchange Server does, then plan, install, and configure it Consider how your users work with their mail and customize your set-up to facilitate their needs Learn to use the Exchange Management Console Use the new Exchange Server security features to protect e-mail from viruses, spam, phishing, and other threats Set up an offline address book, use templates, and develop custom forms Create settings for the most efficient interaction with clients, use multiple mailboxes, and view digital certificates Manage resource scheduling and interactive calendars Troubleshoot your configuration, perform regular maintenance, and be able to recover from mail-specific problems Monitor Exchange Server performance and maintain databases, mail flow, and peak performance Microsoft Exchange Server 2007 For Dummies gets you ready to exchange problems for solutions. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.