Exceldigest - exceldigest.com
General Information:
Latest News:
How to link to values in another Excel 2010 worksheet or workbook 20 Jun 2013 | 01:05 pm
In Excel 2010 or 2007, if you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps: 1. In the sheet you want to link to (source) select the cell where th...
How to convert numbers between decimal and hexadecimal 11 Apr 2013 | 12:19 pm
To convert numbers between decimal and hexadecimal you use the equivalent Excel built-in function. To convert from decimal to hexadecimal use the function DEC2HEX. Syntax DEC2HEX(number;places) Number...
How to convert numbers between decimal and hexadecimal 11 Apr 2013 | 12:19 pm
To convert numbers between decimal and hexadecimal you use the equivalent Excel built-in function. To convert from decimal to hexadecimal use the function DEC2HEX. Syntax DEC2HEX(number;places) Number...
Use INDEX and MATCH functions for table lookup 28 Mar 2013 | 12:02 pm
The table above lists some internet Top Level Domains (TLD) and their equivalent country codes. How can we look up the country name from the table if we know its TLD? E.g. we have the code “cn” and ...
Use INDEX and MATCH functions for table lookup 28 Mar 2013 | 12:02 pm
The table above lists some internet Top Level Domains (TLD) and their equivalent country codes. How can we look up the country name from the table if we know its TLD? E.g. we have the code “cn” and ...
How to get the day of the week as text in Excel 2010 4 Jan 2013 | 11:02 am
Excel WEEKDAY function will return the day of the week as a number. See details here: How-to-get-the-day-of-the-week-in-excel-2010 To return the day of the week as text (name of the day), we combine t...
How to get the day of the week as text in Excel 2010 4 Jan 2013 | 11:02 am
Excel WEEKDAY function will return the day of the week as a number. See details here: How-to-get-the-day-of-the-week-in-excel-2010 To return the day of the week as text (name of the day), we combine t...
How to get the day of the week in Excel 2010 13 Dec 2012 | 01:07 pm
To get the day of the week as a number you use Excel WEEKDAY function. Syntax WEEKDAY(serial_number,[return_type]) Serial number: a serial number that represent the date. Return type (optional): a num...
How to get the day of the week in Excel 2010 13 Dec 2012 | 01:07 pm
To get the day of the week as a number you use Excel WEEKDAY function. Syntax WEEKDAY(serial_number,[return_type]) Serial number: a serial number that represent the date. Return type (optional): a num...
How to change the range of a defined name in Excel 2010 5 Dec 2012 | 10:49 pm
In a previous post I explained how to define named ranges in Excel 2010. OK, you have defined a name for a specified range. Later on you decided to change the size of that range either by expanding it...
