Hope College CSCI 140

This video demonstrates the process of creating and modifying a stacked column chart.

This video outlines the concept of pivot tables, and demonstrates the process of creating and manipulating them.

This video outlines how to create and manipulate subtotals in Microsoft Excel 2010

This video describes when and how to group worksheets and use 3D references, along with how to write formulas that reference multiple workbooks.

This video outlines how to use Lists (Tables) in Excel 2010

This video covers the use of the COUNTIF function, sparklines, and conditional formatting operations including Data Bars, Color Scales, and Icon Sets

This video demonstrates how to complete the Mortality Rate portion of the Chart Practice Exercises

This video demonstrates how to use conditional formatting to format an entire row based on the contents of a single cell within that row.

This video covers the process of creating and modifying pie, column and line charts.

This video allows the viewer to follow along as the process of using a formula in conjunction with conditional formatting is demonstrated.