Formulae and Functions The Office Interface Excel Basics Entering and Editing Data Copying and Moving Cells Filling Cells Moving and Selecting in Excel Working with Files Styles Number and Date Formats Conditional Formatting Download this chapter Absolute and Relative References Range Names Cell Comments Printing | Formatting worksheets Multiple Worksheets Consolidating Data Data Validation Protection Templates Tables-edited Tables Formatting Tables Subtotals Pivot Tables IF Functions The VLOOKUP Function Other Lookup Functions Date and Time Functions Text Functions Information Functions Inspection and Error Functions | Conditional Statistics The SUMPRODUCT Function Dynamic Range Names Grouping (Outlining) Recording Macros Charts Advanced Charts Array formulae Scenarios Data Tables Goal-Seeking The Excel Solver Excel Short-Cut Keys |