February 2022 - Python In Office

Use Python To Concatenate Excel Files

Last Updated on July 14, 2022 by Jay In this tutorial, we’ll learn how to use Python to concatenate/append/merge/combine multiple[…]

Last Updated on February 26, 2022 by Jay This short tutorial will show you how to protect & unprotect Excel[…]

Last Updated on July 14, 2022 by Jay Password encrypted Excel files are annoying, in this tutorial I’ll show you[…]

Last Updated on February 25, 2022 by Jay If you are trying to use pandas to read a password encrypted[…]

Last Updated on February 24, 2022 by Jay This is a pandas cheat sheet that I recently created. Feel free[…]

Last Updated on February 22, 2022 by Jay In this article, I will walk through how I built a Bitcoin[…]

Last Updated on February 17, 2022 by Jay In this tutorial, we’ll learn how to use the Mail Merge, aka[…]

Last Updated on July 14, 2022 by Jay This tutorial will walk through how to perform the SUMIF and COUNTIF[…]

Last Updated on July 14, 2022 by Jay In this tutorial, we’ll combine sheets from different Excel files into a[…]

Last Updated on February 9, 2022 by Jay In this tutorial, I’ll show you how to create Excel pixel art[…]