Excel Exercises Lessons

Learn Excel text functions such as LEFT, RIGHT, MID, LEN, TRIM, and SUBSTITUTE with interactive lessons and exercises.

Master 27 Excel date and time functions like TODAY, NOW, DATE, DATEDIF, and NETWORKDAYS with interactive exercises. Manage schedules and calculate durations efficiently.

Master 11 Excel logical functions like IF, IFS, AND, OR, SWITCH, and IFERROR with interactive exercises. Build decision engines, validate data, and automate alerts efficiently.

Master 17 Excel information functions like ISNUMBER, ISTEXT, ISBLANK, ISERROR, and TYPE with interactive exercises. Inspect cells and validate data types efficiently.

Master 26 Excel math and trigonometry functions like SUM, SUMIFS, ROUND, PRODUCT, and MOD with interactive exercises. Perform calculations and solve complex numeric problems efficiently.

Master 28 Excel financial functions like PMT, FV, PV, IRR, and NPV with interactive exercises. Analyze loans and calculate investments efficiently.

Master 14 Excel lookup and reference functions like VLOOKUP, XLOOKUP, INDEX, MATCH, and OFFSET with interactive exercises. Retrieve data and connect datasets efficiently.

Learn the core Excel matrix functions, including MUNIT, MDETERM, MINVERSE, and MMULT, with practical examples and exercises.

Master 25 Excel statistical functions like AVERAGE, COUNTIFS, MAX, MIN, and STDEV with interactive exercises. Analyze data trends and perform calculations efficiently.

Master 20 Excel engineering functions like BIN2DEC, DEC2HEX, COMPLEX, and BITAND with interactive exercises. Handle base conversions and bitwise logic efficiently.