A step-by-step, fully illustrated guide to using Microsoft Excel 2016 (part 2 of 3 - intermediate).
Activities include: functions of, sum, average, stdev, max, min, count, counta, today, now; using AutoSum; sorting text and numbers in ascending and descending order; sorting on multiple columns; challenge activity; the use of charts (graphs) in Excel to visually display data; absolute and relative addressing; the use of lookup tables; naming ranges; the if logical function; and practical application of absolute addressing and a lookup table.
All files required for the activities are available as a free download through a link at the bottom of the title page.
This item is also available as part of the Excel 2016 bundle,
and the Office 2016 bundle.
Click on the links for more details.