In this tutorial. We’re going to set the Excel Range name for the cells in worksheet. Let’s have a look on the worksheet i’ll be using. In this worksheet, we’ll change the price of wines from US Dollars to British Pounds, Euros and Japanese Yen. I’ll be using currency conversion rates in a table so […]
Read MoreIn this tutorial, you’ll learn to link Excel Worksheet to Word Document instead of embedding Worksheet in the document. Below are some steps to make it work: Excel worksheet to Work document Step#1: Open new Word Document. Define your template and Write whatever the text you want before the Worksheet. Step#2: Next step is to […]
Read MoreData Validation helps us to make our Excel sheet error free. With data validation, we can define which data type cell can accept. We can also provide a list of values, in which we can select. Entering wrong value will prompt with an error. In this tutorial, we’ll learn how to do data validation in […]
Read More