Forum Index
shamskm.com Home
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 251 matches
Forum Index
Author Message
  Topic: How to properly display single quotes in Excel
Admin

Replies: 0
Views: 17

PostForum: Technology & How-To Forum   Posted: Tue Feb 21, 2017 1:22 pm   Subject: 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 'Joh ...
  Topic: Excel: Some Examples with SUMIF Function
Admin

Replies: 0
Views: 17

PostForum: Technology & How-To Forum   Posted: Sun Feb 19, 2017 1:08 pm   Subject: 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, range - range of cells that will be evaluated by the specified criteria ...
  Topic: Use ISERROR Function in Excel Like an Expert
Admin

Replies: 0
Views: 47

PostForum: Technology & How-To Forum   Posted: Sun Feb 05, 2017 1:39 pm   Subject: 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(val ...
  Topic: How to Change Gridline Color in Excel
Admin

Replies: 0
Views: 38

PostForum: Technology & How-To Forum   Posted: Fri Feb 03, 2017 8:06 pm   Subject: 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 workshee ...
  Topic: Excel: Add an Average Line to Your Graph
Admin

Replies: 0
Views: 35

PostForum: Technology & How-To Forum   Posted: Fri Feb 03, 2017 6:46 pm   Subject: 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 g ...
  Topic: Create a Pareto Chart in Excel for Business Analysis
Admin

Replies: 0
Views: 39

PostForum: Technology & How-To Forum   Posted: Wed Feb 01, 2017 11:28 am   Subject: 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 ...
  Topic: Publish online - Excel data as Html
Admin

Replies: 0
Views: 39

PostForum: Technology & How-To Forum   Posted: Tue Jan 31, 2017 11:10 am   Subject: 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 w ...
  Topic: Blank cells in Excel how to organize them better way?
Admin

Replies: 0
Views: 36

PostForum: Technology & How-To Forum   Posted: Mon Jan 30, 2017 10:25 am   Subject: 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://shams ...
  Topic: Find duplicates with conditional formatting in Excel
Admin

Replies: 0
Views: 39

PostForum: Technology & How-To Forum   Posted: Sat Jan 28, 2017 3:17 pm   Subject: 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 ...
  Topic: Conditional Formatting with Nested IF Function in Excel
Admin

Replies: 0
Views: 53

PostForum: Technology & How-To Forum   Posted: Thu Jan 26, 2017 11:51 am   Subject: 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 ...
  Topic: Quickly convert units in Excel like Kg to pounds
Admin

Replies: 0
Views: 50

PostForum: Technology & How-To Forum   Posted: Tue Jan 24, 2017 2:28 pm   Subject: 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 t ...
  Topic: Save list of files as csv or txt from MS dos command line
Admin

Replies: 0
Views: 55

PostForum: Technology & How-To Forum   Posted: Mon Jan 23, 2017 7:09 pm   Subject: 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 ...
  Topic: How AutoSum Shortcut works in Excel?
Admin

Replies: 0
Views: 57

PostForum: Technology & How-To Forum   Posted: Sun Jan 22, 2017 4:03 pm   Subject: How AutoSum Shortcut works in Excel?
If you want to make a quick sum of a range of data, the best and easiest way is to use the shortcut for Autosum.

First, you need to install it in your quick access toolbar. So follow the steps:
...
  Topic: How to easily calculate age in excel?
Admin

Replies: 0
Views: 54

PostForum: Technology & How-To Forum   Posted: Sat Jan 21, 2017 4:32 pm   Subject: How to easily calculate age in excel?
There are several ways to calculate age in Excel.

Let's say, in the following table I will calculate the age of Jens Hendrik.

So in cell C2 enter =(YEAR(NOW())-YEAR(B2))


http://shamskm.com ...
  Topic: How to take screenshots with mouse cursor?
Admin

Replies: 0
Views: 60

PostForum: Technology & How-To Forum   Posted: Thu Jan 19, 2017 2:59 pm   Subject: How to take screenshots with mouse cursor?
You can do it with 'Steps Recorder', also called 'Problems Steps Recorder' to take a screenshot with mouse cursor.

Click on Start button > go to Windows Accessories > click on Steps Recorder. ...
 
Page 1 of 17 Goto page 1, 2, 3 ... 15, 16, 17  Next
All times are GMT + 2 Hours
Jump to:  


Powered by phpBB © 2001, 2005 phpBB Group