The Ladder Alliance

Lesson 5: Change page setup

Lesson 6: Adjust row height and column width

Lesson 7: Customize headers and footers

Lesson 8: Personalize the Quick Access toolbar

Lesson 9: Change how content is displayed

Lesson 10: View multiple parts of a worksheet simultaneously

Lesson 11: Show formulas

Lesson 12: Edit basic workbook properties

Lesson 13: Check workbooks for issues

Lesson 14: Print workbook content

Lesson 15: Save workbooks in different file formats

Lesson 16: Create data, reuse data, and modify worksheet structure

Lesson 17: Merge and unmerge cells, change cell alignment, orientation, and indentation. Wrap text within cells

Lesson 18: Apply cell formats and styles, apply number formats, and reapply existing formatting

Lesson 19: Define and reference named ranges

Lesson 20: Format cells based on their content

Lesson 21: Insert sparklines

Lesson 22: Create an Excel table from a range of cells, apply styles to tables, and convert a table back to a cell range

Lesson 23: Add or remove rows and columns in a table, and adjust table style options

Lesson 24: Filter tables and sort tables

Lesson 25: Use relative and absolute references

Lesson 26: Reference named cell ranges and tables in formulas

Lesson 27: Perform calculations with SUM(), AVERAGE(), MAX(), and MIN() functions

Lesson 28: Count cells with COUNT(), COUNTA(), and COUNTBLANK() functions

Lesson 29: Perform conditional operations with the IF() function

Lesson 30: Select text with LEFT(), MID(), and RIGHT() functions

Lesson 31: Format text with UPPER(), LOWER(), and PROPER() functions

Lesson 32: Counting characters with The LEN() function

Lesson 33: Combine text with CONCAT() and TEXTJOIN() functions

Lesson 34: How to create a chart

Lesson 35: Change chart content

Lesson 36: Adjust chart elements

Lesson 37: Apply layouts and styles

Lesson 38: Provide alternative text for accessibility

Lesson 39: Scheduling your exam