SAP is the world's leading provider of ERP software and services, with worldwide revenue in 2004 of $9.7 billion and a 57 percent market share among major business application providers; it is one of the world's largest software companies overall ERP is a flexible, open technology platform that helps businesses run more efficiently (and profitably) by providing integrated management of key operations and supply chains Written for IT professionals who find it hard to get through SAP's complex documentation, our book demonstrates how ERP can cut costs, provides a clear overview of how the ESA (enterprise service architecture) model affects ERP, and shows how to implement the new ERP in the real world Topics covered include reducing the cost of an existing IT backbone, using the new ERP to address a company's «pain points» and challenges, and proving the value of ERP through ROI (return on investment) and TCO (total cost of ownership) studies
Get expert advice on daily, monthly, and yearly activities Define your business, maintain records, manage sales tax, and produce reports So you've pulled off the corporate highway and started your own business? Good for you! Now you need a small business accountant, and guess what? With QuickBooks Simple Start and this handy guide, it just might be YOU! Find out how to set up an accounting system, prepare invoices, pay expenses, organize your tax stuff, and more. The Dummies Way * Explanations in plain English * «Get in, get out» information * Icons and other navigational aids * Tear-out cheat sheet * Top ten lists * A dash of humor and fun Discover how to: * Install Simple Start and understand its features * Create invoices and sales receipts * Save big on business taxes * Set up and reconcile bank accounts * Measure your profits
Having Excel and just using it for standard spreadsheets is a little like getting the ultimate cable system and a 50” flat panel plasma HDTV and using it exclusively to watch Lawrence Welk reruns. With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more. This guide is not for rank Excel amateurs. It’s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you’re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes: An introduction to the VBA language A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder The essential VBA language elements, including comments, variables and constants, and labels Working with Range objects and discovering useful Range objective properties and methods Using VBA and worksheet functions, including a list and examples Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop Automatic procedures and Workbook events, including a table and event-handler procedures Error-handling and bug extermination techniques, and using the Excel debugging tools Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks Customizing the Excel toolbars Using VBA code to modify the Excel menu system Creating worksheet functions and working with various types of arguments Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there’s no substitute for hands-on learning. The book is complete with: A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes Information to help you make the most of Excel’s built-in Help system so you can find out other stuff you may need to know What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it’s a Very Big Accomplishment.
Find out how to * Understand XML specification and schemas * Set up and complete InfoPath?TM forms * Design new forms from XML data files * Debug InfoPath scripts * Tackle real-world problems with the help of case studies * Work with data in each of the XML-supported Office applications You don't need to be a programmer to enhance Office with XML XML support for Microsoft?? Office 2003 has taken interoperability to a new level. Now you can share data among Office applications, across platforms, and over the Internet using built-in XML tools. In this clearly organized volume, Peter Aitken helps you define and standardize document data structure within your organization using XML. He explains XML technology, walks you through designing templates with InfoPath, and shows you how to use the XML tools built into Word, Excel, Access, and FrontPage?? to facilitate data exchange throughout your enterprise. «…the real-world case studies are practical, offering detailed solutions to the scenarios outlined. I would recommend this book to anyone who plans to leverage the features found in the Office System 2003 for their business.» –Dave Beauchemin, Microsoft MVP CD-ROM Includes * Trial versions of John Walkenbach's Power Utility Pak, HotDog Professional, WinRAR?TM, and many others * Demo versions of BBEdit??, XML Pro, and more * Exclusive Office 2003 Super Bible eBook, with more than 500 pages of information about how Microsoft Office components work together * Valuable author files and examples
Use these great ideas to help you make your point Create PowerPoint presentations with Flash(r) movies, Excel(r) charts, and more Okay, you've PowerPointed before, right? And you knew there must be more cool things you could do? Here they are! This handy guide gives you pointers on what makes a powerful presentation, tips on using the right formats and templates, and directions for dressing up text, wowing 'em with color, adding action, and much more. Discover how to * Tweak and streamline PowerPoint * Get the most from color * Avoid amateur mistakes * Use shapes, fills, and 3D effects * Add photos, soundtracks, and DVD video * Deliver your presentation with punch
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.
Covers the new features, tools, and technologies in Office 2003 and demonstrates how developers can extend, enhance, and customize the suite using VisualBasic for Applications (VBA) More than 800 pages of clear and friendly For Dummies advice and instructions help developers get up to speed fast, improve workflow, and get the job done Packed with helpful real-world examples, including creating an Office document collaboration manager, automating e-mail routing, administering the Task Pane from within an application, and building a distributed business system using Web services The eight minibooks cover Office 2003 essentials; understanding Office programming; maximizing Word; making the most of Excel; advanced Access; exploiting Outlook; InterOffice; working as a team; and power techniques such as advanced Office automation, VBA, and .NET