ChatGPT (Generative Pre-trained Transformer)

ChatGPT is a large language model developed by OpenAI. It is based on the GPT (Generative Pre-trained Transformer) architecture and has been trained on a massive dataset of human text to generate human-like responses to text inputs. It can be used for a variety of tasks such as language translation, question answering, and text generation.

Excel textjoin() add-in for 2013

Steps:

1. Open a blank workbook

2. Press ALT+F11 to open the VBA editor

3. In the Project window on the left, right-click on the workbook name and choose Insert ->Module

4. Paste this code in the resultant window

Option Explicit
Function TEXTJOIN(delimiter As String, ignore_empty As String, ParamArray textn() As Variant) As String
    Dim i As Long
    For i = LBound(textn) To UBound(textn) - 1
        If Len(textn(i)) = 0 Then
            If Not ignore_empty = True Then
                TEXTJOIN = TEXTJOIN & textn(i) & delimiter
            End If
        Else
            TEXTJOIN = TEXTJOIN & textn(i) & delimiter
        End If
    Next
    TEXTJOIN = TEXTJOIN & textn(UBound(textn))
End Function

5. Save the workbook as an add-in type (.xlam)

6. Load the add-in into Excel (File ->Options ->Addins)

Syntax

TEXTJOIN( delimiter, ignore_empty, text1, [ text2, ... text_n ] )

Parameters or Arguments

delimiter

A string inserted between each text value in the resulting string. Most commonly, you would use a delimiter such as a comma or space character.

ignore_empty

Determines whether empty values are included in the resulting string. TRUE ignores empty values and FALSE includes empty values in the result.

text1, text2, ... text_n

The strings that you wish to join together. There can be up to 252 strings that are joined together.

Returns

The TEXTJOIN function returns a string/text value.

Google Chrome Tips & Trick

How to send a URL with a part of text highlighted in Chrome?

• Select the text that you want to link to.

• Right-click and choose “Copy Link to Selected Text” from the context menu.
• If the link creation succeeded, the selected text will be briefly highlighted.
• Paste your link wherever you want to share it.

Search your open tabs in Chrome

1. Open Chrome . 
2. Next to the address bar, select Tab search . 
3. Enter the name of a site or a related word. 
4. To go to the open tab or close the tab, select the name of the site.

Pin a tab on Google Chrome?

Arrange tabs

To pin a tab to the left, right-click the tab and select Pin. ...

To unpin a tab, right-click the tab and select Unpin.

To move a tab to a different window, right click on the tab and point to Move tab to another window, then select the window you want to move it to.

Group your tabs

1. Open Chrome browser.
2. Click New tab .
3. Choose an option:
• To add a tab to an existing group, drag the tab into the group.
• To add a tab to a new group:
1. Click New Tab right-click a tabselect Add Tab to New Group.
2. Enter a name for your group.
3. (Optional) You can also:
• Select a color for the tab.
• Add additional tabs to the group.
• Remove the group.

Top signs that someone is stealing data from your computer as well as some tips for how to avoid viruses.

 

Battery Drain

If your device is unknowingly running malicious software in the background, this will use your central processing power. This software may be spyware or viruses. If your battery life seems to be much shorter, it often is a sign that your device is infected with malware or that someone is crypto mining with your processor. In addition to your laptop discharging much faster than normal, it may also feel hot to touch.

Program Crashes

Hackers sometimes try to collect data by placing code into your apps so that it can steal your personal information. This malicious code can cause your apps to act up, run slower, and frequently crash. The best way to protect yourself is to try not to put your financial data, like credit cards, into apps and if you do have to, be sure to use a strong password and two-factor authentication.

Hackers are always looking for new ways to collect your data. They can put code into your apps to make them collect all the needed information. This can make an app run slower, act up, and crash a lot. To protect yourself, try not to put your financial data like your credit card numbers or codes into apps, and always create a complicated password.

If you have a new computer and it is suddenly running very slow, it may be infected with malware software like a worm or Trojan horse. Often this software is disguised as a legitimate download but once installed will consume a lot of your processor’s resources, causing your device to run much slower.

WebCam Recording

If your webcam suddenly starts recording, or the microphone turns on by itself, someone could be spying on you. In addition to stealing your data, they could be recording your voice and taking photos. It is recommended to frequently change passwords, cover your camera with tape and turn off your microphone when not in use.

Blinking Lights

If someone has taken control of your computer, the send and receive lights may be blinking when you are not using it. Spy malware and other viruses can cause data to be uploaded and downloaded in the background, without you even realizing it.

Frequent Pop-Ups

When surfing online, you may have accidentally clicked on a suspicious banner ad. These can inject your laptop with an advertising virus that sends constant pop up ads to your screen. While it is annoying, more concerning is that the virus can allow hackers to access your data.

Browser Redirect

When searching on Yahoo or Google, if you are being redirected to a suspicious website instead of being served search results, this is a sign of being hacked. A Trojan virus may be installed on your device. To verify, you can check the extensions of your browser to search for anything suspicious.

Restrict access to hard disk on Window

 

1. Log on to the computer with an Administrator account.
2. Click "Start," type "Control Panel" (without quotes) and then navigate to "Control Panel > User Accounts" (Control Panel\All Control Panel Items\User Accounts).
3. Click "Manage another account."
4. Click "Create a new account" or " Add a new user in PC settings" (in case of Windows 8/10) and fill in the required username, password etc.
   
   On Windows 8/10, the process to add a new user to PC is slightly different. Add a new user following the steps below: 
•  Navigate to Control Panel\All Control Panel Items\User Accounts
• Click on Manage Another Account
• Click on "Add a new user in PC settings"
• In the PC Settings > Family & Other People > Click "Add someone else to this PC"
• Windows will attempt to let you enter Windows / Outlook account details of the person you want to add. If you have, well and good. Otherwise, click on " I don't have this person's sign-in information".
• Windows will then tell you to create an account for the user. If you want Windows / Microsoft account, go ahead. Otherwise, click on "Add a user without Microsoft Account"
• Fill in Username, Password and Password Hint if required.
• Then click on next and proceed as per the instructions.
5. If the user account already exists or you have created a new user account, then open Windows Explorer. 
6. Right-click the name of the hard drive or hard drive partition you want to restrict access to and then click "Properties."
7. Click the "Security tab" in the "Properties" window that opened. Click "Edit..." and "Add..." in the "Select Users or Groups" window that opened.
8. Type the name of the user account on your computer with which other users will login with (existing account or the one newly created). 
9. Click "OK." Uncheck the boxes against ALLOW of any options that you DO NOT want available to the user. Also check the "DENY" boxes for "Full control". It should be disabled or unchecked.
10. Click "OK," "Yes" and "OK." Close any open windows. 
11. Log off the administrator account that is signed in currently and then log on as the other user to test the settings applied.
12. After you are logged in as the other user account, open Windows Explorer.
13. Double-click the name of the hard drive or hard drive partition you restricted access to. A window indicating that "Access is denied" is shown. The user is denied access to the hard drive or hard drive partition henceforth.

The steps above will successfully restrict or deny access to a hard drive or hard drive partition from other users.