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

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

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

    Excel Picture Lookup: 5 easy steps for dynamic images

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

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

    3
    0
    10
  4. Excel Dependent Drop Down List with Tabular Data without Named Ranges

    Excel Dependent Drop Down List with Tabular Data without Named Ranges

    4
    0
    15
  5. Charting Survey Results in Excel (Visualize Employee Satisfaction results)

    Charting Survey Results in Excel (Visualize Employee Satisfaction results)

    3
    0
    7
  6. How to create a Step Chart in Excel (that is fully dynamic & easy to read)

    How to create a Step Chart in Excel (that is fully dynamic & easy to read)

    3
    0
    9
  7. Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs

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

    4
    0
    15
  8. Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    Excel Reset Week Number Every Month - (WeekDay & WeekNum Functions Explained)

    3
    0
    8
  9. Excel Dynamic Chart with Drop down List (column graph with average line)

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

    3
    0
    8
  10. Excel Charts: How To Show Percentages in Stacked Charts (in addition to values)

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

    5
    0
    5
  11. Creative infographics in Excel (Male, Female icons)

    Creative infographics in Excel (Male, Female icons)

    3
    0
    13
  12. Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    Excel VBA: Check If File or Folder Exists (DIR) - Open File or Create Folder

    3
    0
    17
  13. Excel Sum(ifs) between dates, sum month & sum with multiple criteria

    Excel Sum(ifs) between dates, sum month & sum with multiple criteria

    3
    0
    21
  14. 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
  15. Excel Flash Fill For MAJOR Time Saving (7 Examples)

    Excel Flash Fill For MAJOR Time Saving (7 Examples)

    4
    0
    18
  16. Progress Circle Chart in Excel as NEVER seen before!

    Progress Circle Chart in Excel as NEVER seen before!

    3
    0
    37
  17. How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

    How to use the Message Box in Excel VBA (syntax you'll need for msgbox)

    3
    0
    27
  18. Excel Column Chart - Stacked and Clustered combination graph

    Excel Column Chart - Stacked and Clustered combination graph

    3
    0
    7
  19. Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)

    Excel 3D Formulas Explained (Includes a Bonus Excel Hack!)

    3
    0
    114
  20. Excel VBA: Adjust Fill Color of WordArt with a Macro

    Excel VBA: Adjust Fill Color of WordArt with a Macro

    3
    0
    23
  21. How to create barcodes in Excel that WORK!

    How to create barcodes in Excel that WORK!

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

    Excel Dashboard with 4 Strange Features (Excel Hash Episode)

    5
    0
    98
  23. Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)

    Copy & Paste in Excel VBA (copy, pastespecial, resize & offset)

    3
    0
    39