Microsoft Excel Pivot Table Tutorial for Beginners - MS Excel 2003 , 2007, 2010 , 2013

Microsoft Excel Pivot Table Tutorial for Beginners - MS Excel 2003 , 2007, 2010 , 2013
This Is an Introduction how can we use Microsoft Excel Pivot Table. Here you learn how to use pivot table . this tutorial works in all update of Microsoft Excel .Complete guide Here are some Basic Problem Watch The Whole Video to under stand Microsoft Pivot Table - I , II , III   Excel Users Now Can Create Easily Pivot Table
Tagged Under - MS Excel, Microsoft, pivot, table, how to, complete guide, tutorials, excel, microsoft excel 2010, microsoft excel 2007, microsoft tricks, pivot table, google docs, microsoft, google tv , chrome cast, best google products, microsft windows 2010 microsoft windows 8 new windows update How to use excel pivot table


Also Read - How to Write Formal Reports
Famous Affairs Of Indian Cricketers
Top 10 most Awkward Movies - You Should Not Watch With parents
7 Amazing Look Alike Celebrities

Read more

Free Line Messenger || How to install line for windows 8 Phone and Pc and upgraded windows 8.1 Step By Step

INTRODUCTION:-

 Just like WhatsApp, WeChat and several other instant messaging companies are now available online line is also one of the best messenger now available . Line is actually a Japanese company which uses internet for its working and is only available in smartphones i.e it will only work on smartphones. The features provided by line are as follows:-

1.     Text messaging.

2.     Audio media i.e free phones calls at the cost of internet.

3.     Video calls.

4.     Make free audio and video conferences.

The line was launched in japan in the year of 2011 and by the passage of only 18 months the numbe of users using line was 100 million which double crossed to 200 million only six months later. In year 2013 the largest socio-network that was exixting in japan was line and the number of registered user all over the world was crossed  300 million with the highest number of users from japan which was 50 million.

Challenges overcome by line:-

When at the earthquake that happened in japan in the year of 2011 all the telecommunication units of japan were severely damaged by the earthquake and it was becoming very difficult to communicate with each other for the citizens of japan in that condition. Then to make sure that people can contact with each other line was setup by the brainchild of Japanese engineers. Soon after the line was released for public use it faced a huge problem of server overload but soon it overcome this problem and choose a secure data base for storing all the data of user profile and within 18 months of its start it reached a huge traffic of 100 million users. And from that day line has started it has not stopped till now and is one of the most successful messenger available on net.

FEATURES AVAILABLE IN LINE:-

Line has huge variety of features out of which few are described below:-

     1.     Sticker shop:-  This features avails a user to collect virtual stickers of some original characters known. Stickers can collected for free which available and the number of free stickers that are available varies from country to country. A user can also purchase stickers which are not free and by paying the amount for purchase those stickers are attached to the users account which he can use any time. Now these stickers are used by the users during the chat session as the use of the stickers enhances the excitement of the chat and makes it interesting. As users are not getting bored by the use of stickers they stay online in line messenger for a long period which increases the revenue of the company.

    2.     Gaming features:- some of the special effect gaming features are also available in line.

    3.     Free calls:- A line user can easily call for free to another line user and it costs no money only the internet charge consumed during the call. Call may be either video or simply audio calls.

    4.     Line camera:-  This is one of the most interesting feature of line as it hosts about 100 frames and several number of stickers for a user to decorate and make his image or photo to look more beautiful and type of decoration can be compared to an Instagram, thus so efficient is the camera of line. A user of line can also share the edited photo in the social networks like twitter and facebook.

    5.     Line Brush:- Brush as the name features is most commonly used by painter . yes in line you can edit a photo by using brush and there about 27 style brushes and 15 brushes for photo available in line. By using these brushed you can edit your photo very beautifully by creating sharp brush stokes at the edges where needed.

 tropics in social media. So here line gives an option for wishing birthdays and marriage anniversary in the form of line card.

