A complete word processing with Python
Reading pdf file, utilizing regular expressions, exporting to Excel and Word document, and converting it back to pdf format- 24523Murphy ≡ DeepGuide
Running Python via Excel VBA -a Case of Time Series Resampling
A comprehensive assessment of time series resampling of solar irradiance using VBA, using Python, and using Python via Excel VBA- 26070Murphy ≡ DeepGuide
Supercharged pandas: Encrypting Excel Files Written from DataFrames
Introducing an ExcelHelper class which allows you to encrypt Excel files with a strong password or a password of your choice- 21425Murphy ≡ DeepGuide
Creating a Project Updates Tracker in Excel Using VBA
Three simple steps to track project updates in Excel and log them- 22897Murphy ≡ DeepGuide
Interactive Dashboards in Excel
Using the pioneer data analytics software- 22172Murphy ≡ DeepGuide
Arrays in Python and Excel VBA
Learning about arrays through simple examples- 22785Murphy ≡ DeepGuide
Managing Pivot Table and Excel Charts with VBA
Save precious hours by automating working with pivot tables and charts using VBA- 27920Murphy ≡ DeepGuide
Your eCommerce product performance reports are probably misleading you
Why single metrics in isolation fall short and how Weighted Composite Scoring can transform your business insights- 22656Murphy ≡ DeepGuide
Reporting in Excel Could Be Costing Your Business More Than You Think – Here's How to Fi
Discover how you can save hours, eliminate costly data errors, and free up your team to focus on insights that drive real business growth- 21808Murphy ≡ DeepGuide
Information at a Glance: Do Your Charts Suck?
How pre-attentive processing, Gestalt theory, and visual data encoding inform data design decisions- 28920Murphy ≡ DeepGuide
Think you Know Excel? Take Your Analytics Skills to the Next Level with Power Query!
5 practical use cases that prove Power Query is worth exploring.- 26183Murphy ≡ DeepGuide
We look at an implementation of the HyperLogLog cardinality estimati
Using clustering algorithms such as K-means is one of the most popul
Level up Your Data Game by Mastering These 4 Skills
Learn how to create an object-oriented approach to compare and evalu
When I was a beginner using Kubernetes, my main concern was getting
Tutorial and theory on how to carry out forecasts with moving averag