Anaconda Certified: Data Analysis with Python in Excel

Believe it or not, Microsoft Excel and Python have many things in common. For example, working with data tables is fundamental in both technologies when your goal is to produce new insights and positively impact the business.

This 5-day series of live courses will leverage your Excel knowledge to jumpstart your Python skills using pandas, one of the most popular Python packages for working with data. The pandas library provides Python with rich data table functionality. Not surprisingly, skills with pandas are fundamental for analyzing data with Python.

Enhance your data analysis, boost your career, and unlock new opportunities with a certification from Anaconda. You’ll learn how to construct tables, for example, and perform advanced analytics in Excel with embedded Python. Successfully complete an exam with a grade of 70% or more to earn the Data Analysis with Python in Excel certification (validity: 1 year).

By the end of this hands-on course, you’ll understand:

• 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.

And you’ll be able to:

• Construct Python tables from Excel data.
• Handle data using Python code.
• Analyze and profile data for advanced analytics (e.g., cluster analysis).

This training 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.
• Need access to Python in Excel features.
• Need to have Excel installed on Windows. (Python features not yet available on Mac.) 

Recommended preparation

• Get Started with Anaconda: Learn about Python, packages, and more in these short tutorials.
• Python for Excel Analysts: The Basics - Series of blog posts by Dave Langer.

About the instructor

Dave Langer founded Dave on Data, where he delivers training designed for ANY professional to develop data analysis skills. Over the years, Dave has trained 1000s of professionals. Previously, he delivered insights that drove business strategy at Schedulicity, Data Science Dojo, and Microsoft.

Cost: $149. Anaconda Learning subscription is not required.

You may cancel your registration at any time before the course airs. Once the course is live, there are no refunds or credits. All registered users will receive a Zoom recording of the live course one day after the final course airs.

Important info:

The tutorial will be conducted using Zoom Meetings. It is important that the name you used to register for the event is the same as the name you use when you login to Zoom. If this will not be the case, please email [email protected] to let us know.

All participants will have their microphones muted and cameras off upon entry to help minimize distractions during the live event. Support and Q&A will be conducted via the Chat function within Zoom.

Questions? Issues? Contact [email protected].