STEPS TO INSTALL LINE ON WINDOWS 7 :-

   1.     At first you have to make a line account in an android smartphone and if you are not having a Smart Phone just you need to borrow it from your close friend  just to set up a line account. And while creating the account you have to give a registered email address.

   2.     Now you need to download the LINE app for windows which you can get from google for free.

   3.     Now as you download has been completed you need to install it on your pc by double-click on the downloaded file and then comes license and aggrement,choose your language and  whatever that are need to install a file in pc.

   4.     As soon as the installation progress has finished click on the finish buttom.

   5.     Now open the line app from the shortcut created on the desktop you see a a line dialog box appears on the screen asking for email address and password and it works as fine as it works on smartphones.

keywords:-
how to make audio call in line, how to make video call in line, how to use line camera, how to use line brush,, how to share a photo in line, how to use a line card, how to install line on pc, how to install line on windows 7, how to install line on windows 8.1 lunia phone, Buy windows phone from low pricw flipkart snapdeal amazon how to install line on samsung, how to install line on apple mac os, how to install line on applle iphone, how to install line on android phone, steps to install line on android, how to download line app for pc, line application free download, line free download for windows, line free download for android, line free download for windows 8.1 mobile phone, line free download for windows 7 mobile phone, line free calls and messages, line 4.4.1 free download, how to use line,

Read more

HOW TO SAVE YOUR EMAIL ATTACHMENTS DIRECTLY TO GOOGLE DRIVE

HOW TO SAVE YOUR EMAIL ATTACHMENTS DIRECTLY TO GOOGLE DRIVE:::

When you receive an email it doesn't contain only scripts instead it may also contain attachments which may either be videos or photos or in any other format. Now how to save the attachment directly to a folder in your Google drive.

You can save the document directly in the Google drive by using the option send to Google drive. Now a latest version is available by which you are getting the chance to specify a list of files and those attachments belonging to those specific list of files which you have been selected will be saved automatically to Google drive.

Now if you not used the option send to Google drive and using it for the first time I will show how actually you can do it.

You need to give a label name to your gmail sheet and the script which is there will be scanning whatever emails you are receiving and sort out if any attachments is there inside it.   For example if you want all the attachments that are coming in your gmail inbox you can label it by ‘Inbox’ and thus whatever emails are coming in your inbox folder will be scanned or if you want to scan your promotions folder you can name it ‘Promotion’ and all the attachments which are there in the promotion folder will be scanned. Now after scanning when an attachment is found out by the script automatically the file will be downloaded   to your Google drive.

For the work to be done there is no need to install any sort of extensions  for your browser and there is also no need to take permission or giving access of your Google drive or your gmail to another party for loading the attachments in  your Google drive.

Hence all is done as private for a user and it is totally safe. And it is also observed that your mobiles devices an desktops are synchronized automatically by the Google drive hence whatever attachments have been saved  in your Google drive will be automatically viewed or accessed in any sort of devices.

 STEP BY STEP PROCEDURE::::

1.   You need to bring the cursor of your mouse over the attachment which you are going to save in the google drive.

2.    Now you need to click on the icon named save to drive.

3.    Now if you want to save all the files in one chance ::::

Ø  Click on the icon  named save all to drive. This icon is available in the header area of the attachment.

Ø Now you need to note that if you are saving all the files at a once you are not having the option to move or save some particular files individually. Now If you are giving a label to some documents then only you are getting a chance to individually save them in the google drive.

4.   To give  label or moving some saved files:::

Ø You need to click on the folder you want to save under the option save to drive.

Ø for going or selecting the sub folders you need to repeat the above steps.

Ø To create a new folder inside the current folder you need to click on the icon new folder.

Ø Now click on move which is the final step. Your folder or attachments will be moved.

Ø  Now if the document is not filed then click on done.

How to open a document which has been recently saved in Google drive????

