SyntaxPilot
Courses/Data Analytics with Python/Lesson 54
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

Data Analytics with Python · Lesson 54 of 90

Excel for analysts 1: formulas and lookups

workbookworksheetcell referencerelative vs absolute reference ($A$1)formulaSUMAVERAGECOUNTIF(S)SUMIF(S)IFIFERRORVLOOKUPXLOOKUPINDEX-MATCH

Detailed notes for this lesson are being written. They appear here together with the video.