Teach Yourself MS Office 2003 In 24 Hours Free Open Book

Teach Yourself MS Office 2003 In 24 Hours

Previous Section Next Section

Hour 8. Using Excel 2003

Make your worksheets more accurate by mastering the techniques in this hour's lesson. You can easily edit cell contents with the tools Excel 2003 provides.

After you master worksheet-editing skills, you are then ready to see how Excel's AutoCorrect feature works to improve the accuracy of your worksheets. Excel is smart and can even enter cell values for you. When you ask Excel to fill in a series of cell values, it uses some intuitive guesswork to complete any series that you begin. If you often enter a special series of numbers or labels, you can teach Excel to recognize that series. This feature eliminates typing when you use the series again.

The highlights of this hour include the following:

  • Why AutoCorrect is important to numeral-based worksheets

  • How Excel fills in series for you

  • When (and how) to teach Excel a new series

  • How to find and replace worksheet data

  • How to print worksheets more effectively

  • How to use comments to describe a cell

    Previous Section Next Section
    Index: [SYMBOL][A][B][C][D][E][F][G][H][I][J][L][M][N][O][P][Q][R][S][T][U][V][W][X][Z]


         Main Menu
    Main Page
    Table of content
    Copyright
    About the Author
    Acknowledgments
    We Want to Hear from You!
    Introduction
    Part I: Working with Office 2003
    Part II: Processing with Word 2003
    Part III: Computing with Excel 2003
    Hour 6. Understanding Excel 2003 Workbooks
    Hour 7. Restructuring and Editing Excel 2003 Worksheets
    Hour 8. Using Excel 2003
    AutoCorrect Worksheets
    Reviewing Cut, Copy, and Paste in Excel
    Clearing Data
    Speed Data Entry
    Smarter Fills with AutoFill
    Designing Your Own Fills
    A Word About Printing
    Adding Comments
    Summary
    Q&A
    Hour 9. Formatting Worksheets to Look Great
    Hour 10. Charting with Excel 2003
    Part IV: Presenting with Flair
    Part V: Organizing with Outlook 2003
    Part VI: Tracking with Access 2003
    Part VII: Combining Office 2003 and the Internet
    Part VIII: Publishing Eye-Catching Documents
    Part IX: Appendixes
    Part X: Bonus Hours
    Index


    More Books
    PHP Hacks
    Processing Xml With Java - A Guide To Sax, Dom, Jdom, Jaxp, And Trax
    The Koran (Holy Qur'an)
    Macromedia Flash 8 Bible
    Search Engine Optimization for Dummies
    YouTube Traffic
    PHP 5 for Dummies
    Harry Potter and The Chamber of Secrets
    Harry Potter and the Sorcerer's Stone
    The Pilgrim's Progress
    Wireless Hacks
    Flash Hacks. 100 Industrial-Strength Tips & Tools
    PayPal Hacks. 100 Industrial-Strength Tips and Tools
    Amazon Hacks
    Pdf Hacks
    The Da Vinci Code
    Google Hacks
    The Holy Bible
    Windows XP For Dummies
    Harry Potter and the Half-Blood Prince
    Seo Book
    Upgrading and Repairing Networks
    Macromedia Dreamweaver 8 UNLEASHED
    Windows XP Annoyances
    Windows XP Hacks
    Microsoft Windows XP Power Toolkit
    Teach Yourself MS Office In 24Hours
    iPod & iTunes Missing Manual
    PC Hacks 100 Industrial-Strength Tips and Tools
    PC Overclocking, Optimization, and Tuning - 2th Edition
    PC Hardware In A Nutshell 3rd Edition
    PC Hardware in a Nutshell, 2nd Edition
    Upgrading and Repairing PCs
    Google for Dummies
    MySQL Cookbook
    Teach Yourself Macromedia Flash 8 In 24 Hours
    PHP CookBook
    Sams Teach Yourself JavaScript in 24 Hours
    PHP5 Manual
    Free Games Paper Airplanes
    500 Juegos Gratis 500 Giochi Gratis 500 Jeux Gratuits 500 Jogos Gratis 500 Kostenlose Spiele