Jumper’s knee, also known as Patellar tendonitis, is a condition characterized by inflammation of the patellar tendon. It is a common injury among athletes doing frequent jumping on hard surfaces. Since my early age I have been struggling with intense pain in my kneecaps when doing my favorite sport. At the age of 10 I […]
AppSumo deals: $10 discount when you make your first purchase
I’m so excited that you are ready to try start your new Appsumo adventure. Great digital products are at your fingertips. I know you love a good deal. To get you started at AppSumo you can now get a $10 discount on your first purchase. Don’t forget to check out the digital products I sell […]
Etsy: Get 40 free listings when you open an Etsy shop
Are you an artisan, a craftsperson, or a creative soul looking to showcase your unique products to the world? Look no further! I’m so excited that you are ready to start on your new Etsy adventure. You probably have butterflies in your tummy as you are taking your first steps to bring a dream into […]
Employee Absence tracking Template for Microsoft Excel
From time to time, every employee will be absent from work. Companies must deal with sick leave in some form or another for a variety of reasons. Absence might range from a minor cold that clears up in a few days to a lengthy sick leave that has a significant influence on a team’s performance […]
Excel VBA: Get Employee information from Active Directory
If you manage people in your organization, either as a leader or a project manager, the Microsoft Active Directory (AD) is a gold mine of valuable information open to anyone inside the corporate network. Active Directory (AD) is a directory service for Windows domain networks. It was original designed to keep track of computers and […]
Excel VBA: Force full Calculation of Formulas
Have you ever experienced that Excel does not calculate all formulas correctly? I guess we have all experienced extremely large Excel spreadsheets with a lot of formulas. Now and then Excel refuses to calculate all the cell values. I don’t really know why, but it happens more frequently than I would hope for. One way […]
Excel VBA: Copy and Paste text to/from the Clipboard
There is no built-in functionality in Excel to use the clipboard. We could have implemented the clipboard functionality from scratch using COM DataObject and Win32 API. To save time we will instead show you how to use the Microsoft Forms DataObject class. There are two different ways to use the Microsoft Forms DataObject: Add a […]
Excel VBA: Convert Column Index to Column Name
This article demonstrates how you can convert a Excel column index to the corresponding alphabetical character name of the column. For example, the column number 30 will be converted to the equivalent string “AD”. I often use this function when I am referring to ranges in Excel, or when I dynamically generate formulas. Usage If […]
How do I Print my own Passport Photos?
Have you ever wanted to print your own passport photos without having to go through the trouble of visiting to the local photo store? As long as you have your own personal printer at home, ImagePrint makes it easy for you to do so with just a few clicks. In this example we will show […]
What is Cropping, and how do I Crop a Picture?
To crop a picture is the removal of unnecessary parts of a photo or drawing. You may choose to adjust the outer edges of a picture in order to improve the composition, draw the viewer’s attention to specific parts of the photo, or to change the size or aspect ratio. Cropping can also be used […]