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
- What is a logical test...click on name for definition and related articles
- And....click on name for definition and related articles
- If ....click on name for definition and related articles
- Or....click on name for definition and related articles
- Iserror....click on name for definition and related articles
- Iferror....click on name for definition and related articles
Lookup formulas
- Vlookup....click on name for definition and related articles
- Hlookup....click on name for definition and related articles
- Autofilter....click on name for definition and related articles
Reporting formulas
- Pivottables....click on name for definition and related articles
- Sumif....click on name for definition and related articles
- Sumifs....click on name for definition and related articles
Text formulas
- Left....click on name for definition and related articles
- Right....click on name for definition and related articles
- Mid....click on name for definition and related articles
- Len....click on name for definition and related articles
- Trim....click on name for definition and related articles
- Replace....click on name for definition and related articles
- Search....click on name for definition and related articles
- Concatenate....click on name for definition and related articles
Date formulas
- Working with dates in excel...click on name for definition and related articles
- Now....click on name for definition and related articles
- Today....click on name for definition and related articles
- Networkingdays....click on name for definition and related articles
- Day....click on name for definition and related articles
- Month....click on name for definition and related articles
- Year....click on name for definition and related articles
VBA
- VBA coding....click on name for definition and related articles
- Macros....click on name for definition and related articles
Other
- Breaking links....click on name for definition and related articles
- Countif....click on name for definition and related articles
- Indirect....click on name for definition and related articles
|