| File Code | Title | Link to the File |
|---|---|---|
EC0023 |
30 Excel Tips in 15 Minutes |
|
EC0022 |
XLOOKUP Can’t Return All Matches |
|
EC0021 |
Combine Multiple Columns into Single Column |
|
EC0020 |
Pivot from Multiple Tables or Worksheets |
|
EC0019 |
Compare Two Tables with Power Query |
|
EC0018 |
Top 10 / Bottom 10 Chart with ONE Powerful Formula |
|
| EC0017 | An Awesome Animated Line Chart | Download |
| EC0016 | 7 Excel Tips that You Can’t Afford to Miss in 2025 | Download |
| EC0015 | Count Cells with Bold, Italic, Underlined, and Strikethrough | Download |
| EC0014 | Perform VLOOKUP in Power Query | Download |
| EC0013 | Connect Google Drive File with Excel Workbook using Power Query | Download |
| EC0012 | 7 Game-Changer Excel Functions | Download |
| EC0011 | DGET Function in Excel | Download |
| EC0010 | VBA to Create PIVOT Tables | Download |
| EC0009 | Rename Files in Folder | Download |
| EC0008 | Count Colored Cells in Excel | Download |
| EC0007 | Create a Star Rating System in Excel (With Ready Template) | Download |
| EC0006 | Split Data into Multiple Worksheets | Download |
| EC0005 | Create a Waffle Chart in Excel | Download |
| EC0004 | VBA Code to Auto Sort Data in Excel | Download |
| EC0003 | Ratio Chart in Excel | Download |
| EC0002 | Animated Toggle Button in Excel | Download |
| EC0001 | Create Multiple Folders, Workbooks, and Worksheets | Download |