mark rowley

Epicor 9.05.701 - How to default a field via a customisation (C# syntax)

Excel - Index Match Match

Windows - How to delete specific files / empty a folder on a schedule

Excel - IFERROR, IF, IF(AND, IF(OR

Excel - SUMIFS to look between two dates

Excel - Partial match using the filter formula

Excel - Picture placed in cell vs Picture over cell

Excel - Removing duplicates

Excel - Creating a search box and using the Filter formula to find data (exact match method)

Excel - Translate

Excel - Transpose

Excel - Checkboxes / Checklist

Excel - Data types from third party (internet)

Excel - XLOOKUP vs INDEX MATCH MATCH

Excel - Flash Fill and the use of MID(SEARCH

Excel - XLOOKUP how to return multiple columns

Excel - How to add a row or column in multiple sheets in one action.

Excel - Referencing (Naming) a table, worksheet or cell.

Excel - Colour Scaling / Heat Map

Excel - Dashboard Creation, Pivots, Graphs, Slicers and Timeline Slicer

Excel - circular references

Excel - How to import a table from a PDF file.

Excel - CTL + fn + arroba (¬) key

Excel - Various date formulas

Excel - Sequence

Excel - Value