Tag: Leila Gharani

Convert Columns to Rows in Excel (NO Transpose, NO Formulas – SIMPLY UNPIVOT in Power Query)

Convert Columns to Rows in Excel (NO Transpose, NO Formulas – SIMPLY UNPIVOT in Power Query)

Sources from Leila Gharani, • Youtube on Youtube • Published 5 years ago

Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)

Project Plan in Excel with Gantt Chart (Plan, Actual & Progress in ONE VIEW)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Lock Cells & Protect Excel Worksheet – EVEN by Cell Color!

Lock Cells & Protect Excel Worksheet – EVEN by Cell Color!

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Excel IF Function with PARTIAL Text Match (IF with Wildcards)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials

How To Transpose Or Convert A Single Column To Multiple Columns In Excel || dptutorials

Sources from dptutorials, • Youtube on Youtube • Published 6 years ago

Excel Shortcuts You SHOULD Know!

Excel Shortcuts You SHOULD Know!

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Easily Change CASE of Text in Excel (3 ways including NO Formulas)

Easily Change CASE of Text in Excel (3 ways including NO Formulas)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Find or Replace Text and Numbers in Excel (surprising features)

Find or Replace Text and Numbers in Excel (surprising features)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Searchable Drop Down List in Excel (Very Easy with FILTER Function)

Searchable Drop Down List in Excel (Very Easy with FILTER Function)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

3 Methods to Unhide All Sheets in Excel (& how to hide)

3 Methods to Unhide All Sheets in Excel (& how to hide)

Sources from Leila Gharani, • Youtube on Youtube • Published 6 years ago

Return Multiple Match Results in Excel (2 methods)

Return Multiple Match Results in Excel (2 methods)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria

Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

Excel VBA: Copy Data from one Sheet to Another (Absolute Vs. Relative Macro Recording)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel Hack: Copy Formula Without Changing Cell References (or Without File References)

Excel Hack: Copy Formula Without Changing Cell References (or Without File References)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel Dynamic Chart with Drop down List (column graph with average line)

Excel Dynamic Chart with Drop down List (column graph with average line)

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Excel Dependent Drop Down List with Tabular Data without Named Ranges

Excel Dependent Drop Down List with Tabular Data without Named Ranges

Sources from Leila Gharani, • Youtube on Youtube • Published 7 years ago

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel – Part 1

Four SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel – Part 1

Sources from Leila Gharani, • Youtube on Youtube • Published 8 years ago

How to Quickly Make a Gantt Chart in Excel

How to Quickly Make a Gantt Chart in Excel

Sources from Leila Gharani, • Youtube on Youtube • Published 8 years ago

Waterfall Chart in Excel – Advantages and Limitations – Ultimate guide to Excel’s Bridge Graph

Waterfall Chart in Excel – Advantages and Limitations – Ultimate guide to Excel’s Bridge Graph

Sources from Leila Gharani, • Youtube on Youtube • Published 8 years ago