MICROSOFT EXCEL (BASIC)

MICROSOFT EXCEL (BASIC) 1.       There are different field in MICROSOFT EXCEL, the most upper toolbar is call quick access tool bar. Read Best Story Books 2.       Under this toolbar you will find different types of TABs like File, Insert, Page layout, Data, Review and View. Older version of Microsoft Excel 2007 and 2003, these tabs were call as Menu bar. 3.       In each Tab there are many commands groups, for example in Home tab you will find many groups (Clipboard, Font, Paragraph, Styles and Editing). In each groups there are certain types of commands. For example, in Clipboard group (Paste, Cut, Copy and format Painter) 4.       Below command groups, there is Name Box. It shows where is your cursor in excel page, in which cell you are. As you can see below cell is selected by E column and 5 Row. Name box is representing E5 5.       After Name Box, you will find formula bar, formula bar is used to apply formula in cell. This can be minimized and maximized after click below sign to formula bar. 6.       Below formulae bar A, B, C, D that are called Column Name and left side 1,2,3,4 that are called Rows name. If you click any of column Name, the whole column will be selected same as applied to Rows. If you select any Row name, the whole Row will be selected. 7.       In the bottom of page, there are sheets (sheet 1, sheet 2 and sheet 3). If you click on + sign it will increment of sheets. If you want to see all sheet name in one location, there is an arrow sign left side of sheet name. Just right click on it. It will show all sheet name. 8.       In right bottom side of sheet, there is Screen Zoom scroll bar. That can minimize and maximized after clicking – and + signs. But by this only sheet will be minimize and maximize. All Tabs will be same. 9.       There are also two scroll bar, Vertical Scroll Bar and Horizontal Scroll Bar. That are used for screen backward and forward, Screen up and Screen down. 10.   There is up right side of workbook. Three buttons for minimize and maximize of page, restore and close workbook. 11.   Left side of screen, there is File tab if click of on you will find some certain options (save, open, save as etc). In some version of Microsoft excel, this tab was not present. It was as office button. 12.   In last but not least, if you want write anything on excel sheet. How will you write? It is very simple. Just click on any cell where do you want to write. And type from your keyboard what you want. Note: This is workbook. Let me tell you what exactly workbook is. Workbook is collection of sheets which contains data.

MIRCOSOFT EXCEL (Introduction)

MIRCOSOFT EXCEL (Introduction) ·         Welcome to Technical with Practical platform, we will learn here about Microsoft excel. Let me tell you what we will learn here, we will learn function, grouping, pivot table, formulas and charts etc. ·         What is excel actually, Excel is spreadsheet program which develop by Microsoft that is available in different operating system like Windows, linux, MacOs, Android etc. ·         What excel does? Excel is huge program that does various types of works. In this you can create pivot Table, charts, function and many more. ·         What is pre condition for this tutorial is. You should have basic knowledge of computer peripherals like mouse, keyboard, monitor and printer etc. Read Best Story Books

Read Best Story Books

How to use Hyper Terminal or console cable on network

How to use Hyper Terminal or console cable on network. 1.   In this lesson we will learn about using Hyper Terminal or console cable over network. Mostly all network devices are accessed from remote location. All configurations or network management is done by network administrator from remote location. But when device is down that can’t be accessed from remote then it is compulsory to go to device location and configure it from there with the help of hyper terminal. 2.  If we connect with cross over cable or any other Mode then we can’t find Router CLI mode. For checking router CLI mode Go to PC> Desktop> Terminal > Click OK>Your screen 3.  In below picture we have taken one router that can’t be controlled from remote location. We go to nearby device and connect our PC with console cable with Router. To connect console cable just connect cable with R232 PC port and Router console port. After connecting ports Go to same way : Go to PC> Desktop Tab> Terminal>Click OK> Your CLI screen. 4.  As you can see above CLI mode is accessed by PC. You can configure it what you want.

Setting Dial up on CISCO Packet Tracer

Setting Dial up on CISCO Packet Tracer. 1.       In this chapter we will learn how to set dial up on packet tracer as well real time scenarios. 2.       On cisco packet tracer we need one router, one PC and one modem cloud as given in the picture below. 3.       For connecting these devices, phone line is required. It is necessary to change PC port Fastethernet to Modem0. To change port GO to PC >Physical Tab>Turn off PC light>remove fastethernet port>attach PT-HOST-NM-1AM port> Turn on PC light. 4.       Same thing we need to do on router. Go to router(1841) >Physical Tab> Turn off Router light>Attach WIC-1AM module > Turn on Router light. 5.       In next step connect all device with phone cable, PC to cloud and cloud to router. Suppose I have chosen 1111 number for PC and 2222 for router. Go to Cloud-PT>Config Tab>Modem 4> put phone number as 1111 > Modem 5> put phone number as 2222. 6.       In further step Go to Router > CLI mode>provide username and password on configuration terminal and also assign IP to PC like 192.168.1.10 with subnet mask 255.255.255.0                  --- System Configuration Dialog --- Would you like to enter the initial configuration dialog? [yes/no]: no Press RETURN to get started! Router>en Router#config t Enter configuration commands, one per line. End with CNTL/Z. Router(config)#username dialup password dialup Router(config)# 7.       Last step is to go on PC > Desktop Tab>Dial up > provide follow below details. You will get status is connected. Device is able to Ping, send packet and many more………

VLAN creation on cisco packet tracer.

