Author : Sarah Hutchinson Clifford
Publisher : McGraw-Hill Technology Education
Page : 862 pages
File Size : 27,45 MB
Release : 2001-12
Category : Computers
ISBN : 9780072470406
The Advantage Series presents the Feature-Method-Practice approach to computer software applications to today's technology and business students. This series implements an efficient and effective learning model, which enhances critical thinking skills and provides students and faculty with complete application coverage.
Author : Kathy Ivens
Publisher : McGraw-Hill Companies
Page : 759 pages
File Size : 49,57 MB
Release : 2001
Category : Business
ISBN : 9780072132458
Guide to using the latest edition of the popular Excel spreadsheet program for Office XP from tips on using basic features to easy to understand explanations of advanced functions. By inputting or importing data, analyses for financial, statistical, engineering, or, other professional functions can be made.
Author : Reed Jacobson
Publisher :
Page : 336 pages
File Size : 43,66 MB
Release : 2001
Category : Computers
ISBN : 9780735613591
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].
Author : John Green
Publisher : Wrox
Page : 760 pages
File Size : 33,4 MB
Release : 1999
Category : Business
ISBN : 9781861002549
Office 2002 is the next version (after Office 2000) of Microsoft's program suite that includes Word, Access, Outlook and Excel. The aim of 2002 is to take advantage of Office's core position within most business systems and make it the interface to business processes and web services. One of the most significant advances is the XML capability that has been added to Access and Excel, with the latter becoming the key to future Web Service integration and an essential part of any Office developer's skill set. -- Written by two active and popular members of the Excel community -- Includes coverage of all the new features including smart tags, pivot tables, and web components -- Examines all the new XML capabilities that 2002 brings to the Excel world
Author : Bernard V. Liengme
Publisher : Newnes
Page : 256 pages
File Size : 32,7 MB
Release : 2002
Category : Business & Economics
ISBN : 9780750656146
The indispensable guide for all managers and business students who wish to use Microsoft Excel to its full potential. As the industry standard spreadsheet for the analysis and presentation of results, Microsoft Excel is indispensable in the business world. This text provides a practical and straightforward guide to using the functions of Microsoft Excel to their full potential, guiding the reader from basic principles through to the more complicated areas such as modelling, the analysis of charts, reporting, and automatic importing of data from the web directly into an Excel workbook. Bernard Liengme has written this book specifically to meet the requirements of business students and professionals working with Microsoft Excel. The text is illustrated throughout with screen-shots, as well as a wide variety of examples and case studies based in real-world business contexts, introduced with a minimum of maths, and readily adaptable to workplace situations. The new edition has been brought fully up to date with the new Microsoft Office XP release of Excel 2002 but can be used alongside any previous version of Excel, with new Excel 2002 features clearly indicated throughout.
Author : John Walkenbach
Publisher : John Wiley & Sons
Page : 835 pages
File Size : 30,59 MB
Release : 2011-07-05
Category : Computers
ISBN : 1118051580
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.
Author : John Green
Publisher : John Wiley & Sons
Page : 1178 pages
File Size : 27,2 MB
Release : 2011-08-10
Category : Computers
ISBN : 1118169360
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).
Author : Keith Darlington
Publisher : Routledge
Page : 236 pages
File Size : 19,39 MB
Release : 2012-08-06
Category : Business & Economics
ISBN : 1136349774
This book provides an introduction to VBA for Excel for new users. It covers basic concepts of VBA and of macro programming, and takes the reader through the process of constructing interactive working applications. Features which make it particularly suitable for new and non-technical users are: * step-by-step approach * avoidance of jargon * clear explanation of all new concepts, symbols and objects * emphasis on correct use of VBA development environment * plentiful examples and the use of complete programs rather than disconnected fragments.
Author : Stephen L. Nelson
Publisher : Firewall Media
Page : 204 pages
File Size : 25,25 MB
Release : 2007
Category :
ISBN : 9788170083221
Author : John Preston
Publisher : Prentice Hall
Page : 452 pages
File Size : 13,81 MB
Release : 2002-05
Category : Computers
ISBN : 9780130097248
For courses in Microsoft Office Professional 2002 and Excel 2002. This text is highly-visual and skills-based, delivering the steps in a screen-by-screen format. Learn.edu methodology gives quick framework for success in Office XP and the series is certified to the core level of Microsoft XP.
