Toggle navigation
Home
Microsoft Products
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
Remember the name: eTutorials.org
Copyright eTutorials.org 2008-2024. All rights reserved.
