Experimenting with Google Sheets

Google Sheets, and Google Documents for that matter, are turning into some really robust tools. If I were to start a company, I would use those tools for writing documents and building spreadsheets. I was experimenting with the data import...

comments

Learning Python helps me with Excel

I use Excel extensively at work and I've always wished to write intricate macros but never understood the complexities of Visual Basic. After spending a few weeks learning Python, I've managed to build an Excel formula in VB that creates an "IF"...

comments

Genetik Solver appears to be no more - ITS BACK!

Wow, Well at least its presence on the Internet. It appears to be gone and I can't locate the .XLA file anywhere to save my life. I wrote about this neat little Excel add-in a long time ago in my Genetic Algorithm Excel Addin post and since then...

comments

Build Your Blog Traffic Using Excel and Data Mining

This past Saturday, I posted about using data mining to look for patterns in your blog traffic. I wrote that you can use something called an Excel Pivot Chart report to get a better feel for how your readers are interacting with your site. What I...

comments