Search found 306 matches
- Sun Mar 19, 2017 8:43 pm
- Forum: German as a Foreign Language (Deutsch als Fremdsprache)
- Topic: German nouns without any plural form
- Replies: 6
- Views: 6823
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: 3438
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 + G >...
- 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: 4748
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. * Recommended : ...
- Sun Mar 12, 2017 6:17 pm
- Forum: Technology & How-To Forum
- Topic: How to show or display formulas in Excelsheet
- Replies: 1
- Views: 4755
How to show or display formulas in Excelsheet
There are several ways to show or display formulas in Excelsheet: Go to the Formulas tab > from the Formula Auditing group click on the Show Formulas button. It will show you the formulas. http://shamskm.com/forum/exceltutor/excel2/show_formulas_in_excel.jpg If you click on Show Formulas again (it's...
- Sat Mar 04, 2017 7:50 pm
- Forum: Technology & How-To Forum
- Topic: The Magic of SUMIFS Function in Excel
- Replies: 0
- Views: 4758
The Magic of SUMIFS Function in Excel
First, what's the difference between SUMIF and SUMIFS functions ? The SUMIF function accepts only one criteria or conditon at a time, while as the name says, SUMIFS function accepts multiple conditions or criteria. So the SUMIFS function offers more flexibilty for data analysis. The syntax of SUMIF ...
- Tue Feb 28, 2017 9:25 pm
- Forum: Technology & How-To Forum
- Topic: Use more efficiently - the ISBLANK Function in Excel
- Replies: 0
- Views: 4687
Use more efficiently - the ISBLANK Function in Excel
In simple words, the ISBLANK Function checks the referenced cell if it is (the cell) empty. And if the cell is empty, the function returns TRUE, if the cell is not empty rather contains any value, then it returns FALSE. Its syntax is: =ISBLANK(value) In most cases, the 'value' argument is a cell ref...
- Tue Feb 21, 2017 1:22 pm
- Forum: Technology & How-To Forum
- Topic: How to properly display single quotes in Excel
- Replies: 0
- Views: 4787
How to properly display single quotes in Excel
In Excel if you type any text within double quotes, it displays properly (like "John Donlee"), but in case of single quotes, it displays without the leading single quote. So if you type 'John Donlee' , it displays John Donlee' as in the image below. http://shamskm.com/forum/exceltutor/excel2/display...
- Sun Feb 19, 2017 1:08 pm
- Forum: Technology & How-To Forum
- Topic: Excel: Some Examples with SUMIF Function
- Replies: 0
- Views: 4866
Excel: Some Examples with SUMIF Function
SUMIF function is used to sum up values in a given range that meet specified criteria. Its syntax is SUMIF(range, criteria, [sum_range]) range - range of cells that will be evaluated by the specified criteria. It is required. criteria – here you specify your criteria. Also required. sum_range - it'...
- Sun Feb 05, 2017 1:39 pm
- Forum: Technology & How-To Forum
- Topic: Use ISERROR Function in Excel Like an Expert
- Replies: 0
- Views: 4826
Use ISERROR Function in Excel Like an Expert
The ISERROR Function returns TRUE if it finds cells containing error like #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! Its syntax is very simple with only one argument =ISERROR(value) Most cases, the 'value' argument is a cell reference. In the following example, I will calculate per day ...
- Fri Feb 03, 2017 8:06 pm
- Forum: Technology & How-To Forum
- Topic: How to Change Gridline Color in Excel
- Replies: 0
- Views: 4811
How to Change Gridline Color in Excel
To change the gridline color of your worksheet, just follow the steps: Click the Office Button > then click Excel Options From Advanced category > under Display options for this worksheet > from the Gridline color box, select any color of your choice > click OK . http://shamskm.com/forum/exceltutor/...
- Fri Feb 03, 2017 6:46 pm
- Forum: Technology & How-To Forum
- Topic: Excel: Add an Average Line to Your Graph
- Replies: 0
- Views: 4874
Excel: Add an Average Line to Your Graph
In Excel when you make a graph or chart to analyze your data, an average line of the plotted data gives a better overview of the whole scenario. And it's very easy to plot such an average line to a graph. In the following example, Column B contains sales information. I will calculate the average of ...
- Wed Feb 01, 2017 11:28 am
- Forum: Technology & How-To Forum
- Topic: Create a Pareto Chart in Excel for Business Analysis
- Replies: 1
- Views: 3710
Create a Pareto Chart in Excel for Business Analysis
Create a Pareto Chart in Excel for Business Analysis or Quality Control : Pareto chart , named after the Italian economist Vilfredo Pareto, who noticed that 80% of Italy's land was owned by 20% of the population while at the University of Lausanne in 1896 . Hence comes the 80/20 rule. So it can hap...
- Tue Jan 31, 2017 11:10 am
- Forum: Technology & How-To Forum
- Topic: Publish online - Excel data as Html
- Replies: 0
- Views: 4637
Publish online - Excel data as Html
If you would like to publish your Excel data online as a web page, let's say as HTML file, then follow these steps: Open the worksheet you want to save or select the range of your data that you want to publish. Click on File or Microsoft Office button > click Save As The 'Save As' window opens. From...
- Mon Jan 30, 2017 10:25 am
- Forum: Technology & How-To Forum
- Topic: Blank cells in Excel – how to organize them better way?
- Replies: 0
- Views: 4579
Blank cells in Excel – how to organize them better way?
If you have lot of blank cells in your Excel data, there are several ways you can organize them nicely. First one : Fill the blank cells with 0 Select your data range ( A2:C16 ) http://shamskm.com/forum/exceltutor/blankcells/organizing_blank_cells_in_excel_step1.jpg Go to Editing (under Home tab) > ...
- Sat Jan 28, 2017 3:17 pm
- Forum: Technology & How-To Forum
- Topic: Find duplicates with conditional formatting in Excel
- Replies: 0
- Views: 4765
Find duplicates with conditional formatting in Excel
In Excel, you can highlight cell values with colors through conditional formatting, to quickly capture important information in your spreadsheet. We will do it here step-by-step to highlight our data with duplicate entries: Select your data range ( A2:C12 ) http://shamskm.com/forum/exceltutor/finddu...