Introduction Excel Structure Excel Interface Entering and Editing Data Cell References and Ranges Basic Formula Syntax Arithmetic Operators Parentheses in Formulas Relative and Absolute References AutoFill and Fill Handle Common Excel Functions SUM Function AVERAGE Function COUNT MIN and MAX IF Function AND and OR Functions Text Formatting and Cell Formatting Format Painter Number Formats Working with Rows and Columns Sorting Data Filtering Data Excel Tables Conditional Formatting Charts Pivot Tables Practice Sheets Common Mistakes Practice Ideas