Microsoft Excel: Tables & Named Ranges

Wishlist Share

About Course

Make spreadsheets easier to manage with Excel Tables and named ranges: automatic formatting and expansion, structured references, total rows and readable formulas.

This course is an independent introduction for learning purposes. Product menus and features change over time, so check the current official documentation.

What Will You Learn?

  • Convert a range into an Excel Table Use structured references in formulas Add total rows and slicers Create and manage named ranges

Course Content

Course Lessons

  • Excel Tables
  • Structured References & Totals
  • Named Ranges

Sources & Further Reading
The official guidance this course is based on.

Final Assessment

Student Ratings & Reviews

No Review Yet
No Review Yet

Want to receive push notifications for all major on-site activities?

✕