LibGuides: BOAD 275: Research and Data Analysis: Tutorials

Using Excel

For this class you should have access to Microsoft Excel (English Version) on a computer, but if you do not have the English version, you will need to use the Excel Functions Translator.

You can also use Microsoft Copilot with Excel. Read more about Microsoft Copilot.

Make note of the differences between Excel on a Mac vs a PC, and watch the video below.

Mac vs PC Excel: Quick Shortcuts

Linkedin Learning

Linkedin Learning Tutorials for Statistics

Linkedin Learning provides a wealth of video tutorials on a wide variety of topics. Start with the links below to see tutorials available on statistics, data visualization, and Microsoft Excel, or search Linkedin Learning to find thousands more tutorials.

Statistics Foundations 1
Professor Eddie Davila covers statistics basics, like calculating averages, medians, modes, and standard deviations. He shows how to use probability and distribution curves to inform decisions, and how to detect false positives and misleading data.
Statistics Foundations 2
Eddie Davila first provides a bridge from Part 1, reviewing introductory concepts such as data and probability, and then moves into the topics of sampling, random samples, sample sizes, sampling error and trustworthiness, the central unit theorem, t-distribution, confidence intervals (including explaining unexpected outcomes), and hypothesis testing.
Excel Statistics Essential Training 1
Joseph Schmuller teaches the fundamentals of descriptive and inferential statistics and shows you how to apply them in Microsoft Excel—an inexpensive and accessible application that offers an array of powerful statistical tools. Using the built-in functions, and charts, along with the Analysis Toolpak add-on, Joe explains how to organize and present data, understand sampling distributions, test hypotheses, and draw conclusions.
Excel Essential Training
Get up to speed with Microsoft Excel, the world's most popular spreadsheet program. Follow along with Excel expert Dennis Taylor as he demonstrates how to efficiently manage and analyze data with this powerful program. Learn how to enter and organize data, perform calculations with simple functions, and format the appearance of rows, columns, cells, and data.
Data Visualization: Storytelling Essentials
Join data visualization expert Bill Shander as he guides you through the process of turning "facts and figures" into "story" to engage and fulfill our human expectation for information.
Learning Data Visualization
Got a big idea? You need to get it across quickly and efficiently, or modern audiences will move on to the next story clamoring for their attention. Data visualization allows you to make the complex simple, the abstract tangible, and the invisible (data) visible with great illustrations.