Skip to content Skip to footer

A Beginner’s Guide to Microsoft Excel Spreadsheets and Graphs

Two tutorials on spreadsheets, equations, graphs and trendlines

This post contains two Microsoft Excel tutorials. The first one shows some basics of Excel spreadsheets, such as equations and formatting. The second one shows how to make an x-y scatter plot and trendline on Microsoft Excel. Sample data is also provided so students can apply what they learned in the tutorials to a data set.

Sample Data

Excel Spreadsheet Basics

This video (~15 min) shows some basics of Excel spreadsheets, such as equations and formatting. The screen capture is on a MacBook 2016 running Office 2016.

Excel Graphs

This video (~25 minutes) shows how to make an x-y scatter plot and trendline on Microsoft Excel. It also shows how to add a second data series and format the graph for presentations and publications. The screen capture is on a MacBook 2016 running Office 2016.

Acknowledgements

The author would like to thank Creighton University’s Center for Undergraduate Research and Scholarship for supporting the production of these tutorials.

Minimum 4 characters