Excel Tutorials and Resources
Here at the Quantitative Resources Center, we have compiled a list of Excel tutorials students have found helpful in the past. We have categorized them by topic to make it
easier for students to find the help they need.
Below are some fast and easy tutorials for understanding the basics of Microsoft Excel.
They cover topics ranging from how to create and manage spreadsheets, to creating graphs
and charts, and more!
Here are some helpful tips for doing basic math in Excel.
GFC Global Education Network — https://edu.gcfglobal.org/en/excel2016/
Graphing and Charts
Below are some resources aimed at helping students create a wide variety of different charts and graphs. It’s important to be able to make and understand many different visual representations for the data you’ll be working within Excel. These resources help students decide for themselves which kind of representation they need for their specific dataset as well as how to create an effective graph.
North Carolina State University Graphing Guide — https://tinyurl.com/yc8w4uml
Creating Advanced Charts — https://tinyurl.com/yaksw6zf
“How to Make a Graph in Excel and Add Visuals to Your Reporting” — https://tinyurl.com/y76hl7mh
Many of our students use Excel for their statistics courses. Here are some useful tools to help manage, manipulate, and analyze statistical data.
Basic Statistical Tools in Excel — https://tinyurl.com/y89264hj
University of Texas Statistics Help Guide for Excel — https://tinyurl.com/yd5h2gue
A guide for importing data and making data models — https://tinyurl.com/y7s4vnt7
PHSTAT is an Excel extension used for more complex statistical analyses. It is required in a number of courses at SPS. We have gathered a list of effective websites and tutorials fur learning how to work within PHSTAT.
Chief among these resources is a series of YouTube tutorials by Dawn Wright, Ph.D., called “The Stats Files.” She has posted dozens of videos explains virtually every possible function PHSTAT has to offer students.
Dr. Wright has also made a PDF tutorial for students — https://tinyurl.com/ydcvjfhm
Business and Finance on Excel
Excel is an extremely useful application for managing finances and business information. It is often used in SPS courses for practice in areas ranging from complex topics like accounting and finance to simple budgeting.
Microsoft Excel as a Financial Calculator — https://tinyurl.com/y77bdvxe
Guide to Excel For Finance — https://tinyurl.com/y7q2fprr
Top 15 Financial Functions in Excel — https://tinyurl.com/y9wgecmo
Miscellaneous Tools and Tutorials
Lynda is a comprehensive website offering dozens of different tutorials in specific mathematical and Excel concepts. It is free and open for anyone with a New York Public Library card.
40 Best Excel Tutorials — https://tinyurl.com/ya38z8uk
Access Tutorials and Resources
Microsoft Access is a software designed for business and data analytics. Below are some
resources for helping students get a head start using the program.
Quackit Microsoft Access Tutorial — https://tinyurl.com/y9ey5nel
Interactive Tutorial and Support from Microsoft — https://tinyurl.com/y49943jh
Tableau Tutorials and Resources
Tableau is a statistical software aimed specifically at managing and analyzing business
data. We have prepared some tutorials on how to use the program below.
Tableau Official Tutorial — https://tinyurl.com/yahz6ghd
Tutorial Gateway: A Step by Step Guide to Tableau — https://tinyurl.com/ycamvgx8