Split expenses calculator
Extract specific word based on position in cell value
How to extract numbers from a cell value
Finding the shortest path – A * pathfinding
Wildcard lookups and include or exclude criteria
Working with ARRAY VARIABLES (VBA)
Merge tables based on a condition
How to use the SORT function
Find and return the highest number and corresponding date based on a condition
Working with Excel tables programmatically
Working with comments – VBA
How to copy non contiguous cell ranges
Customize the ribbon and how to add your macros
Highlight unique values in a filtered Excel table
Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses
Prevent duplicate records in a worksheet
Working with LIST BOXES (Form Controls)
Find numbers closest to sum
Compare two columns and extract differences
How to add chart elements
Excel formula not working
Copy data from workbooks in folder and subfolders
Working with TEXT BOXES [Form Controls]
How to add horizontal line to chart
Compatibility Functions
How to do tiered calculations in one formula
Excel solver examples
Calculate machine utilization
How to save specific multiple worksheets to a pdf file programmatically
How to use the asterisk character
How to use the BIN2DEC function
Complex Calculations: A Guide to Excel’s IM Functions
Engineering functions – D to IMC
How to use the SORTBY function
How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas – use named ranges
Dynamic scoreboard
Time sheet for work
Build a maze programmatically in Excel
How to solve simultaneous linear equations in Excel
Working with classic ciphers in Excel
Add checkboxes and copy values – VBA
Show / hide a picture using a button
How to use the PI function
How to use the LIKE OPERATOR
Populate drop down list with unique distinct values sorted from A to Z
Comparing Excel Sorting Techniques: Formulas, Tools, and VBA
Auto resize columns as you type
Lookup a date in date ranges and get the corresponding value
Extract records between two dates
How to animate an Excel chart
Yet another Excel Calendar
Run a macro every time a workbook opens or closes
Filter unique distinct records case sensitive
How to use the Scroll Bar
How to use DIALOG BOXES
How to track sector performance in the stock market – Excel template
Filter duplicate values based on criteria
Excel template: Getting Things Done [VBA]
How to use the Subtotal tool
How to use the FREQUENCY function
How to improve your Excel Chart
Search website