Leila Gharani

Leila Gharani

159 Followers
AllVideosLiveAbout
    Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header
    8:02

    Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header

     8  views
    Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names
    11:47

    Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

     11  views
    Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards
    12:25

    Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

     9  views
    Excel Conditional Formatting with Symbols and Icons (for better reports)
    10:00

    Excel Conditional Formatting with Symbols and Icons (for better reports)

     10  views
    Fully Featured Excel Gantt Chart - actual, planned & percentage completed
    17:23

    Fully Featured Excel Gantt Chart - actual, planned & percentage completed

     44  views
    Quick Gantt Chart in Excel (Unusual technique)
    11:19

    Quick Gantt Chart in Excel (Unusual technique)

     22  views
    Excel NETWORKDAYS function: Calculate the number of working days between two dates
    10:08

    Excel NETWORKDAYS function: Calculate the number of working days between two dates

     5  views
    Excel Workday function: Find end date - exclude weekends & holidays
    10:21

    Excel Workday function: Find end date - exclude weekends & holidays

     31  views
    Excel Combo Box without VBA - How to create a drop-down list
    5:11

    Excel Combo Box without VBA - How to create a drop-down list

     3  views
    5 Design Tips for Better Excel Reports & Dashboards
    4:43

    5 Design Tips for Better Excel Reports & Dashboards

     12  views
    Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)
    12:22

    Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)

     5  views
    Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability
    8:43

    Excel Charts: Stacked Chart Dynamic Series Label Positioning for Improved Readability

     17  views
    Excel Charts: Total Values for Stacked Charts in Excel
    5:00

    Excel Charts: Total Values for Stacked Charts in Excel

     7  views
    Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria
    10:54

    Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

     10  views
    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header
    10:53

    Excel SUMIFS: Sum Alternate Columns based on Criteria and Header

     14  views
    Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget
    10:19

    Excel Arrow Variance Chart: Dynamic Arrows in Chart to Show Change to Previous Year / Budget

     25  views
    Better Excel Variance Charts to show percentage change (Simple & uncommon technique)
    12:26

    Better Excel Variance Charts to show percentage change (Simple & uncommon technique)

     23  views
    Excel Variance Charts: Actual to Previous Year or Budget Comparisons
    14:17

    Excel Variance Charts: Actual to Previous Year or Budget Comparisons

     30  views
    Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs
    11:40

    Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

     15  views
    Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT
    11:43

    Excel: Dependent Drop Down Lists with OFFSET, CHOOSE, INDEX & INDIRECT

     12  views
    Excel Simple Dependent Drop down List based on numbers (Index without match)
    8:45

    Excel Simple Dependent Drop down List based on numbers (Index without match)

     12  views
    Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)
    10:21

    Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

     15  views
    How to use Excel Index Match (the right way)
    11:31

    How to use Excel Index Match (the right way)

     50  views
    Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
    10:35

    Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

     34  views
    Excel Tables: Use Smart Conditional Formatting for great table layout
    4:21

    Excel Tables: Use Smart Conditional Formatting for great table layout

     8  views
Prev Next