This video demonstrates how to sum between two dates in Excel. In our scenario we want to calculate total revenue. The functions used in this video are SUMIFS, EOMONTH and EDATE. Download the featured file here.
This video will show how to achieve two things in the context of using Lookup functions such as VLOOKUP, LOOKUP, XLOOKUP, INDEX & MATCH. You can download the featured files here. XLOOKUP Version - requires Office 365 or Excel Online. Non XLOOKUP Version - works in any version of Excel. Sum all matching values Here we…
Read MoreExcel's VLOOKUP, XLOOKUP, MATCH & INDEX | Over 20 Functions XLOOKUP, VLOOKUP, MATCH, INDEX, IFERROR, LEFT, RIGHT, MID, FIND, SEARCH, LEN, SUBSTITUTE, REPLACE, TRIM, CLEAN, INDIRECT Click here to enrol This course will teach you how to use lookup functions in Excel. Lookup functions are used frequently to compare and combine data. In our experience…
Read More