Assign unique random number using Excel

Posted on March 17, 2016March 20, 2016 by Wyman W

This tutorial explains how to use assign unique random number using Excel. You can apply this skills to Simple Random Sampling. You may also want to read: Generate random letter A to Z Generate random HKID RANDBETWEEN Function Assign unique random number using Excel There are several ways to assign unique random number, the simplest way to do it is to use Worksheet Rand Function. You can apply this skills to Simple Random Sampling. Rand Function generates a decimal number from 0...

Access first date of month and last date of month

Posted on March 14, 2016 by Wyman W

This Access tutorial explains how to find first date of month, last date of month using Access Expression and VBA Function. You may also want to read: Excel first date of month and last date of month Access first date of month To find first date of month in Access, first we have to understand DateSerial, you can use it to combine the year, month and day to a date. Syntax of Date Function DateSerial( year, month, day ) Example Formula Result Explanation DateSerial(2012,1,...

Excel first date of month and last date of month

Posted on March 14, 2016March 14, 2016 by Wyman W

This Excel tutorial explains how to find first date of month, last date of month using Excel worksheet Function and Excel VBA Function. You may also want to read: Excel Use Date in IF Condition Excel first date of month To find first date of month in Excel, first we have to understand DATE Function, you can use it to combine the year, month and day to a date. Syntax of Date Function DATE( year, month, day ) Example Formula Result Explanation =Date(2012,1,1) 1/1/2012 Co...

Excel VBA Workbooks.Open Method

Posted on March 10, 2016 by Wyman W

This Excel VBA tutorial explains how to use Workbooks.Open Method to open another workbook. Excel VBA Workbooks.Open Method Workbooks.Open Method is useful when you try to open another Workbook using VBA. For example, you can open a workbook > format the spreadsheet > close the workbook automatically. There are a lot of rarely used arguments for Workbooks.Open Method. As most of them are self explanatory, I will demonstrate some common uses of the Method. Syntax of Workbooks.Open Method...

Add password to all Excel workbook in folder

Posted on March 8, 2016April 18, 2016 by Wyman W

This Excel VBA tutorial explains how to add password to all Excel workbook in folder and how to mass remove password. You may also want to read: Excel VBA protect worksheet with password Excel VBA hide worksheet with password (xlVeryHidden) Protect VBA code with password Add password to all Excel workbook in folder In many organizations, employees are required to add password to Excel before sending workbooks through email, or before putting workbooks in network drive. If you have ...

Excel Descriptive Statistics

Posted on February 28, 2016 by Wyman W

This Excel tutorial explains how to interpret the summary table generated from Excel Descriptive Statistics. Excel Descriptive Statistics One of the options under DATA > Data Analysis is Descriptive Statistics, which generates a statistics summary of a variable. It is very useful because it saves you a lot of time from entering a lot of formulas in order to get some basic analysis. Before using Excel Descriptive Statistics feature, you should first install Analysis Toolpak Add-Ins. As...

Excel Hyperlink Function

Posted on February 21, 2016February 21, 2016 by Wyman W

This Excel tutorial explains how to use Excel Hyperlink Function to add hyperlink to Cell and send email. Excel Hyperlink Function Excel Hyperlink Function is to add a hyperlink to a Cell. You can add hyperlink without using any Function. Right click on a Cell and then select Hyperlink to enter a web address or email address. With Excel Hyperlink Function, you only need to enter arguments for the Function instead of right clicking a Cell. This is useful if you are trying to create a ...

Get exchange rate using VBA Access Function

Posted on January 18, 2016July 24, 2017 by Wyman W

This tutorial demonstrates how to create a VBA custom function (UDF) in Microsoft Access in order to get the real time exchange rate. You may also want to read Get Foreign Exchange Rate in Excel Get exchange rate using VBA Access Function Yahoo Finance is designed in the way to facilitate you to get data. You can establish a connection to Yahoo and directly get the exchange rate using User Defined Function. Open Access, press ALT+F11 > Tools > References > enable "Microsoft W...

Get Foreign Exchange Rate in Excel (VBA and non-VBA)

Posted on January 15, 2016July 24, 2017 by Wyman W

This Excel tutorial explains how to get foreign exchange rate in Excel using VBA and non-VBA. You may also want to read: Get exchange rate using VBA Access Function Excel currency converter template Foreign Exchange Rate Websites Excel allows you to create an external connection to website where you can get the data directly in the spreadsheet. To begin with, look for a dynamic website that contains foreign exchange rate where the database constantly refreshes. One example is ...

Excel VBA Hyperlinks Function

Posted on January 12, 2016July 23, 2016 by Wyman W

This Excel VBA tutorial explains how to use Hyperlinks Function to send email and add hyperlink to Cell. Excel VBA Hyperlinks Function The purpose of the Hyperlinks Function is to remove or add hyperlink to a Cell, the hyperlink can be an email or a website. There is another Worksheet Function Hyperlink (without s). Hyperlinks.Add Method Syntax expression.Add(Anchor, Address, SubAddress, ScreenTip, TextToDisplay) Name Required/Optional Data Type Description Anchor Require...