Crear Tablas en Excel
Free to teach as-is — the teacher guide, student handout, and slides are included.
Free — we'll email you an access link. Google Docs format.
Objective
Pudeo crear convertir un rango de datos en una tabla estructurada con funciones avanzadas y visualmente atractiva en Excel
Part 1 of 3
Warm-up video
Unknown Channel · 5:00
We don't generate video — this one is by Unknown Channel on YouTube. The practice questions and exit ticket below were drafted by AI for this objective, and every question is editable in the teacher guide.
Part 2 of 3
Practice
7 questions
Describe the two ways the video demonstrates to select the data range you want to format as a table in Excel.
Explain the steps to apply a pre-designed table style to a range of cells in Excel, as shown in the video.
Part 3 of 3
Exit ticket
Quick comprehension check
“You have a list of student names and their test scores in an Excel sheet. Describe the steps you would take to format this data as a table with a blue, medium-style design, including headers. After formatting the student names and test scores as a table, explain how you would use the filter function to display only the students who scored 85 or higher. You have an existing Excel table with student names, test scores, and attendance records. You want to add a new column for "Homework Completion". Describe the steps you would take to add this new column to the existing table, ensuring it is included in the table's formatting and functionality.”
Sample answer included in the free materials
Get the materials
Teacher guide, student handout, and slides — free, in Google Docs format
Teacher Guide
Complete lesson plan with answer keys and alternate activities
Student Handout
Printable worksheet
Slides
Ready to present
We'll ask for your email to send your access link — nothing else.
Teaching a group at a different level?
Where are your students right now? We'll rebuild this lesson to match — including the teacher guide, student handout, and slides, saved to your Google Drive.
Adapt This Lesson