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.
The author of this post is:
