Skip to main content

Posts

Showing posts from 2015

Excel shortcuts!

I will let you guys know some tips to save time while using excel spreadsheet.

1)Use ALT and = to give sum of the rows.
You need to keep the cursor in the highlighted cell as shown below.

Press ALT and =. The system shows up the formula '=Sum(B2:B3)'. That is the formula for calculating the sum so press 'Enter' to get the answer.


2)Use CTRL and Spacebar to get any particular column selected. You need to keep the cursor in the highlighted cell as shown below.
Press CTRL and Spacebar to get the entire column selected.
3)Use Shift and Spacebar to get any particular row selected. You need to keep the cursor in the highlighted cell as shown below.
Now press CTRL and Spacebar to get the entire row selected.

4)Use CTRL and ;(semicolon) to insert Date in the cell. You need to keep the cursor in the highlighted cell as shown below. Press CTRL and ; and then you will see the date inserted in the cell.
5)Use CTRL, Shift and ; to insert time in the cell. You need to keep the…

How to Move Posts Into Pages On Blogspot

Issue: Moving posts into pages on blogspot


Solution:Blogger doesn't have the option of changing a post to a page. Nevertheless you could do it on your own!
Step 1)Go to Blogger.com. Sign into your account.
Step 2)Click on 'Edit Posts'.
Step 3)Go to the post that you would want to be seen in any page.
Step 4)Click 'Edit Html'.

Step 5)Press 'Ctrl+A' to select the content and then 'Ctrl+C' to copy the same to a notepad.
Step 6)Click on 'Close'. A pop-up would warn you of leaving without any changes being saved. Click 'Ok' .
Step 7)Now click on 'New Page'.
Step 8)Click 'HTML' and paste the content copied to notepad.
Step 9)Enter a title for the page.
Step 10)Click 'Publish'.
Step 11)Now Click 'delete' to delete the original post or to have a copy of the post , click 'Edit' and then 'Revert to Draft' to make sure that the post doesn't appear in the main page..

That's it!


Placing ads in the post

Issue:
How to place ads in the post?


Solution:
1)Click HTML section of the post.
2)Enter this code:
<div style="width:50%;margin: 0px auto">
<add your adsense code here--->
</div>


3)Now, add your ad code in the highlighted space.
4)Now click 'Preview' and check if the ad is appearing in the post. 6)Click 'Save Template'.  This code must be added wherever you require the ad to appear in the post.

Blogger Problem: Undefined Date Issue

Issue:
Date not getting displayed in the webpage.

Solution: 1)Go to Blogger->Blogger Design.

 2)Click on Settings.
3)The following options appear.

4)Click on Timestamp format.


5)Select format: Tuesday, October 06, 2016.


5)Click 'Save'. 6)Go to Template. 7)The below code must be in the template for the time to be displayed in the website.
<script type='text/javascript'> var timestamp = &quot;<data:post.timestamp/>&quot;; if (timestamp != &#39;&#39;) {   var timesplit = timestamp.split(&quot;,&quot;);   var date_yyyy = timesplit[2];   var timesplit = timesplit[1].split(&quot; &quot;);   var date_dd = timesplit[2];   var date_mmm = timesplit[1].substring(0, 3); } </script>
8)Click 'Save Template'. 9)Click 'View Blog' to view the page. 10)Date will get displayed!

Great Amazon Deals!

Seagate Backup Plus Slim for 7,680 Rs4,250 Rs  !! You save a whopping 3,430 Rs!
Details:BrandSeagateModelSTDR1000300Model NameBackup Plus PortableItem Weight159 gProduct Dimensions11.4 x 7.6 x 1.2 cmItem model numberSTDR1000300Memory Storage Capacity1 TBHard Drive Size1 TBHardware PlatformPC, MacIncluded ComponentsSeagate Backup Plus drive, Seagate Dashboard pre-loaded on drive, NTFS driver for Mac pre-loaded on drive, 18-inch USB 3.0 cable, Quick start guideNetwork Interface DescriptionUSB

Click below link to buy!
Seagate Backup Plus Slim 1TB Portable External Hard Drive with 200GB of Cloud Storage & Mobile Device Backup (Black)



HP 15-r245TX 15.6-inch Laptop (Core i3-5th Gen/4GB/500GB/2GB Graphics/DOS), Black for 36,819 Rs 28,399 Rs.
You save 8,420 Rs!

Saucy Chicken Recipe!

Time: 15 to 20 minutes
Servings: 4

Things needed:

Boneless Chicken
Sauce
Flour

Step 1: Toss the chicken pieces with flour until its slightly dusted.
Step 2: Pour around 2 tablespoons of oil into a pan. Heat in high flame.
Step 3: Once oil becomes hot(you will see smoke), add all the chicken pieces into the pan. Let one layer of the chicken fry nicely for 5 minutes or until it turns brown. Meanwhile you should sprinkle salt and pepper.

Step 4: Later toss the chicken to the other side and fry until it gets a brownish color.
Step 5: Turn off the stove, let the pan cool for a moment. Next, add oil and in medium flame add pepper and garlic. After 2 minutes, add ketchup.
Step 6: You will see small bubbles after sometime. Slowly color of the ketchup becomes dark. Now put back the chicken into this pan to coat the pieces with this sauce.

That's it! Done!

Enjoy your dish!

How To Make Butter Chicken?

Time: 30 minutes to prepare chicken gravy and overnight to marinate chicken pieces
Servings: Upto 8

Things needed:
Chicken
White butter
lemon juice
Chilly powder
Onions
Tomatoes
Turmeric powder
Curd
Garam masala
Ginger garlic paste
Black cumin seeds
Tomato puree(Steps to prepare tomato puree)
Fresh cream
Salt
Green chillies
Fenugreek leaves
Sugar
Oil

