Excel Basic to Advanced formulas
I can work on basic to advanced formulas in Excel.
I love the following: Indirect, index+match, vlookup, sumproduct, array formulas, date and time,etc.
PLEASE PING ME BEFORE PLACE ORDER.
- Vlookup/Hlookup, Index + Match
- Countif/Countifs
- Sumif/Sumifs
- Data Validation
- Conditioning Formatting with formulas
- Data Validation: Drop down
- Named Ranges
- Pivot Table with calculated columns
- Apply formulas/Advance Filter
- Text to columns
- Split text/data into different cells
- Sum product
- Removing duplicates
Thank you for reading, I am looking forward to working with you!
Add to WishlistRemove from Wishlist
Add to Wishlist
Description
I can work on basic to advanced formulas in Excel.
I love the following: Indirect, index+match, vlookup, sumproduct, array formulas, date and time,etc.
PLEASE PING ME BEFORE PLACE ORDER.
- Vlookup/Hlookup, Index + Match
- Countif/Countifs
- Sumif/Sumifs
- Data Validation
- Conditioning Formatting with formulas
- Data Validation: Drop down
- Named Ranges
- Pivot Table with calculated columns
- Apply formulas/Advance Filter
- Text to columns
- Split text/data into different cells
- Sum product
- Removing duplicates
Thank you for reading, I am looking forward to working with you!
Additional information
| Type | Formulae, VBA |
|---|---|
| Price | 10, 30, 60, 100 |
| Currency | USD, AUD, CAD |







