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.
2. And
3. If
4. Or
5. Iserror
6. Iferror

Lookup formulas

1. Vlookup
2. Hlookup
3. Autofilter

Reporting formulas

1. Pivottables
2. Sumif
3. Sumifs

Text formulas

1. Left
2. Right
3. Mid
4. Len
5. Trim
6. Replace
7. Search
8. Concatenate

Date formulas

1. Working with dates in excel
2. Now
3. Today
4. Networkingdays
5. Day
6. Month
7. Year

VBA

1. VBA coding
2. Macros

Other

1. Breaking links
2. Countif
3. Indirect
4. Sharing workbooks

Troubleshooting

1. Cannot insert rows