Microsoft Office Specialist
Microsoft Office Specialist

Author: Linda F. Johnson

Publisher: John Wiley & Sons

Published: 2006-07-28

Total Pages: 508

ISBN-13: 0470050195

DOWNLOAD EBOOK

Validate your expertise and get the attention of employers with Microsoft Office Specialist certification. This comprehensive guide is what you need to prepare for certification in Excel 2003, both the Specialist and Expert levels. Carefully planned by a seasoned Microsoft Office Specialist instructor, this invaluable study guide uses real-world scenarios to teach the full range of Excel 2003 skills you need-not only to prepare for the certification exams, but also to increase your ability and productivity in the workplace. Covering twenty-four Specialist exam objectives and thirty-three Expert exam objectives, the book progresses through the functions and features of Excel software. Even entry-level Excel users can rapidly build their skills. Excel 2003 Specialist Certification Skill Sets * Creating Data and Content * Analyzing Data * Formatting Data and Content * Collaborating * Managing Workbooks Excel 2003 Expert Certification Skill Sets * Organizing and Analyzing Data * Formatting Data and Content * Collaborating * Managing Data and Workbooks * Customizing Excel Plus, you'll find additional career preparation tools, including: * Solutions for real-world scenarios * Structured learning for quick productivity * Full glossary of terms Go to www.sybex.com/go/mosexcel2003 for downloadable sample files from the exercises in the book. Practice what you've learned on your own. Visit www.sybex.com for all of your professional certification needs.

Microsoft Office XP Step by Step
Microsoft Office XP Step by Step

Author: Curtis Frye

Publisher:

Published: 2001

Total Pages: 786

ISBN-13: 9780735612945

DOWNLOAD EBOOK

Experience learning made easy--and quickly teach yourself how to use the complete suite of Microsoft Office XP applications. With STEP BY STEP, you can take just the lessons you need or work from cover to cover. Either way, you drive the instruction--building and practicing the skills you need, just when you need them! WORD: Create and publish great-looking documents quickly and easily EXCEL: Develop easy-to-use spreadsheets and perform calculations ACCESS: Build your own databases for better decision making POWERPOINT: Produce and deliver compelling presentations FRONTPAGE: Get yourself--or your company--on the Web fast by constructing your own site PUBLISHER: Create professional-quality marketing materials--without being a designer OUTLOOK: Manage your e-mail communications and calendar

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step

Author: Curtis Frye

Publisher:

Published: 2004

Total Pages: 404

ISBN-13: 9780735615182

DOWNLOAD EBOOK

A step-by-step guide to Microsoft Excel provides lessons and practice exercises to master the tools for organizing data and to help prepare for the Microsoft Office Specialist exam.

Excel 2003 Just the Steps For Dummies
Excel 2003 Just the Steps For Dummies

Author: Diane Koers

Publisher: John Wiley & Sons

Published: 2006-10-11

Total Pages: 218

ISBN-13: 0470040866

DOWNLOAD EBOOK

Easy steps for creating spreadsheets you can really use Simple steps... ...for great results Use AutoOutline Choose Data Group and Outline AutoOutline. Figure 11-9 illustrates a worksheet with outline headings for both rows and columns. Row outline symbols are at the top of the worksheet. AutoOutline works best if the worksheet has summary formulas that reference cells in the detail cells. The summary formulas must be adjacent to the detail. To expand the outline, click the Show Detailbuttons to the left of the rows or above thecolumn headings. (See Figure 11-10.) To collapse the outline, click the Hide buttonsto the left of the rows or above the columnheadings. To remove the AutoOutline, choose Data Group and outline Clear Outline. Get ready to Format cells and data Build formulas and functions Save time with Excel tools Add color graphics toyour spreadsheets Analyze your data Create charts and PivotTables

Excel 2003: The Missing Manual
Excel 2003: The Missing Manual

Author: Matthew MacDonald

Publisher: O'Reilly Media

Published: 2004-12-22

Total Pages: 791

ISBN-13: 9780596517830

DOWNLOAD EBOOK

Whether you are an Excel neophyte, a sophisticate who knows the program inside out, or an intermediate-level plodder eager to hone your skills, Excel: The Missing Manual is sure to become your go-to resource for all things Excel. Covering all the features of Excel 2002 and 2003, the most recent versions for Windows, Excel: The Missing Manual is an easy-to-read, thorough and downright enjoyable guide to one of the world's most popular, (and annoyingly complicated!) computer programs.Never a candidate for "the most user-friendly of Microsoft programs," Excel demands study, practice and dedication to gain even a working knowledge of the basics. Excel 2003 is probably even tougher to use than any previous version of Excel. However, despite its fairly steep learning curve, this marvelously rich program enables users of every stripe to turn data into information using tools to analyze, communicate, and share knowledge. Excel can help you to collaborate effectively, and protect and control access to your work. Power users can take advantage of industry-standard Extensible Markup Language (XML) data to connect to business processes.To unleash the power of the program and mine the full potential of their database talents, users need an authorative and friendly resource. None is more authoritative or friendlier than Excel: The Missing Manual. Not only does the book provide exhaustive coverage of the basics, it provides numerous tips and tricks, as well as advanced data analysis, programming and Web interface knowledge that pros can adopt for their latest project. Neophytes will find everything they need to create professional spreadsheets and become confident users.Excel: The Missing Manual covers: worksheet basics, formulas and functions, organizing worksheets, charts and graphics, advanced data analysis, sharing data with the rest of the world, and programming.If you buy just one book about using Excel, this has GOT to be it. This book has all you need to help you excel at Excel.

Microsoft Office Excel 2003
Microsoft Office Excel 2003

Author: Craig Stinson

Publisher:

Published: 2004

Total Pages: 1062

ISBN-13:

DOWNLOAD EBOOK

Take your Microsoft Excel experience to the next level! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and handy workarounds for Excel 2003 in concise, fast-answer format.

Microsoft Excel 2002 Visual Basic for Applications Step by Step
Microsoft Excel 2002 Visual Basic for Applications Step by Step

Author: Reed Jacobson

Publisher:

Published: 2001

Total Pages: 336

ISBN-13: 9780735613591

DOWNLOAD EBOOK

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].