Part one can be viewed here: I Hate Dev Work Part 1: Why I Hated Being A Programmer A Day in the Life of An Application Developer 8:00 AM: A lot of code all looks the same, does the same, the only differences are in the order and the […]
Have you ever written code for an application? Day in and day out, writing it every single day for months on end. I have, and I hated it every single time I get stuck doing it. I have turned down higher paying jobs than I have to avoid […]
What is Flaccid Scrum or Flaccid Agile? In the beginning, Scrum teams are moving along fast. They are doing most of what they say they will do in a Sprint and churning out code like a virtual code factory. As time goes on, they may start to get […]
*The following is written by guest blogger Tammy Ziemba Test Driven Development (TDD) is a moderate programming advancement process that is driven by a computerized test case which characterizes the ideal improvement to the system. The test is first executed to come up short. The developer at that […]
Versatility is the name of the game here at Agile-Mercurial. If you can do it with Excel, you should be able to figure out how to do it with Google Sheets. If you can’t figure out how to do it with Excel, check out my tutorials here: Excel VBA […]
Pedro Manuel Faria is the CEO of a company called In Forming, a spin-off company of Famousgadget Lda. Pedro was kind enough to let me interview him in a rather unconventional fashion, through LinkedIn messaging. Our main discussion topic was the new project management software his company was […]
66% Off Microsoft Excel Value Bundle My guest blog post on using Selenium Basic in Excel to automate web navigation, user text entry, and button clicking. Originally posted on The Hack Post. This is a more intermediate level tutorial on Excel Visual Basic, but a beginner tutorial for Selenium […]
This tutorial is a little more complicated than the prior three tutorials. It takes what you have learned in those, combines them and adds some additional features. If you haven’t done the prior tutorials and know nothing about VBA, you may want to do those first. The tutorials […]
This is the third part of the Excel Visual Basic tutorial series. It is recommended that if you are new to VBA, you begin with Excel Visual Basic #1: Getting Started. You can view all available tutorials on the Excel VBA Tutorials page. Take a look at the image below: The […]
In this tutorial, we will cover the basics of variables and decision structures. Then we will create a more advanced version of the simple message box created in the first tutorial. If you are unsure how to access the developer tab within Excel, please see the first tutorial […]
Below you will find two videos. The purpose of these videos is to show you how to gain access to the VBA development capabilities of Excel and to show you how to create your first “Hello World” application inside of Excel. I also provide written steps in case […]