This unit builds on the previous Quick Start to Excel by introducing the more advanced concepts which are applicable to using Excel in a commercial context.
The objective of this text is to enable you to use the data entry tools, apply advanced cell formatting, use the built-in functions, absolute, relative and mixed cell references, assign and use range names, understand the basics of Excel’s date and time arithmetic, work with larger spreadsheets, generate and customize a chart, use the grouping feature and data filter feature, use pivot tables for simple data mining.
