MS Office Portable 2007

Portable MS Office 2007

Microsoft Word Portable or Microsoft Office Portable are self-contained tools that allow you to work with Microsoft products without installing any software. With them, you can be more flexible in the workplace.

How To Make Pendrive Bootable Without any Software

Everyone find difficult to formatting a computer to install fresh OS with a CD/DVD as those corrupt after using a couple of time. Today all PC/Laptop comes with many USB Port, so Creating a pen drive Bootable for formatting a computer to install fresh Windows OS is not much difficult and Formatting is very fast and easy When compared to CD/DVD, also no software is required for this method.

Just follow below Steps:

1. Open the Command Prompt
Go to “Start” button and click Run. Write “cmd” and press enter.

2. Open the disk management utility.
Enter the Command "diskpart" and press Enter

3. Identify Your Pendrive
Enter the Command "list disk" to list all available drive and identify your drive(Pendrive/Flashdrive).

4. Select your Pendrive
Make note of the number next to your USB drive. Enter the command select disk #, replace “#” with the number from the step 3.

5. Clean the Data in Pendrive
Once you selected the disk, clean the data in pendrive by entering "clean" Command.

6.Create a New Partition
Ater Cleaning the Pendrive, Create a new partition using the Command "Create Partition Primary"

7. Select the Newly Created Partition
Select the newly created partition in step 6 using the Command "select partition 1".

8. Format the Pendrive
Format the pendrive and create a new filesystem by using the command "format fs=ntfs quick"

9. Active the Current Partition
You must active the selected partition, it will make partition as active for booting after restarting the computer by entering "active" command

10. Copy OS Files
Now Close the Command Prompt and Start copying all the files in your OS CD/DVD or ISO Image to your Pendrive

Now Plug your Usb and restart your computer to test your Bootable Pendrive.

How to use Multi Criteria in Vlookup using INDEX and Match

In Excel, we use Vlookup for pulling data from a table with single criteria but it can only work with one criteria for matching information. If there are multiple rows in your sheet with the same information, you’ll only get the first one. If you need to use two or more conditions to match a specific piece of data, you’re out of luck.

To Achieve multiple criteria in a vlookup, Excel has a pair of functions called INDEX and MATCH

The syntax for INDEX and MATCH as follow:

=INDEX(array, row_num, [col_num])

The array is the table of data that contains the cell value you want.

The row_num is the relative row number of the cell you want.

The col_num is the relative column number of the cell you want.

=MATCH(lookup_value, lookup_array, [match_type])

The lookup_value is what you are searching for.

The lookup_array is the array of values you are trying to find the lookup_value in.

The optional match_type determines whether MATCH must find the lookup_value exactly (with a 0), or return the closest match that comes before it (with a 1) or after it (with a -1) alphanumerically.

Using INDEX and MATCH with one Criteria

The syntax as follow:

=INDEX(array,MATCH(lookup_value, lookup_array, [match_type]) , [col_num])
=INDEX(C4:H1159,MATCH(A2,C4:C1159,0),6)

Using INDEX and MATCH with Two Criteria

The syntax as follow:

=INDEX(array,MATCH(lookup_value, (lookup_array)*(lookup_array), [match_type]) , [col_num])
=INDEX(C4:H1159,MATCH(1,(C4:C1159=A2)*(D4:D1159=B2),0),6)

When you enter the formula, don’t just press ENTER. Press CTRL+SHIFT+ENTER to tell Excel that it is an array formula. You can tell you’ve done it right because the entered formula will be surrounded in curly braces {}.

NetBeans 8.1 IDE

What is NetBean IDE?

NetBeans is an integrated development environment (IDE) for developing primarily with Java, but also with other languages, in particular PHP, C/C++, and HTML5.[3] It is also an application platform framework for Java desktop applications and others.

The NetBeans IDE is written in Java and can run on Windows, OS X, Linux, Solaris and other platforms supporting a compatible JVM.

The NetBeans Platform allows applications to be developed from a set of modular software components called modules. Applications based on the NetBeans Platform (including the NetBeans IDE itself) can be extended by third party developers.

Microsoft Visual Basic 6.0

What is Visual Basic?

It's a computer programming system developed and owned by Microsoft. Visual Basic was originally created to make it easier to write programs for the Windows computer operating system. The basis of Visual Basic is an earlier programming language called BASIC that was invented by Dartmouth College professors John Kemeny and Thomas Kurtz. Visual Basic is often referred to using just the initials, VB. Visual Basic is easily the most widely used computer programming system in the history of software.

"Half GirlFriend" by Chetan Bhagat

About:

Half girlfriend is a story of Bihari boy Madhav and Delhi girl Riya, both are teenagers. Madhav belongs to middle class family where riya is from higher class, both have different lifestyle. Madhav fall in love with Riya and propose her. And Riya rejects it because she thinks they are good as friend only.

Riya thinks there is big communication gap between both of them because Madhav can't even speak english properly and on the other hand riya speaks fluent English. Madhav have very common lifestyle where riya don't have to look around for anything, she has everything, nothing to worry.

Coming back to love story, Madhav try to convince her to being her girlfriend but riya rejects his proposal. She wants them to be just friends but madhav definitely wants more.

Then one day, Riya suggest a unique idea of Half Girlfriend. Riya agrees to being his Half Girlfriend (friend cum girlfriend). From here, the new modern love story starts, how they go, how this relationship moves from good, bad and exited things.

Meanwhile, you will see some beautiful sight seen of Patna (bihar), New york and one special appearance of Bill gates in this story. Also, some bad side of bihar (as backward area) you will be notice in this love story.

Will Madhav succeed to make riya fall in love with him? Will Riya accept him or not? All these answers are available on this 280 page long book. This love story is beyond Live in relationship and Love at first sight type of love story. Chetan bhagat tried his best to make it unique love story.

Highlight Duplicates in Column using Conditional Formatting

Use Excel conditional formatting to highlight duplicate entries in a specific column, or in a range of cells (multiple rows and columns):

In Excel 2007 or later:

Select the cells to format -- range A2:A11 in this example

On the Ribbon's Home tab, click Conditional Formatting

Click Highlight Cell Rules, then click Duplicate Values

Select one of the formatting options, and click OK

For Excel 2003:

Select the cells to format -- range A2:A11 in this example

Choose Format|Conditional Formatting

From the first dropdown, choose Formula Is

For the formula, enter

=COUNTIF($A$2:$A$11,A2)>1

Click the Format button.

Select a font or fill colour for highlighting.

Click OK, click OK