Excel Tutorial Series

Tutorial No. - 001

This is the beginning of my own experiences that I am going to share with my friends and well-wishers. I will try to give them my level best to share my knowledge.

Tutorial No. - 1 

It is about making a chart and present it in good looking. 

Next we will discuss about formula and elements. 

thanks to all

Haurn.

Subject: FTP

What is FTP, and how do I use it to transfer files?

Overview

FTP is an acronym for File Transfer Protocol. As the name suggests, FTP is used to transfer files between computers on a network. You can use FTP to exchange files between computer accounts, transfer files between an account and a desktop computer, or access online software archives. Keep in mind, however, that many FTP sites are heavily used and require several attempts before connecting.

Note: You need to use a client that supports secure FTP to transfer files to and from Indiana University's central systems. For more, see At IU, what SSH/SFTP clients are supported and where can I get them?

How to use FTP

Graphical FTP clients

Graphical FTP clients simplify file transfers by allowing you to drag and drop file icons between windows. When you open the program, enter the name of the FTP host (e.g., ftp.empire.gov) and your username and password. If you are logging into an anonymous FTP server, you may not have to enter anything. Two common FTP programs are Cyberduck (for Mac) and WinSCP (for Windows). For more, see At IU, what SSH/SFTP clients are supported and where can I get them?

Web browser

You can use a web browser to connect to FTP addresses exactly as you would to connect to HTTP addresses. Using a web browser for FTP transfers makes it easy for you to browse large directories and read and retrieve files. Your web browser will also take care of some of the details of connecting to a site and transferring files. While this method is convenient, web browsers are often slower and less reliable and have fewer features than dedicated FTP clients.

To use your web browser to connect to an FTP site such as ftp.empire.gov, where you normally enter a URL, enter: ftp://username@ftp.empire.gov/

Command line FTP

Windows, Mac OS X, and Linux have built-in command line clients; see What are some common FTP commands? For example, to start FTP, at the command line prompt, enter:

   ftp ftp.empire.gov

If you are connecting to your own account, enter your username and password. If you are connecting to an anonymous FTP site, for your username, enter anonymous . For your password, enter your email address.

Shortcut Keys of Windows 7

Those who are really want to work fast, have to understand and increase the use of keyboard and its shortcut command. Lets learn some of them: 

Here are 10 most useful keyboard shortcuts for Windows 7. You have to use them regularly or you will forget them. 

10 useful Keyboard Shortcuts for Windows 7

1. Win+1, 2, 3, 4, etc.: It will launch each program in your taskbar. It is helpful to keep your most used programs at the beginning of your taskbar, so that you can open them one after the other.
2. Win+T: It is used to switch between taskbar programs. This is similar to just hovering over the item with your mouse. You can launch any program with ‘Space’ or ‘Enter’.
3. Win+Home: This shortcut minimizes all programs except the current windows that you are using. It is similar to the Aero Shake and it can be disabled with the same registry key.
4. Alt+Esc: It is like Alt+Tab but it switches windows in the order they were opened.
5. Win+Pause/Break: This will open your System Properties window. This can be helpful if you need to see the name of a computer or simple system statistics quickly.
6. Alt+Enter: It opens the Properties of the file, which you have selected, so that you can view file size, sharing settings, and creation date very easily.
7. Shift+F10: It is a very useful shortcut for laptop users as it opens the contextual or “right click” menu for a file/folder. Can be very handy, at times.
8. Ctrl+Shift+Esc: It will open the Task Manager, without needing to use Ctrl+Alt+Del first.
9. F2: Using this shortcut you can instantly rename a file or folder.
10. F3: This shortcut will open explorer and focus on the search bar. If you already have an explorer window open it will focus on the the search bar and open its drop-down menu.