Rate this item
    (1 Vote)

    I recently had to face an issue which has been ongoing for many months on both my PC and Laptop. Indeed, for many months, windows update failed to upload. It is only with update 1903 that I realised both my devices hadnt been properly updated since update 1809.

    The problem was identified but the solution was no way near to be found. After following various combinations of Fixes proposals, I finally found one solution which seems the most thorough of all. Below is the step by step tutorial to fix the windows 10 update error I would like to share with you. Please leave a comment

    Rate this item
    (2 votes)

    In this article, I will provide you simple step by step instructions on how to clear your cache, your history,  your cookies and your data within Microsoft Edge.

    This can be help free up space and resources on your PC but also get rid of unwanted mini spam programs in cookies and help protect your personal data

    Friday, 30 November 2001 00:00

    Using Concatenate Function in Excel

    Written by
    Rate this item
    (1 Vote)

    Excel CONCATENATE function

    The CONCATENATE function in Excel allows different pieces of text to join into one or combine values from several cells into one cell.

    The syntax of Excel CONCATENATE i:

    CONCATENATE(text1, [text2], …)

    Where text is a text string, cell reference or formula-driven value.

    The following examples show the CONCATENATE FUNCTION in action:

    Example 1: Concatenating the values of several cells:

    Rate this item
    (2 votes)

    In this article, you will find a simple way to format CSV dates ready to import in mySQL database

    Exported date fields from mySQL become strings in Excel CSV as follows 01/05/2016 00:00, The following simple tutorial explains how to convert the dates back into MySQL format

    Rate this item
    (3 votes)

    When you are stuck in safe mode because the admin password was not set up (only your live MS password which is not accessible when the network is off)

    If you have forgotten your local admin password, you won't be able to open Command Prompt as administrator in Windows 10. So you will need to up the Command Prompt with the help of a Windows 10 setup disk.

    Rate this item
    (1 Vote)

    In this article, you will learn the formula to change text to lower case and replace space by a dash.

    This can be useful when importing CSV file to a CMS like Joomla where articles titles need their respective aliases to be in lower case.

    Rate this item
    (4 votes)

    In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

    Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.

    Rate this item
    (1 Vote)

    Sometimes applications, programs or software we install automatically enable themselves within Windows 10 start-up. In other, each time you switch your PC or tablet on, the application, program or software initialise automatically. This can slow down your windows 10 start up process but also it's speed as the apps will continue working in the background using your computer memories and CPU.g

    Fortunately, adding or removing an app or program from the star-up list is relatively easy. In this article, I explain how to enable or disable a program from windows 10 start-up processes list.