Excel TAN Function Tips

Have you ever thrown a pebble in water? You must have in your childhood! The pebble follows not a straight line but a parabolic path.

In real life, resources are scarce and wants are unlimited. This fact leads us to optimize our resources to get best out of available resources

Amongst the various format that number takes, time is the one of the most commonly used formats, after currency and accounting number formats.

Networking days are important for both an employee and the employer.

The CONCAT, CONCATANETE and TEXTJOIN functions are popular as text combining functions, which have been designed to combine a range of strings that contain parts of text, phrases or numbers.

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.

SUMIF() functions is among the most commonly used functions in excel. Whenever ever we have to sum against a given criteria we revert to this function, be the criteria be only one or more then one (for more then one criteria’s we use SUMIFS(), just another function of this family).

In Goal Seek, we try to reach a solution to a problem by iterating values.

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?

Measures is amongst the most important and highly powerful features in **Power Pivot**. Measures are actually the calculations or formulas you add to the Pivot Table. Below is an example of it.

**INDIRECT Function** yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell.

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.

At first instance, you may wonder why we would need to remove spaces in Excel. If you have unnecessary spaces it may prevent working of some functions, filtering etc.

The sorting facility is an important and highly useful feature provided in Excel. Which can be used to handle and retrieve data from large databases.

The CONCAT function was recently introduced by replacing CONCATANETE function and the CONCAT is only available with the latest version of Office (EXCEL 2016, Excel Online and latest mobile excel versions).

VLOOKUP stands for Vertical Lookup. Learning vlookup is very easy but let’s first understand how VLOOKUP works?

Inserting rows in between selected rows, is one of the most necessary and important functions we require when working in excel worksheets.