With sections on editing, formatting, functions, formulas, lists, macros, creating and managing workbooks, and creating and editing charts, this tutorial also includes an interactive companion CD-ROM.
Now included with Microsoft Office, Project 2003 is the world's leading project management tool. With extensive help resources and printing assistance, Project 2003 enables users to organize and track tasks and resources efficiently to keep projects on time and within budget.If you want to realize the immense potential of Microsoft Project 2003 and harness the many features and functionality of this powerful tool, you need Project 2003 Personal Trainer. It includes everything you want to know about Project 2003--and then plenty more. It's the most complete and engaging tutorial available for Microsoft Project.As part of O'Reilly's new Personal Trainer Series, this book is based on content from CustomGuide (www.customguide.com), a leading provider of computer training materials that fly in the face of traditional, dry course materials that bore users to tears. CustomGuide is dedicated to delivering courseware, quick references, software bulletins, and e-learning courses that are fun, flexible, and easy to use.And this book is no exception to their rule. Project 2003 Personal Trainer lets you, whatever your technical expertise (or lack thereof), learn exactly what you need to know--at your own pace. Unlike many consumer software tutorials that dumb down (and dull up) the material or make it exceptionally technical and confusing, this book is written in a style that you'll find entertaining, easy to follow, and most of all, clear and informative.Beginning with the fundamentals of planning and managing a project with Microsoft Project 2003, the book then includes sections on: working with the task list managing costs, timelines, and available resources using the project database viewing and updating a project tracking progress creating reports handling multiple projects The fully illustrated Project 2003 Personal Trainer features dozens of time-saving, task-oriented lessons, includes detailed diagrams, and comes with a fully interactive CD tutorial to guide your learning--everything you need to become a Project pro.
Provides a training manual on using Microsoft Office Word 2003, covering such topics as working with tables, performing mail merge, using Document collaboration, and working with forms.
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.
Why program Excel? For solving complex calculations and presenting results, Excel is amazingly complete with every imaginable feature already in place. But programming Excel isn't about adding new features as much as it's about combining existing features to solve particular problems. With a few modifications, you can transform Excel into a task-specific piece of software that will quickly and precisely serve your needs. In other words, Excel is an ideal platform for probably millions of small spreadsheet-based software solutions. The best part is, you can program Excel with no additional tools. A variant of the Visual Basic programming language, VB for Applications (VBA) is built into Excel to facilitate its use as a platform. With VBA, you can create macros and templates, manipulate user interface features such as menus and toolbars, and work with custom user forms or dialog boxes. VBA is relatively easy to use, but if you've never programmed before, Programming Excel with VBA and .NET is a great way to learn a lot very quickly. If you're an experienced Excel user or a Visual Basic programmer, you'll pick up a lot of valuable new tricks. Developers looking forward to .NET development will also find discussion of how the Excel object model works with .NET tools, including Visual Studio Tools for Office (VSTO). This book teaches you how to use Excel VBA by explaining concepts clearly and concisely in plain English, and provides plenty of downloadable samples so you can learn by doing. You'll be exposed to a wide range of tasks most commonly performed with Excel, arranged into chapters according to subject, with those subjects corresponding to one or more Excel objects. With both the samples and important reference information for each object included right in the chapters, instead of tucked away in separate sections, Programming Excel with VBA and .NET covers the entire Excel object library. For those just starting out, it also lays down the basic rules common to all programming languages. With this single-source reference and how-to guide, you'll learn to use the complete range of Excel programming tasks to solve problems, no matter what you're experience level.
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.
Every time you turn around, you run into Excel. It’s on yourPC at work. It’s on your PC at home. You get Excel files fromyour boss. Wouldn’t you like to understand this powerfulMicrosoft Office spreadsheet program, once and for all? Now, youcan crunch financial data, add sparkle to presentations, convertstatic lists of numbers into impressive charts, and discover whatall the shouting’s about regarding databases, formulas, andcells. You may even decide that getting organized with a goodspreadsheet is downright useful and fun! Flip open Excel 2003 For Dummies, and you’llquickly start getting the basics of Excel in plain English. Writtenfor the rest of us, this down-to-earth book gently shows you howto: Create a spreadsheet from scratch Apply the basics of formatting cells Take on database forms—even add records—andprevail Get organized and stay that way Save worksheets as Web pages for your company intranet In a clear and easy-to-understand style, veteran softwaretrainer and technology writer Greg Harvey explains the basics ofworksheets and workbooks, how to enter data and workwith formulas, and how to print your masterpieces. Whenyou’re feeling very bold, he’ll have you addingcomments and pictures, saving files with security protection, andlearning to zip between multiple worksheets in a workbook withease. And there’s much more: Clip and save the Top Ten Beginner Basics of Excel 2003 Pay heed to the Top Ten Commandments of Excel 2003 Impress your colleagues by creating a company org chart Re-open those documents and add or edit new data withaplomb Move between these sheets without trouble Decipher and take charge of helpful tools and commands such asSort, Filter, Format Cells, and PivotTable You’ll finally be able to stop pestering the Excel expertsin your office. Become your own expert with the friendly anddown-to-earth practical instruction you’ll find in Excel2003 For Dummies.
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 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.