To open a document which you have saved recently you need to follow the following steps::

 Ø  First of all you need to bring the cursor of your mouse on the attachment you have just save recently and now want to open it.

 ØYou need to click on the icon show in drive.

 ØYou now need to click on the document you want to open.

     Point to note::::

When all the attachments have been saved there a new label named processed is put onto the gmail message which actually indicates that the message is run by the script. This saves attachment of any type .  In order to save a number attachments separately you can use commas.

In order to stop the script at any point of time the only thing you need to do is to open the script of the Google and select the option uninstall from the menu of the gmail attachments.

How to send attachments to the premium version of the google drive????

The premium version of the Google drive supports a lot of new features which are as follows:::

    1.  Nested labels of Gmail::: the function of this feature is to put an eye on the messages that are coming in the Gmail which are in the block of this label.

  2.  The Google drive folders which are nested:::  according the label of the Gmail you are getting the opportunity to chose a specific folder or  saving the attachment under a specific sub folder .

    3.  Keeping an eye on a multiple number of labels::: The version which is available for free you are only getting the independence to save files which are falling under a particular label. But now with premium version you are  getting the opportunity to save the email attachments belonging to one or more than one number of labels thus increasing the flexibility of the system.

    4.   To get premium support:::: for getting this support you have to pay an amount of $49.99. as you pay immediately  you are the owner of your premium features which you ere going to enjoy.

  

Read more

Wireless Keyboard and Wireless Mouse function and How It's works

Well the terms wireless mouse and keyboard  often makes people think that it’s complicates thing but the reality is just opposite, its simple data transmission and reception technology Where the transmitter is the mouse or keyboard and the receiver is the computer or laptop.

Since in the era of advancing technology the wireless mouse have proved to be milestone  because of its portability  and precise nature. It has been proved enormously good in presentations and the places where wire could really have messed it up.

How a wireless keyboard and wireless mouse work.

Well its very easy to understand. In a wired keyboard or mouse the data or the signals are transmitted through medium i.e. metal wire but in the case it requires radio frequency or infrared.well at the reception point i.e. the computer or the laptop we just require  a USB=Universal Serial Bus which acts as the receiver. It also works with the blue tooth technology. But using the IR technology it limits the area of operation .i.e. it just makes it limited to few meters. Or may be less.

There is an circuit being very precise an IC: Integrated Circuit present on the computer  which encodes the signal and summons the the operating system about the the incoming signal, further the CPU decodes it and present it on the display or the screen.

 Example the code For T is +0054.

Types of wireless keyboard.

1.)Optical Keyboard

2.)Laser Keyboard

1.)Optical Keyboard:

There are basically two components of an optical keyboard  light emitting diode and photo detector.

Printed circuit board is used to embed them upon it.light emitting diode works on the principle of “ELECTRO LUMININESCENCE” and further works by detection of light rays both horizontal and vertical beams are emitted by the LED s and these beams are blocked by the keys which are pressed and hence the keys pressed is detected.

2.)Laser keyboard:

The image of the keys is projected on the surface. Which is flat and this done through tracking of the user’s figure over the cmos or the virtual Interface Processing Core TM which is basically an infrared sensor, which examines the location of the pressed keys. The image of the keys is projected using diodes of different colors the projection is enlarged using diffracting surfaces.  

Wireless mouse and it’s working:

Just like any other device which is wireless it has two components  transmitter. In addition to this a wire less mouse also has ceramic capacitor and oscillator 26.690MHz crystal, for tans mission well the data is only in transmission mode when the mouse is working,else it goes into idle mode .i.e. standby mode.

1.)Optical mouse:

It’s basic components are

Light Emitter(LEDs)

Light sensors

Cmos sensors

The cmos sensors are used to capture the movement of the mouse and convert into the digital signal format and transmitters it to the USB attached to the pc. Well here some digital signal processing is done then after that the DSP:- Digital Signal Processor marks the co-ordinates of the image pattern which is received through the optical reflection.

