Excel
-
Save precious hours by automating working with pivot tables and charts using VBA
10 min read -
Learning about arrays through simple examples
9 min read -
-
Three simple steps to track project updates in Excel and log them
8 min read -
Introducing an ExcelHelper class which allows you to encrypt Excel files with a strong password…
7 min read -
A comprehensive assessment of time series resampling of solar irradiance using VBA, using Python, and…
13 min read -
Reading pdf file, utilizing regular expressions, exporting to Excel and Word document, and converting it…
11 min read -
Welcome to Part 2 of this series of articles about learning Python and Data Science…
11 min read -
Learn how to properly load your worksheets into Pandas DataFrames
9 min read -
Enhancing .read_excel & .to_excel methods to allow you to focus on data exploration
5 min read