How to find Name Manager (Name list) in Excel 2007

When your MS Excel 2007 program is open; Simply press Ctrl + F3

Battery charger without cable

Technology experts are thinking to say bye of cable charger. Recently Samsung has started to find out the way to charge battery without cable charger. Some other company also became partner with Samsung for this research. They agreed to use the same method to charge there all electronic devices. This charger is not only compatible with single device; as well it can charge multiple devices. Not even that, they are planning to charge even electric Motor vehicle. The project already being started from 5th May 2012 and main concept of the charging method is using a transmitter and receiver.

-->

How to share big size file with a link via email

Some time we may need to share a file with other people, but due to file size or may be due to file type like .exe we can't share thorough email. In this type of situation we can upload it to any place (if not confidential) then can send the link only to the recipient. You can share up to 2.25 GB.

How we can do it:

Download drop box from here: https://www.dropbox.com/downloading

Install in your PC

You will find it under My Computer

Open it then go to "Public" folder and upload your file.

After successfully uploading copy the link and add this to your email body and send the email to recipient.

Market Place for Nokia Lumia Windows Phone

MarketPlace is the website where you can find information regarding your Nokia Lumia device.

·         You can buy a new device

·         Can locate your lost device

·         Can get huge collections off windows phone apps

·         And many more

Visit below locations for all about your Nokia Lumia Device

http://www.windowsphone.com/en-US/marketplace

http://www.microsoft.com/windowsphone/en-US/buy/7/default.aspx

https://www.windowsphone.com/en-US

http://www.microsoft.com/windowsphone/en-US/features/default.aspx

How to remove gridlines in Excel 2007

Gridlines in Excel appears by default every time you open the program. Some time we need to remove gridlines depending on formatting. Please follow the steps to disappear gridlines from your Excel worksheet.

    Step 1: Open your Excel worksheet

    Step 2: Click on "View" tab

    Step 3: Untick Gridlines

    It’s done...

Google TV - Coming soon

Google TV is coming to the market by this month. Second largest Television producer company LG is bringing this internet Google TV in the Market. At the beginning this product will be available at European market. Google TV will come with Google operating system and will be included all the Google service, even viewers can enjoy Youtube video directly. LG did not disclose yet about the pricing or size.

Nokia Lumia Windows Mobile phone

Nokia Lumia 800 (codenamed 'Sea Ray') is a Windows Phone-OS powered smartphone, first unveiled on 26 October 2011 at the Nokia World 2011 event.[4] It was Nokia's first mobile phone to run the Windows Phone OS and marked the company's shift of focus in favor of Windows Phone for its premium priced phones.

Lumia 800 shares its design with the previously released Meego-based Nokia N9. The outward differences are one added physical button dedicated to the camera on the right side of the phone, and a dual LED flash moved directly above the Carl Zeiss camera lens.[5] Despite a similar exterior, the Lumia 800 has a different interior than N9. Lumia 800's chipset comes from Qualcomm, whereby N9 is based on a Texas Instruments chipset and CPU.[6][7]

Like the N9, it has a convex curved Gorilla Glass AMOLED PenTile screen with a ClearBlack antiglare filter. The screen diagonal is 3.7 inches (800 x 480 pixels) compared with 3.9 inches (854 x 480 pixels) for N9, to conform with the Windows Phone specifications list, which includes three capacitive softkeys placed under the glass. A trough-colored unibody shell is made from polycarbonate plastic.[1]

Nokia outsourced the production of its Qualcomm-based Lumia 800 to Compal Electronics. According to Nokia, this was due to time constraints and Compal's experience with the chipset. Future models, starting from Lumia 710, would be built in a Nokia factory, according to the same source.[6] Devices for the European and Northern American markets are configured, tested and packed by Nokia's factory in Salo, Finland.[8]

On January 9, 2012, Nokia Lumia 900 was announced as a parallel model with LTE support, a larger display, front-facing camera for video conferencing, and its main (back) camera improved for focus and color balance.

SoftwareThe Lumia 800 device comes with four Nokia-exclusive applications not included by the default Windows Phone OS: Nokia Drive, a free turn-by-turn navigation system; Nokia Maps; Nokia Music, a free streaming music service and music store; and App Highlights, a service suggesting software based on location and operator. In addition to these applications and services, Microsoft themselves have added Office 365, in which the user can edit documents, create spreadsheets, open PowerPoint presentations, and even make OneNote files. The files created can be stored on Microsoft's SkyDrive cloud service, on the phone itself, and other areas.[10] The Lumia 800, despite the joint cooperation of Nokia and Microsoft, lacks some standard functionality presented by default on Mango, including Internet Sharing, which prevents the use of the device for tethering.

[edit] Nokia CollectionIn addition to factory-installed Nokia-exclusive Windows Phone applications, the Windows Phone Marketplace contains a Nokia Collection section.[11] As of April 2012 it contains the following additional applications: Nokia Transport, a location-aware public transport schedule and navigation application; Creative Studio, a photo editing application; TuneIn Radio, a local and global radio streaming application; CNN, a news reader and video viewer for the Cable News Network; and WRC Live, an application to follow live timing and media from the FIA WRC series.[12]

