Channels

Leila Gharani

152 Followers
  1. How to use Excel Index Match (the right way)

    How to use Excel Index Match (the right way)

    5
    0
    42
  2. Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    Quick Excel Trick to Unstack Data from one Column to Multiple Columns

    3
    0
    140
  3. Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)

    Build Impressive Charts: It's NOT your usual Bar Chart (Infographics in Excel)

    3
    0
    39
  4. Excel Dashboard with 4 Strange Features (Excel Hash Episode)

    Excel Dashboard with 4 Strange Features (Excel Hash Episode)

    5
    0
    101
  5. 3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes)

    3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes)

    3
    0
    42
  6. Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    Excel Array Formula: Count Rows based on OR condition - Excel MMULT, INDIRECT Functions (Part 3/3)

    4
    0
    35
  7. Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method)

    3
    0
    17
  8. Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

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

    4
    0
    15
  9. 4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

    4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1

    3
    0
    26
  10. How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

    How to Create a DYNAMIC Map Chart With Drop-Down (works with ANY Excel version)

    3
    0
    8
  11. 5 Design Tips for Better Excel Reports & Dashboards

    5 Design Tips for Better Excel Reports & Dashboards

    4
    0
    12
  12. Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria)

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

    4
    0
    11
  13. Excel Charts & Graphs: Learn the Basics for a Quick Start

    Excel Charts & Graphs: Learn the Basics for a Quick Start

    3
    0
    13
  14. Excel VBA tutorial for beginners: The Visual Basic Editor (VBE)

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

    3
    0
    32
  15. Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

    Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples

    4
    0
    26
  16. Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)

    Properly Print a Large Spreadsheet on Multiple Pages in Excel (Repeat Headers)

    3
    0
    21
  17. Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps

    Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps

    4
    0
    11
  18. 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)

    4
    0
    38
  19. This Excel Chart will grab your attention (Infographic template included)

    This Excel Chart will grab your attention (Infographic template included)

    6
    0
    22
  20. 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)

    3
    0
    40
  21. Easily Import Data from Web to Excel (2 Practical Examples)

    Easily Import Data from Web to Excel (2 Practical Examples)

    3
    0
    29