Learn What Usability Really Is, Why to Strive for It, and How to Achieve It «Highly useable» software is easy to use. It does what you expect it to. And it does it well. It's not easy to build but as this book demonstrates, it's well worth the effort. Highly useable software is highly successful software—and everyone wins. Inside, an accomplished programmer who has made usability his business systematically explores the world of programming, showing you how every aspect of the work is implicated in the usability of the final product. This is not just an «issues» book, however, but systematic, real-world instructions for developing applications that are better in every way. As you'll learn, there's no such thing as «intuitive» software. Instead, there are just the factors that make it highly useable: simplicity, consistency, the recognition of accepted conventions, and the foregrounding of the user's perspective. With these principles under your belt, you'll quickly discover dozens of ways to make your applications more useable: Making windows and dialog boxes easy to comprehend and use Designing software that is time- and resource-efficient Making your software easy to navigate Reducing the complexity of reports and other presentations of data Understanding how the wrong programming decisions can limit usability Ensuring smooth starts and stops Capitalizing on the usability advantages of object-oriented programming Understanding how usability affects your product's financial success Using the testing process to improve usability Promoting usability in training, installation, and online help Making management decisions that will benefit software usability Some chapters are written primarily for programmers, one primarily for managers. Most are for everyone, and all are filled with illuminating, usually amusing examples drawn from both inside and outside the technical world. A helpful appendix provides information on standards, usability groups, and sources for more information.
One look at Excel 2007, with its new Office Button, Quick Access toolbar, and Ribbon, and you realize you’re not in Kansas anymore. Well, have no fear— Excel 2007 for Dummies is here! If you’ve never worked with a computer spreadsheet, or if you’ve had some experience with earlier versions of Excel but need help transitioning, here you’ll find everything you need to create, edit, format, and print your own worksheets (without sacrificing your sanity!). Excel 2007 for Dummies covers all the fundamental techniques, concentrating on only the easiest, most user-friendly ways to get things done. You’ll discover how to: Rearrange, delete and insert new information Keep track of and organize data in a single worksheet Transfer data between the sheets of different workbooks Create a chart using the data in a worksheet Add hyperlinks and graphics to worksheets And more! Plus, in keeping with Excel 2007’s more graphical and colorful look, Excel 2007 for Dummies has taken on some color of its own, with full-color plates in the mid-section of the book illustrating exactly what you’ll see on your screen. Whether you read it from cover to cover or skip to the sections that answer your specific questions, the simple guidance in this book will have you excelling at home or in the office no time.
Apply Excel daily and smooth out life's wrinkles Who knew a spreadsheet could do as much for you as your favorite moisturizer? Become a Microsoft Excel Diva with this sassy guide and discover what hip IT Girls already know: smart is beautiful. Impress the heck out of everyone at work with your stylish reports. Do a budget and see exactly what you can spend on shoes. Get better organized. Who has time for dull technical manuals? Learn all of Microsoft Excel's secrets in this girl-talk guide. Welcome to the party! Relax, refresh, and reward yourself at the end of each chapter with fun, stress-reducing chats, like why soy Chai lattes are better than regular lattes. Don't miss these gems! * Meet Microsoft(r) Excel(r) 2007, the Louis Vuitton of spreadsheets * Join the conversation with these basic Excel terms * Learn the fine art of Excel formulas and functions * Dress up Excel data with SmartArt, WordArt, and other chic accessories * Build a shopping spree budget from scratch * Show off by adding Excel data into Word and PowerPoint(r)
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
This book is a single reference that’s indispensable for Excel beginners, intermediate users, power users, and would-be power users everywhere Fully updated for the new release, this latest edition provides comprehensive, soup-to-nuts coverage, delivering over 900 pages of Excel tips, tricks, and techniques readers won’t find anywhere else John Walkenbach, aka «Mr. Spreadsheet,» is one of the world’s leading authorities on Excel Thoroughly updated to cover the revamped Excel interface, new file formats, enhanced interactivity with other Office applications, and upgraded collaboration features Includes a valuable CD-ROM with templates and worksheets from the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Step-by-step instructions for creating VBA macros Harness the power of VBA and create custom Excel applications Make Excel 2007 work for you! This clear, nonintimidating guide shows you how to use VBA to create Excel apps that look and work the way you want. Packed with plenty of sample programs, it explains how to work with range objects, control program flow, develop custom dialog boxes, create custom toolbars and menus, and much more. Discover how to Grasp essential programming concepts Use the Visual Basic Editor Navigate the new Excel user interface Communicate with your users Deal with errors and bugs
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