Step 1: Marinating the chicken:
Mix red chilly powder, ginger garlic paste, salt, lemon juice, a cup of curd or yoghurt , cumin, chicken pieces and keep in refrigerator overnight.

Step 2: Roast chicken
We have noticed that the butter chicken served in hotel with be little roasted so we need to do the same. Roast the chicken in oven for sometime, maybe around 10 minutes.

Step 3: Preparing the chicken gravy
Next is to prepare gravy. We are preparing butter chicken so butter needs to be definitely used here. Lol. Heat the butter (white butter) in a pan with oil. Add onions, tomatoes, cumin seeds(zeera), tomato puree, salt, red chilly powder and little sugar. Mix prop…

How to Prepare Lemon Rice

Time: 15 minutes
Servings: For 4

Things needed:


Mustard seeds(half teaspoon)

Groundnut seeds(handfull)
Turmeric powder(half teaspoon)
Onion (just 1)
Green Chillies(4)
Curry leaves(2 strands, I mean you should have around 10 to 12 leaves)
Coriander
Rice
Lemon(1)

Pre-requisites:

Its always best to have ingredients ready before we actually start cooking. Wash the onion, green chillies, curry leaves , coriander and lemon.
1)Slice onion into long thin strands.
2)Cut the green chillies. Make sure not to slice these into very small pieces because you may end up eating them. Chillies are meant to give a spicy taste to the dish not to your tongue.
3)Coriander also need to be sliced.1 strand is more than enough. 1 strand will have many small strands in it.
4)You need to keep rice ready.



Steps:

1)Pour a tsp of cooking oil to the vessel , turn on the stove. There is one thing that is very common in most of our Indian recipes, use of oil and mustard seeds.
2)After few seconds put half tsp of mustard seeds. You…

Your Man Not Wearing His WEDDING RING. Does it matter??

 It was a cloudy day. Susan was standing near a bus stop when a friend of her, Lizy, just passes by. Lizy notices that Susan was not wearing the usual smile on her face so stops by.
Lizy- Hi Susan. Congratulations on getting engaged. Now waiting for the big day right? The ring reminds you that you are now engaged and you have a person excited to marry you. I am sure his ring also reminds him of the same.
Susan(smiles)- Thanks Lizy. Yes I am waiting for the big day but I am not sure if he is also eagerly waiting like me.
Lizy- Why? What makes u think like that?
Susan- He isn't wearing my ring on his ring finger. 
Lizy- So? 
Susan- That is the symbol that he is engaged to me right? He is not wearing it. Don't know why.
Lizy- Hahaha. You really think that the ring is the symbol for your engagement? 

Susan- Yes , when I can wear it then why the heck can't he also wear it?

Lizy- Chill. You are pondering over something that has no meaning. Don't waste your time.

Lizy sees that …

Lenovo A7000 Full Specification

Hi All,

Today I am going to let you know about a phone that has made me write a review about it. Its none other than the latest Lenovo A7000.




Its Cool features:


OS: Android v5 (Lollipop)
Processor:True Octa Core Processor MediaTek MT6752m
Processor Speed: 1.5 Ghz
RAM: 2GB 
Primary camera: 8MP
Secondary camera: 5MP
Display Size: 5.5-inch Capacitive Touchscreen
Sim Type: Dual Sim(GSM+LTE)
Ext SD: Expandable upto 32 GB(micro SD) 


It has Lollipop 5.0 OS. Its the world's first smartphone with Dolby Atmos. What does this mean? It means you will love the music that you play on it! Big screen so you would enjoy your movies more better than ever before. 5.5 inch is 13.97 cms! Octa Core Processor means eight core processors would be running to enhance your game performance. These processors consume less power to boost battery life! 2GB RAM would make sure that your phone would perform without any lags. You can connect to 4G LTE to get better net experience while gaming online. You can d…

Marriage or Career?

Hi everyone,
If a girl had to choose between marriage and better job offer which one would she choose?
OR
If it was the case of arranged marriage then there are high chances of choosing the latter because she would be more interested in working than getting married. What if it is a love marriage?
In love marriage, the girl will take less time to decide between the two. Obviously she would choose 'Marriage'! There are two main reasons for this. First, the effort she had put to make sure her love was accepted by the her family because not always a girl's love becomes successful just like that within few hours. Second, the girl would have waited for long for her beloved to make the first move to such a big step in life! The efforts and time spent for that special moment in life will seem pointless when the girl chooses the job offer over marriage.
Now, it may seem that the girl has taken a good decision to choose marriage over job offer but how can we be so sure? Lets say sh…

Review of Banjaras Gold Facial Kit

Hola everyone!

Today I tried Banjara's Gold Facial Kit and it is such a wonderful kit that absolutely was so mild on my skin.





It has four items inside it. Gold Cleansing MilkGold Scrub GelGold Massage CreamGold Face Pack



First I started with the cleansing milk. Banjara's Gold Cleansing Milk deep cleanses the skin without stripping it of its natural oils. It effectively removes make-up and dirt to leave skin clean and fresh.



Key Ingredients: Each gm contains Swarna Varka 0.2%, Turmeric Extract (Curcuma Longa) 0.5%, Lotion Base.
Directions for use: Apply a small amount of Banjara's Gold Cleansing Milk on the skin and gently massage in a circular motion for 3-4 minutes. Wipe off with cotton. 
Next I used Gold Scrub Gel. Banjara's Gold Scrub Gel contains natural exfoliating beads that deep cleanse and unclog pores, thereby eliminating skin impurities. Sandalwood extract and Gold Dust gently purify and brighten the skin.
Key Ingredients: Each gm contains Swarna Varka 0.2%, San…