Описание: *Written especially for advanced beginners and intermediate users, this book offers quick fixes for anyone bedeviled by faulty formulas, failed formatting, printer purgatory, and other perplexing Excel problems *Offers three types of fixes: Escape in Under 30 Seconds, Escape in Under Two Mites, and More Elaborate Escapes-over 400 solutions in all *Topics covered include formula fixes, formatting fixes, data and layout fixes for Excel charts, PivotTable fixes, managing complexity in very large spreadsheets, fixing broken procedure functions, and more *Includes preventive measures and best practices that teach users how to avoid problems in the future
Автор: John Walkenbach Название: Excel 2002 Formulas ISBN: 076454800X ISBN-13(EAN): 9780764548000 Издательство: Wiley Рейтинг: Цена: 3464 р. Наличие на складе: Поставка под заказ.
Описание: Excel 2002 Formulas covers every aspect of formulas, including some unusual uses -- such as chart series and conditional formatting specifications. This book answers virtually all formula-related questions posed in Excel newsgroups on the Internet. Plus, contains a coupon for Walkenbach's Professional Power Utility Pak.
Описание: Presents a step-by step way to develop computer application skills. The design of this title emphasizes a visual approach, with screen captures for every concept.
Автор: Rob Bovey Название: Excel 2002 VBA: Programmers Reference ISBN: 0764543717 ISBN-13(EAN): 9780764543715 Издательство: Wiley Рейтинг: Цена: 7508 р. Наличие на складе: Поставка под заказ.
Описание: What is this book about? VBA is the programming language for the Microsoft Office suite and many other applications. VBA gives you complete control of Excel, allowing you to do anything from automating Excel tasks to developing full applications, using Excel as the development environment. Excel 2002 is an important upgrade to the Office suite spreadsheet program. It shows Microsoft's commitment to moving Office to be a web-enabled productivity tool, a rich client for working with web-based data, with new features such as SmartTags and XML support. Based on the successful content and format of Excel 2000 VProgrammer's Reference, this new edition has been fully updated for Excel 2002. The authors are all Excel MVPs, involved daily in supporting the Excel VBA programmer community. What does this book cover? The first part of the book introduces Excel and VBA, including a VBA primer. The second part offers thematic, succinct, and practical discussions of the features available to Excel VBA programmers, with real-world examples answering frequently asked questions. The third and final part is a complete reference to the Excel, VBE, and Common Office Object Models. Here are just a few of the things you'll learn in this edition: * The entire Excel Object Model and the Common Office Object Model * Working with PivotTables * Accessing and manipulating data sources from Excel with ADO * Programming the Visual Basic Editor (VBE) * New features in Excel 2002, SmartTags, XML, and the Web * Expanded references for Excel versions 97, 2000, and 2002 Who is this book for? This book not only caters for beginner- and intermediate-level programmers with its introductory coverage of VBA and Excel, but also provides advanced information for experienced Excel developers in later chapters and the reference.
Автор: Colin Banfield Название: Excel 2002 for Dummies: Quick Reference ISBN: 0764508296 ISBN-13(EAN): 9780764508295 Издательство: Wiley Рейтинг: Цена: 1500 р. Наличие на складе: Есть у поставщика Поставка под заказ.
Описание: This "Quick Reference" will quickly get you up to speed with Excel's new features, whether you're a novice user or an expert. You'll master how to easily publish interactive Web pages that include spreadsheets and tables. You'll learn how to use new Smart Tags to access real-time data from the Web for your Excel documents. You will be able to use Excel's latest speech recognition capabilities to "talk to your spreadsheets," and much, much more!
Автор: Greg Harvey PhD Название: Excel 2002 For Dummies ISBN: 0764508229 ISBN-13(EAN): 9780764508226 Издательство: Wiley Рейтинг: Цена: 2193 р. Наличие на складе: Поставка под заказ.
Описание: Just because electronic spreadsheets like Excel 2002 have become almost as commonplace on today's personal computers as word processors and games doesn't mean that they're either well understood or well used. If you're one of the many folks who has Office XP on your computer but doesn't know a spreadsheet from a bedsheet, this means that Excel 2002 is just sitting there taking up a lot of space. Well, it's high time to change all that. One look at the Excel 2002 screen (with all its boxes, buttons, and tabs), and you realize how much stuff is going on there. Excel 2002 For Dummies will help you make some sense out of the rash of icons, buttons, and boxes that you're going to be facing day after day. And when you ready to go beyond spreadsheet basics, this guide will also introduce you to Conjuring up charts Inserting graphics Designing a database Converting spreadsheets into Web pages Most of all, Excel 2002 For Dummies covers the fundamental techniques that you need to know in order to create, edit, format, and print your own worksheets. In this book, you'll find all the information that you need to keep your head above water as you accomplish the everyday tasks that people do with Excel. This down-to-earth guide covers all these topics and more: Creating a spreadsheet from scratch Document recovery Formatting fundamentals Making corrections (and how to undo them) Retrieving data from your spreadsheets Protecting your documents Demystifying formulas Now, even if your job doesn't involve creating worksheets with a lot of fancy financial calculations or lah-dee-dah charts, you probably have plenty of things for which you could and should be using Excel. For instance, you may have to keep lists of information or maybe even put together tables of information for your job. Excel is a great list keeper and one heck of a table maker. You can use Excel anytime you need to keep track of products that you sell, clients who you service, employees who you oversee, or you name it.
Описание: * Combining nine books in one, this thorough desk reference delivers the know-how readers need to take full advantage of Excel * Outlines the most practical and useful applications of Excel for the workplace * Explains how to import data, build and edit worksheets, create formulas, generate pivot tables, and work with financial functions, what-if scenarios, database functions, and Web queries * Explores more advanced topics such as worksheet sharing and auditing, error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web * Author is one of the bestselling technology authors of all time
Автор: John Walkenbach Название: Excel 2002 Power Programming with VBA ISBN: 0764547992 ISBN-13(EAN): 9780764547997 Издательство: Wiley Рейтинг: Цена: 4619 р. Наличие на складе: Поставка под заказ.
Описание: Master the programming features in Excel 2002 and unleash the power of VBA (VIsual Basic for Applications). With the author`s expert guideance, you should quickly lean how to harness the full programming power of Excel 2002 - from UserForms to class modules.
ООО "Логосфера " Тел:+7(495) 980-12-10 www.logobook.ru