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 […]
MS SQL: Get the Day of Week in Transact-SQL
The day of week for a given date can in Microsoft SQL server be calculated based on the @@datefirst system variable and the datepart function in Transact-SQL. The value returned from datepart is not constant but depends on the first day of week specified by the @@datefirstvariable. In modern programming languages like C# we will get a constant value for each […]
MS SQL: Get the First Day of Week in Transact-SQL
In Transact-SQL the first day of week can be calculated based on the @@datefirst system variable. The variable will return different values depending on which language has been configured for the server. For US English the first day of week will be set to 7, i.e. Sunday, while for other regions the first day will […]
MS SQL: Store a Color (ARGB) as an Integer in Transact-SQL
The most common way is to store colors in a SQL database as a string, i.e. the HTML color code (ex. #FFFFFF). The colors can also be stored as 32 bit integers. A 32 bit color value (including alpha channel) can be calculated in the following way: @Alpha * 16777216 + @Red * 65536 + @Green * 256 + @Blue The complete user-defined […]