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

"Like It Happened Yesterday " by Ravinder Singh

About:

Like It Happened Yesterday is a wonderful and fictional journey through Ravinder Singh's childhood. From vaccinations to final exams, the book is filled stories that almost all of us can relate to. The book is popular in metropolitans and B-towns alike. ndias highest selling and much loved writer is back with his highly anticipated third book!

Has anyone ever asked you - What were the best days of your life?

That one period of your life you always wanted to go back to? And live that life . . . one more time?

When asked this, I closed my eyes and went back in my own past. And I thought of the days, when lifes most complex choices had a simple solution of Akkad Bakkad Bambey Bo! The seasons when rains were celebrated by making paper boats. The times when waiting at the railway crossing meant counting the bogies of the train passing by.

When I opened my eyes, it seems Like it Happened Yesterday! Like it was yesterday that I broke my first tooth and fell in love for the first time. Like it was yesterday, when I was about to lose my friend, and suddenly he became my best friend.

I look back and it becomes a journey full of adventure. It makes me laugh, it makes me cry and I know Im here because I was . . .

Come, hold my hand, and take this trip with me. It will be yesterday for you, once again! .

"A Walk To Remember" by Nicholas Sparks

Main Character:

Jamie Sullivan, Landon Carter, Hegbert Sullivan, Mr and Mrs. Carter, Angela Clark, Carey Denison, Lew, Miss Garber, Eric Hunter, Eddie Jones, Jamie's dead mother and Margaret.

What’s Good:

A real inspirational novel you won't ever forget! Intriguing, great character development

What’s Bad:

Predictable, inadequate ending.

About:

A Walk to Remember is a novel by American writer Nicholas Sparks, released in October 1999. The novel, set in 1958-'59 in Beaufort, North Carolina, is a story of two teenagers who fall in love with each other despite the disparity of their personalities. A Walk to Remember is adapted in the film of the same name.

How to remove temporary files from computer

Worry About Temp Files in your Computer ?

Mostly a part of our hard disk memory occupied by temp files, those all unwanted files and need to clear for freeing up your hard disk space, its hard to keep on deleting those files manually. Come lets make a bat script for clearing those temporary files

Copy the below code and save it as bat script(*.bat)

@echo off
del /s /f /q c:\windows\temp\*.*
rd /s /q c:\windows\temp
md c:\windows\temp
del /s /f /q C:\WINDOWS\Prefetch
del /s /f /q %temp%\*.*
rd /s /q %temp%
md %temp%
deltree /y c:\windows\tempor~1
deltree /y c:\windows\temp
deltree /y c:\windows\tmp
deltree /y c:\windows\ff*.tmp
deltree /y c:\windows\history
deltree /y c:\windows\cookies
deltree /y c:\windows\recentplaces
deltree /y c:\windows\spool\printers
del c:\WIN386.SWP
cls

How the VLOOKUP Function Works

Excel's VLOOKUP function, which stands for vertical lookup, can be used to look up specific information located in a table of data or database.

VLOOKUP normally returns a single field of data as its output. How it does this is:

you provide a name or lookup _value that tells VLOOKUP in which row or record of the data table to look for the desired data.

you supply the column number - known as the col_index_num - of the data you seek.

The function looks for the lookup _value in the first column of the data table.

VLOOKUP then locates and returns the information you seek from another field of the same record using the supplied column number.

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the VLOOKUP function is:

= VLOOKUP ( lookup_value , table_array , col_index_num , range_lookup )

lookup _value (required):
The value you want to find in the first column of the table_array.

table_array - (required):
This is the table of data that VLOOKUP searches to find the information you are after.
The table_array must contain at least two columns of data.
The first column normally contains the lookup_value.

col_index_num - (required):
The column number of the value you want found.
The numbering begins with the search_key column as column 1.
If index is set to a number greater than the number of columns selected in the range argument a #REF! error is returned by the function.

range_lookup - (optional):
It indicates whether or not the range is sorted in ascending order. The data in the first column is used as the sort key.

