Introduction.
Conventions Used in This Book.
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.
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.
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.
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.
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.
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.
