Excel mod Function Tips

Finding if a Number if Prime!

Prime Numbers are numbers that are only divisible by their selves. In this small tutorial we will guide you how to find if a number is prime or not.

How To Use MOD() Function To Repeat Values Certain Number Of Time

MOD() function has variety of uses. One of the most basic one is that it is used to find the remainder from a division

Using Hyperlink () With Vlookup () To Jump To A Specific Cell

Excel model can be as simple as adding up two values in cell or so complicated to cover multiple sheets or even multiple workbooks

Whenever you come up with a useful sheet, it is almost always essential to get it printed. Be it a simple sheet or complex business model, we can not deny the importance of a hard printed copy – it is always easier to read and record.

Excel Training

The world has been growing rapidly over the past few decades. Today modern technology has completely changed our lifestyle and is adding a lot to our daily lives

Displaying Large Data Sets With Sparkline In Excel

Our paper is designed to accommodate two-dimensional charts, or at best 3 dimensional charts. But those charts are produced at the expense of understandability and appearance of them. What if you want to produce so many to them to accommodate cross-tabbed data?

A 3 Step Guide To Make Your First Excel Based Model

There are a lot of resources available for modeling on internet, available from books to tutorial to boot-camp trainings; this one focuses more on the concept of modeling rather then discussing details of any particular field.

Generating Random Data In 5 Minutes

When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.