Working with Functions
What are Functions?
Using Math and Trigonometric Functions
Using Statistical Functions
Working with Financial Functions
Using Logical Functions
Using Date and Time Functions
Using Text Functions
Using Information Functions
Summary

Customized Formatting & Drawing Tools
Aligning the Cell Contents
Using the Format Painter
Hiding/Unhiding Rows & Columns
Using Comments
Using Styles
Drawing Objects
Summary

Using Internet & Data Tools
Using Hyperlinks
Publishing Worksheets to the Internet
Using Autofill
Finding and Replacing Data
Using Paste Sepecial
Sorting Data
Using the AutoFilter

Exporting Data as a Text File
Using the Research Tool
Setting Up Research Services
Changing Excel Options
Summary

Working with Lists and Databases
Using Lists
Understanding Database Concepts and Terminology
Creating a Database
Filtering Information
Using Advanced Functions
Grouping and Outlining Data
Summarizing Data
Summary

Formatting Cells
Looking at Custom Cell Formats
Using Conditional Formatting
Modifying Drawing Objects

Customizing Charts
Customizing a Chart
Modifying Charts
Formatting Legend, Axis, Title Text, Data Series, Plot and Chart Areas
Summary