All articles from Apps & Sites

    January 2022

    19 January
    • How to make money on OnlyFans: as a woman, as a male

      OnlyFans is a social media platform that allows content creators to monetize their content by sharing it with members who pay a monthly subscription fee. The most common content on the site is NSFW, however this is not a requirement, there are also many users who produce SFW content, similar to that which can be found on Patreon. This article will look at how much money you could potentially make, and the best ways to make money with an OnlyFans account.

    • What is OnlyFans and how does OnlyFans work?

      Launched in 2016, OnlyFans is a social media platform, similar to Patreon, that allows influencers and creators to monetize their content by sharing it with other users who pay a monthly subscription fee. The main difference between Patreon and OnlyFans is that OnlyFans allows for NSFW and adult content.

    • How to get a Clubhouse invite code: free, for Android, iOS

      Clubhouse is a social network that focuses on drop-in audio conversations, and is currently in its early beta stage. If you want to join Clubhouse, you need an invitation. At the moment, there are two ways of getting an invitation, either join the Clubhouse waitlist, or ask an existing user for an invitation. This article will show you how to get a Clubhouse invite. Clubhouse is now available on both Android and iOS so this should work for both.

    18 January
    17 January
    • Orkut login: account, old version, Gmail account

      Orkut was a free social networking service owned and managed by Google. It was designed to help users discover new friends and maintain existing relationships. It has been followed up by hello, another social media network built by the same publisher as Orkut.

    14 January
    • How combine IF function, SEARCH and ISERROR in Excel

      When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred to as nesting. This tutorial will walk you through how to combine the SEARCH, ISERROR and IF functions to scan a document for a particular data piece, and mark it with a particular coding piece in the adjacent column.

    • How to create a drop-down List in Excel

      This article will teach you how to create drop-down lists in Microsoft Excel using a feature called Data Validation. When applied, the Data Validation function serves to restrict data that can be entered in the target cell, requiring users to select a value from a list of pre-determined inputs. This function is very useful in a number of cases, from planning employee vacation schedules, to monitoring expenses, to general project management. Here's how to get started.

    • How to run macro when data entered in a cell

      If a user wishes to run a Macro in Microsoft Excel 2007 when the D10 cell is found to be populated, worksheet change event must be used in the Excel Worksheet, not in the module. This article will show you how to run a macro when cell value changes.

    • How to copy data to another workbook: using VBA

      When manipulating data in Microsoft Excel, the Move or Copy Sheet command is a quick and simple way to move or copy entire sheets to other locations either in the same file or in a different workbook. Alternatively, you can use VBA (Visual Basic for Applications) to automate the task and make it much less tedious. This article will introduce you to both methods of copying data to another workbook in Microsoft Excel.

    • Insert picture in Excel: cell, shortcut, using formula

      Macros in Excel can perform functions like inserting pictures, copying data from one cell to another, etc. In order to write an effective macro to insert images in excel, you will need to use a loop. This FAQ will walk you through the steps to applying this macro to your spreadsheet in order to have pictures appear.

    • How to show or hide formula bar in Excel: VBA, shortcut

      Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show you an easy way to create some more space on your computer screen.

    • How to enter multiple lines in a single Excel cell

      It may be needed that you want to type multiple lines of text a particular cell. The main concern lies in the fact that under Excel when you press the Enter Key, the cursor will move to the next cell.

    • How to automatically transfer data between sheets in Excel

      If you are using Excel and would like to automatically transfer data from a master sheet to specified sub sheets when a certain condition is met, this article will explain how to use VBA (Visual Basic for Applications) to do so. This example will demonstrate how to automatically transfer multiple columns in one sheet to another when the value in one of the fields is "Yes". The value of the conditional field can be changed as required.

    • VBA Excel color codes: index number, list

      Do you want to find all of the VBA Excel Color Codes? This brief tutorial explains the different color codes for VBA Excel and then the VBA color conversion function.

    • 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.

    • How to use Excel color cell if formula

      Excel allows defined functions to be executed in Worksheets by a user. Instead of a formula based on the color of a cell, it is better to write a function that can detect the color of the cell and manipulate the data accordingly. Some knowledge of programming concepts such as if-else conditions and looping may be useful to write user defined functions. To write a function to determine the color of a cell, the interior color object can be used.

    • 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 count names in Excel: formula, using COUNTIF

      For users who are struggling with handling Microsoft Excel when trying to copy the same name multiple times without making it confusing, a simple procedure needs to be followed in order to count a list of names. A list of names in a report may be generated, where the same name appears multiple times. With column 'A' having a list of names, where the same name is repeated, and the user desires to display all the names in column 'B', but only once.

    • How to change the character in the dinosaur Chrome game?

      When we go offline and there is a Google Chrome search page opened, we see the dinosaur T-Rex, the famous and simple game that many people have fun with playing. What if we told you that the T-Rex can become Mario Bros, Batman or even Naruto? In this article, you will find out how to replace the dinosaur from Google Chrome with Mario Bros and other characters.

    • How to use an IF statement to add 1 to total

      Excel is used to store, share and analyze data. It has inbuilt formulas that can be customized and combined with each other to achieve the desired results. For example, IF statement incorporates conditional statements. The user can combine IF statement with other functions to add in a conditional statement. These conditions can be based either on some text or numeric value which the formula would automatically check for.

    • How to insert file path in excel: cell, sheet

      If you're using Excel and would like to link another document or Excel file to your spreadsheet, you can do so by inserting the path a file name in a specific cell. This article will show you how to get started.

    • 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.

    • How many IF statements can you nest in Excel

      In normal circumstances, Excel places a limit on the number of nested conditional formulas that you can use. The limit is 7. However, it is possible to circumvent the limitation over the number of nested conditional formulas by cascading them. This article will look at the different methods for nesting multiple IF statements in Excel.

    13 January
    • How to apply a function to multiple sheets on Excel

      Anyone who uses Excel will know that shortcuts and functions to make repetitive actions easier are very much welcomed. Therefore, in this article we will show you how to apply a formula to multiple sheets in Excel.

    • 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.

    • How to change author name in Excel: spreadsheet, VBA

      By default, Excel uses your Windows username as the default author name, which automatically appears in the properties of creating Excel files. You can change the default author name in Excel by following the procedure described below.

    • How to insert GIF in Excel: 365, sheet, VBA

      In an Excel workbook it is possible to insert a GIF, although the animation will only work when the image is inserted into a control. This can be done through Control Toolbox, Design mode and Microsoft Web Browser. ​​​​​​​VBA code is an integral part of inserting a GIF in Excel. This article will show you how to insert a GIF into an excel sheet using VBA code.

    • How to take screenshot in Excel: shortcut, sheet, cell

      Among its wide array of features, Microsoft Excel allows you to take screenshots of data cells in your spreadsheet so that you can present your information in a way that is cleaner and easier to read. Although these screenshots are saved as static images and will not be updated if information changes, this feature is extremely versatile and can be easily transferred to other Office software (such as Word, PowerPoint, or Outlook) for further use.

    • How to enable VBA in Excel: Mac, Office 365

      Visual Basic for Applications, or VBA, is a Microsoft programming language that allows users to create scripts to execute certain actions or functions in a document by using Macros. It is most widely used in Excel to manage large quantities of data; however, other uses do exist. In this article we will show you how to activate VBA in Excel. These methods should work on both PC and Mac.

    12 January
    • Copy data from one excel sheet to another: automatically

      This article will teach you how to transfer data from one spreadsheet to another in Microsoft Excel if your copy and paste function is not working. The two methods presented will use a quick formula that you can apply to data present in the same Microsoft Excel file. This article will show you how to transfer data from one excel worksheet to another automatically.

    • Change date format in Excel: to dd/mm/yyyy, mm/dd/yyyy

      Excel spreadsheets permit you to stay organized while managing large amounts of data, which can be organized in a number of ways. One popular way to organize this data is by date. Excel has a default date format of mm/dd/yyyy, but you can always choose to change the date format, to dd/mm/yyyy, for example. In this article we will show you how to change date format in excel to dd/mm/yyyy, and also how to revert it to mm/dd/yyyy.

    • How to delete boards and pins on Pinterest?

      Pinterest is a social media platform that allows users to pin interesting content. However, if your interests have changed, you can also change the pins you have saved. In this article, we'll show you how to edit and delete your pins and boards.

    11 January
    • Badoo account blocked: contact, recovery

      If your Badoo account has been blocked, it is most likely due to your profile having violated the Badoo Community Guidelines. Below is a summary of the guidelines for the Badoo community and for any photos that you use. This article will explain how to recover a blocked Badoo account.

    5 January
    4 January
    • The best apps to fulfil New Year's resolutions

      During this time of the year, many people decide to set personal goals to achieve in the coming year. Whether it is about breaking a bad habit, learning to play a new instrument, getting into physical activity, or spending more time on self-care, all of these things have one thing in common: the need for willpower and persistence. And in order to help you to achieve your 2022 New Year's resolutions here is a selection of the best New Year's resolution apps.

    • January