- The Workbook
- Posts
- The lazy way to create perfect Excel tables š
The lazy way to create perfect Excel tables š
How to create custom Excel tables in ChatGPT!
Hey! Happy Halloween eve. š Iām knee-deep in pumpkin carving, but Iām taking a break to tell you about something scarier than cleaning up the pumpkin seeds all over my floor: falling behind on AI.
AI skills are becoming essential. The sooner you learn them, the more time youāll save and the quicker youāll become the person your team canāt afford to lose.
Thatās why Iām hosting a free, brand-new AI and Excel class! After just one hour, youāll leave this class knowing:
- Which prompts get the best results on the first try 
- Tips to make AI basics more powerful than you expect 
- How to create your own AI assistant that thinks exactly like you 
ā¦and so much more!


ChatGPT š¤ Custom Excel Tables
POV: Youāre planning ahead for Q1 2026 and want an Excel table of all the US holidays plus those fun observance days (Pizza Day, World Compliment Day, etc.) from January to March.
You tell yourself youāll find this table online and copy-paste it into Excel. Itāll take two minutes. Right?
Nope. š«
Your Google search comes up dry. None of the tables you find have quite the columns you want or combine both holiday and fun observance days.

So closeā¦yet so far!
Cue: ChatGPT. Instead of manually piecing together data from multiple sources, you can ask ChatGPT to build the exact table you need and format it so you can directly copy-paste it into Excel.
Hereās how:
Step 1) Write the prompt:
āCreate a table showing major US holidays and fun observance days calendar from January to March 2026. Include these columns: Date, Holiday Name, Day of the Week, and Federal Holiday (Yes/No).ā

Step 2) Hit enter. ChatGPT creates the table for you in seconds.

Step 3) Copy and paste your table into Excel. Double-check your data, adjust your formatting, and youāre set.

This is just one of hundreds of ways you can leverage AI in Excel. I go over more tips in my free Excel and AI class, which you can register for right here!


Missed Last Weekās AI & Excel Class?
ICYMI: Last week, I hosted a brand-new free AI and Excel training where I show you to stop fighting with ChatGPT and actually apply it so you can save hours at work.
Iāve led over 100 Excel webinars. But this AI and Excel class? It was one of our best reviewed classes ever!
So, Iāve opened up extra spots in case you havenāt been able to attend yet. In just one hour, youāll learn how to customize ChatGPT, use AI with Excel (game-changer), and speed up projects with handy Copilot tips.
Save your spot today before these last few spots disappear!


3 Easy Brain-Boosting Habits š§
Here at Miss Excel, weāre big fans of AI.
Honestly, I wish Iād had it growing up! I couldāve saved hours if AI had been around to handle my tedious Excel tasks, brainstorm PowerPoint openers, and craft that (very) delicate email to my professor asking for an extension. š
Butā¦as amazing as AI is, it canāt replace your brain. Itās here to support it. Think of it like this: AI is the tool, but youāre still the one using the tool. And like any muscle, your brain needs regular exercise to stay strong.
So how do we stay cognitively fit while leveraging AI? Here are three of my favorite brain-boosting habits:
Take notes by hand on what you consume. š
Whether itās a client meeting, book, or 10-page report, write notes before AI summarizes the whole thing. Why? Because writing by hand helps you better understand and remember the material.
Write more. šļø
As the saying goes, āwriting is thinking.ā Writing is how you figure out what you want to say and stretch your brain. I write a first draft of everythingāfrom a client email to Instagram captionābefore letting ChatGPT polish.
Play brain games. š§©
Wordle. Sudoku. Puzzles. These games train pattern recognition, problem-solving, and critical thinking. I do Wordle every morning with my chai tea. Itās only five minutes but I can literally feel my brain sweat.
AI isnāt going anywhere, and it really will improve our work lives. But to squeeze every bit of value from it? Keep learning (like by coming to a free AI and Excel class š) and keep your brain sharp. Thatās how you become unstoppable.


- Powerpoint pros share the one trick they wish they knew sooner. š 
- How to use ChatGPT to get rid of blank spaces in under 30 seconds. 
- Tired of Pivot Tables? Let Excel do the heavy lifting for you. šŖ 
- Watch this if you never want to manually compare lists in Excel again. 
- āBrilliantly helpful,ā says a comment on my custom calendar views video! š 


Thanks for reading! Hopefully this (spooky) scenario doesnāt happen to you before the week is over. š
Stay Exceling,
Kat




