Skip to Main Content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

ECON1103 - Excel Workshop - Gabriele: Excel Overview

Calculations and Formulas

Overview of Formulas in Excel (Microsoft)

  • See section under Formulas In-depth on Using Reference in Excel Formulas to learn about the difference between relative and absolute references.
  • See Formulas and functions for a description of statistical functions, including STDEV.S function (standard deviation).


Graphs/Scatter Plots/Linear Fitting


Formating Charts

Linear Fitting (Adding Trendlines)

Graphing two data sets on the same graph with Excel


  • This video also demonstrates selecting the X- and Y- Axes and inserting a linear trendline.
  • Created by Clayton Spencer

Analyzing Data with a Pivot Table

Need Help?

Text Message Icon

Access to Microsoft Office through Emmanuel

Note: The online version of Excel that you can access without downloading the program onto your computer does not have all the features that you may need to use.



E-Book Collections

Academic Resources Center (ARC)

  • Contact the ARC for Excel guidance by course or discipline-specific tutors.
    LIB G-04 | 617-735-9755 | (for online appointments)
Site Search | Accessibility | Web site feedback:
617-735-9927 |