VLAN creation on cisco packet tracer. 1.    We will discuss in this lesson about VLAN. What is its purpose and why do we create it?    2.      VLAN stands for virtual local area network that means we can divide resources virtually in different type of tasks. For example, in a company there are three department HR, ADMIN and IT department. All resources connected to each other in single LAN by physically, but we can divide them into three VLANs which will be separately for each department.   3.    Let’s understand with practical way. In this below picture we have taken one router, one switch and 6 PCs. We will assign each two PC in different VLANs.  4.    Put Unique VLAN ID for each Department like vlan 10 for HR, vlan 11 for ADMIN and vlan 12 for IT Department. Assign IPs to each PC according to given in the picture. As I have put on PC0.      5.    As you can see on above picture, I have put IP for PC0 192.168.1.10 and default gateway for this 192.168.1.1 Its mean default gateway will be 192.168.1.1, 192.168.2.1 and 192.168.3.1 for each Department HR, ADMIN and IT. IPs will be next network host like 192.168.1.2 192.168.1.3 and so on ….          6.     In next step we will configure VLAN on switch, Kindly follow below configuration Switch>en Switch#config t Switch(config)#vlan 10 Switch(config-vlan)#name HR Switch(config-vlan)#exit Switch(config)#vlan 11 Switch(config-vlan)#name ADMIN Switch(config-vlan)#exit Switch(config)#vlan 12 Switch(config-vlan)#name IT Switch(config-vlan)#exit Switch(config)# 7   7.    Further step we need to assign switch ports as access or trunk. So ports F0/1 to F0/6 will be access because they will carry single VLAN data and port F0/7 will be trunk because it carries all VLAN data. Follow below configuration to assign ports to particular VLAN. Switch> Switch>en Switch#config t Switch(config)#int range f0/1-2 Switch(config-if-range)#switchport mode access Switch(config-if-range)#switchport access vlan 10 Switch(config-if-range)#exit Switch(config)# Switch(config)#int range f0/3-4 Switch(config-if-range)#switchport mode access Switch(config-if-range)#switchport access vlan 11 Switch(config-if-range)#exit Switch(config)#int range f0/5-6 Switch(config-if-range)#switchport mode access Switch(config-if-range)#switchport access vlan 12 Switch(config-if-range)#exit Switch(config)# Switch(config)#int f0/7 Switch(config-if)#switchport mode trunk Switch(config-if)#switchport trunk allowed vlan 10 Switch(config-if)#switchport trunk allowed add vlan 11 Switch(config-if)#switchport trunk allowed add vlan 12 Switch(config-if)#                       8.     Go to router and need to configure below for further steps. Router>en Router#config t Router(config)#int f0/0 Router(config-if)#ip address 192.168.1.1 255.255.255.0 Router(config-if)#no shut Router(config-if)#exit Router(config)#int f0/0.1 Router(config-subif)#encapsulation dot1Q 11 Router(config-subif)#ip address 192.168.2.1 255.255.255.0 Router(config-subif)#no shut Router(config-subif)#exit Router(config)#int f0/0.2 Router(config-subif)#encapsulation dot1Q 12 Router(config-subif)#ip address 192.168.3.1 255.255.255.0 Router(config-subif)#no shut Router(config-subif)# 9.      Now you can try ICMP packets can be sent. As below in the picture. 10.  Kindly put comment on comment box below for suggestion or concern.

How to create loopback interface in cisco packet trace

How to create loopback interface in cisco packet trace 1.       Let me tell you what is need of loopback over network. In each router there are many interfaces like ethernet, fastEthernet, GigabitEthernet, console. All interfaces have different different IPs. It is difficult to manage whole network for network administrator. So network administrator creates loopback IP for each devices for his or her comfort. 2.       So lets how do we create Loopback IP. We are taking 2 routers and one PC which are connected through cross over cable. Assign IP to each connect port. As given in the picture below. 3.       For example I am going to create loopback IP for router0 192.168.5.1 and for router1 192.168.10.1 . Loopback ID is required for creation of interface. We can put as per our choice. As I put loopback 1. Same we will do for Router0. 4.       Loopback has been created. For testing we need to login by telnet so that we can check loopback is accessible from remote location. Below are commands to create telnet. Router#config t Router(config)#line vty 0 15 Router(config-line)#pass Router(config-line)#password cisco Router(config-line)#login Router(config-line)#exit Router(config)# Router(config)#ena Router(config)#enable secret cisco Router(config)# Router(config)# Router(config)# Router(config)#exit Router# 5.      Now we will check it from PC>Desktop>Command Prompt 6.      It is accessible from remote location. By loopback IP 192.168.5.1 user can access router. He or she can configure any thing on device. Instead of keeping all IPs of each port, one loopback IP is good. 7.      Kindly put comment on comment box for any concern or suggestion. \

How to set IOT(AC and Solar panel) on cisco packet tracer

How to set IOT(AC and Solar panel) on cisco packet tracer 1.    In this lesson we will learn about adding IOT devices cisco packet tracer as real time network if you want to configure your own corporate or office network. 2.    Here I have taken one monitoring server and two IOTs and one switch for connecting all devices with the help of straight through cable. 3.    Now we are going to assign IPs to each device. With the help of DHCP server we will get Dynamic IPs for each end device. How to configure DHCP, kindly follow this below path. Server>Services>DHCP>on>fill all highlighted fields>click add. 4.    Now It is time to sign up with your username and password on server. Follow below path to login into server Server>Desktop>IoT Monitor>Login(put server IP and username password. If it is first time, it will ask you for sign up then provide your username and password as per your choice. 5.    After login into server you can see your IoT Devices on your server screen. You can manage your devices from server. You can turn on and turn off your Air conditioner and can check energy status of solar panel. Please comment on below comment box for any concern.