All articles from Apps & Sites

    October 2022

    28 October
    • Select empty cell in Excel: VBA

      Visual Basic Application or VBA , when used in Microsoft Excel, is an efficient tool, as repetitive jobs can be automated with its help. Users can even write custom VBA code to meet their programming needs. Using interesting properties like offset, one can operate across different cells in Excel. Operations like selecting the next empty cell in a row can be automatically done and in this article we will provide the VBA code to so.

    27 October
    26 October
    • The best crypto exchange apps

      If you are new to investing in Bitcoin then it can seem like quite a daunting process, but with more and more cryptocurrency exchanges (also known as a crypto exchanges) opening, it is becoming increasingly simple and more common to invest and trade in cryptocurrency. In this article, we will look at the best places to buy and sell cryptocurrency, explain what a crypto exchange is and how crypto exchanges work.

    25 October
    • How to play Apple Music on an Amazon Alexa device

      Alexa has changed the way we listen to music today. With just a short voice command, she can play any of your favourite tunes, search for new songs via numerous music services and libraries and lower or increase volume, all without you lifting a finger. In this article we're going to explain how you can connect Alexa and your Apple Music account simply by adjusting some settings.

    21 October
    • How to modify comments and indicator preferences in Excel

      By default upon adding a comment to a cell under Excel, only the comment indicators will be displayed (Comments appears upon mouse over). If you want to have your comments permanently displayed in your spreadsheet or just change your preferences, follow these steps.

    • How to use spreadsheets: introduction, formulas, functions

      Excel spreadsheets are one of the most useful tools to create documents with calculations and data and organize the accounting or VAT tax, among other tasks. Luckily, while working on Excel you can use various formulas to speed up and facilitate the process. In this article, we will show you what it is and how to use formulas.

    20 October
    • How to track Aadhaar card usage history

      The Aadhaar card has become the most important official document in India. It is required for opening a bank account, signing up for an insurance policy, changing your address, etc. Whenever you present this card, you are required to provide a thumbprint for security reasons. However, there have still been reports of the misuse of the cards. Here we explain how to track your Aadhaar card usage details online in order to be sure that you are the only one who has used it.

    • What is an FTP protocol: definition, commands

      What is FTP Protocol? FTP (File Transfer Protocol) is, as its name indicates, a protocol for transferring files. The implementation of FTP dates from 1971, when a file transfer system (described in RFC141) between MIT machines (Massachusetts Institute of Technology) was developed. Many RFCs have since improved the basic protocol, but the greatest innovations date from July 1973. The FTP protocol is currently defined by RFC 959.

    19 October
    • Auto generate serial number in Excel: VBA, formula

      Microsoft's office software Excel is a powerful tool to perform day-to-day activities with, like simple arithmetic, sorting, filtering, arranging and summarising data in various formats. Excel has a huge collection of formulas which can be used independently or in conjunction with each other to achieve desired results. This article will show you how to create serial numbers.

    • WhatsApp's new policy 2022: safe or not?

      WhatsApp regularly makes alterations to its privacy policy. The purpose of the policy is to declare why and how the messaging service may collect and use your personal data, among other important things. In this article we will bring you up to speed on the most important changes to the policy.

    • Password protect a document: in OpenOffice Calc/OpenOffice

      OpenOffice is a very useful program that helps you organize your documents, create graphics and formulas, make multimedia presentations, calculations and easily convert your files into various formats. The software also allows you to set a password for your important files to encrypt them and enhance their security. Read on to discover how to do it.

    18 October
    • Calendar apps: for iPhone, Windows, Mac, Android

      If you are tired of multiple work and personal calendars on different devices and want to just keep everything in one place, this article is for you. We gathered the top calendar and organizing apps for you to better schedule your work duties, personal tasks, efficiently manage your timetable, never miss appointments and always keep it organized.

    • Free online puzzles: for adults, for kids

      Puzzles can be a good way to pass the time while having fun. If you usually enjoy classic puzzles but don't have any at home, don't worry: there are several websites and apps where you can access online jigsaw puzzles free of charge. We'll give you a quick overview of some to check out.

    • Astrology apps better than Co-Star: free, iPhone, widgets

      Do you believe the stars influence your personality and destiny? If you're a fan of horoscopes, it can be handy to have an app on your phone to check whenever you want what the stars have in store for you. In this article, we're going to give you a rundown of some of the best astrology apps out there.

    • Covid travel restrictions: UK, USA, Canada

      As a result of the pandemic, buying tickets to go on a trip has become a more daunting task than before. It is difficult to track which country or state will close its borders and which new restrictions can be introduced as part of the fight against the pandemic. Read this article to find out which sources and maps you can consult to see the actual info on current travel restrictions.

    • How to turn your old cell phone into a security camera?

      Would you like to detect the presence of intruders when you leave your house alone? It is not necessary to install an expensive security system to achieve this. If you have a smartphone that you are not using with a working camera, you can reuse it by transforming it into a security camera or baby monitor using just one app. Take advantage of this resource even to see how your pet is doing when you are away.

    • Remove Java HD Popups

      During your browsing session, you might be redirected to a webpage displaying the below message: You might need to install Java HD and continue /Please install Java HD and continue (required). You will also encounter such popups when browsing on illegal streaming websites. In this article, we will show you how to get rid of the malware displaying these popups!

    17 October
    14 October
    13 October
    • How to conduct a meeting: efficiently, step-by-step

      Meetings are chronophagic (meaning "they eat up a lot of time"). Therefore, it is best to be as brief as possible and run with a high degree of efficiency to take specific actions. The organization of a meeting refers to all actions to be taken to organize and carry out a meeting in good conditions, allowing for monitoring of its effects. This article is a collection of recommendations to help you conduct a meeting.

    • How To Get Help from Google Assistant on Homework

      Google Assistant is the AI (Artificial Intelligence) from Google. It's available as an app for Android and iPhone, and it comes readily available on Google devices, including the Google Home smart speaker. You can ask the Assistant many questions, including those concerning your homework. If you need help on your homework, this article will give you some tips.

    12 October
    • How email works: step-by-step, diagram

      As simple as it is to use, an email relies on a more complicated set of operating procedures than that of the Web. For most users, its operation is transparent, which means that it is not necessary to understand how it works in order to be able to use it. The goal of this article is to help you to understand its basic principles, give you an idea of how to best configure your email clients, and inform you about the underlying mechanisms of spam.

    • How to structure an email: format, example

      Nowadays, we send emails almost every day. They have become one of the most convenient ways to communicate with colleagues, friends, and family living far away. If you'd like to explore how the email is structured, read this article and find out what the body of an email entails and how many headers it can have, among other details.

    11 October
    • What is Augmented Reality (AR): definition, lenses, AR vs VR

      Have you ever played Pokémon GO? Or tried to see how furniture from IKEA looks in your apartment by pointing the phone screen at a specific place in the house? Maybe you managed to walk into a museum and see what it looked like 200 years ago. This is augmented reality, innovative technology that superimposes virtual objects into "reality" with a smartphone, optical device, or tablet screen. This article will introduce you to augmented reality and explain how it works.

    • How to check fake reviews on Amazon

      Amazon has grown to become a giant online retailer where you can find almost anything. The site also allows its customers to post item reviews, which help you to rank an item and make a purchase decision. However, some of these reviews are fake. When considering a new product here are some tips to help you filter out suspicious or misleading reviews on Amazon.

    • Best fundraising sites: for individuals, for nonprofits

      Crowdfunding sites have risen in popularity in recent years and are becoming an important source of financing for personal projects and entrepreneurs. Once a crowdfunding campaign is posted, small donations collected online add up to a targeted amount. Check out the most popular crowdfunding sites in this article!

    10 October
    • How to recruit candidates using social media

      How can you find the ideal candidate with the help of social networking? What role does brand image play? Over time, the digitalization of the working world has also impacted the recruitment process. Currently, we are in the era of "social recruiting," where social networks have become an important channel when recruiting talent, as they represent a source of valuable information and more opportunities for both recruiters and candidates. Read on and recruit candidates through social media!

    • How to protect yourself from malware

      Malware is a common problem on all computers. Infecting a PC with malicious software can slow down and impair computer performance. Fortunately, there are simple ways to minimize the risk of getting infected and remove these programs once they have entered your computer. In this article, we explain what malware is and how to combat it.

    7 October
    • How to search for a word in a PDF: online, via Adobe Reader

      The search function in Adobe Acrobat Reader allows you to locate words or phrases while working with PDF documents, even if it has been converted to PDF using character recognition technology (OCR). Thanks to this function, you can perform a simple search in a single document or a more complex search in one or several PDF documents. Read on to find out how to do it.

    • How to conditionally format Excel data with dates?

      Excel is a very handy tool for working with data. It has many built-in features, like conditional formatting, which helps you to format and highlight data based on certain rules. The rules can be based on number values or ranges, text values, or even dates. This FAQ will get into how you can conditionally format your data based on dates.

    • How to generate email notifications for Excel updates

      When working on a shared network, it is very common for multiple employees to access and change common files throughout the day. This article will explain how to implement a macro in Microsoft Excel that will send an automated email each time a change is made to a common document.

    • How to add a background image in Open Office Writer

      Open Office Writer is a software that allows you to add a background image to your document. For example, it can be a creative background for a postcard or a logo for an official document. Read this article to find out how to add a background image to a document on the Open Office Writer program.

    • Popular video effects on Funimate

      Funimate has become one of the most popular apps on the web for editing and creating videos. It has original and creative effects and perfectly combines music and video imagery making it ideal to use with other applications eg TikTok. Want to learn how to use Funimate? In this article we'll provide all you need to know and show you the best video effects.

    6 October
    4 October
    • Merge multiple social media accounts: Instagram, Facebook

      Maintaining a presence on social networks is a key element in digital marketing strategies for companies, brands or professionals. Sometimes having multiple accounts on Facebook, Instagram, LinkedIn, or Twitter can fulfill this strategy. However, you may find that you no longer need a particular account and want to merge it with another. In this article, we will show you how to merge multiple accounts.

    • Google Docs spell check: not working, settings

      Sometimes, when writing a text in a rush, you can make mistakes, typos, and other spelling and grammar errors. Thanks to Google Docs' built-in Spell Checker, the online word processor application integrated into Google Drive, you will see all your errors and spelling suggestions to improve your text. This article explains how to use the spell check feature in Google Docs, which is available in different languages and is easy to use.

    • How to insert emoji in Outlook email

      Emoticons serve as representations of various facial expressions "smiley faces'' using punctuation marks, numbers, and letters. Emoticons are now so widely used that they've almost become a language in their own right especially on social networks and instant messaging applications. If you want to express your joy, disappointment, or sadness when composing an email, you can add one of the smileys available in Microsoft Outlook email client.

    • WhatsApp supported phone list (2022)

      With the latest WhatsApp update, as of 2021, some smartphones will no longer be able to support the app, and it will cease to work. Either the app will expire or keep running but will have recurring errors. In this article, we will list the smartphone models that won't be compatible with the latest WhatsApp update.

    • What are the most private internet browsers

      Have you ever made a search on the internet, and then found that for several days you are bombarded with advertisements on social networks? The most popular browsers, such as Google Chrome, Internet Explorer, and Safari, come with a major drawback: the lack of user privacy. Luckily if you would like to surf the web more securely, there are alternative browsers available.

    3 October
    • Facebook Fan Badge: meaning, how to get it

      If you have your favourite Facebook page, where you always read posts, often leave comments and likes, you probably already have a Top Fan badge. If so, read on to find out, what a Top Fan badge is and how to manage it.

    • How to remove hyperlinks in Word?

      Hyperlinks are helpful for computing as they provide data reference points. The user is automatically directed to the data's location within the file by clicking on a hyperlink. When text is copied from a website onto Office software like a Word document, naturally, the hyperlinks of the text also appear. However, these can be removed easily. Follow the guide below if you want to learn how to do this.

    • How to turn off the Microphone on Facebook?

      If you care about your privacy and want to prevent your smartphone from "spying" on your conversations through the apps installed, you can check out below how to disable the microphone for the Facebook app and all the other apps you installed.

    • How to close a Paypal account

      PayPal is one of the most widely used online payment methods worldwide for private and business transactions. So no matter your reasons, read on to find out how to shut down your PayPal account.

    • Mouse cursor settings in Bandicam

      You can either display or hide the mouse cursor when recording a video or taking screenshots with Bandicam. In this article, we will take you through the procedure.

    • Send email with attachment Excel: VBA, macros

      Excel is not only used for storing, cleaning, and analyzing data, but also for automating data-related processes. Automation can be done in Excel by writing or recording macros in VBA. You can even use macros on Outlook to send an email with attachments. This article will show you how to do so.

    • What is the credit summation formula?

      MS Office Excel is a spreadsheet application. In Excel, various kinds of statistical functions can be applied to the cells. One can also apply mathematical functions to the data. The below article details a user generated credit/debit summation formula which should be simply pasted into the cell where a result is desired.

    2 October
    • The best Adobe Illustrator alternative

      Adobe Illustrator is one of the most complete and used graphic design softwares on the market but its high price makes it difficult for many non-professional users to acquire. If you need a free or low cost program that offers similar features, in this article we talk about four very interesting design alternatives that you can easily obtain.