A Boolean value :
TRUE or FALSE are the only acceptable values.
If omitted, the value is set to TRUE by default.
If set to TRUE or omitted and an exact match for the lookup _value is not found, the nearest match that is smaller in size or value is used as the search_key.
If set to TRUE or omitted and the first column of the range is not sorted in ascending order, an incorrect result might occur. If set to FALSE, VLOOKUP only accepts an exact match for the lookup _value. If there are multiple matching values, the first matching value is returned If set to FALSE, and no matching value for the search_key is found a #N/A error is returned by the function.

"Can Love Happen Twice" By Ravinder Singh

Main Character:

Ravin, Simar,Amardeep, Manpreet, Happy, Manpreet, Shambhavi, Sanchit and more.

What’s Good:

Great dialogues, simple and perfect writing, Language decency, Spreading message, Lot of funny moments, Emotional roller coaster

What’s Bad:

Spent the enough pages before main story starts, Some part in starting and in end part are boring.

About:

Can love happen twice? is Ravin’s life after “I too had a love story”(his first book).The book is simple and heart touching full of romance and funny moments.This too end on a sad note with a message:

"I Too Had a Love Story" by Ravinder Singh

Main Character:

Ravin, Kushi and more.

What’s Good:

Great dialogues, simple and perfect writing, Language decency, Spreading message, Lot of funny moments, Emotional roller coaster

About:

This book made me cry. Why? Because I wasn’t reading the fiction. It is based on real life events and you can realize the love and pain from which he has gone through in a time frame of merely less than a year. It hurts and it surely hurts. The person who has never fallen in love before, the person who has never thought of getting into any sort of fake relationships had to face such a bitter truth of life . He turned into a writer and in several pages he has written heart-warming poems for her. I adore his love for Khushi who is dead yet so alive in his thoughts and memories. May god give each of us whatever we want and whosoever we love in our life. It doesn’t happen again and again, life is just once; make the best use of it. If you love someone, please do make them read this beautiful love story.

"Three Mistake of My Life" by Chetan Bhagat

Main Character:

Omi, Govind, Ishaan, Vidya, Ali

About:

In late-2000, a young boy in Ahmedabad called Govind dreamt of having a business. To accomodate his friends Ish and Omi’s passion, they open a cricket shop. Govind wants to make money and thinks big. Ish is all about nurturing Ali, the batsman with a rare gift. Omi knows his limited capabiltiies and just wants to be with his friends. However, nothing comes easy in a turbulent city. To realize their goals, they will have to face it all – religious politics, earthquakes, riots, unacceptable love and above all, their own mistakes. Will they make it? Can an individual’s dreams overcome the nightmares offered by real life? Can we succeed despite a few mistakes?

"One Night at the Call Center" by Chetan Bhagat

Main Character:

Shyam, Priyanka, Vroom, Esha, Radhika and Bakshi

About:

In winter 2004, a writer met a young girl on a night train journey. To pass the time, she offered to tell a story. However, she had a condition: that he make it into his second book. He hesitated, but asked what the story was about. The girl said the story was about six people working in a a call center, set in one night. She said it was the night they got a phone call. That phone call was from God. Welcome to one night @ call center, another witty, dark novel from the award-winning author of the national bestseller Five Point Someone. Are you ready to take the Call?

"Two States" by Chetan Bhagat

Main Character:

Krish and his family, Ananya and her family.

About:

Love marriages around the world are simple:

Boy loves girl. Girl loves boy.

They get married.

In India, there are a few more steps:

Boy loves Girl. Girl loves Boy.

Girl’s family has to love boy. Boy’s family has to love girl.

Girl’s Family has to love Boy’s Family. Boy’s family has to love girl’s family.

Girl and Boy still love each other. They get married.

Welcome to 2 States, a story about Krish and Ananya. They are from two different states of India, deeply in love and want to get married. Of course, their parents don’t agree. To convert their love story into a love marriage, the couple have a tough battle in front of them. For it is easy to fight and rebel, but it is much harder to convince. Will they make it?