Formatting the Cells
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).
- Copy a formula by dragging the fill handle in Excel for Mac (Microsoft)
- Fill a formula down into adjacent cells (Microsoft)
- Move or copy a formula (Microsoft)
Graphs/Scatter Plots/Linear Fitting
- Creating a Chart from Start to Finish (Microsoft)
- Add or remove titles in a chart (Microsoft)
- Show or hide a chart legend or data table (Microsoft)
- Format elements of a chart (Microsoft)
- Change the display of chart axes (Microsoft)
Linear Fitting (Adding Trendlines)
- Add a trend or moving average line to a chart (Microsoft)
- See also Trendline options in Office (Microsoft) for a discussion of the linear trend line option, which is used "to create a best-fit straight line for simple linear data sets."
- 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
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.
Academic Resources Center (ARC)
- Contact the ARC for Excel guidance by course or discipline-specific tutors.
LIB G-04 | 617-735-9755 | emmanuel.mywconline.com (for online appointments)