• Attendance Tracker Template for Microsoft Excel
    Employees and their managers often need to know how many vacation days they have left, how many sick days they’ve used, and whether or not they have personal days left. The user-friendly attendance tracker template from Coragi makes it possible for you to record attendance as well as a […]
  • Lock Aspect Ratio
    “Lock Aspect Ratio” is the possibility to preserve the relative width and height when you resize an image or graphics shape. When locked, the original proportions of the selected shape are preserved when the height or width is changed. If the aspect ratio unlocked, then you can change the […]
  • Sprained ankle: How to prevent and treat a reoccurring injury
    Ankle sprains are one of the most common joint injuries, with almost everyone suffering from a minor strain or sprain at some point during their lives. As a result, learning how to treat a sprained ankle is wise whether you’re treating yourself, a family member, or someone in your […]
  • Jumper’s Knee: My personal treatment of Patellar Tendonitis
    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. […]
  • 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 […]
  • Etsy: Get 40 free listings when you open an Etsy shop
    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 reality. We all love free stuff, and free listings in your brand-new shop is a good […]
  • 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 […]
  • 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 […]
  • 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 […]
  • 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 […]
  • 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 […]
  • 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. […]
  • 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 […]
  • How do I rotate a picture?
    Often you need to rotate a picture when you are working with digital content that will be published on different websites.  You may need to adjust a photo for several reasons. The default orientation of a photo depends on how the photo was originally taken. Most mobile phones use […]
  • PDF File: What is a .PDF file, and how do I create it?
    PDF is the acronym of “Portable Document Format”, and the format was originally designed by Adobe for printing. The format is based on the PostScript language which is supported by most printers. The internal file structure encapsulates a complete description of any texts, fonts, vector graphics, raster images, etc. […]
  • 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 […]
  • 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 […]
Back To Top

Subscribe to our newsletter