Excel-lent Skills
This formula adds up all the numbers in a selected range of cells.
What is SUM()?
Before you leave, you should turn this on to let people know you’re unavailable and when you’ll be back.
What is Automatic Replies (Out of Office message)?
This Excel feature lets you quickly summarize large datasets by dragging and dropping fields.
What is a Pivot Table?
Unlike VLOOKUP, this function can look up values both horizontally and vertically.
What is XLOOKUP()?
This type of conditional formatting uses a gradient of colors to show relative values across a range of cells.
What is a Color Scale?
This formula allows you to bring in data via volume attribution
What is
=IFERROR(SUMIFS(SOURCE FINAL COST COLUMN, SOURCE DATE COLUMN, row’s date, SOURCE PLACEMENT ID COLUMN, row’s placement ID) * (row’s impressions/ SUMIFS(impressions column, placement ID column, row’s placement ID, date column, row’s date)),0)