Testing apps with different version of browser

It frustrated because one machine only can use one version IE. So if your testing required to cover scenario different browser with different version for example IE 6, IE 7, IE 8 and IE 9.

I'm suggesting this link. " http://spoon.net/browsers". They use many type of browser and version.
For register, just enter your name, email and password. But if you need to be officially use for work then you need to register and buy for 10GB. 

How to setup test scenario 'Regular User' on Window 7

When to run testing using scenario 'Regular User', first you have to become 'Admin User' because you need to have right access to make some changes on your machine.

1) Click on Control Panel -> User Account

 2) Click on Advanced tab, then click on Advanced button under Advanced user management.

3)  Local User and Groups window is opened. Click Users to expand the list. Then right-click on the content to create new user. Click on 'New User..' button

4) New User window is opened. Enter username, Full Name, Password and Confirm Password. Then click on Create button.

5) New user available in the table.

6) Verify new user is available at Users table.

7) Try 'Switch User' on machine. Then login with different user.

     User Name: '\SUser' 
     Password: 'xxxxxx'

     Successfully access the Window with Regular User

How to gets the total value from other tab into summary tab in excel

Are you having problem to get the summary review for the 'Total from other month' ? Like in the snapshot below.

So the step are:-
1) Click on the selected box you want the 'Total from Report January'

2) Under Data, click on Consolidate button

3) Consolidate will be opened. Select Function: 'Product'

4) Click on icon next to 'Browse' under Reference. Window like below will be displayed

5) Click on 'Report January' then click on 'Total Value'

6) Click on previous icon. Then the window will be displayed like below. 

7) Click on 'Add' button and tick on 'Create links to source data' checkbox.

8) View on Summary tab, Price value on 'January' column is same as in 'Report January'

9) Try change the value price at 'Report January'. The Price value on Summary tab will be updates.
     Example. From 100 to 150. New total will be 238.

How to count in excel table automatically

If you having a problem to count the 'Status' like below snapshot.

Please use the formula like in the excel table below.

At the end, the result should be like below.

Its easy right? Do a practice you will be expert at the end. Try it!!