When programming in Python or other programming languages, loops are very important to understand in order to create dynamic programs that can do many different things. Loops are a programming construct that repeats a section of code a set number of times until the desired result is achieved. Much of the power of programming is having the ability to automate repetitive tasks, and loops are the tool to get that job done.…

A list is a collection of items in a particular order. They allow you to store various types of data as individual elements within the list. Python Lists are probably the most used type of construct to work with within the Python programming language. The concept of lists are fairly easy to grasp even for newer programmers, and they are an important foundation concept in Python as they are part of many different concepts in Python programming.…

You might have heard that programming requires lots of Math. You can actually get by doing a lot of programming without intense math, as long as you have basic arithmetic skills. For when you do need to work with numbers in Python, it offers convenient ways to add, subtract, multiply, divide, round, sort, convert numbers into letters, convert numbers to binary, separate numbers, and a few other handy tricks.…

The String data type is one of the most common you’ll likely use in Python. Strings are used to represent text, and text is something that is quite useful to work on and manipulate in a Python application. Python strings are immutable, meaning they can not be changed in place once created. You can manipulate a string, and then store its contents in a new variable, but the original string will remain intact.…

Variables are important parts of a Python program. They are what allow us to create a placeholder of sorts in the code, and then we can put varying values in that placeholder. Any time you change the value of a variable, Python will keep track of it. There are some guidelines and rules you want to adhere to when using variables in Python. If you don’t pay attention to these, you will encounter various errors and create code that will be more difficult to understand.…

Microsoft Excel is arguably the most popular business software on the planet, with almost every single company making use of it in one way or another. Proficiency in Excel is a must-have skill in many jobs. Here is the rub. Managing data in Excel manually is often quite repetitive and tedious. Wouldn’t it be great if you could still leverage the power of Microsoft Excel while reducing the repetition?…