Notebooks

Understand the differences and similarities between Excel and Excel Online.

Learn the difference between a workbook and a worksheet in Excel.

Learn how to create and use basic Excel formulas.

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.