66% Off Microsoft Excel Value Bundle This is a beginner level tutorial, but I will assume you know how to do basic things like open the “Developer” pane. You can learn more about that in Excel Visual Basic #1: Getting Started. The Below Video has no Sound, it is […]
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 […]
If you went through an earlier tutorial on custom issue types I created (Customize Issue Types in Jira), you would have noticed that I modified the Issue Types for one project and one project only. But what if we wanted to create a standard set of Issue Types […]
Before we begin, I want to explain what issues are in Jira. Issues are pretty much all of the things you need to do during a project to get it to the end and everything that comes up during a project. You may start with a series of […]
66% Off Microsoft Excel Value Bundle In this tutorial, I am going to show you how to duplicate sheets from a template sheet. This is aimed at someone who knows the basics of VBA. I assume you know how to do a lot of things already and I […]
Now that you have Jira on your computer(Self-Hosting Jira for Small Teams Part 2: Setting Jira up on First Run), you might just find that you want others on your network to access it. If you recall from the earlier tutorials, there was talk about “localhost.” If someone […]
If you haven’t already, complete Self-Hosting Jira for Small Teams Part 1: Installing Jira At the end of Part 1, you either had the installer launch Jira for you, or you can navigate a web browser to http://localhost:8080/secure/SetupMode!default.jspa This is a reference to the localhost. That means your computer. You […]
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 […]