Press enter or spacebar to select a desired language.
Coquitlam Library
Friday: Closed for Good Friday
New Westminster Library
Friday: Closed for Good Friday
Learning Centre New Westminster
Friday: Closed for Good Friday
Learning Centre Coquitlam
Friday: Closed for Good Friday
Press enter or spacebar to select a desired language.

Computer Skills

Microsoft Excel 2013/360

Excel is software used for storing, organizing and manipulating data. It is useful for doing cell based calculations, making pivot tables, graphs and many other functions.

Topics covered in this guide

  1. Intro to Excel : Creating workbooks; Creating and renaming worksheets; Creating top-down lists of data; Using text wrapping; Copying and pasting options; Saving the Workbook
  2. What if Analysis: Creating a one-variable data table; Creating a two-variable data table; Using the scenario manager tool
  3. Graphing; Making different types of Charts
  4. Inserting tables: Inserting tables in a worksheet;  Table styles
  5. External Resources


Handouts

These handouts are provided to help you practice your Excel skills. Download and save the files to your computer so that you can edit the Sample Excel Workbook.

Depending on your security settings you may have to allow the Enable Editing button.

 Enable Editing button example


Intro to Excel

This video provides a basic introduction to Excel 2013. The topics included in the video :

  • Opening Excel
  • Creating a Workbook
  • Creating Worksheets
  • Renaming Worksheets
  • Inserting Data
  • Creating top-down lists

Making a one-variable data table

A one-variable data table is part of the 'What If Analysis' tool in Excel. It helps to compute the possible results as the value of one variable changes in the particular formula that is used to compute the results. The following video shows how to compute the possible monthly payments for a range of different interest rates for the loan.


Making a two-variable data table

A two-variable data table is quite similar to the one-variable data table. The only difference is that, instead of using one variable, a two-variable data table computes the possible results in the change of two variables from the formula that is used to calculate the results. It helps to determine how a change in those values from the formula might change the results' values. The following video explains how to compute the change in value of the monthly payment for a loan changing both the rate and loan amount at the same time.


Using the scenario manager

The scenario manger is also  part of the 'What If Analysis' tool in Excel. It helps to create different scenarios by using the input values from the formula that is used to calculate the results. The following video shows how to create different scenarios using the scenario manager in excel 2013.

How to plot scatter charts

Getting equation and r-squared values from charts 

Tables in Excel

The following video shows:

  • How to insert tables in Excel
  • How to style the tables
  • Inserting total rows for tables