The technology is used is DotsPerInch(DPI). It uses 400-800 dpi.

2.)Laser mouse:

This mouse has the same working principle as that of the optical mouse . but with the variation in dpias it uses an 2000 dpi technology with invisible laser.














Related keywords:- Wireless Keyboard and Wireless Mouse function and How It's works,wireless sensor network wireless power transmission,wireless communication,wireless mouse,wireless keyboard price,wireless keyboard and mouse combo price,wireless keyboard and mouse combo price flipkart amazon ebay snapdeal,mouse price,keyboard shortcut,keyboard not working, keyboards button, wireless mouse problems, mouse battery life, keybord function, keybord press tab caps lock shift, keybord shortcuts, mouse clicks right clicks, wireless mouse click

Read more

How to install Bluestacks Android App Player in PC - Step By Step Process

Blue Stacks App Player is software created by Bluestacks .It creates Blue Stacks Cloud Connect. Hench enable the  uses to run anorid based apps on their pcs The company came into vision 2008 by Rosen Sharma and Coint, who is former CTO at McAfee and  also a board member of “Cloud.com”.

Type: - This is freeware software you can get your copy from the link below

Download Free Bluestacks Android App Player -  CLICK HERE

Blue Stacks App For windows enables the user to run apps like watts app, viber, line etc

On the pc or laptop and is especially helpful for those people who do not own an anroid but desires to use certain apps of anroid, well to them the answer is blue Stacks.  It could be thought of a mobile emulator that runs on windows7 windows 8 Mac os etc.  Hence empowers you to turn your pc into powerful anroid phone with enormous processing speed and yes high speed net.

How to use blue stacks

First download the set up from the given link.

Now run the set up

N.B.: an active internet connection is needed to install the blue stacks it may take several minutes.

After installing the software it will appear like.

Now the screen will appear

 As you can see the several options are there with the featured search option to search the Google play store

Searching and installing an application (app)

Step 1:

First of all click the search option present on the left hand top of the screen

Step 2:-

The search option will get opened then search for some app or game or something which u like say floppy bird for example:

Step 3:-

Now enter the name as per your requirement we are taking the name as floppy bird.

Step 4:-

Click on floppy bird option and there will appear the terms and condition click on accept.

AND WAIT FOR THE APPLICATION TO BE INSTALLED

Step 5: when the app will be installed then notification will be received @ the icon as shown on desktop.

Further the app will be available on the emulator

Now run the app and have fun

Now let’s see some of the mobile feel of the emulator

We have a full screen view of the window by passing the key “f11” and same is pressed for the full screen view to the customer view.

 We can also check quick notification as shown

Well as touch screen we ales close an app by dragging it towards right with the help of mouse pointer or touch pad in case of laptops

Well it is no doubt amazing software and certain screen shorts of social networking apps are:

Line:

Viber

Uninstalling blue stacks

Go to control panel then find (add/remove options for the program)

Select the name “BLUE SATCKS”

AND HIT THE OPTION UNINSTALL

THEN THE RESEDUE FILES COULD BE FOUND IN

C:\ProgramData\BlueStacks

C:\Users\ \AppData\Local\BlueStacks

SHUTTING BLUE STACKS

Simply press “x” key it will close the blue stack main window

For shutting it down completely we must select quit option from the status bar icon

As given below:

Disclaimer: All there information is just for knowledge sake. The users are responsible for any harm if cause using this software.

Related Keywords:-how to install bluestacks in pc,how to install bluestacks app in pc,how to uninstall app in bluestacks, how to play games in android, how to install games in bluestacks, how to install windows app in pc, how to install android app in pc,how to play app in pc, how to boot android phone, how to connect bluestacks in pc, how to connect bluestacks in wifi,how to configure setting in bluestacks, how to download free bluestacks, download bluestacks , app, how to change setting in bluestacks,how to configure email id in bluestacks, how to install bluestacks android games apps in pc, how to change setting of connectify, bluestacks games app, bluestacks android apps in pc, How to run android apps in Mac or windows, Android apps in mac

