Intro To Python Programming For Microsoft Excel & Data Analysis: Evening Class

Join us for a workshop and learn some Python programming to make you more efficient using Microsoft Excel and other tools at the office. Start automating the "boring stuff." No prior experience is needed.

*** Please note, this is a PAID workshop. For official registration, you must signup here http://bit.ly/2DeuclO**

ABOUT: 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.

In this hands-on class you will learn how to use Python as an alternative to Excel. Walking through examples, we’ll show you how to use the language for data analysis and to read csv and excel files in jupyter notebooks. After completion, you’ll start saving time for the things you actually want to do!

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. For beginners who want to dig even deeper after the workshop, we suggest our Python Foundation course.

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 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. Links to resources below:

http://greenteapress.com/thinkpython2/html/index.html
https://automatetheboringstuff.com/

Prior to class students must install Python & Jupyter notebook (link below to install)
https://test-jupyter.readthedocs.io/en/rtd-theme/install.html

** Don't forget to use this link for OFFICIAL registration: http://bit.ly/2DeuclO **