Search found 314 matches
- Thu Oct 12, 2017 12:24 am
- Forum: Technology & How-To Forum
- Topic: Excel VLOOKUP Function for Your Business
- Replies: 1
- Views: 11610
Excel VLOOKUP Function for Your Business
VLOOKUP or 'vertical lookup' is one of Excel's frequently used lookup and reference functions. In general, it looks for a 'value' you want to look up from a table or a range, and when found, returns that value. VLOOKUP function has four parameters or arguments in its syntax. The parameters are sepa...
- Mon Oct 09, 2017 10:11 pm
- Forum: Technology & How-To Forum
- Topic: How to Move Text in Microsoft Word without Copy-Paste
- Replies: 0
- Views: 14112
How to Move Text in Microsoft Word without Copy-Paste
In Microsoft Word, if you want to move any single word or any block of text to any other location of your document, then simply highlight the word or the block of text > press F2 > now place the cursor at the location where you want to move your text > press Enter . Your selected word or block of te...
- Thu Sep 14, 2017 11:32 am
- Forum: Technology & How-To Forum
- Topic: How to add a new line in a cell in Google Spreadsheet?
- Replies: 0
- Views: 14495
How to add a new line in a cell in Google Spreadsheet?
Just press Ctrl + Enter or Alt + Enter at the end of your line or after any word where you would like to break and start a new line. It will create a new line there in the same cell.
- Sun Jul 02, 2017 12:13 pm
- Forum: German as a Foreign Language (Deutsch als Fremdsprache)
- Topic: A few notes to increase your learning skills in German
- Replies: 0
- Views: 16799
A few notes to increase your learning skills in German
For beginners who just started learning German or for newcomers in Germany, the German language could look very difficult to absorb at first look - specially words, grammer, then comes the slangs which are widely used in everyday life. But hold on, put a smile on your face and let me start :-) In fa...
- Mon Jun 26, 2017 11:25 am
- Forum: Technology & How-To Forum
- Topic: How to remove table in MS Word but keeping the text inside?
- Replies: 1
- Views: 16360
How to remove table in MS Word but keeping the text inside?
So you want to remove the table in your word document while the text inside the table should retain its structure as it is, right? Select the table by clicking on the small plus sign on the top left corner. http://shamskm.com/forum/exceltutor/removetable/how_to_remove_table_in_word_document.jpg Once...
- Mon Jun 19, 2017 6:27 pm
- Forum: Public Health & Yoga forum
- Topic: Is Sauna risky when you have high blood pressure?
- Replies: 1
- Views: 12647
Is Sauna risky when you have high blood pressure?
Yes, a group of German researchers say, it's risky to go to Sauna when you have high blood pressure. According to Deutsche Hochdruckliga (German High Pressure League): The sauna session is initially a burden for the cardiovascular system. Skin and body temperatures can rise upto 40 degrees Celsius. ...
- Fri Jun 16, 2017 5:32 pm
- Forum: Science
- Topic: What is Sonoluminescence?
- Replies: 0
- Views: 14088
What is Sonoluminescence?
Sonoluminescence is the emission of short bursts of light from imploding bubbles in a liquid when excited by sound (Source: Wikipedia)
A nice article on the subject on the New York Times by Kenneth Chan: "Tiny Bubbles Implode With the Heat of a Star"
A nice article on the subject on the New York Times by Kenneth Chan: "Tiny Bubbles Implode With the Heat of a Star"
- Sun Jun 11, 2017 11:16 am
- Forum: German as a Foreign Language (Deutsch als Fremdsprache)
- Topic: Basic Sentence Structure in German
- Replies: 0
- Views: 17356
Basic Sentence Structure in German
Let's start with normal sentence formation in German. In a simple or normal structure the subject comes first, then the conjugated verb, then the object and any infinitives or participles. Ich lese ein Buch – I read a book. Ich trinke Kaffee – I drink coffee. Ich spiele Schach - I play chess. Comple...
- Wed May 24, 2017 9:26 am
- Forum: Science
- Topic: What does R.I.P or RIP stand for?
- Replies: 0
- Views: 15600
What does R.I.P or RIP stand for?
R.I.P or RIP is an abbreviation of 'requiescat in pace' (Latin meaning: May He/She Rest in Peace) or in English - Rest in peace.
It's an idiomatic expression wishing eternal rest and peace to someone who has died.
It's an idiomatic expression wishing eternal rest and peace to someone who has died.
- Tue May 16, 2017 7:21 pm
- Forum: German as a Foreign Language (Deutsch als Fremdsprache)
- Topic: Oben, Unten, Vorne und Hinten
- Replies: 0
- Views: 15433
Oben, Unten, Vorne und Hinten
Oben, Unten, Vorne und Hinten. These are commonly used adverbs in everyday life for German language speakers. oben - above, upstairs nach oben schauen – to look up Bist du schon oben gewesen? - Have you already been up (there)? Alles Gute kommt von oben. - All good things come from above (means fro...
- Thu May 04, 2017 5:16 pm
- Forum: Technology & How-To Forum
- Topic: How to Create a Project Milestone Chart in Excel
- Replies: 1
- Views: 20851
How to Create a Project Milestone Chart in Excel
Milestone charts are used to represent important events or commitments in your projects. It's also known as timeline chart. So let's start : Data Preparation: As you see in the following table, I have 3 columns. One for Date, the other one for the Events and the third one is actually a helper column...
- Sun Mar 26, 2017 12:31 pm
- Forum: Technology & How-To Forum
- Topic: How to turn off error checking green triangles in Excel
- Replies: 1
- Views: 13917
How to turn off error checking green triangles in Excel
Sometimes you have error checking, otherwise known as, green triangles in the upper-left corner of your cells in Excelsheet possibly suggesting errors in the formula in those cells. Sometimes you get it if you type numbers into cells that were previously formatted as text. Sometimes you get it if yo...
- Sun Mar 19, 2017 8:43 pm
- Forum: German as a Foreign Language (Deutsch als Fremdsprache)
- Topic: German nouns without any plural form
- Replies: 0
- Views: 16825
German nouns without any plural form
The following nouns are always used in their singular forms, i.e. these nouns in German have no plural forms: das Innere - inside das Äußere – outside das Gute – good das Böse – evil die Hetze - agitation die Unsitte – bad habit das All – universe das Web – web das Geld – money die Gier – greed, lus...
- Tue Mar 14, 2017 7:59 pm
- Forum: Technology & How-To Forum
- Topic: How to identify cells that contain formulas in Excel
- Replies: 1
- Views: 13042
How to identify cells that contain formulas in Excel
If you are working with an Excelsheet and would like to know which cells contain formulas, then follow the steps to easily identify them: Go to Home tab > from under the Editing group click on Find & Select > click on Go To Special.... > Go to Special dialog box opens Alternatively, press CTRL +...
- Mon Mar 13, 2017 8:11 pm
- Forum: Technology & How-To Forum
- Topic: How to capitalize the first letter in a text string in Excel
- Replies: 0
- Views: 14812
How to capitalize the first letter in a text string in Excel
Excel has a function that capitalizes the first letter in each word: =PROPER(text) Let's see the following example. Enter in cell B1 =PROPER(A1) http://shamskm.com/forum/exceltutor/excel2/capitalize_first_letter_in_excel.jpg You may copy it down the column for the rest text strings.