CERTIFICATION

Anaconda Certified: Data Analysis with Python in Excel

Enhance your data analysis skills with Python in Excel, boost your career, and unlock new opportunities.

By the end of this certification program, you’ll learn:

What are Python objects, and how they relate to Microsoft Excel
How pandas DataFrame and Series objects are fundamental to data analysis using Python
How Python provides a repeatable process for crafting the best data tables for your analyses
Get Access
9 Lessons

Data Analysis with Python in Excel: The Basics (Day 1)

This course is Part 1 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

8 Lessons

Data Analysis with Python in Excel: Working with Columns (Day 2)

This course is Part 2 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

6 Lessons

Data Analysis with Python in Excel: Filtering DataFrames (Day 3)

This course is Part 3 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

7 Lessons

Data Analysis with Python in Excel: Data Cleaning and Wrangling (Day 4)

This course is Part 4 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

8 Lessons

Data Analysis with Python in Excel: Combining and Pivoting Tables (Day 5)

This course is Part 5 of the five-course series in the Data Analysis with Python in Excel learning path.

View Course

3 Lessons

Data Analysis with Python in Excel

Successfully complete the exam to receive the Data Analysis with Python in Excel certificate.

View Course

Become Anaconda Certified

Complete all courses and pass the exam to claim your certificate.

This is for you because...

  • You’re an Excel-based data analyst.

  • You work with tables of data in Excel to produce insights.

  • You want to move beyond the limitations of Excel to have more impact.

Prerequisites

  • Knowledge of Excel tables, PivotTables, formulas, and VLOOKUP.

  • Required: You must have access to Python in Excel features.

  • Required: Install Excel on Windows. If you’re using a Mac, follow these steps to get access to Python in Excel.

INSTRUCTOR

Dave Langer

Dave is the Founder of Dave on Data, where he delivers training designed for ANY professional to develop data analysis skills.

Dave Langer

Frequently Asked Questions

  • What is the expected time to complete the exam?

    The exam contains 25 multiple-choice questions. We anticipate you taking approx. 1-2 minutes per question. Therefore, you should be able to attempt all questions within an hour or so. Note that the exam itself is not timed. You will see the following instruction before starting the exam: "The exam should be completed in one session, rather than pausing and resuming."

  • Can I refer to study materials during the exam?

    The exam is closed book. Our Exam Instructions explicitly state the following: "This is an individual exam, and collaboration or seeking external assistance is strictly prohibited. / Do not attempt to copy, print, or save any exam questions or materials."

  • Is there a validity period for the certification?

    The certification is valid for 1 year from the date of issue.

  • Will there be someone monitoring the exam?

    No, the exam is not proctored.

  • Can I take the exam from home?

    You will take the exam remotely, whenever you're ready, using your own computer or laptop. Our Exam Instructions state the following: "Ensure that you have a stable internet connection throughout the duration of the exam. / Use a desktop or laptop computer for optimal compatibility. Mobile devices and tablets are not recommended."

  • How do I add the certification to my LinkedIn profile?

    Once you successfully pass the exam, visit My Certificates. Click on View certificate for this certification program. You will see an option there for sharing your certificate on LinkedIn.