Microsoft Excel™ Basics:

This section introduces data manipulation using Microsoft Excel™, including importing, copying and pasting data and entering equations. A basic understanding of computer operating systems (Windows/Mac) is assumed, including the ability to launch applications and find and open files.

Tips & links:

Download a PDF version of this section

Section Outline:

Entering Data
→   Referencing, pasting and creating data series and navigating cells
Formulas
→   Using Excel™ formulas in cells to enter equations and manipulate data
Plotting & Graphs
→   Plotting data using different charts, including an example of proper graph format
Functions
→   Using the built-in functions in Excel™ to manipulate your data
Adding a Trendline
→   Using the trendline function to add a best-fit line to your graph

Start with Entering Data in Excel™...

See “Site Conventions” for the meaning of different type faces.

Use “Next Page” to start the section content

Use “Next Topic” to skip to “Basic Statistics”