31 – SUMPRODUCT Function in Excel (in Urdu) |
|
30 – SWITCH Function in Excel (in Urdu) |
|
29 – Hyperlink Function in Excel (in Urdu) |
|
28 – DATEDIF, YEARFRAC, EDATE & EOMONTH Functions in Excel (in Urdu) |
|
27 – AND and OR Logical Functions in Excel (in Urdu) |
|
26 – Date(), Now(), Today(), Year(), Month(), Day(), & Time() Functions in Excel (in Urdu) |
|
25 – Why we use IFERROR Function in Excel (in Urdu) |
|
24 – A simple Income and Expense worksheet Dashboard in Excel |
|
23 – Automate payslip in PDF on one click in Excel |
|
22 – Why we use Sumif() & Sumifs() and Countif() & Countifs() in Excel (in Urdu) |
|
21 – Why we use “Tables” in Excel (in Urdu) |
|
20 – Dashboard for an Event Budget worksheet (in Urdu) |
|
19 – IF Function in Excel (in Urdu) |
|
18 – Text to Column in Excel (in Urdu) |
|
17 – Advanced Filter in Excel (in Urdu) |
|
16 – Paste Special in Excel (in Urdu) |
|
15 – Seaching blank cells with “Goto Special” in excel (in Urdu) |
|
14 – How to use index function in excel (in Urdu) |
|
13 – Speaking Cells in Excel (in Urdu) |
|
12 – Microsoft Excel – LEN(), LEFT(), RIGHT(), MID() Functions (in Urdu) |
|
11 – Microsoft Excel – Text Function in Excel (in Urdu) |
|
10 – Microsoft Excel – Data Validation (in Urdu) |
|
9 – Microsoft Excel – VLOOKUP() and MATCH() (in Urdu) |
|
8 – Microsoft Excel – Conditional Formatting, Duplicate Values & Sparklines (in Urdu) |
|
7 – Microsoft Excel – Conditional Formatting, Data Bars & Icon Sets (in Urdu) |
|
6 – Microsoft Excel – Cell Range and Named Range (in Urdu) |
|
5 – Microsoft Excel – Relative & Absolute Cell References (in Urdu) |
|
4 – Microsoft Excel – Number Formatting & Customer Formatting (in Urdu) |
|
3 – Microsoft Excel AutoFill & FlashFill feature (in Urdu) |
|
2- Microsoft Excel SumIF() Function (in Urdu) |
|
1- Microsoft Excel Count(), Counta(), CountIF() Functions (in Urdu) |
|