This Excel tutorial explains how to create organization chart in Excel. Different ways to create organization chart Some companies use HR systems that have function to auto generate real time organization chart, some develop in house system to create organization chart automatically by pulling the HR database,  some companies draw the data from HR system and do it half manually using software (s...

This Excel tutorial explains how to extract file name from file path using VBA and without VBA. Excel Access VBA extract percentage from text Access Excel VBA extract number from text or extract alphabet Excel Extract Time from Date Time or Extract Date Excel extract file name from file path Assume that you have a file path such as C:\Program Files\Google\GoogleToolbarNotifier\a.jpg I...

This Excel tutorial explains how to insert file (insert object) in Excel using VBA and without using VBA. Excel insert file object (non-VBA) In Excel, insert file is known as insert object, there are two kinds of insert: Embedded Object - insert the source file into Excel Linked Object - insert the link of file into Excel, not the actual source file In terms of display of the inserted...

This Excel tutorial demonstrates how to install Analysis Toolpak. What is Analysis Toolpak Add-Ins Excel Analysis Tookpak is an Add-Ins that adds additional analysis functions (such as statistics and engineering functions) to Excel. You have to install the Analysis Toolpak in order to use the functions. Note that if you use the Add-Ins function but the receiver of the file has not installed t...

This Excel tutorial explains how to create Excel Histogram. You may also want to read: Excel clustered column chart Excel scatter chart using text name Definition of Histogram Before reading this post, you are recommended to read my below post. Types of data in statistics (Interval, Nominal, Ordinal). Histogram is a column chart that counts frequency of numbers and categorize the nu...

This Excel tutorial explains how to use Excel GetPivotData Function to get Pivot Table Data. You may also want to read: Create Pivot Table using Excel VBA Excel VBA refresh all Pivot Table or Pivot Cache Excel GetPivotData Function Excel GetPivotData Function is used to get data in Pivot Table. For example, in a Pivot Table above, if you type =G3 in a Cell, a formula will generat...

This Excel tutorial explains how to Vlookup different format (a mix of text and number). You may also want to read: Case sensitive lookup Excel verify Text format and convert number to text Excel verify number format and convert Text to Number Issue with VLookup different format (a mix of text and number) Sometimes your data source table may contain a mix of text and number, let's sa...

This tutorial explains how to use Excel and SPSS to perform one sample T Test. You may also want to read: Statistics Hypothesis Testing Calculate Z Score and probability using SPSS and Excel What is T Test In statistical inference, we are interested to know whether a small sample comes from a population. To inference using sample mean, when the population standard deviation and populati...

This tutorial explains the concepts of hypothesis testing in statistics. Hypothesis Testing Many text book uses the court case example to explain hypothesis testing. In the U.S. (but not all countries), the court finds evidence to prove the defendant guilty, instead of proving the defendant innocent. There are two hypothesis for a court case: The defendant is guilty - when we have a the...

This Excel tutorial explains how to clear cell contents / clear cell formats using Clear, ClearContents, ClearFormats Method. Excel VBA clear cell contents There are several kinds of "clear" related Excel VBA Methods for different scenarios. I will also explain how to clear single cell contents, clear merged cells contents, and clear blank cells. Clear single cell contents with ClearContents ...