Learn to use tables and create powerful formulas in Excel. Learn SumIF, Date, IF, VLOOKUP and Text formulas
InstructorIan Littlejohn
Free
The curriculum includes contemporary Excel functions such as Groupby, Pivotby, VStack, HStack, and XLookup.
Instruction uses role-play discussions to frame the practical application of tables, conditional formatting, and formulas.
Editorial course preview
These 2 complementary views highlight concrete, legible examples from the course presentation.
This image displays an Excel spreadsheet containing sales data with columns for Order ID, Date, Sales, and Region, accompanied by text outlining course topics like tables, formulas, and conditional formatting.
This image shows an Excel spreadsheet with a structured data table and an open filter dropdown menu, illustrating how to manipulate data using tables and formulas.
Some practical activities may reference functions not yet introduced in earlier modules, and one signal suggests potential missing spreadsheet files.
The curriculum aligns with the target of Excel users through practical table and formula instruction.