Explanations and calculations for formulas and functions most commonly used by Merchandisers and Ecommerce Managers
Formula Fridays are short reads, spotlighting a single formula that you can start using straight away.
If you are looking for industry specific examples to help support your day to day, you’ve come to the right place.
A guide for decoding formula error messages in Excel
This guide will show you how to display the calendar month of a date using with an Excel formula
Count
Countifs
An advanced guide to using COUNTIFS to get more from your data
Goal Seek
A step-by-step guide to using Goal Seek to forecast OTB margin
HLOOKUP
This is a step-by-step guide for how to use the HLOOKUP Function in Excel
IF
INDEX
INDEX MATCH MATCH
This is a step-by-step guide for how to INDEX, MATCH, MATCH in Excel
SUBTOTAL
A step-by-step guide to adding subtotals to your data summaries
SUMIFS
VLOOKUP
This is a step-by-step guide for how to use the VLOOKUP Function in Excel
Excel and Me has the examples, templates and formulas you need to analyse and interpret performance data. Helping to easily translate your findings into action focused summaries.
Receive exclusive access to summaries of the content shared on my blog and socials. And the techniques behind my methodology.
A discovery call is an opportunity for you to share your business goals, receive FREE expert advice and gain insight on what to do next.
