Details:
|
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.
|