[edit] Diagnostic ToolJust like the Lumia 900, the 800 has the diagnostic tool.

It can be obtained by pressing ##634# on the dial keypad, which should initiate the download after the last # is pressed. The diagnostic tool should appear on the app list under Diagnostics.

On this diagnostic tool a user can run tests on the following: Accelerometer, ALS, audio loopback, camera, battery status, DTMF, gyroscope, hardware buttons, headset detection, LCD white, lights, life timer, magnetometer, power source, proximity, speaker, touch and vibration. It's also possible to perform all the tests in one run.

Note: This app does not harm the phone, it's just a hidden app Nokia forgot to mention in the owner's guide. The app can be uninstalled if a user chooses to do so.[13][14]

[edit] ReleaseThe Lumia 800 device was presented along with Lumia 710 by Nokia's CEO Stephen Elop at the Nokia World conference in London October 2011. In the presentation referred to their devices as 'the first real Windows Phones'.[15]

The London launch was promoted with a massive sound and light show. Nokia and Canadian-based DJ deadmau5 illuminated the banks of the River Thames and the Millbank Tower with a state-of-the-art music and laser show. According to The Daily Telegraph, "The 118 metre building was turned into a canvas for a state-of-the-art light show during which the London skyscraper seemed to buckle and twist". [16][17]

[edit] ImpactAs of January 26, 2012, Nokia announced they had sold "well over 1 million Lumia devices to date", better than what was expected by analysts.[18]

European carriers have stated that Nokia Lumia phones are not good enough to compete with Apple iPhone or Samsung Galaxy phones, that "they are overpriced for what is not an innovative product" and that "No one comes into the store and asks for a Windows phone".[19]

Nokia Lumia 800 won the "Editor's Choice" award of 2011 from What Mobile magazine.[20] Their review rated it 5/5, commending that "[t]he Lumia 800 is a massive step forward for Nokia and sits apart in an increasingly crowded market. Alongside Windows Phone Mango, there’s enough inside the Lumia 800 to worry rivals and make iPhone fans jealous."[21]

Brian Klug of AnandTech in his review wrote: "The Lumia 800 is indubitably the best Windows Phone hardware out there right now," with notable features such as "[a] camera without compromises, hardware build quality that’s unique and solid, Nokia’s attention to detail..." With regard to the device's shortcomings, Klug mentioned "lack of USB or external storage, a still fledgling application ecosystem, and a few others."[22] Regarding the camera, Brian Klug added: "Lumia 800’s camera comes out looking very good against the rest of the 8MP competition, and for me this is the first F/2.2 8 MP shooter I’ve come across. With less compression and better ISP, it could be even better than most."[23]

In an Engadget review, Sharif Sakr wrote: "Nokia's Lumia 800 is a sophisticated and capable smartphone that melds its hardware beautifully with the Windows Phone OS." Sakr writes that while the phone lacked features like USB mass storage and expandable storage, the phone is welcome for those who want to be "part of a carefully crafted, simple and generally happy emerging ecosystem."[2]

PC World reported that Nokia Lumia 800 has solid guts and shiny looks, and was an "interesting proposal", though they also said it had "nothing extraordinary to offer" when compared to the highest-end models of Samsung Galaxy Nexus, Motorola Droid RAZR, or the more expensive iPhone 4s in hardware and software.[24]

Cnet UK noted that "overall, the Lumia 800 is a very good handset. The Windows Phone software is slick and fun to use, especially if you like to keep up-to-date with what friends are up to on social networking sites. It also looks attractive and the excellent build quality gives you the confidence that it's built to last."[25] CNET UK made a camera comparison with current (as of early 2012) high-end phones iPhone 4S and Samsung Galaxy S II, and wrote that Lumia 800 "didn't offer the quality of camera we were hoping for."[26] Regarding the camera, GSM Arena wrote, that "We were quite impressed by the job done by the 8 megapixel sensor and the bright F/2.2 lens. Images might not be the sharpest around and the noise levels are only average, but their colors and contrast are great, despite the sub-optimal lighting. Cameraphone lovers should definitely check this one out."[27]

Ketaki Bhojnagarwala in The Hindu review wrote, "The Lumia 800 isn't perfect, but its one of the best products that Nokia has released in the market in recent months. I have no complaints about the hardware - Nokia gets it right every time. Windows Mango is a refreshing and vibrant operating system that's already got a big fan list,..."[28]

In an opinion review by Matthew Baxter-Reynolds of The Guardian, after using Nokia Lumia 800 for a month and being a previous iPhone user, he argued that Lumia 800 is not up to an iPhone. In summary, he wrote: "I really wanted Windows Phone to work for me. This was £400 of my own money spent to try it. But it just doesn't work well enough to be the small-scale personal computer that I must have on me all the time."[29]

[edit] Reported problemsOn-screen keyboard is disappearing during typing. Nokia has addressed the problem with a software fix in the update 8107.[30]

