Get-digital-help - get-digital-help.com - Get Digital Help
General Information:
Latest News:
Basic mathematics in excel for school children 23 Aug 2013 | 04:34 pm
Right now most kids in Sweden are back in school after summer holidays. Their parents have had 4 to 6 weeks vacation during summer so it has been a time of joy and happiness. I have created an excel ...
Find out if excel files in a folder are password protected 20 Aug 2013 | 05:43 pm
rahul jadhav asks: How can we identify any protected excel file before opening using macro VBA (e.g. i have a folder with multiple excel files i need to find out using macro how many files are passwo...
Count text strings in formulas (vba) 15 Aug 2013 | 02:01 pm
Rahul Jadhav asks: I have many excel files with multiple sheets and each excel sheet has many formula which are starting from perticular word e.g. FDS, FDSB, etc some formula has FDS, FDSB occur in t...
Quickly select a data set or an excel defined table [HYPERLINK] 7 Aug 2013 | 06:58 pm
If you often copy data sets or tables, the following technique might be interesting! The animated gif shows two hyperlinks, the first one selects a data set, the second one selects an excel defined ta...
Quickly jump to last row in a data set using excel hyperlink function 30 Jul 2013 | 06:43 pm
Today I´ll show you how to create a useful hyperlink in excel. If you click the link it will take you to the first empty row in a data set. Formula in cell C2: =HYPERLINK("[Quickly jump to last row ...
IFERROR function 16 Jul 2013 | 02:43 pm
The IFERROR function was introduced in excel 2007. In previous excel versions you could check for errors with the ISERROR function. IFERROR(value, value_if_error) If the value argument returns an err...
Locate a particular cell in a table 9 Jul 2013 | 04:34 pm
Find a value and return a corresponding value is really easy with Excel´s INDEX and MATCH functions. Did you know that you also can quickly "jump to" and select that value in a table using the HYPERLI...
Excel RANDBETWEEN and RAND functions – How to generate random numbers and text 5 Jul 2013 | 03:27 pm
Microsoft Excel has two useful functions for generating numbers. The RAND function and RANDBETWEEN function. RAND() function returns a random number between 0 and 1. Example: 0.600842025092928 RANDB...
Use drop down lists to compare data series in an excel chart 3 Jul 2013 | 06:58 pm
The two drop down lists below the chart let´s you compare two data series from separate tables. It is easier to follow the tutorial steps if you download the excel *.xlsx file: Compare data series in...
Hierarchical relationships in an excel chart 27 Jun 2013 | 05:49 pm
The macro in this example adds series to a scatter chart. The first series is the dots and their names. The remaining series are the lines connecting the dots. They originate from the "Connected to" c...
