Search found 314 matches

by Admin
Thu Oct 12, 2017 12:24 am
Forum: Technology & How-To Forum
Topic: Excel VLOOKUP Function for Your Business
Replies: 1
Views: 9589

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...
by Admin
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: 10652

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...
by Admin
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: 10937

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.
by Admin
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: 1
Views: 13156

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...
by Admin
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: 2
Views: 10879

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...
by Admin
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: 9900

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. ...
by Admin
Fri Jun 16, 2017 5:32 pm
Forum: Science
Topic: What is Sonoluminescence?
Replies: 0
Views: 11337

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"
by Admin
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: 13940

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...
by Admin
Wed May 24, 2017 9:26 am
Forum: Science
Topic: What does R.I.P or RIP stand for?
Replies: 0
Views: 11884

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.
by Admin
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: 11897

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...
by Admin
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: 17171

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...
by Admin
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: 11694

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...
by Admin
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: 13293

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...
by Admin
Tue Mar 14, 2017 7:59 pm
Forum: Technology & How-To Forum
Topic: How to identify cells that contain formulas in Excel
Replies: 2
Views: 10783

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 +...
by Admin
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: 11435

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.