Data Analytics Tutorials Downloads
SQL Summarize Data Tutorial
YouTube Video: https://youtu.be/CPXGsCGKCM8
Excel for Scientist Tutorial Series
Learn how to quickly import your data into excel in a variety of formats!
YouTube Video: https://youtu.be/rcqaYSbwa-4
Import Data
(Lesson 1)
Learn how to quickly import your data into excel in a variety of formats!
YouTube Video: https://youtu.be/rcqaYSbwa-4
Format Data
(Lesson 2)
Learn how to format and clean your data in Excel!
YouTube Video: https://youtu.be/P4PTJr9hvOw
Combining Data
(Lesson 3)
Learn how to combine data from multiple tables in Excel!
YouTube Video: https://youtu.be/aKEebEjnMus
Filter and Sort Data
(Lesson 4)
Learn how to filter and sort in Excel! Including shortcuts most don't know.
YouTube Video: https://youtu.be/9PXeoloLN9U
Summarizing Data
(Lesson 5)
Learn how to summarize your data including averages, standard deviations, and max/min!
YouTube Video: https://youtu.be/KjNt9yIYBgk
Visualizing Data
(Lesson 6)
Learn how to create all the charts and graphs you need to visualize your data!
YouTube Video: https://youtu.be/nYVDYl7n8Mo
Formatting Figures
(Lesson 7)
Format Excel charts into publication-worthy figures!!
YouTube Video:https://youtu.be/n41Vt0Dwp7M
T-Tests
(Lesson 8)
Become a master of t-tests in Excel, including paired and independent!
YouTube Video: https://youtu.be/pxtk7-HEGxo
Correlations
(Lesson 9)
LVisualize correlations and perform regression analysis easily!
YouTube Video: https://youtu.be/yfqVrHk1DVg
Export data
(Lesson 10)
Export your data into .csv, .txt, .pdf, and Excel files!
YouTube Video: https://youtu.be/jAYQtSauLwg