How To Blog

The blogs below outline some routine types of problems that can be encountered in your career as an analyst of any sort. Feel free to take whatever you need from these blogs. Some of the blogs shown here are part of a larger series of creating a custom python package that houses functions and routines that you commonly use.

Posts in Excel

How to Perform Sum Product Function in Python

How to Perform Sum Product Function in Python

An Example of creating a sumproduct function in python.

Python, ExcelDaniel KorponApril 12, 2023python, math

Using Python to Read a Range in Excel

Using Python to Read a Range in Excel

Using pandas to read the range of an excel file.

Python, ExcelDaniel KorponMarch 31, 2022data analysis, data science, data formatting

Remove All Numbers From Cells in Excel

Remove All Numbers From Cells in Excel

Excel functions to remove special characters are explored. Several different methods including a VBA macro are included.

ExcelDaniel KorponFebruary 12, 2022