1. Make better Excel tables: BMW report to the test (Part 3)

    Make better Excel tables: BMW report to the test (Part 3)

    3
    0
    10
  2. Excel: Extract unique items for dynamic data validation drop down list

    Excel: Extract unique items for dynamic data validation drop down list

    3
    0
    7
  3. Easiest Step Chart in Excel (this trick will surprise you!)

    Easiest Step Chart in Excel (this trick will surprise you!)

    3
    0
    8
  4. Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    Excel Waterfall Charts: Business Examples of Waterfall Charts and When to Use Them in Your Reports

    4
    0
    22
  5. Excel FILTER Function TRICK for Non Adjacent Columns

    Excel FILTER Function TRICK for Non Adjacent Columns

    4
    0
    81
  6. Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)

    Excel: Find Multiple Matches & Dependent Drop Down List (Unsorted Tabular Data Set)

    3
    0
    13
  7. Excel Picture Lookup: 5 easy steps for dynamic images

    Excel Picture Lookup: 5 easy steps for dynamic images

    3
    0
    3
  8. 5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?

    5 Eye-Tracking Discoveries for OPTIMAL Chart Design - Do you use these?

    3
    0
    12
  9. Easily Import Data from Web to Excel (2 Practical Examples)

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

    3
    0
    29
  10. Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    Reset Dependent Drop-down in Excel (with a tiny bit of VBA)

    3
    0
    27
  11. (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter

    (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter

    4
    0
    45
  12. Excel Dynamic Chart Range based on Cell (drop-down) Value for dashboards

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

    4
    0
    9
  13. Excel IF Function with PARTIAL Text Match (IF with Wildcards)

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

    3
    0
    12
  14. Fully Featured Excel Gantt Chart - actual, planned & percentage completed

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

    6
    0
    44
  15. Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

    Smart Dependent Drop-Down Lists in Excel: Expandable & Exclude Blank Cells

    3
    0
    19
  16. 5 Tips to Unlock the Power of OneNote

    5 Tips to Unlock the Power of OneNote

    6
    0
    128
  17. Microsoft Excel Tutorial – How to Create Formulas and Functions

    Microsoft Excel Tutorial – How to Create Formulas and Functions

    2
  18. Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

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

    4
    0
    15
  19. Excel SUMPRODUCT with Criteria: SUM Alternate Columns based on Header and Criteria

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

    6
    0
    10
  20. Easiest Excel Waterfall Chart (Bridge graph) from Scratch - Works with minus values

    Easiest Excel Waterfall Chart (Bridge graph) from Scratch - Works with minus values

    4
    0
    20
  21. Excel Conditional Formatting the Lookup result in data table (Index Match)

    Excel Conditional Formatting the Lookup result in data table (Index Match)

    4
    0
    9
  22. Excel Tips and Tricks - How to Use Checkboxes in Excel

    Excel Tips and Tricks - How to Use Checkboxes in Excel

    6
    0
    438
  23. Excel Tips and Tricks - How to use the LOOKUP function

    Excel Tips and Tricks - How to use the LOOKUP function

    88