Advance excel

When you want to become an advance excel user, you will have to have a very good understanding of the formula below. We have listed the best formula/functions in excel to use. Be sure that you understand all of them fully to utilize the full capabilities

Logical formulas

1. What is a logical test...click on name for definition and related articles
2. And....click on name for definition and related articles
3. If ....click on name for definition and related articles
4. Or....click on name for definition and related articles
5. Iserror....click on name for definition and related articles
6. Iferror....click on name for definition and related articles

Lookup formulas

1. Vlookup....click on name for definition and related articles
2. Hlookup....click on name for definition and related articles
3. Autofilter....click on name for definition and related articles

Reporting formulas

1. Pivottables....click on name for definition and related articles
2. Sumif....click on name for definition and related articles
3. Sumifs....click on name for definition and related articles

Text formulas

1. Left....click on name for definition and related articles
2. Right....click on name for definition and related articles
3. Mid....click on name for definition and related articles
4. Len....click on name for definition and related articles
5. Trim....click on name for definition and related articles
6. Replace....click on name for definition and related articles
7. Search....click on name for definition and related articles
8. Concatenate....click on name for definition and related articles

Date formulas

1. Working with dates in excel...click on name for definition and related articles
2. Now....click on name for definition and related articles
3. Today....click on name for definition and related articles
4. Networkingdays....click on name for definition and related articles
5. Day....click on name for definition and related articles
6. Month....click on name for definition and related articles
7. Year....click on name for definition and related articles

VBA

1. VBA coding....click on name for definition and related articles
2. Macros....click on name for definition and related articles

Other

1. Breaking links....click on name for definition and related articles
2. Countif....click on name for definition and related articles
3. Indirect....click on name for definition and related articles