Search found 314 matches

by Admin
Sun Mar 12, 2017 6:17 pm
Forum: Technology & How-To Forum
Topic: How to show or display formulas in Excelsheet
Replies: 1
Views: 11427

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...
by Admin
Sat Mar 04, 2017 7:50 pm
Forum: Technology & How-To Forum
Topic: The Magic of SUMIFS Function in Excel
Replies: 0
Views: 11343

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 ...
by Admin
Tue Feb 28, 2017 9:25 pm
Forum: Technology & How-To Forum
Topic: Use more efficiently - the ISBLANK Function in Excel
Replies: 0
Views: 11295

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...
by Admin
Tue Feb 21, 2017 1:22 pm
Forum: Technology & How-To Forum
Topic: How to properly display single quotes in Excel
Replies: 0
Views: 11368

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/exce...
by Admin
Sun Feb 19, 2017 1:08 pm
Forum: Technology & How-To Forum
Topic: Excel: Some Examples with SUMIF Function
Replies: 0
Views: 11550

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'...
by Admin
Sun Feb 05, 2017 1:39 pm
Forum: Technology & How-To Forum
Topic: Use ISERROR Function in Excel Like an Expert
Replies: 0
Views: 11576

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 ...
by Admin
Fri Feb 03, 2017 8:06 pm
Forum: Technology & How-To Forum
Topic: How to Change Gridline Color in Excel
Replies: 1
Views: 11492

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/...
by Admin
Fri Feb 03, 2017 6:46 pm
Forum: Technology & How-To Forum
Topic: Excel: Add an Average Line to Your Graph
Replies: 1
Views: 11489

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 ...
by Admin
Wed Feb 01, 2017 11:28 am
Forum: Technology & How-To Forum
Topic: Create a Pareto Chart in Excel for Business Analysis
Replies: 2
Views: 11693

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...
by Admin
Tue Jan 31, 2017 11:10 am
Forum: Technology & How-To Forum
Topic: Publish online - Excel data as Html
Replies: 0
Views: 16453

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

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) > ...
by Admin
Sat Jan 28, 2017 3:17 pm
Forum: Technology & How-To Forum
Topic: Find duplicates with conditional formatting in Excel
Replies: 0
Views: 11363

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...
by Admin
Thu Jan 26, 2017 11:51 am
Forum: Technology & How-To Forum
Topic: Conditional Formatting with Nested IF Function in Excel
Replies: 0
Views: 11767

Conditional Formatting with Nested IF Function in Excel

To meet multiple conditions in data or record, Excel offers the nested if function. We know, the IF function has three arguments – in case of nesting, you can replace one of the arguments with another function – it can be another IF function or SUM function or AVERAGE function and so on. It depends ...
by Admin
Tue Jan 24, 2017 2:28 pm
Forum: Technology & How-To Forum
Topic: Quickly convert units in Excel – like Kg to pounds
Replies: 0
Views: 11795

Quickly convert units in Excel – like Kg to pounds

The following table lists weight of several persons in kilogram. I would like to convert them into pounds. Select cell C2 > click on fx (you find it ( fx ) left to the formula bar or under the Formulas tab – it's called 'Insert Function') The 'Insert Function' window opens > from under Select a func...
by Admin
Mon Jan 23, 2017 7:09 pm
Forum: Technology & How-To Forum
Topic: Save list of files as csv or txt from MS dos command line
Replies: 0
Views: 12256

Save list of files as csv or txt from MS dos command line

First open the MS-DOS prompt Click Start > type cmd and press Enter . The dos command prompt opens. In my case, it always opens with the default directory path C:\Users\mybook99> So type cd.. and press Enter, it will move you one level up. C:\Users\mybook99>cd.. [enter] C:\Users\>cd.. [enter] C:\> N...