Open Learning Guide for Excel 2003 Intermediate


Book Description

This A4 spiral bound manual has been specifically designed to provide the necessary knowledge and techniques for the successful creation and manipulation of a more complex Excel spreadsheet. The accompanying data files on disk are designed to help demonstrate the features you are learning as you work through the manual step by step approach.







Excel 2007 Formulas


Book Description

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.




Excel 2010 Power Programming with VBA


Book Description

All the methods and tools you need to successfully program with Excel John Walkenbach's name is synonymous with excellence in computer books that decipher complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows you how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Featuring a complete introduction to Visual Basic for Applications and fully updated for the new features of Excel 2010, this essential reference includes an analysis of Excel application development and is packed with procedures, tips, and ideas for expanding Excel’s capabilities with VBA. Offers an analysis of Excel application development and a complete introduction to Visual Basic for Applications (VBA) Features invaluable advice from "Mr. Spreadsheet" himself (bestselling author John Walkenbach), who demonstrates all the techniques you need to create large and small Excel applications Provides tips, tricks, and techniques for expanding Excel's capabilities with VBA that you won’t find anywhere else This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with VBA.




Microsoft Excel 2000 at a Glance


Book Description

Provides illustrated step-by-step instructions for using the Microsoft Excel 2000 spreadsheet program.




MBA's Guide to Microsoft Excel 2000


Book Description

Designed as a reference for business professionals, this guide to Excel 2002 begins with quick primers that move users to proficiency in all categories. It describes features of Excel that are important to business users and provides step-by-step plans for completing common Excel projects. The CD-ROM provides examples of Excel workbooks discussed throughout the book.




Microsoft Office 2000 User Specialist Study Guide


Book Description

Go into the exams confident-and come out MOUS-certified! Earning your Microsoft Office User Specialist (MOUS) certification shows your current or future employer that you have the skills they need. This book helps you get those skills--by reinforcing what you know, teaching you what you don't, and preparing you for all the questions you'll face on the exam. Affordable and comprehensive, the Microsoft Office 2000 User Specialist Study Guide is the clear choice, and the only study resource you need to ready yourself to pass all the MOUS exams. Meet every exam's objectives: Word 2000 * Format characters and paragraphs * Use styles, templates, and macros * Publish documents on the Web * Create tables and forms * Generate a mail merge Excel 2000 * Create, modify, and print workbooks * Format worksheets * Create charts * Audit worksheets * Create and use templates Access 2000 * Create and modify a database * Integrate information from other applications * Publish Access data to the Web * Build forms for other users * Produce reports PowerPoint 2000 * Create and modify presentations * Add textual and visual information * Deliver and distribute presentations Outlook 2000 * Manage a contact list and calendar * Send, receive, and organize e-mail * Identify and filter spam and other unwanted e-mail * Make Outlook work with other Office applications FrontPage 2000 * Build and manage Web sites * Publish Web documents from Word, Excel, and Access * Create hyperlinks to link your site to others * Craft your site's navigational structure using Navigation bars PhotoDraw * Learn the PhotoDraw interface and expansive tool set * Import artwork or create your own graphics * Touch up and enhance photos with designer effects * Design your own professional images for the Web