3 ways to automate your workflow in Excel
Excel has a plethora of automation possibilities. Whether it's formulas, Power Query, VBA, ribbon features, or keyboard shortcuts.
What isn't automation?
To become more productive, the more methods you know — the better.
Here are just three you should be aware of:
𝗧𝗮𝗯𝗹𝗲𝘀
You have a dataset you keep referring to as a table. Except…it's not. Official Excel tables are resizable data containers that have filter and sort capabilities.
Just select a cell in your data and press Ctrl + T to create one.
𝗙𝗹𝗮𝘀𝗵 𝗙𝗶𝗹𝗹
If you want to join together first and last names housed in separate columns, Flash Fill is your friend. It's an intelligent feature that spots patterns in your data.
Just input the first value you want to see in the adjacent column and press Ctrl + E. Voila!
𝗫𝗟𝗢𝗢𝗞𝗨𝗣
This function is commonly used for finding a value in one column and returning another from the corresponding row in a different column.
Just provide the function with a 𝚕𝚘𝚘𝚔𝚞𝚙_𝚟𝚊𝚕𝚞𝚎, 𝚕𝚘𝚘𝚔𝚞𝚙_𝚛𝚊𝚗𝚐𝚎, and 𝚛𝚎𝚝𝚞𝚛𝚗_𝚊𝚛𝚛𝚊𝚢!
What are your favourite Excel automation methods?
---
The Global Excel Summit 2023 takes place on 6–8 February. To see our full agenda, go to https://lnkd.in/er3ZEkkG.
#ExcelerationThursdays #excel #microsoftexcel #globalexcelsummit
Global Excel Summit Socials:
🌐: Website: https://globalexcelsummit.com/
🟦: Facebook: / globalexcelsummit
🐤: Twitter: / excelsummit
📸: Instagram: / globalexcelsummit
👔: LinkedIn: / global-excel-summit
The Global Excel Summit is the world’s largest virtual gathering of Microsoft Excel users, pros and industry experts. It's time to become Excel(lent). Learn more about our event by visiting our official website. 👇
https://globalexcelsummit.com/