In a LAN, one way of identifying a computer, when all you have is an IP address, is by using nbtstat command.

Simply launch command prompt and type:

C:> nbstat -a 192.168.1.1

It will return the computer’s DNS and mac address.

Another way of searching for specific file or folder is by using locate. You can actually search for commands using this and it will return the absolute path name.

Example:

[aby@localhost ~]$ locate smb.conf

This will return all possible search results:

/etc/pam_smb.conf
/etc/samba/smb.conf
/usr/share/doc/pam_smb-1.1.7/pam_smb.conf.example
/usr/share/man/man5/smb.conf.5.gz
/usr/share/system-config-samba/smb.conf.template

To ignore case:

[aby@localhost ~]$ locate -i smb.conf

You can read man page for other options available for locate.

In order to open rar files, we have to do the exact opposite of it, which is UNRAR.

Installing unrar in Fedora is as easy as:

root@localhost ~]# yum -y install unrar

in Debian:

root@localhost ~]# apt-get install unrar

in FreeBSD:

root@localhost ~]# pkg_add -v -r unrar

Mounted disk partitions that are integrated into the overall file system can be found in fstab. It is loaded every system bootup. But, instead of restarting the entire system when a file system is inaccessible, we can simply reload fstab by executing the command:

]# mount -a

[root@ localhost ~]# mount -a

Here’s a simple yet useful tool that sometimes is forgotten on how to perform.

1. Select all cells

2. Click Data > Filter > AutoFilter

It’s that easy!!

Note: In Windows, you will be asked what header to use.

**Now I wonder why I keep on forgetting this. hmmm…