McGraw-Hill Technology Education’s Professional Approach Series presents exercises in real-life business situations so students get hands-on experience working on actual projects--the best way to prepare them for the on-the-job challenges they'll face. Each lesson contains up to 25 skill-applications and 5 end-of-unit skill-applications that take students from simple to complex situations. The Office 2003 texts complete instruction in all skill sets and activities for the appropriate Microsoft Office Specialist Certification (MOS) Exams.
The Student-Teacher Edition of Microsoft Office 2003 is the best-selling version of the software suite, and Special Edition Using Microsoft Office 2003, Student-Teacher Edition is the first book to tackle it from the perspective of this unique user. The SE Using format will help you explore advanced techniques that can save you time and help automate repetitive tasks. You will be able to increase your productivity in all areas of any one of the Microsoft Office 2003 applications. You'll also learn ways to make them work better together, further increasing your productivity. Take a look at Microsoft Office 2003 through the eyes of an expert with Special Edition Using Microsoft Office 2003, Student-Teacher Edition.
This book is aimed squarely at Excel users who want to harness the power of the VBA language in their Excel applications. At all times, the VBA language is presented in the context of Excel, not just as a general application programming language. The Primer has been written for those who are new to VBA programming and the Excel object model. It introduces the VBA language and the features of the language that are common to all VBA applications. It explains the relationship between collections, objects, properties, methods, and events and shows how to relate these concepts to Excel through its object model. It also shows how to use the Visual Basic Editor and its multitude of tools, including how to obtain help. The middle section of the book takes the key objects in Excel and shows, through many practical examples, how to go about working with those objects. The techniques presented have been developed through the exchange of ideas of many talented Excel VBA programmers over many years and show the best way to gain access to workbooks, worksheets, charts, ranges, and so on. The emphasis is on efficiency—that is, how to write code that is readable and easy to maintain and that runs at maximum speed. In addition, the chapters devoted to accessing external databases detail techniques for accessing data in a range of formats. The final four chapters of the book address the following advanced issues: linking Excel to the Internet, writing code for international compatibility, programming the Visual Basic Editor, and how to use the functions in the Win32 API (Windows 32-bit Application Programming Interface).
For any course teaching application software using Microsoft Office 2003 applications. This series will appeal to students in a variety of disciplines including liberal arts, business, and the sciences. This series gives the how and why of performing tasks in Office 2003. It provides new chapter opening case studies, real-world practice exercises; full business and integrated end of chapter cases, and expert topics of Microsoft Office 2003. More than two million students have used previous editions of this highly successful series!
This text presents statistical concepts and methods in a unified, modern, spreadsheet-oriented approach. Featuring a wealth of business applications, this examples-based text illustrates a variety of statistical methods to help students analyze data sets and uncover important information to aid decision-making. DATA ANALYSIS FOR MANAGERS contains professional StatPro add-ins for Microsoft Excel from Palisade, valued at one hundred fifty dollars packaged at no additional cost with every new text.
The goal of the O’Leary Series is to give students a basic understanding of computing concepts and to build the skills necessary to ensure that information technology is an advantage in whatever career they choose in life. The O’Leary Microsoft Office 2003 texts are crafted to be the true step-by-step way for students to develop Microsoft Office application skills. The text design emphasizes step-by-step instructions with full screen captures that illustrate the results of each step performed. Each Tutorial (chapter) combines conceptual coverage with detailed software-specific instructions. A running case that is featured in each tutorial highlights the real-world applications of each software program and leads students step-by-step from problem to solution.
The Performing Series takes students to a higher level of learning through applied and project-based activities that go beyond the mechanics of the software. Most textbooks begin by teaching students software skills. The Performing Series presents various business documents first, then shows students the Office 2003 skills they need to create them. This approach shows students the relevance of what they are learning as they apply technology to task.
The most comprehensive guidebook available on the most popular spreadsheet program, fully updated to include all-new "X" features Written by the leading Excel guru known as "Mr. Spreadsheet," John Walkenbach, who has written more than thirty books and 300 articles on related topics and maintains the popular Spreadsheet Page at www.j-walk.com/ss The definitive reference book for beginning to advanced users, featuring expert advice and hundreds of examples, tips, techniques, shortcuts, work-arounds, and more Covers expanded use of XML and Web services to facilitate data reporting, analysis, importing, and exporting information Explores Excel programming for those who want advanced information CD-ROM includes all templates and worksheets used in the book, as well as sample chapters from all Wiley Office "X" related Bibles and useful third party software, including John Walkenbach's Power Utility Pak Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
Teach yourself how to use Microsoft® Visual Basic® for Applications (VBA) to take command of Microsoft Excel Version 2002. Choose your own best starting point in this self-paced guide to learn how to automate spreadsheets, write your own functions and procedures, customize menus and toolbars, and more. Easy-to-follow lessons with real-world scenarios and examples show you exactly how to maximize the built-in programming power in Microsoft Excel 2002. Numerous screenshots and a CD full of practice files help you master step-by-step programming procedures. Find out how to create custom solutions with Microsoft Excel and this book—then keep it nearby as an ongoing desktop reference to VBA functions and features. Learn at your own pace how to: Use macros to automate simple and complex tasks Manipulate workbooks and worksheets Explore range objects Work with graphical objects Build and manipulate PivotTable® objects Create loops and conditional statements with Visual Basic Use dialog box controls on worksheets Create and use custom functions and handle macro errors Create custom toolbar buttons, menu commands, command buttons, event handlers, and dialog boxes A Note Regarding the CD or DVD The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to [email protected].