Read more

How to create a bootable USB drive or pendrive for windows

HOW TO MAKE YOUR USB DRIVE OR PEN DRIVE  BOOTABLE:-

Now if you are a daily user of your computer you should know this small and easy tricks of making a bootable USB. Because sometimes some situations arises when you need to format your system to  remove virus infections and at that particular moment your CD drive is not working properly , then what should you do. An easy technique is that you can easily use your pendrive or some external  USB to format your system by making them bootable .Here  I am here to show you how to do it actually:-

                                              TECHNIQUE:-1

STEP:1

All you need to do is to open the command prompt and run it as  an administrator. To run it as an administrator you have to right-click on it and several options appear.  From there you have to select run it as an administrator. In some situations you need to give the administrator password.

STEP:2

In the second step  you have to open the disk management utility. To open the disk management utility you need to type the command diskpart in command prompt.

STEP:3

In the third step you need to display the disks which are connected to your computer . This can be done by typing the command list disk in the command prompt. Then all the disks which are connected to your system will be displayed including your USB. Then you have to note down the number next to your USB drive.

STEP:4

You have to now select your USB drive by using the command select disk # , replace # with the number you noted down from the previous step. Here as shown in the figure the selected disk is Disk 1. So value of # is 1.

STEP:5

Now what you need to do is to clean the flash drive. For this job to be done you have to enter the command clean  to have the disk management utility ans this will verify your USB drive and thus will format your drive.

STEP:6

As your USB drive is clean you need to type the command create partition primary. A message will appeared in the screen saying that the operation was successful.

STEP:7

Now type the command create partition 1 and press enter for selecting the new partition. And after that once a confirmation message is received , type active and press enter. This command will activate the partition.

STEP:8

Now write the command format fs=fat32 to format your USB drive. When you press enter , the program will  run for a few minutes and if the  usb is small example 8GB  then it would take around 25 mins for slow format and all you can monitor in percentage.

STEP:9

Now the command assign is to be entered to give a letter designation to the USB drive and then type exist for the disk management program to come to an end.

STEP:10

The last but not the least step is to copy the operating system you want to install because the USB is now made bootable.  You can drag your files to the USB or simply copy it. For smooth installation of your operating system you should copy all the drivers needed during installation.

                                      TECHNIQUE :-2

It is far simple method to make your pendrive bootable by the use of a simple software . It consists  of a single executable file and it needs no installation.

The advantage of this technique is that it will not erase any of your data from the USB drive and thus it is a timer saver method. Because in the previous case it use to take around 30 mins for formatting.

However this software will only work for the USB device which is having Phison’s chip solution and FAT-file system only.

If the utility shown above fails to recognize your USB then you need to download the HP USB BOOT UTILITY as it will work in any brand of USB  and the best software to create a bootable USB is the FLASHBOOT founded by the prime experts. This software is the most expensive bootable software because it has an extensive support for the drives and having extra number of advanced options. It costs around $31, but you can download its demo version available for an experience. And if satisfied  you can buy it. It is shown below:-

Now once you have succeed in making a bootable USB drive all you need to do is to  change the boot up setting as discussed below:-                                     

1.    Restart your system with your device inserted.

2.    Now you need to enter the BIOS setup menu to change the bios device setting.

3.    Now you have to see the boot-up files are created in the USB rive or not, and then select USB-hdd or USB-ZIP.  Now if the boot up files are seen to be created in the flop drive of your device then you need to select the USB-FDD ( for the pen drive which is supporting the security mode) 

     Now you need to save and exist the BIOS setup and you are now able to boot up with your USb device.

     Hope you people like this article and if you have any suggestions  then you are free to comment below. IF you like then please share it......

Read more