Some code templates on using DB files with SQL and Python

Learn how to automate clicks and keyboard presses with Python, and some ways I have actually used this with Excel and webpages!

What have I learned and got up to in 2020?

Quick and easy way to save Excel range as a PDF! Straight to the point!

Learn how to use Filter Formulas to automatically remove duplicates. Which is perfect for drop down boxes in Data Validation! It’s very easy!

Sharing should be caring, but sometimes Macro don’t work well on Sharepoint. This is a workaround for the SaveCopyAs bug.

Errors in Python can be managed very similar to an Excel Iferror. Here’s some error handling tips and tutorials.

Excel has an ISONUMBER formula, but no ISOYEAR. This cool formula solves the problem!

Learn how to sort data with formulas in Excel and Google Sheets! It’s easy and powerful! Great way to make dashboard and dynamic reports!

Index Match Match is one of the most useful formulas out there. Learn how to use it, and why it is better than Vlookups and Index Match! It will make your life easier and improve your accuracy!

Use Python and XLWINGS to easily find the last row in Excel! Great for storing and managing data!

Have a script that takes awhile? Want to make sure you are connected to the internet before you run it? PowerShell can easily do this!

Excel is a great piece of software. But if you are frequently using it, you need the right hardware. The Logitech MX Master is a must have for using spreadsheets. I doubt you can find better!

Figuring out if the variance you see in the average of a test and control group can be confusing. Is it significant or not? Excel can make answering this easy, you just need to understand the T.Test formula first!

After an Excel macro to send emails automatically? Find free tutorials, with free Excel template downloads to do exactly that! Send a specific range or PDF! Also learn about setting a goal to improve your automation!

What’s the point of Excel’s Linear Trendline Equation? You easily build a model with it, find out how!

Notes are useless unless they lead to music. Data is useless unless it leads to action.
Think of the story of how notes lead to music, and apply it to data.

The best way to learn Python is using it with Excel. XLWINGS makes this easy!

Ask Questions Regarding Excel Scheduling

PowerShell is a better version of Batch files, and works great with Excel!