Notebooks

Understand the use of basic Excel functions like SUM, AVERAGE, COUNT, and IF.

Learn how to use data validation to control the type of data or the values that users can enter into a cell.

Understand how to use conditional formatting to highlight cells that meet certain conditions.

Learn how to use the PROPER, UPPER, and LOWER functions to change the case of text in Excel.

Understand how to use the AVERAGE, MAX, and MIN functions to perform basic statistical calculations in Excel.

Learn how to use the COUNT, COUNTA, and COUNTIF functions to count cells that meet certain conditions.

Understand how to use pivot tables to summarize, analyze, explore, and present your data.

Learn how to use the VLOOKUP function to find things in a table or a range by row.

Learn how to create and customize charts and graphs to visualize your data.

Understand how to use macros and VBA to automate repetitive tasks in Excel.