This Excel tutorial explains how to delete blank rows in Excel with VBA and without VBA. You may also want to read: Excel delete blank rows and blank cells before import into Access Excel delete duplicated data in consecutive rows Excel Delete Blank Rows Sometimes we have data that contains blank rows, one example is data with pivot table layout where data are grouped together and repea...

This SPSS Excel tutorial explains how to calculate Covariance, Correlation and Least Squares Method in Excel and SPSS. Covariance and Correlation When we plot a scattered graph to see the relationship between two interval variables, we can see how straight a line is formed (whether the relationship is strong) and whether the relationship is positive or negative (upward or download). Howev...

This tutorial explains how to calculate Z Score and probability using SPSS and Excel. You may also want to read SPSS Excel one sample T Test Calculate probability of a range using Z Score Calculate Z Score and probability using SPSS and Excel In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the popul...

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), give...

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 tr...

This Excel VBA tutorial explains VBA LinkInfo Method to check status of linked workbook. You may also want to read: Excel find all external links and broken links in workbook Excel VBA LinkInfo Method Workbook LinkInfo Method is usually used to check status of linked workbook, so that we know whether the workbook link is broken or normal. Usually this Method is used with LinkSources Me...

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 th...

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 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...

This Excel VBA tutorial explains how to separate line break data into different rows. You may also want to read: Access Excel remove line break and carriage return Excel VBA separate line break data into different rows Recently I received a report from a HR system which is claimed to be a standard report. In the report, some data are grouped into one Cell and are separated by line break. ...

This Excel VBA tutorial explains how to use VBA to protect worksheet with password. You may also want to read: Excel VBA hide worksheet with password (xlVeryHidden) Excel VBA Add password to Excel workbook in folder Protect VBA code with password Different kinds of workbook protection There are several kinds of protection in Excel. Add password to workbook. Users are asked to ...