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

Are you a visual learner? Do you prefer instructions that show you how to do something – and skip the long-winded explanations? If so, then this book is for you. Open it up and you'll find clear, step-by-step screen shots that show you how to tackle more than 150 Excel 2007 tasks. Each task-based spread includes easy, visual directions for performing necessary operations, including: * Using the Ribbon and galleries * Entering data and resizing columns * Applying formulas and functions * Formatting worksheets * Adding clip art and 3D effects * Interpreting data with charts * Helpful sidebars offer practical tips and tricks * Succinct explanations walk you through step by step * Full-color screen shots demonstrate each task * Two-page lessons break big topics into bite-sized modules

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

Are you ready to reap the benefits of the bestselling contact relationship manager (CRM) software on the market today? Well, then—get into the act with ACT! 2008 and find out how the latest version of this exciting software enables you to set up a database that’s right for you so that you can focus on your business and career growth while also saving time and money. With this fun and friendly guide in hand, you’ll discover how ACT! organizes customer information in one place, safely shares customer info between workgroups, and provides you with forecast tools, reports, and a contact database. Whether you’re new to the features of ACT! or you are familiar with the basics but have not yet put to use ACT!’s more advanced abilities, this nuts-and-bolts reference has been updated and revised to make sure that you are up to speed on the most efficient way to organize your customer relationships and activities. Author and full-time ACT! Certified Consultant and ACT! Premier Trainer Karen Fredricks walks you through tasks such as: Setting up the contact database Adding multiple contacts to a group and adding contacts to a company Changing contact-level security access Scheduling activities Using the basic ACT! Reports Designing new reports Automating the backup process Integrating with Outlook Creating groups ACT! by Sage For Dummies, 9th Edition also boasts a companion Web site that includes all the updates for the 2008 version of ACT! You’ll be amazed by just how quickly you’ll be able to set up a database and get it to act for you.

Microsoft Office Live is a service that allows individuals, small businesses, and organizations to create Web sites, share documents, and have a shared storage area on the Web Explains how to create a Web site; share documents, contact lists, project plans, and calendars; send or receive e-mails using Live Mail; and allow customers, employees, and vendors access to data based on specific security restrictions Discusses establishing security levels, sharing documents, defining and managing projects, tracking company assets, using the Contact Manager, using marketing campaigns, and working with client workspaces Office Live services can be used independently but they also integrate well with Microsoft Office programs used regularly by more than 400 million people around the world, including Microsoft Access, Excel, Outlook, Microsoft Office Live Meeting and Microsoft Office Small Business Edition

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!