Workshop

Advancing into Data Analytics from Excel to Python

Academy360.ai

CEO BigDataTrunk&Certify360.ai | Author

An immersive 3-hour hands-on training on Data Analytics

This is live session we do for Stanford but have opportunity to include public audience.

What you’ll learn

This six-hour session will review the foundations of data analytics using Excel

  • Learn core analytics concepts, data handling techniques, and how Excel supports data-driven decision-making.

  • Understand different data types, summarize datasets, and uncover patterns using exploratory analysis techniques.

  • Learn statistical methods to draw conclusions, validate assumptions, and support decision-making with data.

  • Work with Python to perform faster, deeper, and more scalable data analysis beyond Excel’s capabilities.

  • Import Excel files into Python, clean datasets, and automate repetitive data processing tasks.

Workshop agenda

  • Excel Review

    -Foundations of Analytics in Excel -Variables in Excel -Exploratory Data Analysis in Excel -Data Visualization in Excel

  • Introduction to the Python Programming Language

    Installing Anaconda

  • Milestone 1: How to use Jupyter Notebooks

    -Python Essentials -Introduction to Pandas -Using Pandas to access Excel files -Data Analysis with Pandas

  • Milestone 2: Perform exploratory data analysis using Pandas

    -Using Python for data wrangling -Using Python to manipulate Excel files -Data Visualization in Python: Matplotlib, Pandas, Seaborn

  • Milestone 3: Perform data visualization using Python

    -Inferential Statistics and Hypothesis Testing in Python -Correlation and Linear Regression using Excel and Python -Using Python to perform machine learning

Learn directly from Academy360.ai

Academy360.ai

Academy360.ai

Contact

CEO BigDataTrunk.com , Academy360.ai &Certify360.ai | Author

See all products from Academy360.ai

Who this workshop is for

  • Excel Users and Business Analysts

  • Aspiring Data Analysts and Data Science Beginners

  • Working Professionals

What's included

Academy360.ai

Live sessions

Learn directly from Academy360.ai in a real-time, interactive format.

Access to E-learning course

Go back to course content and recordings whenever you need to.

Certificate of completion

Share your new skills with your employer or on LinkedIn.

Maven Guarantee

Your purchase is backed by the Maven Guarantee.

Frequently asked questions

Maven for Teams

Reimbursement

Get your company to pay

Everything L&D needs: email template, receipts, and certificate of completion.

Get reimbursed

Team discount

Learn with your teammates

Save 20%+ when 2 or more teammates enroll in the same cohort.

Save 20%+ with a team

Private cohort

Run a cohort for your org

A dedicated cohort with a custom schedule and curriculum, tailored to your team.

Book a private cohort

$200

USD

Jul 17
·

3:30–6:30am EDT

Enroll