Switch branches/tags
Nothing to show
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
..
Failed to load latest commit information.
FormulasReferences.xlsx
KeyFormulasReferences.xlsx
KeyMacrosFlow.xlsm
KeyMatrices.xlsx
KeySolver.xlsx
KeyStart.xlsx
KeyStatistics.xlsx
KeyUserFunction.xlsm
MacrosFlow.xlsx
Matrices.xlsx
README.md
Shortcuts and Easy Guide.pdf
Solver.xlsx
Start.xlsx
Statistics.xlsx
UserFunction.xlsx

README.md

Microsof Excel

Instructor: Charles Thraves, cthraves@mit.edu
Date/time: Tuesday January 31st, 9:00 AM - 12:00 PM
Classroom: E62-223

Pre-Assignment

  • Download all the files uploaded. Every excel file has a solution file included. For example, the file KeyMatrices.xlsx is the solution of the file Matrices.xlsx. The file Shortcuts and Easy Guide.pdf shows some of the most important shortcuts we will use during the session, and a summary on how to access some of the things we will do in the session.
  • Install Microsoft Excel in your computer.

Course Objectives

Introduce and practice with concrete real life examples on how to use the most important functions and shortcuts in Excel. The goal is to enable students to face a wide variety of problems in an efficient way in Excel. In each session the students will be given a problem with a series of tasks to accomplish. These tasks will be solved using different Excel functionalities. Most of these problems have been based on real company spreadsheet problems.

Requirements

This course is open to all students with any level of background: from beginners to intermediate users. Even advanced users can learn useful material. Students are strongly encouraged to bring their laptop to the session with the respective spreadsheets downloaded. Windows or MAC operating systems are fine, and regarding Microsoft Excel version, Excel 2003 or posterior.

Topics

  • Basic Formulas
  • Shortcuts
  • Absolute and relative references
  • Conditional formatting
  • Special paste
  • Define variables
  • Matrices
  • Statistical formulas
  • Reference formulas
  • Filters
  • Charts
  • Pivot tables
  • Cell Validation
  • Sheet protection
  • User defined formulas
  • Macros