[Using Excel] If you don't know, it's a loss! Can you make a narrowing button ✨

Other posts from here 💁‍♀️

@ yui _ exel _ work

Refine the data,

It will be very easy ✨

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

◆ Useful way to narrow down the data in the table ◆

< Table >

① Select all tables with [Ctrl + A]

Press [Ctrl + T] and press [OK].

It's about converting table data into a form that Excel can easily manage 💡

After tabling,

✔ each row is colored

✔ filter attached automatically

✔ data is added, the range automatically expands

The table will be much easier to handle ✨

< Slicer >

① Select all tables with [Ctrl + A]

② Press [Alt → N → S → F] in order

③ Check the item you want to create (department, base name, etc.) and press [OK]

The slicer is...

At the click of a button

It is a function to narrow down data 💡

For example, if the sales table for each department,

[Sales Department]

[General Affairs Department]

[Accounting Department]

A button like this is displayed on the screen,

Just click on the department you want to see

Only that data can be displayed 😊✨

You don't have to open the filter ▼ every time,

Because you can see the options and narrowing status at a glance,

It makes checking and aggregating data much easier ❤

─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─ ─

Please "Like ❤️" and "Save 🔖" if you like 😊

Please feel free to comment and DM 🌸

Excel technique to make work a little easier 📊

Follow here → @ yui _ exel _ work

# excel # Excel # excel _ time # Excel Time Shortener # excel _ beginner