Nokia Lumia 800 is claimed to have "sound quality problems" when using low impedance headphones like the supplied ones. Nokia has acknowledged the issue and is working on a fix.[31]

Battery life. In December 2011 Nokia confirmed that some Lumia 800 devices do not use the full capacity of their battery.[32] They also state that "only a charger with an output of 1000mA will fully charge your Lumia 800 battery." During 19-20th January 2012, two updates were made available—battery related software update and another of Windows Phone 7.5 Mango build 8107.[33] Nokia has stated that reported issues are fixed with the update and it triples the battery life.[34][35]

Problems with camera focus in certain conditions. Nokia has confirmed this and is working on a fix.[36]

Daily Mobile reports an issue with screen flickering.[37]

File Transfer via Bluetooth is not possible since it does not support Bluetooth BIP, OPP, or FTP profiles. Contacts transfer is possible, though, with the built-in 'Contacts Transfer' application.[38][39]

[edit] ConnectivityLike other Windows Phone devices, Lumia 800 uses Microsoft's Zune software on Windows PCs to synchronize user content. For Mac OS X, the device can be synchronized with Windows Phone 7 Connector software. WiFi sync is also available when the phone is charging and connected to the same network as the host PC. Lumia 800 includes the Windows Phone feature of 25GB free SkyDrive storage in Microsoft's cloud service.[27]

900

Saving and Printing your Excel worksheet

Saving workbook
Until now, everything that you’ve done has occurred in your computer’s memory. If the power should fail, all may be lost—unless Excel’s AutoRecover feature happened to kick in. It’s time to save your work to a file on your hard drive.
1. Click the Save button on the Standard toolbar. (This button looks like a floppy disk.) Excel responds with the Save As dialog box.
2. In the box labeled File Name, enter Monthly Sales Projection, and then click Save or press Enter.  


Printing worksheet

Printing your worksheet is very easy (assuming that you have a printer attached and that it works properly). Before printing, it’s a good idea to do a print preview.
1. First, make sure that the chart is not selected. Just press Esc or click any cell to deselect the chart.
2. Click the Preview button on the Standard toolbar. Excel opens a new window and displays a preview of the printed output.
3. Click Close to return to your worksheet. 4. If the preview was acceptable, click the Print button on the Standard toolbar. (This button has an image of a printer on it.) The worksheet is printed using the default settings.

Basic useful Excel formula

How to make Averaging between two numbers


Formula:

=AVERAGE(A1:J1)
____________________________
5
6
7
8
9
10
11
12
13
5
____________________________

Description:

See the above formula, if your date with in the range A1 to J1 then the average will show any place where you have placed the cursor.

The result will be populate 8.6

Count, how much value do you have with the range

=COUNT(A1:J1)

The result will be populate 10

Count, how many “5” do you have with the range

=COUNTIF(A1:J1, "5")

The result will be populate 2, because with the range only 2 value available with the formula condition

Count Text

Same way you can count a “text” with a certain data range. Just change the “5” to your desired word.

As an example; you have some data with the word “Apple”. You need to count how many “Apple” word available with in your data. Same way apply this formula-

=COUNTIF(A1:J1, "Apple")

Some more formula for your study-

=COUNTIF(A1:A10,">=5")

=COUNTIF(A1:A10,">10")

=COUNTIF(A1:A10,">=5")-COUNTIF(A1:A10,">10")
Reflect a particular word
Suppose you are doing profit and loss calculation and if the figure comes with profit then you might want to show the ward “Profit” before the figure. Or if the figure comes in loss the definitely the word is “Loss”.
How can we make it-
=IF(J5 >0, "Profit","Loss")
If we describe the formula; ‘J5’ means where the profit or loss value will populate. If the value less the 0, suppose ‘–1000’; that means loss by 1000 Dollar. The formula result will display “Loss”, other then “Profit”.
You can modify this formula and can with other condition.

Let’s practices this formula. I will add some more function time to time.

How to do Average in Excel

In our previous worksheet we have learn, how to do summation. Better we discus with example. Let’s think like this way- we went to by that 5 products and total cost comes182 dollar. We paid to the cashier 200 dollar. How much should we get back? Simple right? 18 dollar. That means total cost minus (-) total cash given to the cashier.
How we can do it in excel!


• Do the summation for all item value, suppose the value comes in C7
• Put paid amount in cell C8
• Write formula in C9 likes “=(C8-C7)" then press Enter
• Result will come 18
Repeat the same thing 2/3 times for more practices.
Suppose we have done lots of shopping, Saturday we have brought something, Sunday something and Monday also something. This is our weekly shopping and now we wants to know how much we spend in a week and how much in average,
1st we will find out the total weekly shopping amount-
• Put your cursor in a empty cell and write =SUM(C10,H10,M10) then press Enter. You will see the amount 220
Now we can find out easily, how much we spend in average-
• Simply remove the word “SUM” and put “AVERAGE”. You will see the value 73.3333
Check the tutorial from attached file

In the tutorial you might have seen 2 comments. Wanna learn how to do that? Just right click on the value; then select "Insert Comment. You can show or hide the comment any time followed by the same way. See the below image to make more understanding.