“Through wisdom is an house builded; and by understanding it is established.” — Proverbs 24:3
Lesson
What You Will Learn
- Sort data by one or more columns
- Filter lists to find records
- Convert a range into an Excel table
- Use conditional formatting to highlight information
Lesson Notes
Sorting
Select any cell in a list and use Data > Sort. Sort A–Z or by numbers or dates. For multi-level sorts (by Department, then Last Name), use Custom Sort. Always sort the whole list so rows stay together.
Filtering
Data > Filter adds drop-down arrows to headers. Filter to show only certain values (all orders from one vendor, all items under 10 in stock). Filtering hides rows; it does not delete them. Clear filters when done.
Excel Tables
Insert > Table (Ctrl + T) turns a range into a table with banded rows, built-in filters, a total row, and formulas that fill down automatically. Name your table on the Table Design tab.
Conditional Formatting
Home > Conditional Formatting colors cells that meet rules: stock below 5 in red, overdue dates highlighted, top 10 values in bold. Use it sparingly so important information stands out.
Key Terms
| Item | Details |
|---|---|
| Sort | Arrange rows in order |
| Filter | Show only rows meeting criteria |
| Excel table | A structured, formatted range with built-in tools |
| Conditional formatting | Automatic formatting based on rules |
In-Class Activities
Visitor Log Analysis
Using the 40-row sample visitor log, sort by date then time, filter to show one department's visitors, and count them. Clear the filter.
Low-Stock Alert
Convert your supply list into a table. Add conditional formatting that highlights Quantity below 5. Add a total row.
Assignment: Organized Data Report
Using the sample employee training list:
- Convert it to a named table.
- Sort by Department, then Last Name.
- Filter to show employees whose training is overdue; record how many.
- Highlight overdue dates with conditional formatting.
- Write two sentences a supervisor could act on.
Graded with the Module Assignment Rubric.
Reflection Journal
Proverbs 24:3 says a house is built by wisdom and established by understanding. Organizing data turns noise into understanding. What in your life needs sorting so you can see clearly what matters most?
Prayer focus: Ask God for wisdom to see clearly and understanding to act well.
Weekly Reading & Devotions
Seeing Clearly
A list of 400 visitors tells you very little until you sort and filter it. Then questions get answers: Which day is busiest? Which department has the most visitors? Who hasn't completed training?
Sorting and filtering turn raw information into understanding. Proverbs says a house is built by wisdom and established by understanding (24:3). In offices, organized data helps leaders make wise decisions.
Conditional formatting is like a highlighter that works automatically: overdue dates turn red, low stock stands out. Use it sparingly. When everything is highlighted, nothing stands out.
Your life has information too: bills, appointments, goals. Organizing it helps you see clearly what needs attention first.
Think About It
- What question could sorting and filtering answer at a job? ______________________
- What in your life needs to be sorted by priority? ______________________
- Where do you need clearer understanding? ______________________
Daily Devotions for Week 3
Built by Wisdom
Through wisdom is an house builded; and by understanding it is established.— Proverbs 24:3 (KJV)
Wisdom organizes; understanding establishes.
Reflect: Where do you need understanding?
Pray: Lord, give me understanding.
Do: Organize one set of information.
Lamp to My Feet
Thy word is a lamp unto my feet, and a light unto my path.— Psalm 119:105 (KJV)
God's Word shows the next step clearly.
Reflect: What next step do you need to see?
Pray: Lord, light my path.
Do: Read Psalm 119:105 each morning.
First Things First
But seek ye first the kingdom of God.— Matthew 6:33 (KJV)
Sorting by priority starts with putting God first.
Reflect: What comes first in your day?
Pray: Lord, be first in my life.
Do: Start your day with prayer.
Discernment
That your love may abound yet more and more in knowledge and in all judgment; that ye may approve things that are excellent.— Philippians 1:9–10 (KJV)
Discernment filters what is excellent from what is not.
Reflect: What do you need to filter out?
Pray: Lord, give me discernment.
Do: Remove one distraction today.
Things That Stand Out
Ye are the light of the world. A city that is set on an hill cannot be hid.— Matthew 5:14 (KJV)
Like highlighted data, a life of faith stands out.
Reflect: How does your life stand out?
Pray: Lord, let my light shine.
Do: Do one kind act that stands out.
Module Quiz
- 1.
Filtering a list:
- 2.
Which shortcut creates an Excel table?
- 3.
To sort by Department and then Last Name, use:
- 4.
Conditional formatting can automatically highlight low stock.
- 5.
Why must you sort the entire list, not just one column?