How to Calculate CAGR in Google Sheets

The Compound Annual Growth Rate (CAGR) is a useful measure to understand the growth of an investment over time. How do I calculate CAGR in Google Sheets? πŸ‘‡ To calculate CAGR in Google Sheets, use the following formula: (Ending Value/Starting Value)Λ„(1/Number of Years) – 1 Step 1: Input Your Start and End Values In column … Read more

Parsing Excel Sheets into Text Files and Lists with Python

Python provides robust tools for handling Excel files, and this article will guide you through the process of parsing Excel sheets into different formats using Python. To parse Excel sheets into text files and lists in Python, use the pandas library. Install pandas and openpyxl, then read the Excel file with pd.read_excel(). Convert the DataFrame … Read more

How to Filter Data from an Excel File in Python with Pandas

Problem Formulation and Solution Overview This article will show different ways to read and filter an Excel file in Python. To make it more interesting, we have the following scenario: Sven is a Senior Coder at K-Paddles. K-Paddles manufactures Kayak Paddles made of Kevlar for the White Water Rafting Community. Sven has been asked to … Read more

Convert CSV to Excel xlsx in Python

Problem Formulation πŸ’‘ Challenge: Given a CSV file. How to convert it to an excel file in Python? We create a folder with two files, the file and my_file.csv. We want to convert the CSV file to an excel file so that after running the script, we obtain the third file my_file.csv in … Read more

VBA Developer Income and Opportunity

Annual Income How much does a VBA Developer make per year? The average annual income of a VBA Excel Developer is between $96,000 and $125,000 according to (source): Let’s have a look at the hourly rate of VBA Developers next! Hourly Rate VBA Developers are well-paid on freelancing platforms such as Upwork or Fiverr. … Read more

Python Excel – Styling Your Worksheets

Part 6 in Working with Excel focuses on styling. Impress your customers by styling the Worksheet to match their brand by: adding in their unique logo, using their color scheme, using their preferred font style, formatting the Worksheet using their preferred report style. Taking the time to do this makes you stand above the crowd. … Read more

Python Excel – Sum, Average, Max, and Date Formulas

Part 5 in the Working with Excel series focuses on formulas.   Background After completing Part 4 of this series, you should be comfortable using Python and openpyxl to: add worksheets rename worksheets reorder worksheets delete Worksheets The j-greats.xlsx file should exist on your system.  If you do not have this particular file, click here … Read more

Python Excel – Basic Worksheet Operations

Part 4 in the Working with Excel series focuses on Worksheet(s) manipulation.   Background After completing Part 3 of this series, you should be comfortable using Python and openpyxl to: append row(s), modify data, insert column(s), delete row(s) and column(s) The j-greats.xlsx file should exist on your system. If you do not have this particular … Read more