Login
Excel Yourself/Formatted Tables and Columns (90 min)
Buy now

  • $25

Formatted Tables and Columns (90 min)

  • Course
  • 6 Lessons

Excel's formatted tables are a powerful data feature, but structured references have a few issues. This session looks at solving those issues with range names. In the process providing more flexibility and interaction when referring to columns in a formatted table. Version: M365 Recorded: July 2026 Level: Advanced Duration: 90 min Price: AUD25
Buy now

Contents

Formatted Tables and Columns

Session Materials

The session materials

  • a pdf manual which you can print out and make notes in

  • Excel file to work through during the session

  • the completed file to review if you need to

Formatted Tables Columns.pdf
Formatted Table Columns.xlsx
Formatted Table Columns completed.xlsx

Course video - July 2026

Formatted Table Columns video

Quiz

Test your new found knowledge with 10 multiple choice questions.

Quiz