General Interest includes but not limited to CBD (Cannabidiol),Computers, photography, Travel, Miss Universe, Current events, International, the outdoors, Politics, World Events, LPGA, culture and tasteful women's photos. International Models. Social Injustice. Creative people. Great music bands. Bitcoin.
Alba Delgado was crowned Miss El Salvador Universe 2013 orNuestra Belleza El Salvador Universo 2013 (in local language) at the Royal Decameron Salinitas Hotel in Los Cobanos on April 26, 2013. She will represent El Salvador in the upcoming Miss Universe 2013 beauty pageant.
I wanted to ask you: Do you think she is pretty or not?
Alba Delgado (right) was crowned Miss El Salvador Universe 2013 and Paola Ayala (Left) was crowned Miss El Salvador World 2013 or Nuestra Belleza El Salvador Mundo 2013
At the same event, Paola Ayala was crowned Miss El Salvador World 2013 or Nuestra Belleza El Salvador Mundo 2013. She will represent El Salvador in the upcoming Miss World 2013 in Jakarta, Indonesia on September 28. The first runner-up was Fátima Ferrufino. The second runner-up was Brenda Platero. The third runner-up was Karina Velásquez.
She will compete in the upcoming Miss Universe 2013.
Miss El Salvador Universe 2013, Alba Delgado.
Miss El Salvador Universe 2013 Alba Delgado posed in swimsuit.
Hindu girl Navneet Kaur Dhillon is Miss World India 2013
Navneet Kaur Dhillon was crowned Pond’s Femina Miss India 2013 or Miss World India 2013
Navneet Kaur Dhillon was crowned Pond’s Femina Miss India 2013or Miss World India 2013 during the 50th edition of the pageant held at the Yash Raj Studios in Mumbai on March 24, 2013. The beauty from Patiala is 20 years old and stands 1.73 m. She will represent India in the upcoming Miss World 2013 in Jakarta, Indonesia on September 28. The first runner-up was Sobhita Dhulipala and the second runner-up wasZoya Afroz. Afroz will represent the country in Miss International 2013later this year.
The beauty from Patiala is 20 years old and stands 1.73 m.
Navneet Kaur Dhillon was crowned Pond’s Femina Miss India Chandigarh 2013 during the fifth regional round of PFMI 2013 in Chandigarh at JW Marriott on the night of December 17, 2012 and got direct entry into the finals of Pond’s Femina Miss India 2013.
She will represent India in the upcoming Miss World 2013 in Jakarta, Indonesia
Navneet Kaur Dhillon profile:
Name : Navneet Kaur Dhillon
Age : 20 years
City : Patiala
Profession : Media Student
Interests : Photography, Swimming, Horse-riding
Crowned : Pond’s Femina Miss Glowing Skin /photo.cms?msid=17652838
A quote or saying that has had a profound impact on you Use your ATTITUDE to reach the ALTITUDE.
What gives you a high? Love and support from my loved ones and of course appreciation from them for whatever I do.
One law you would like to break… Laws are not meant to be broken.
If you win Miss India, what would be your first big splurge?
That would be my dream come true because like every ‘ordinary’ girl dreams of being ‘Extra-ordinary’ someday. Hence after winning, I will invest in setting up my production house.
Best pick up line you ever heard? You know who is the most beautiful?? Read the first word again.
Rate in order of priority the three qualities every woman must possess Femininity Grace Love
One achievement that will make you feel your life was a huge success! When my acted/ directed films will be appreciated by the world.
The last movie that made you cry? Talaash
Rate in order of personal preference the three qualities you admire in a man Positive outlook Reliable Strength of character
What is the craziest rumour you have heard about yourself? I look like Dayana Mendoza.
With which celebrity would you like to go on vacation? Adam Sandler
If you were to give one bit of advice to the youth today, what would that be? Do not crib, help the nation grow by giving your bit.
Your body to you means… Most valued gift of God.
Favourite Actor Naseeruddin Shah
Favourite Movies Avatar, 3 idiots and True grit.
Love is …. Source of inspiration.
Photos Gallery of Navneet Kaur Dhillon Miss World India 2013
Chalita Yaemwannang is the newly crowned Miss Universe Thailand 2013
Chalita Yaemwannang is the newly crowned Miss Universe Thailand 2013. Twenty-five years old holds a Masters Degree Tourism Management and Marketing Bournemouth University, United Kingdom stand 175 cm. won the title Saturday 11 May 2013 at Royal Paragon Hall, Siam Paragon, replacing outgoing champion Nutpimon Farida Waller Miss Universe Thailand 2012.
Chalita Yaemwannang is the newly crowned Miss Universe Thailand 2013
Chalita will receive a cash prize 1,000,000฿ (one million baht), Sprinkling Rains Crown and jewelry set from Beauty Gems, the new Toyota Prius cars and other prizes a total of over 4,000,000฿ (four million baht) and she will representing THAILAND in the Miss Universe pageant this year.
The first runner-up was the contestant number 27 Chonticha Tiangtham. Chonticha is 18 years old and stands 5″7′. She received the title of Miss International Thailand 2013 will represent Thailand in the Miss International 2013 pageant. The second runner-up was the contestant number 37 Sakaowan Singhapreecha. Sakaowan is 19 years old and stands 5’9″. She received the title of Miss Tourism Thailand 2013 and will compete in theMiss Tourism Queen International 2013 pageant. The third runner-up was the contestant number 38 Wanvisa Prapasirivichaikul (19, 5’7″). The fourth runner-up was the contestant number 30 Sunitporn Srisuwan (23, 5’8″).
Chalita Yaemwannang is the newly crowned Miss Universe Thailand 2013
Don’t waste any more hours in Microsoft Excel doing things manually. There are many ways to use Excel formulas to decrease the amount of time you spend in Excel and increase the accuracy of your data and your reports.
Excel Formulas You Should Definitely Know:
1. SUM
Formula: =SUM(5, 5) or =SUM(A1, B1) or =SUM(A1:B5)
The SUM formula does exactly what you would expect. It allows you to add 2 or more numbers together. You can use cell references as well in this formula.
The above shows you different examples. You can have numbers in there separated by commas and it will add them together for you, you can have cell references and as long as there are numbers in those cells it will add them together for you, or you can have a range of cells with a colon in between the 2 cells, and it will add the numbers in all the cells in the range.
2. COUNT
Formula: =COUNT(A1:A10)
The count formula counts the number of cells in a range that have numbers in them.
Counts the number of non-empty cells in a range. It will count cells that have numbers and/or any other characters in them.
The COUNTA Formula works with all data types.
It counts the number of non-empty cells no matter the data type.
4. LEN
Formula: =LEN(A1)
The LEN formula counts the number of characters in a cell. Be careful though! This includes spaces.
Notice the difference in the formula results: 10 characters without spaces in between the words, 12 with spaces between the words.
5. TRIM
Formula: =TRIM(A1)
Gets rid of any space in a cell, except for single spaces between words. I’ve found this formula to be extremely useful because I’ve often run into situations where you pull data from a database and for some reason extra spaces are put in behind or in front of legitimate data. This can wreak havoc if you are trying to compare using IF statements or VLOOKUP’s.
I added in an extra space behind “I Love Excel”. The TRIM formula removes that extra space. Check out the character count difference with and without the TRIM formula.
6. RIGHT, LEFT, MID
Formulas: = RIGHT(text, number of characters), =LEFT(text, number of characters), =MID(text, start number, number of characters).
(Note: In all of these formulas, wherever it says “text” you can use a cell reference as well)
These formulas return the specified number of characters from a text string. RIGHT gives you the number of characters from the right of the text string, LEFT gives you the number of characters from the left, and MID gives you the specified number of characters from the middle of the word. You tell the MID formula where to start with the start_number and then it grabs the specified number of characters to the right of the start_number.
I used the LEFT formula to get the first word. I had it look in cell A1 and grab only the 1st character from the left. This gave us the word “I” from “I love Excel”
I used the MID formula to get the middle word. I had it look in cell A1, start at character 3, and grab 5 characters after that. This gives us just the word “love” from “I love Excel”
I used the RIGHT formula to get the last word. I had it look at cell A1 and grab the first 6 characters from the right. This gives us “Excel” from “I love Excel”
By far my most used formula. The official description of what it does: “Looks for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify…”. (See the full explanation of VLOOKUP) Basically, you define a value (the lookup_value) for the formula to look for. It looks for this value in the leftmost column of a table (the table_array).
Note: If at all possible use a number for the lookup_value. This makes it a lot easier to make sure the data you are getting back is a correct match.
If it finds a match of the “lookup_value” in the left column of the “table_array” it will return the value in the column you specify using the “index_num”. The “index_num” is relative to the left most column. So, if you have the table_index look in column A and you want what is returned to be what’s in column B the “index_num” would be 2 because the leftmost column, column A in this case, is the 1st column in the table array and column B is the 2nd column (hence the 2 for the index number). If you want what is in column C to be returned you’d put 3 for the index_num. The “range_lookup” is a TRUE or FALSE value. If you put TRUE it will give you the closest match. If you put FALSE it will only give you an exact match. I only use FALSE when using the VLOOKUP formula.
Example:
You have 2 lists: 1 with a sales person’s ID and the sales revenue for the quarter. Another with the sales person’s ID and the sales person’s name. You want to match up the sales person’s name to the sales person’s revenue numbers for the quarter. They are all jumbled around so to manually match this, even for a small number of salesmen would leave room for a high margin of error and take a lot of time.
The first list goes from A1 to B13. The 2nd list goes from D1 to E25.
In cell C1 I would put the formula =VLOOKUP(B18, $A$1:$B$13, 2, FALSE)
B18 = the lookup_value (the sales person’s ID. This is a number that appears on both lists.)
$A$1:$B$13 = the “table_array”. This is the area I want the formula to search the leftmost column (column E in this case) for the “lookup_value”. I went to F because if it finds match in column E, I want it to return what’s in column F. (The money signs are there so that the table_array will stay the same no matter where the formula is moved or copied to. This is called an absolute reference.)
2 = the index_num. This tells the formula the number of columns away from the left most column to return in case of match. So, if you find a match between the lookup_value and the leftmost column of the table array, return what’s in the same row in the 2nd column of the table (the 1st column is always the leftmost column. It starts at 1, not 0).
FALSE= tells the formula I want it to only return the value if it’s an exact match.
I would then copy and paste that formula along all the cells in column C next to the first list. This would give me a perfectly aligned list with the sales person’s ID, sales person’s revenue for the quarter, and the sales person’s name.
In order to get a nice neat list of Sales Person ID, Sales Person Name, and Sales Person Revenue all next to each other I used the VLOOKUP formula to compare 1 listto another.
Formula: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
When you’re doing an analysis of a lot of data in Excel there are a lot of scenarios you could be trying to discover and the data has to react differently based on a different situation.
Continuing with the sales example: Let’s say a salesperson has a quota to meet. You used VLOOKUP to put the revenue next to the name. Now you can use an IF statement that says: “IF the salesperson met their quota, say “Met quota”, if not say “Did not meet quota” (Tip: saying it in a statement like this can make it a lot easier to create the formula, especially when you get to more complicated things like Nested IF Statements in Excel).
It would look like this:
In the example with the VLOOKUP we had the revenue in column B and the person’s name in column C (brought in with the VLOOKUP). We could put their quota in column D and then we’d put the following formula in cell E1:
=IF(C3>D3, “Met Quota”, “Did Not Meet Quota”)
This IF statement will tell us if the first salesperson met their quota or not. We would then copy and paste this formula along all the entries in the list. It would change for each sales person.
Having the result right there from the IF statement is a lot easier than manually figuring this out.
These formulas all do their respective functions (SUM, COUNT, AVERAGE) IF the criteria are met. There are also the formulas: SUMIFS, COUNTIFS, AVERAGEIFS where they will do their respective functions based on multiple criteria you give the formula.
I use these formulas in our example to see the average revenue (AVERAGEIF) if a person met their quota, Total revenue (SUMIF) for the just the sales people who met their quota, and the count of sales people who met their quota (COUNTIF)
10. CONCATENATE
A fancy word for combining data in 2 (or more) different cells into one cell. This can be done with the Concatenate excel formula or it can be done by simply putting the &symbol in between the two cells. If I have “Steve” in cell A1 and “Quatrani” in cell B1 I could put this formula: =A1&” “&B1 and it would give me “Steve Quatrani”. (The “ “ puts a space in between what you are combining with the &). I can use =concatenate(A1, “ “, B1) and it will give me the same thing: “Steve Quatrani”
Finding The Right Excel Formulas For The Job
There are 316 built in functions in Excel. You’re not going to sit there and memorize what all of them do (or at least I hope not!). Luckily Excel has a built in wizard that helps you find the correct formula for what you’re looking to do (if there is one).
Click the “fx” next to the formula bar in Excel
This brings up a menu and in there you can type in a description of what you are trying to do and it will bring up the correct excel formula:
I typed in “remove extra spaces” and it returned the TRIM formula that we went over earlier.
More Excel Formulas
There is so much more that I use on a regular basis such as Time formulas (NOW, TODAY, MONTH, YEAR, DAY, etc.), other formulas like AND and OR, along with many others.
The real power comes in combining these functions into complicated excel formulas.
Do you see formulas like the one above and run away screaming AHHHHHHHHHHHHHHHHHHHHHHHHH!!!
Well I don’t blame ya!
This can be a really intimidating formula even for the most seasoned Excel user.
I have a solution for you that makes it easy to both break down, and build up complicated combinations of Excel formulas but first check out this short video by fellow Udemy trainer, Mynda Treacy, that will reveal tips on how to get inside the mind of an Excel formula:
So What’s Going on With This Excel Formula?
Let’s break down all the Excel functions in it:
IFERROR
TRIM
IF
LEN
VLOOKUP
SUBSTITUTE
I’m not going to go in depth into each formula, but you’ll get the point.
Let’s start with the innermost formula. This is the end result that you are trying to accomplish.
We want to take a phrase (that we get with a VLOOKUP) that has a space in it and SUBSTITUTE that space with nothing. So it will take a phrase like “Excel Formula” and make it “ExcelFormula”.
We use the VLOOKUP formula to get the actual phrase we want from a different sheet in the Excel Workbook if it matches what’s in cell F7.
VLOOKUP(F7, Sheet2!$A$1:$B$10000, 2, FALSE)
We use an IF statement to say IF the number of characters (LEN) of what’s returned from the VLOOKUP is above 0, then run the VLOOKUP, otherwise, put nothing here. This way if the VLOOKUP returns nothing, then nothing will happen and this will prevent most errors.
We then wrap it with the TRIM function which gets rid of all extra spaces, besides 1 space in between words. Sometimes when you’re getting data from a database extraspaces can be added after a word. This can make it really hard to compare data from different sources, so the TRIM function comes in handy a lot!
Finally we wrap it in the IFERROR formula. This formula will be triggered if the other formulas wind up giving you an error. It could look something like #N/A and that’s pretty ugly. This can happen for legitimate reasons, but you don’t want to hand your boss a sheet full of #N/A symbols.
What happens is IF the combined formulas return any excel error, it will make the cell blank, otherwise it will show the results of the formula.
There you have it, this long complicated formula broken down into simple step by step functions.
You can use the same method for building up a long formula
Our goal is to SUBSTITUTE the spaces for nothing so we start with that. We then have to pull it in from another sheet so we use VLOOKUP for that, etc., etc.
You always start with the innermost formula, the end result that you are looking for. Then you use other formulas to help you deal with the different situations you’ll have to deal with working with large datasets.
Resources to Become an Excel Expert:
This article is the tip of the iceberg. Check out these other resources for more tips.
Resources For Showing Data:
Excel Formulas will help you deal with data, how you present that data is a whole other animal. Check out this awesome Excel Dashboard course if you’re interested in using Excel for reporting.
Resources For Excel Help:
Mr. Excel
No matter how good you get at Excel there is too much for one person to be great at everything Excel can do. The Mr. Excel forums are the place to go for any questions. They have a very active community around that site and you can probably get your excel questions answered very quickly.
OzGrid
There are a ton of examples for how to do just about anything in Excel or VBA onOzgrid.
Learning Excel Macros and VBA
Formulas are awesome by themselves. Using VBA to create Excel Macros in combination with Excel Formulas is how you become a true Excel expert.
It was my 3rd year in college and I went to intern for an options trading firm. There were some brilliant people at this place and even the janitors knew Excel better than I did. The intern in there before me was a software engineer who had basically written a ton of macros that automated almost every daily task I had to do. Great! I thought, I’d have the easiest time doing the daily boring tasks and I could spend time learning how to be a trader.
Well, the week after he left, EVERYTHING BROKE. None of the macros were working and they all depended on each other. “I was never trained on this” I thought, because the software engineer had only told me what buttons to push and when, never how to do it manually. I started giving out wrong information, needing to ask busy people to take time to help me, and was just generally helpless. I did the best I could, but I didn’t even know most excel formulas, much less how to read and write VBA code and create Excel Macros.
Necessity, the Mother of Invention
Then one day I was taken aside and my manager said, “I know the kid before you did all this stuff, and you weren’t brought here to write code, but if you can’t fix it and start giving us the correct information on time, we’re going to have to go in a different direction.” WHAT?! I thought. I hadn’t been prepared or trained for this, and code that another person wrote is not working, and I’m going to get fired for it? I knew he meant it. I had seen interns get fired from here, it wasn’t pretty. It was an open trading floor, you didn’t get pulled aside into someone’s office, you were unceremoniously escorted off the floor and everyone knew what happened.
So, I had a goal to meet, and I had to meet it quickly. I set off to learn VBA, Excel Formulas, and how to get all these Excel macros working. After about 2 weeks of waking up at 5:30am, struggling through the day with the help of others, then teaching myself Excel until about 2am, I had learned enough to read the code that was written. After about a month I became proficient at it. After about 6 months I knew enough to write any Excel formula I wanted, read & write VBA code, and solve any Excel problem I had without doing manual work in Excel.
Learning it was a pain in the butt! There was no single resource to learn what I needed to learn. I had to go all over the web to find things or ask questions on Mr. Excel. That’s why I created a course on learning Excel. I put all my knowledge gained over the last 5 years, all my tips & tricks into this Excel VBA tutorial.
About the Author:
Steve Quatrani is an excel expert with years of experience using and teaching Excel. He has created advanced systems using VBA code, advanced dashboards using Excel and other business intelligence software, and he continues to build new ways of viewing and analyzing data in Excel and automating those processes. He teaches Microsoft Excel VBA Video Tutorial on Udemy.
I launched www.bigbadchinesemama.com, a mock mail order bride website that targeted Asiaphiles with images like the above. Now, 13 years later, I find myself dating the descendants of the same men I once loathed.
If my vagina had a guest book, it would look like the roster of the United Nations (if the United Nations consisted of a small group of broke-ass ambassadors of different ethnic backgrounds). Lately, though, with white guys I’ve dated, I’m consistently finding out that I’m one in a long line of Asian women they’ve dated. It’s awkward.
White guys with Asian fetishes used to be easy to spot -- pathetic social pariahs planning their sex tour vacations to Thailand, creeping around Japanese language classes. Now, Asiaphiles are attractive tattooed hipsters that possess fantastic social skills, and we meet them through friends of friends.
When I ask these guys: “What’s up with your long history of dating so many Asian women?” It’s like I’ve triggered the shaming meltdown of a lifetime -- dudes get nervous, defensive, and very rarely, are willing to engage in an inevitably uncomfortable conversation about race.
9 Wack Things I’ve ACTUALLY been told by Asian Fetish Guys in Denial
1. “I can’t be accused of having an Asian fetish because my Russian Great-Grandfather looked Asian.”
I think Latoya Jackson looks Thai on the “We Are the World” album cover, shall I ask for her pad thai recipe? First lesson in Race 101: There’s a difference between having a distant relative “look” like a member of an ethnic group and having lived the experience enough to claim it.
2. “If I really had an Asian Fetish, I’d be buying sex slaves off the Internet.”
According to Wikipedia: “An Asian fetish is usually understood to be an interest, attraction, or preference for Asian culture, things or people.” Just like “racists” are not just people who scream the N-word and wear KKK robes, not all guys with Asian fetishists do drastically evil things. Your fetish may be an admiration of Asian people and culture, not an all out need for colonial conquest. STOP DEFLECTING.
3. “How is being into Asian women any different than a woman being only into guys who wear glasses or have a certain color hair?”
Because moron -- my history, my culture and my racial identity is not the same as a pair of glasses or a hair color. Race is not something we choose to be born with or can add or remove to create sexual attraction. I am not “amping up” my race so you find me more sexually attractive.
4. “I lived in China/Japan/Thailand/Mongolia/Studied Buddhism for a year. I know more about your culture than you!”
Just like I don’t assume to know what it’s like for you to be a presumptuous white man, you don’t know “my culture” until you’ve spent 18 years raised by my Chinese mother and another lifetime fighting off the guilt that I’ll have from publishing the opening sentence of this essay. And who are you to define what my culture is? “Culture” is an ever-evolving diasporic phenomenon; it’s not just about language and ancient customs.
5. “I don’t see race.”
Then how is it that your dating habits have me feeling like I’m on an assembly line of Asian blow-up dolls?!
6. “I don’t date only Asian women. I once dated a Puerto Rican girl in college.”
If your bar tab has one daiquiri and 17 Singapore Slings, I'm thinking rum isn't your drink.
7. If you only date white men, does that mean you have a white fetish?
No, it means I live on the East coast or Midwest or the South or a work in an environment teeming with white men. Or it means you creeps keep making a beeline toward me.
And can people stop making analogies of race where white people and people of color are interchangeable?! White people and People of Color have different histories of power, so it is problematic to interchange them in an analogy as if they are equal.
8. “I don’t know why you keep insinuating I have 'white privilege.’ I grew up working class and was bullied as a kid for my big nose. I never had white privilege.”
EVERYONE has felt left out. EVERYONE got picked on. Do women clutch their purses tighter to themselves when you pass them on the street? Do people constantly assume you can’t speak English? Are you part of a race that systematically receives the worst health care, education, and environmental policy? Would you ever want to play the DNA lottery and come back to this life as a black man? This is the white privilege I speak of.
9. “When I approach a group of women, I tend to be better at picking up the Asian ones. So that’s why I tend to go for them.”
Thanks for using an obvious metaphor that dating is an act of colonial conquest where Asian women are the injured gazelles and you the stupid insecure hunter with one bullet. Keep digging yourself that hole you are standing in.
Guys! Here’s the better response to give me next time I ask you why you only date Asian women: “I acknowledge that I’ve been gravitating towards dating Asian women, and it probably has to do with a subconscious racial preference. I want to explore my racial biases, my racism, and my privilege as a white male. I vow to actively unlearn my racism and white privilege, build cultural competency and sensitivity, so that the women I’m dating feel less creeped out.”
I know. It’s a long, wordy, unrealistic statement to follow through on that you will have to read to me off a notecard. But openly talking about race is sexy to me. Admitting your privilege and wanting unlearn racism is sexy to me. If you say it and mean it, you’ll improve your chances of signing my vagina’s guestbook.