Battery charger without cable
How to share big size file with a link via email
How we can do it:
Market Place for Nokia Lumia Windows Phone
How to remove gridlines in Excel 2007
Step 1: Open your Excel worksheet
Step 2: Click on "View" tab
Step 3: Untick Gridlines
It’s done...
Google TV - Coming soon
Nokia Lumia Windows Mobile phone
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
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")
=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
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.
How to add web page hit counter at blogger.com
Sign up for a free account at StatCounter and follow the 'Install Code' wizard to generate your StatCounter code.
When prompted, make sure to choose Blogger / Blogspot as your Blog/Web Page Editor from the drop down list.
Copy the StatCounter code.
Log into your Blogger / Blogspot blog.
Go to the layout area.
Click one of the “Add a Gadget” links at the bottom or to the right of your blog layout area (as indicated in the picture). (Note from the screenshot that we are in the “Page Elements” tab of the “Layout” area.)
Clicking “Add a Gadget” opens a new window similar to the one pictured below.
Scroll down through the list of Basic gadgets to find the HTML/Javascript gadget as shown in the picture below. Click the text (that says HTML/JavaScript) to add the gadget to your blog.
Paste the StatCounter code into the content section of the gadget.
Click "Save" and that's it!
About this blog
Welcome to http://onlybabu.blogspot.com technology related blog site. This website is all about latest technology; such as Computer, Mobile device, Electronics, Blogging, Website design and many more. You can get a huge number of tips and tricks from this website; that could be helpful for your daily life as in our life every moment we are using technology.
Feel free to visit us as your presence is our inspiration to continue this website.
Blog Archive
Popular topics
-
When your MS Excel 2007 program is open; Simply press Ctrl + F3
-
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 tho...
-
Nokia Lumia 800 (codenamed 'Sea Ray') is a Windows Phone-OS powered smartphone, first unveiled on 26 October 2011 at the Nokia Wor...
-
Technology experts are thinking to say bye of cable charger. Recently Samsung has started to find out the way to charge battery without ...
-
Google TV is coming to the market by this month. Second largest Television producer company LG is bringing this internet Google TV in...
-
MarketPlace is the website where you can find information regarding your Nokia Lumia device. · You can buy a new device · ...
-
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 ...
-
Gridlines in Excel appears by default every time you open the program. Some time we need to remove gridlines depending on formatting. Pleas...
-
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—u...
-
1. Find a font. First, find a TrueType font you want to use. I can recommend Larabie Fonts, where there are over 300 free fonts to download...
Labels
Which topic you like to see in our website?
Copyright 2009 -
Rising up with new TECHNOLOGY every day
Blogspot Theme Design by: Ray Creations, HostingITrust.com
Distributed by Deluxe Templates


