Good day,
This week, let's cover a step-by-step example for how to use AI to successfully repair or update your macros in Excel!
Stop Fixing Excel Macros Manually (Do This Instead)
Can’t see the thumbnail? Click here to watch on YouTube
Funny Work-Humor Clip
A little office humor from us to start the week, courtesy of YouTube Shorts.
[Tiny Tip] Visual Filters for Tables (Slicers)
Slicers give you clickable buttons to filter your data, which are much faster and cleaner than dropdown filters.
Example
Imagine a table with Category, Product, Sales.
Instead of opening filter menus, just click Food, Clothing, or Electronics to instantly filter everything.
How to Add a Slicer
Click inside your table (data should be formatted as a Table)
Go to Table Design > Insert Slicer
Select the column by which you want to filter (e.g., Category)
Click OK
Move and resize the slicer so it fites nicely within your worksheet
Click a button to filter, or hold Ctrl to select multiple.
Notes
Slicers make your data interactive and easy to explore, which is perfect for reports, dashboards, or quickly showcasing data to others.
Courses
Cheers and see you next week!
Don