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

This tutorial explains the types of data in statistics, such as Interval, Nominal, Ordinal data. You may also want to read: Excel Range, Variance, Standard Deviation Excel central tendency (mean mode median) Types of data in statistics (Interval, Nominal, Ordinal) This tutorial is nothing related to Excel, but it is the foundation for my other Excel statistics tutorial. Understanding t...

This Excel tutorial explains how to export Excel to PDF with and without VBA, how to export all worksheets to one PDF, and export all worksheets to separate PDF. You may also want to read: Select multiple worksheets using Excel VBA Excel export Excel to PDF In Excel, navigate to File > Save As, in the Save As Type,  you can save a file as different file types. Below is the available typ...

This Excel tutorial explains how to consolidate all Comments in the workbook using Macro. You may also want to read: Excel show all comments in worksheet Excel delete all comments in Workbook Excel consolidate all Comments in the workbook Previously I wrote a post about how to show all Comments on the Cell (unhide it), in this tutorial I will show a Macro that consolidate all comments...

This Excel tutorial explains how to show all comments and hide all comments in workbook. You may also want to read: Excel consolidate all Comments in the workbook Excel delete all comments in Workbook Excel show comments in worksheet Comment is a yellow dialog box that you can write comment regarding specific Cell. To insert a Comment, right click on a Cell and then select Insert Com...

This Excel tutorial explains how to verify Number format in a column. If it is a Text then convert Text to Number. You may also want to read: Excel verify Text format and convert number to text Excel Cell Function to check Cell format, address, contents Excel verify Number format Number can be in two forms in Excel - Text and Number. If a Number is a Text, there is a small triangle on...

This Excel tutorial explains difference between VBA Inputbox and  Application.Inputbox and how to use them. You may also want to read: Excel VBA Msgbox and handling of return value Excel VBA use Inputbox to select options Excel VBA Inputbox and Application.Inputbox Inputbox is a pop up dialog box that displays a message and provides a text box for users to input free text. It is very si...

This Excel tutorial explains how to add Excel Add-in in Ribbon. You may also want to read: Writing your first Excel Macro by recording Macro Why use Excel Add-in After you have created a Macro (Sub Procedure), you may want to distribute it for users to use. You can simply add the VBA code in the Module of a Workbook and then distribute the Workbook, but the problem is that the Macro cannot...

This Excel tutorial explains how to use Excel Macro to remove space in prefix and suffix in all worksheets. Excel Macro remove space in prefix and suffix Most recently I performed data validation on Excel spreadsheet in which the data contained a lot of spaces in prefix and suffix. I guess this happened because they delimited the data string using space. For example, seperating first name from...

This Excel tutorial explains how to create Data Validation (drop down box) and Combo Box (Form Control / ActiveX Control). You may also want to read: Excel Indirect Function to convert text to Reference Excel difference between Form Controls vs ActiveX Controls Excel Data Validation and Combo Box If you want to design an Excel template to restrict users to input specific values instead ...