Skip to main content
Book an appointment Submit a paper Learning Centre

Basic Excel: Home

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 LibGuide

  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 AnalysisCreating a one-variable data table; Creating a two-variable data table; Using  the scenario manager tool; Graphing; Making different types of Charts
  3. Inserting tables: Inserting tables in a worksheet;  Table styles

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
Opening Excel
Creating a workbook
Saving a workbook
Creating worksheets in excel
Renaming worksheets
Inserting Data
Creating top down lists
Formatting data => conditional Formatting
Opening Excel
Creating a workbook
Saving a workbook
Creating worksheets in excel
Renaming worksheets
Inserting Data
Creating top down lists
Formatting data => conditional Formatting
Opening Excel
Creating a workbook
Saving a workbook
Creating worksheets in excel
Renaming worksheets
Inserting Data
Creating top down lists
Formatting data => conditional Formatting

 

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.

The following videos show:

How to make bar, column, and pie charts

How to make a line chart

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

Handouts

Credits

Created by peer tutors under the direction of Learning Centre faculty at Douglas College, British Columbia.

 

Project Coordinator

Mina Sedaghatjou

 

 

 

Content Developer & Editor

Khushbu Batra

 

 

‚Äč