Calculate probability of a range using Z Score

Posted on September 13, 2015October 26, 2015 by Wyman W

This tutorial explains how to calculate probability of a range using Z score (standard normal random variable). You may also want to read: Excel Range, Variance, Standard Deviation Calculate Z Score and probability using SPSS and Excel SPSS Excel one sample T Test Calculate probability of a range using Z Score Assume that a random variable is a normally distributed (a normal curve), given that we have the standard deviation and mean, we can find the probability that a certain value ran...

Import Excel into SPSS

Posted on September 11, 2015 by Wyman W

This SPSS tutorial explains how to import Excel into SPSS. Import Excel into SPSS It is easy to import Excel into SPSS but you should note that SPSS will automatically define each variable, some of them can be correct and some incorrect (this is very similar to Microsoft Access). In this tutorial, I will demonstrate how to import Excel into SPSS and how SPSS guesses the variable types, I will try too cover the most common scenario. Lets say we have the following table in Excel, which contai...

How to become Microsoft MVP (Excel MVP)

Posted on September 3, 2015March 20, 2016 by Wyman W

This article is to share my experience to become Microsoft MVP - Excel (Microsoft Most Valuable Professional). Introduction of Microsoft MVP I received the Microsoft MVP - Excel award on July 1st 2015 and it was my first Microsoft MVP award. I have done many research before I applied for Microsoft MVP, and I have seen many articles on the internet that copy the official information form the Microsoft website which is not helpful at all. In this article, I will share everything I know fro...

Excel Access VBA extract percentage from text

Posted on September 1, 2015April 30, 2019 by Wyman W

This Excel / Access tutorial explains how to extract percentage from text. Access Excel VBA extract number from text or extract alphabet Excel Extract Time from Date Time or Extract Date Access Excel extract file name from file path Excel extract text in brackets Excel Access VBA extract percentage from text Recently I got a report that contains percentage but it is mixed with other text. For example, Salary increased by 10% We are unable to do any calculation unless we extract the 1...

Excel VBA color code list – ColorIndex, RGB color, VB color

Posted on August 23, 2015August 23, 2015 by Wyman W

This Excel tutorial collects the VBA color code list for reference purpose, which includes ColorIndex, RGB color, VB color. Excel ColorIndex VBA Excel ColorIndex Property is to set color or get color for Objects like Cell color and Shape color. ColorIndex offers 56 basic colors plus the following special numbers. ColorIndex Value Explanation -4142 / xlColorIndexNone / xlNone No fill -4105 / xlColorIndexAutomatic / xlAutomatic Default color (white) Example 1: Se...

Access Excel remove line break and carriage return

Posted on August 22, 2015December 26, 2016 by Wyman W

This Access / Excel tutorial explains how to remove carriage return and remove line break in a text. You may also want to read: Excel VBA separate line break data into different rows Access Excel remove carriage return and remove line break Recently our company uploaded employee data in spreadsheet data to the new system. One user reported that her home address shows some special code (something like hex code) that is supposed to be a space. Since the code appears after a comma, I suspec...

Access Excel VBA day month year difference between two dates

Posted on July 18, 2015July 7, 2017 by Wyman W

This Access Excel tutorial explains how to find complete year difference, month difference and date difference between two dates. You may also want to read: Excel DATEDIF Function to calculate date difference Access Excel VBA difference between two dates (year difference, month difference, day difference) In Excel worksheet, there is a Function called DateDif that can calculate difference between two dates in complete year, month or day. In VBA, there is no DateDif Function. There is ...

Excel VBA Copy Range and Paste Method

Posted on July 12, 2015June 2, 2017 by Wyman W

This Excel VBA tutorial explains how to copy Range and paste data using VBA Excel VBA Copy Range Method Range.Copy Method is a very convenient Method to copy and paste Range to destination in one line of code. All the formatting will be copied and pasted. You can copy a Range, a column, a row. Syntax Range.Copy(Destination) Destination is optional. If not specified, Excel copies the Range to the Clipboard. In some cases, we may just want to copy to Clipboard and then use Paste/PasteSp...

Excel verify Text format and convert number to text

Posted on July 11, 2015 by Wyman W

This Excel tutorial explains how to verify Text format in a column. If it is a Number then convert Number to Text. You may also want to read: Excel verify Number format and convert Text to Number Excel verify Text format Three kinds of Cell contents are considered as Text 1) Non-number - such as alphabet, symbol 2) A mix of number and non-number 3) Number with small triangle on the top left of the Cell Number can be in two forms in Excel - Text and Number. If a Number is a ...

Excel calculate Covariance, Coefficient of Correlation

Posted on June 28, 2015 by Wyman W

This Excel tutorial explains the meaning and calculation of Covariance and Coefficient of Correlation. You may also want to read: Excel Range, Variance, Standard Deviation Covariance, Coefficient of Correlation Assume that we have two sets of data - English and Mathematics results for each student. How can we tell whether English result has any relationship with Mathematics result? Name of Student English Result Math Result John 50 60 Mary 60 70 Peter 70 80 ...