Tutorial: Microsoft Office Excel 2003 in 24 hours

Please select a chapter from the "Contents" menu at the very bottom of the page.

Microsoft Office Excel 2003 in 24 hours

Part I: Excel Basics Hour 1. Getting Started What Is Excel? Planning Strategies for Excel Worksheets Starting Excel Looking at the Excel Screen Working with Toolbars Using Excel Menus and Dialog Boxes Working with Dialog Boxes Examining the Task Pane Getting the Most Out of Help Moving Within a Workbook Summary Q&A Hour 2. Entering Data Typing Data in a Cell Entering Labels Automating Your Work Creating a Simple Spreadsheet Entering Values Adding Dates and Times Copying from Cell to Cell Making Changes to the Worksheet Inserting and Deleting Cells Working with Rows and Columns Summary Q&A Hour 3. Organizing Your Files Saving Your Workbook Saving Your Work for the First Time Saving Your Work Later Understanding Excel Filenames Protecting Your Work with AutoRecover Saving an Existing Workbook with a New Name Other Save Options Rearranging Your Files Summary Q&A Hour 4. Managing Your Files and Workbooks Creating a Blank Workbook Opening an Existing Workbook Making Use of the Getting Started Task Pane Searching for the Right File Working with Workbooks and Worksheets Getting a View of the Workbook Using Ranges Changing Worksheet Views Workbook and Worksheet Navigation Tools Summary Q&A Hour 5. Letting Excel Do the Math Why Use Formulas? How Formulas Work Creating a Simple Formula Referencing Cells Using AutoSum Using Range Names in Formulas Using Relative and Absolute Addressing Copying Formulas Troubleshooting Formula Errors Summary Q&A Hour 6. Using Excel Templates What Is a Template? Exploring Excel Templates Creating Your Own Template Saving a Worksheet as a Template Summary Q&A Hour 7. Printing Your Workbook The Value of Hard Copy Checking Your Spelling Before You Print Setting Up Your Page Changing the Orientation and Paper Size Adding Headers and Footers Choosing What to Print Controlling Where Pages Break Printing What You Want Summary Q&A Part II: Dress Up Your Work Hour 8. Changing the Appearance of Text Formatting Your Text Treating Numbers Like Text Using Fonts Changing Cell Alignment Rotating Cell Entries Centering a Heading Controlling the Flow of Text Copying Formatting with the Format Painter Removing Formatting Adjusting Column Width Altering Row Height Finding Data Replacing Data Working with Comments Summary Q&A Hour 9. Changing the Look of Values What Formats Are Available? Choosing a Number Style Working with Decimal Places Designing Custom Numeric Formats Formatting Conditionally Hiding Zeros Working with Dates Summary Q&A Hour 10. Adding Borders, Colors, and Fills Have It Your Way Changing the Color of Cell Entries Adding Borders to Cells and Ranges Working with Fills, Shading, and Color Formatting with AutoFormat Summary Q&A Part III: Interactive Data Makes Your Worksheet Come Alive Hour 11. Working with Graphics Objects What Is a Graphics Object? Why Use Graphics? Using the Drawing Toolbar Adding Clip Art Adding Special Effects with WordArt Manipulating Graphics Objects Combining Multiple Objects Deleting Graphics Objects Summary Q&A Hour 12. Adding a Chart Why Use a Chart? Chart Elements Types of Charts Creating Charts with the Chart Wizard Working with Charts Chart Formatting Techniques Creating a Pie Chart Summary Q&A Hour 13. Other Types of Charts Creating Other Chart Types Creating an Excel Diagram Summary Q&A Part IV: Advanced Excel Techniques Hour 14. Working Smarter Working with Multiple Workbooks Working with Formulas That Reference Other Workbooks and Worksheets Creating Links Between Worksheets and Workbooks Customizing Excel Protecting Your Data Protecting Your Files Saving Your Workspace Using Excel Add-ins Summary Q&A Hour 15. Using Functions Advantages of Excel Functions Using the Insert Function Dialog Box and Formula Palette Financial Functions Date and Time Functions 'DATEVALUE' Logical Functions How to Use Lookup Functions Summary Q&A Hour 16. Auditing and Validating Your Work Auditing Workbooks Validating Input Using Named Constants and Formulas Defining Label Ranges Summary Q&A Hour 17. Analyzing Your Data Using the Scenario Manager Using the Goal Seek Tool Summary Q&A Hour 18. Working with Pivot Tables What Is a Pivot Table? Learning the PivotTable Lingo Building a Pivot Table Modifying a Pivot Table Working with Pivot Table Reports Building a PivotChart Creating a Chart from PivotTable Report Data Summary Q&A Hour 19. Integrating Excel with Other Office Applications Using Objects in Excel Inserting Objects Using Hyperlinks with Other Office Documents Sending Your Document Via Email with Outlook Summary Q&A Hour 20. Automating Tasks with Macros and Smart Tags What Is a Macro? Creating a Macro Running the Macro Fixing Macro Errors Attaching a Macro to a Toolbar Using a Macro in Other Workbooks Understanding Macro Viruses Working with Smart Tags Summary Q&A Part V: Creating and Using Databases in Excel Hour 21. Building an Excel Database Basic Database Concepts Starting with a Plan Creating a Database Entering and Adding Data Searching for Data Saving the Database Summary Q&A Hour 22. Working with Your Database Working with Subtotals Using Advanced AutoFilter Functions Setting a Criteria Range Retrieving Data with the Query Wizard Choosing a Data Source Saving Data Queries Summary Q&A Part VI: At the Office and on the Internet/Intranet Hour 23. Sharing Your Work with Your Colleagues What Is a Network? Sharing Workbooks Setting Up a Shared Workbook Opening a Shared Workbook Tracking Changes in Your Worksheet Summary Q&A Hour 24. Worksheets and the Web What Is the Internet? Using Internet Explorer 6.0 Searching on the Web Adding a Hyperlink to a Worksheet Saving Excel Documents to the Web Posting Your Worksheet to the Web Summary Q&A