$45 – $60

Intro To Python For Microsoft Excel & Data Analysis

Event Information

Share this event

Date and Time

Location

Location

Byte Academy

295 Madison Ave

Fl 35

New York, NY 10017

View Map

Refund Policy

Refund Policy

Refunds up to 7 days before event

Event description

Description

Python, a high level programming language, can be a great complement to or a direct replacement for Microsoft Excel. This is particularly with its capabilities to perform powerful data analysis. Though based on simplicity, Python is very powerful and popular in industries such as data science and finance. People ranging from programmers to analysts to management are using it.

Learning some Python will help you “automate the boring stuff” in your day-to-day activities and make your office work more efficient regardless of which industry that you work in. Though this workshop focuses on Excel, the language can also be used for other Microsoft applications. It can also be used for Google office tasks and more.

About: In this hands-on workshop you will learn how to use Python as an alternative to Excel. We'll show you how to use the language for data analysis and to read csv and excel files in jupyter notebooks. This workshop is a must for anyone who uses Microsoft Excel at the office or in other day-to-day activity!

We’ll start with an overview of Python packages for basic data analysis. This will be followed by basic data manipulation and cleaning in a CSV, followed by some analysis and basic data visualization as time allows.

Take Aways

You’ll learn:

  • How to use simple Python to load, clean, and prepare spreadsheets

  • Write your data back to an Excel-compatible format

  • An overview of the basic libraries & data types we’ll be using, predominantly Pandas

  • How to use Python to manipulate large data sets programmatically

  • Basic visualization as time allows

Pre-requisites

Some familiarity with Excel and experience with Python syntax and data types is suggested. Prior to class students must install Python & Jupyter notebook.

Some familiarity with Excel is suggested in addition to experience with Python syntax and data types. For those unfamiliar, we suggest reading Think Python for background and basic syntax items. Automate The Boring Stuff, is great additional material for non-coders.

Prior to class students must install Python & Jupyter notebook. Click to install.

If difficulties are encountered with the above download go to the Anaconda official page here and download the suite for your desired platform.

If you have time, feel free to look through this as well. Anaconda should create an icon on your desktop or in your applications folder from which you can launch the GUI and start a Jupyter Notebook server. If you can get one up and running that's awesome, if you have issues we'll go through it real quick tonight as well.

* Note, although class time above is 6:30pm we suggest that you arrive 15 minutes in advance




Share with friends

Date and Time

Location

Byte Academy

295 Madison Ave

Fl 35

New York, NY 10017

View Map

Refund Policy

Refunds up to 7 days before event

Save This Event

Event Saved