Category Archives for "Excel Tips"

2 How to Find External Links and References in Excel

What are External Links or References? When you create formulas in Excel and refer to a data point in an another workbook, Excel creates a link to that workbook. So your formula may look like something as shown below: Note that the part highlighted in yellow is the external link (also called external reference). This […]

Continue reading >>

1 How to Generate Random Numbers in Excel

There may be cases when you need to generate random numbers in Excel. For example, to select random winners from a list or to get a random list of numbers for data analysis or to create random groups of students in class. In this tutorial, you will learn how to generate random numbers in Excel (with […]

Continue reading >>
1 2 3 28