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
Phone 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)