INLS161-001 | Spring 2018

Class Session: Monday Mar 19, 2018

Data Display


Preparation for this Session

for refreshers, glance over these

About.com

Microsoft

for data display, glance over these:

 

To prepare for thinking about data display ...

glance over Part IV: Charts and Graphics
in Excel 2007+: The Missing Manual.
You might also find Making Charts in Microsoft Excel to be useful.

You also might want to scan

Data Visualization Best Practices

Some other assistance (should you need it)

top/reload prep panel

Review from introductory class

In our last class before spring break, we downloaded Task04-01-Intro.xlsx and learned some Excel basics. The in class demo was done on the Windows 10 class computer.

This workbook (the entire file) contains the following worksheets:

1a.Worksheets

Objective: learn how work with worksheets within a workbook

Demos: New worksheet, copy worksheet, move worksheet to another workbook (Another open Excel file) or to a new workbook, select mutiple worksheets, rename a worksheet, change worksheet tab color, turn gridlines on and off.

1b. Overview

Objective: learn the global basics. Focused on working with the top three bars, the worksheet area, and the bottom worksheet bar and status bar below the worksheet bar.

Top three bars: Quick access bar, ribbon bar (note the expansion buttons on each tab in the ribbon), formula bar with name box and insert function

Worksheet Area: Top left corner box selects all; selecting a row or column, selecting multiple rows or columns, scroll bars; inserting one columns or row; inserting multiple columns or rows, moving columns or rows, shift dragging to move.

2. Mac Ribbons

This worksheet shows at-a-glance chart of Macintosh ribbons and the operations that are available under each ribbon. If it is highlighted in yellow, you will need it for your 04-task assignment. Orange shows that the option is available one more than one ribbon.

3a. Home Ribbon

This home ribbon worksheet showcases the commands in the areas of the clipboard, font, and alignment areas. Examples of all of these options are shown in the worksheet. As you click on the samples, you can see the buttons in the ribbon change to match the example. There are also examples of wrapped text, indented text, amd merged and centered text.

3b. Home Ribbon

This worksheet shows examples of all of the options in the drop-down box to the right of the Wrap Text button: general, number, currency, accounting, short date, long date, time, percent fraction, scientific, text.

There are also examples of conditional formatting and format as Table button.

A demonstration of the insert, delete, and format button was shown. Row height and column width were also demonstrated. Important, because Task-04 requires you to make a column fit and to adjust a column height.

Formatting Practice

This worksheet was used to demonstrate how to clean up the header cells (consolidate multiple cells into one cell), format rows with different colors (sorting was needed to do this efficiently).

Also covered: freeze panes, hide columns and rows, validate data

4. Formulas, filters

This worksheet was used to demonstrate the sum and average formula. The filter command and a multi-filter command was also demonstrated.

We did not get to the last four worksheets. we will go over these in class today:

5. Relative vs. locked formula

6. Flash fill

7. Examples

Reference for Angled text

See Spreadsheet Task Page for practice files and help links.

Instructor

Lawrence Jones

Office hours by appointment.