Page 41 - Voices-2021-12
P. 41
pristine shape, just in case the need arises. To In the Status column pulldown menu, select
make the sorting and parsing easy, copy the Completed. Then in the first column select a
title row from Level-1 only into the new empty Name for the generated report (include the
file, Level_1-5_Projects.xlsx. This can be edited rows for Levels 1-5) used to separate the Levels
to include a “Level #” as each Level when the (shown highlighted in yellow in Figure 5). For
data is pasted in the file. This additional row this example this report selected the Name Peter
makes it easier to separate the processed levels. Rabbit.
To make the columns more meaningful, edit This report can be saved uniquely for each
the column titles to a one-word description. Name by printing to a PDF. Generating a separate
For instance: (Name, ID, Project, Path, Type, report for each user requires only changing the
Status, Date). Name selected.
After all five levels have been pasted into
1 Analytics is the process of discovering, interpreting, and
the new file, select the Title row (row#1), then
communicating significant patterns in data. . Quite simply,
in the Excel function ribbon at the top, select analytics helps illuminate insights and meaningful data that
the Data tab. In the Data tab, select the Filter we might not otherwise detect. Analytics is a tool that turns
data into useful information that can be used to assess, address
option, a funnel-shaped object (Figure 4). This or solve a defined problem.
2 The VP-Pathways is an optional ex-officio club officer elected
will enable pulldown data selection for each
by the membership to provide Pathways support to members
column.
Figure 1 Figure 2 Figure 3
Figure 4 Figure 5
VOICES! | DECEMBER 2021 41
