Quick Start Microsoft Excel basics

Start Learning Excel

• • An electronic spreadsheet is a computer program that is used for storing, organizing and manipulating data.
  • Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.
  • When you look at the Excel screen (refer to the example on this page) you see a rectangular table or grid of rows and columns. The horizontal rows are identified by numbers (1,2,3) and the vertical columns with letters of the alphabet (A,B,C). For columns beyond 26, columns are identified by two or more letters such as AA, AB, AC.
  • The intersection point between a column and a row is a small rectangular box known as a cell.

Why use Excel?

• • Spreadsheets (like Microsoft Excel) can be very useful for student interactive activities, interactive lectures, and instructor use for developing materials for class.
  • Using Excel as a calculator to explore what mathematical equations can tell us about how the real world works for specific input conditions or for a range of possible values.
  • Graphically displaying equations (analytical models) and real data.
  • Obtaining numerical solutions to more mathematically complex models.
  • Graphically comparing results from a model and observations.
  • Displaying histograms of students results or student response to exams or questions.

Course to be include:

• • Introduction
  • Functions
  • Conditional logic in excel
  • Formulas
  • Charts
  • A more complex predsheet
  • Make a start with excel
  • Processing data