Skip to content Skip to site navigation Skip to service navigation

Advancing into Data Analytics from Excel to Python

Class Code Date Delivery Method Cost
ITS-1235
  • Wed Nov 6, 1:00 pm to 4:00 pm
  • Fri Nov 8, 1:00 pm to 4:00 pm
Live Online - 2 sessions $450

Most Technology Training classes will be delivered online until further notice.

Before each sesson, Tech Training will provide a Zoom link for live online classes, along with any required class materials.
 


 

 
This six-hour session will review the foundations of data analytics using Excel and then transfer and advance that knowledge to perform a complete data analysis using the Python programming language.
 
Prerequisite: Learners should have an understanding of Basic Programming and Excel.
 
You will have the opportunity to learn how to conduct exploratory data analysis, data visualization and hypothesis testing, and how to use Python to access and manipulate Excel files. At the end of the course, you will be able to perform a complete data analysis using Python.
 
Learning Objectives:
 
During this course, you will have the opportunity to learn how to:
  • Understand the Foundations of Analytics in Excel
  • Explore Variables in Excel
  • Understand Exploratory Data Analysis
  • Understand the Foundations of Inferential Statistics and Hypothesis Testing
  • Use the Python Programming Language for Data Analysis
  • Access Excel Files Using Python
  • Perform Data Visualization and Exploration in Python
  • Perform More Efficient and Deeper Data Analyses using Python
  • Explore Correlation and Linear Regression in Excel and Python
  • Use Python to Manipulate Excel Files and to perform Machine Learning
 
 
Topic Outline:
 
-  Overview of Data Analytics
 
-  Excel Review
i. Foundations of Analytics in Excel
ii. Variables in Excel
iii. Exploratory Data Analysis in Excel
iv. Data Visualization in Excel
 
-  Introduction to the Python Programming Language
i. Installing Anaconda
 
-  Milestone 1: How to use Jupyter Notebooks
i. Python Essentials
ii. Introduction to Pandas
iii. Using Pandas to access Excel files
iv. Data Analysis with Pandas
 
-   Milestone 2: Perform exploratory data analysis using Pandas
i. Using Python for data wrangling
ii. Using Python to manipulate Excel files
iii. Data Visualization in Python: Matplotlib, Pandas, Seaborn
 
-  Milestone 3: Perform data visualization using Python
i. Inferential Statistics and Hypothesis Testing in Python
ii. Correlation and Linear Regression using Excel and Python
iii. Using Python to perform machine learning
 
-  Milestone 4: Perform complete Python data analysis
 
-  Conclusion: Data Analytics in the real world, and next steps.
Antony Ross

Antony originally attained a degree in psychology with an emphasis in sport psychology. He began working with athletes and eventually chose to pursue a graduate degree in exercise physiology. He conducted research in muscle physiology while teaching at USC and, subsequently, UCLA.

Custom training workshops are available for this program

Technology training sessions structured around individual or group learning objectives. Learn more about custom training


University IT Technology Training sessions are available to a wide range of participants, including Stanford University staff, faculty, students, and employees of Stanford Hospitals & Clinics, such as Stanford Health Care, Stanford Health Care Tri-Valley, Stanford Medicine Partners, and Stanford Medicine Children's Health.

Additionally, some of these programs are open to interested individuals not affiliated with Stanford, allowing for broader community engagement and learning opportunities.