- 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
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.
Note: different text formats indicate different actions or
operations. Things you need to type will be denoted with the Courier
font. Menus will be denoted with bold Arial,
with the menu item in Arial, e.g. File→New
means select the New item in the File menu.
Options, buttons in dialog boxes and the Enter key will also use this font.
Dialog box titles will be in bold Times. Functions will be
denoted with ALL-CAPS COURIER.
To begin, continue to the next page to learn how data is organized in Excel, and how to enter data.