Introduction

Quick reference

• 00:04 All right, welcome to the course.
• 00:05 My name is John Elder and I'll be your instructor today.
• 00:08 In this video, I want to spend just a couple of minutes sort of talking about
• 00:11 what you can expect from the course, going over some of the things we're
• 00:14 going to be learning throughout the course, and
• 00:16 just giving you a basic introduction to what to expect going forward.
• 00:18 So, this course is basically broken into seven sections.
• 00:22 In the first section we'll look at installation and setup.
• 00:25 In the second section,
• 00:26 we'll look at a short introduction to the Python Programming language.
• 00:30 In the third section, we'll do a short introduction to OpenPYXL.
• 00:33 In the fourth section, we'll do a little exercise.
• 00:35 And the fifth section we'll look at formatting and
• 00:37 styling spreadsheets with Python.
• 00:39 In the sixth section, we'll look at working with graphs and charts.
• 00:42 And in the seventh section, we'll look at tables and images.
• 00:46 So basically this is a course in using Python Programming with Excel spreadsheets
• 00:50 or if you want to look at it from the other point of view using Excel
• 00:53 spreadsheets with Python Programming.
• 00:56 So if you have absolutely no Python Programming experience,
• 00:59 you're going to be just fine.
• 01:01 Like I said in the second section,
• 01:02 we're going to do quick introduction to Python it's going to be very top level.
• 01:06 We're not going to get into a lot of great detail, but
• 01:09 it'll give you enough to get started and
• 01:10 sort of understand what we're going to be doing throughout the rest of the course.
• 01:14 If you already know Python, if you already have a good solid foundation,
• 01:17 you can kind of skip that section if you want, or just watch it as a refresher.
• 01:21 I'm going to assume throughout this course that you all ready have a basic
• 01:24 understanding of Excel.
• 01:25 You don't need to know anything particularly complicated about Excel.
• 01:29 But you need to know what Excel is how to create a basic worksheet,
• 01:33 you know how to add data to cells.
• 01:36 Understand there are rows and columns in Excel.
• 01:38 And it would be useful if you knew how to use charts and graphs and
• 01:42 formulas in Excel.
• 01:43 If you don't know those things, it's no big deal,
• 01:45 we're going to walk through all of it step by step throughout this course.
• 01:49 So like I said, we're going to start out in the first section,
• 01:52 installing all the tools that we need.
• 01:54 First off, we'll install Python, then we're going to install something
• 01:57 called the Sublime Text Editor, which is a text editor that allows us to write code,
• 02:01 that's this thing right here that we've been looking at.
• 02:04 After that, we're going to install the Git Bash Terminal,
• 02:06 which is a terminal that we can use to run commands.
• 02:09 This will allow us to actually run our Python code.
• 02:11 And you can see this is, what it looks like right here.
• 02:14 After that we'll set up a virtual environment and
• 02:17 make sure everything's ready to go to start writing code.
• 02:20 After that, we're going to learn a little bit about Python, we will spend five or
• 02:23 six videos talking about some very basic python programming concepts.
• 02:26 Things like variables, things like lists, tuples, loops, and random numbers.
• 02:31 After that we're going to jump right into OpenPYXL.
• 02:34 OpenPYXL is the thing that allows us to sort of connect our Python
• 02:38 program to Excel or vice versa connect our Excel to our Python programs.
• 02:43 We'll start out very simply learning how to create basic workbooks and
• 02:48 worksheets in Excel.
• 02:49 How to grab data from those worksheets,
• 02:52 how to pull it into our program here that so that we can manipulate it.
• 02:56 How to do things in our program here and then save it to an Excel spreadsheet.
• 03:02 Know how to call specific data out of a spreadsheet and do stuff with it, how to
• 03:06 then after we've done stuff with it, kind of behind the scenes using Python,
• 03:11 how to then get it back onto the spreadsheet, right?
• 03:14 After that, we'll do a little exercise to see how much we've learned, and
• 03:17 then we'll move on to sort of more visual type things.
• 03:19 We'll look at formatting spreadsheets, merging cells, doing cell alignment,
• 03:24 pattern fills, gradient fills, borders, sides, things like that.
• 03:29 After that, we'll jump into charts.
• 03:31 So you can see we're going to look at all kinds of different charts.
• 03:34 We've got donut charts, we've got radar charts, surface charts,
• 03:38 bubble charts are fun, and many other charts.
• 03:41 And we'll also look at basic charts like pie charts, bar charts,
• 03:44 line charts, area charts, scatter charts, and things like that.
• 03:48 And then finally, in the last section, we'll look at tables and images.
• 03:51 See we've added a little image here and created tables using Python, and
• 03:56 tables as you're probably familiar with allows you to change your data,
• 04:02 change your filters, and do all kinds of neat things.
• 04:06 So I'm pretty excited about this course I think you're going to be very surprised
• 04:09 how quickly and easily it is to learn a lot of this stuff.
• 04:11 And we'll be writing Python programs for our Excel spreadsheets before you know it.
• 04:16 So let's get started.

Lesson notes are only available for subscribers.