Advance Excel Contents
- Randbetween
- Skip Blank
- Substitute \Double Substitute
- If-Is blank-if error
- If/Or/And Condition’s
- Sum if/Sumifs
- Conditional Formatting
- Left/Right/Mid(Formula’s)
- Pivot-Table/Pivot-Chart
- If-Left/Mid/Right
- Data Validation
- Consolidate, GST Invoice, GST Billing
- What If Analysis
- Lookup’s (Vlookup + Hlookup + Xlookup)
- Lookup’s By 10-15 Method’s
- Reverse vlookup
- Interest Generate By Pmt /Ipmt
- Mis Report
- Macros
- Command Using By Shortcut’s Keys
- Date if Formula’s
- Salary sheet/mark sheet/price list
And many more Advance commands by short cut methods
- Advance filter
- Income tax calculator
- GST Invoice form
- Repeated cells
- Penalty list.
- Advance formula up to 100 etc.