All articles from Apps & Sites

    January 2022

    31 January
    • Winter Olympics 2022: schedule, sports, where to watch

      After what seemed like a long wait for Tokyo 2020, the Beijing 2022 Winter Oympics are already here. In this article we will show you everything you need to know about Beijing 2022, from the Opening Ceremony to how to watch the Winter games online for free.

    • Add or remove the progress bar in PowerPoint

      Added visual components, such as a progress bar, can make your PowerPoint presentations much more appealing to viewers. A progress bar will show the status of the current slide in relation to the total number of slides in a presentation. Inserting a progress bar must be done via macro. This article will explain you how to do.

    • Tokyo Olympics: watch online, live, free

      After the postponement of many major sporting events in 2020, the summer of 2021 was full of sport! Beginning with the 2020 European Football Championships, Wimbledon and the 2021 Tour de France, three events that finished before the 2020 Olympics started in July, and finished with the Tokyo Paralympics which ran from August into September. This article will show you the Olympics start date, how to watch the 2020 Tokyo Olympics for free and the rough outline of the Olympic schedule.

    27 January
    • Opera torrent: extension, support, settings

      Opera used to allow you to download torrents (BiT torrent protocol) directly via its interface, without using any P2P client. Upon downloading a magnet link (e.g downloading Ubuntu) under Opera, you would be prompted to choose if you want to start downloading your torrent via Opera or the P2P software installed on your system. Since version 12.17, this is no longer possible, but you still have options.

    26 January
    • How to delete Classmates account

      If you are among the frustrated former users who would like to unsubscribe from the online yearbook, here are tips on how to deactivate your Classmates.com

    25 January
    • WinRar set password: not working, to open file, encryption

      WinRar is a file compression tool that allows you to manage documents on your PC. It also offers a feature allowing you to password protect your files. This article will show you how to encrypt your files using WinRar add password.

    24 January
    14 January
    • Repeat rows in Excel: based on cell value, VBA

      Rows in an Excel worksheet can be repeated a specified number of times with user-defined functions. The Selection.insert command can be used to insert rows in an Excel sheet and there is no need to write the code from scratch as code snippets are freely available for use in worksheets. However, one must ensure that the user-defined function or subroutine to repeat rows a specified number of times is inserted in the right place.

    • What is the VBA code to select last sheet in workbook

      It is possible to select the last sheet of the workbook in Microsoft Excel even if you do not remember the sheet name, or if you don't want the selection to be reliant on the sheet name, and adapt to any changes to the sheets. Here is how you can do it.

    • How to copy a Macro into a blank cell

      In this article we will show you an example of a Macro that can copy data in the next blank cell. Using this example you should then be able to apply the solution to a specific problem that you have.

    13 January
    • How to perform a partial cell match in Excel?

      If you'd like to isolate cells in a Microsoft Excel data sheet based on criteria that has a partial cell match, this can be done through the use of a MATCH function. When applied, the MATCH function searches for items in a range of cells based on any given criteria. When found, the function will direct you to any cells that fit the criteria given. This article will teach you how to use the MATCH formula in Excel to find data entries that are partially linked to one another.