EXCEL FEATURES | BI & AI Telegram 帖子

🌟 Discover Your Potential with a Complimentary Excel VBA Course! 🚀
Ready to elevate your Excel skills with VBA mastery?

Check out these links for free Excel VBA courses to unlock the secrets of task automation, powerful macros creation, and workflow optimization!

1) https://www.simplilearn.com/free-excel-macros-vba-course-skillup
2) https://www.mygreatlearning.com/vba/free-courses

Don't miss this opportunity to supercharge your Excel abilities!
🎓💼 #ExcelVBA #LearnWithUs

💡 Why XLOOKUP function is better than VLOOKUP?

Check out this video ⬇️

https://youtube.com/shorts/SVk3tYzh-Kc?si=CxpT1e8opLBteeRQ

💡Excel for Data Analytics- Full Course from Beginner Level to Advanced


You will learn from basics Excel to advanced formulas, during the course you will finalize the following:

Project #1 - Salary Dashboard

PivotTables

Advanced Data Analysis

Power Query

M Language
Power Pivot / DAX

Project #2 - Salary Analysis

Here is the link below ⬇️
https://youtu.be/pCJ15nGFgVg?si=En0rvxjhkuO3TWvX

💡SUM + XLOOKUP COMBO
Manually adding numbers again?
Your data should work for you, not the other way around.

- Tedious, repetitive clicks
- Errors hiding in formulas
- Wasted minutes, every time

That changes now.

SUM + XLOOKUP = one step, done.

- Finds numbers for you
- Sums instantly, less effort
- Accurate, every single time

Big time-saver, zero frustration.

If you are struggling to master Excel for business analysis 👇

https://youtube.com/shorts/iRMn6XTHB4o?si=w_BRYaP1_HhTSdQu

💡Copilot in Excel Tutorial in 1 minute ⬇️
This micro-learning tutorial will teach you the features and capabilities of microsoft copilot in Microsoft Excel. Al is a great way to get data insights and learn how to do basic formulas in function in Excel.
The features are: Analyze data, Highlights data trends and analysis, Sort and filter data and also create a formula column.
Microsoft Copilot is the artificial

https://youtube.com/shorts/sDV0oltxf6o?si=uAyVGCDCwnf3EVKo

🚀 Unlock these 5 Microsoft Copilot features ⬇️


https://youtube.com/shorts/BWbBt80keO0?si=VPjTyGn5hi9DyNZu

💡 New Excel features that will set you apart in 2025 ⬇️

TIMESTAMPS
ニニニニニニニニニニニニニニ
0:00 New Excel feature Nº1 Checkboxes
3:30 New Excel feature N°2
Copilot
5:32 New Excel feature Nº3
Scan function
7:37 New Excel feature Nº4
Trimrange
10:17 New Excel feature N°5
Navigating
11:00 More new Excel features


https://youtu.be/obYrPnTxBxU

💡Column to Rows in Seconds.
To convert a column into rows in Excel, you can use the "Transpose" feature. Here's how you can do it:

1. Copy the column you want to convert.
2. Right-click on the cell where you want to paste the transposed data.
3. Select "Paste Special."
4. Check the "Transpose" option.
5. Click "OK."

This will paste the column data as rows in the new location. Another option is to use the TRANSPOSE function in Excel. Here's how you can do it:

1. Select the same number of cells in rows as the column you want to convert.
2. Enter the following formula: =TRANSPOSE(A1:A10) (Replace A1:A10 with your actual column range)
3. Press Ctrl + Shift + Enter to confirm the formula (as it's an array formula).

These methods should help you convert a column into rows in Excel quickly and efficiently.

Or just check out this video ⬇️

https://youtube.com/shorts/_DBsUujCoto?si=DUpb3Saqdc_fplwD

💡What If Excel Could Write Formulas For You?
In this video David Fortin shows you what Copilot in Excel can do.
00:15 - Write an Excel formula with Microsoft Copilot
04:43 - Sheetmatcher Sponsor
05:19 - Write Excel Formula without typing with Copilot in Excel
10:45 - Merge two lists with Copilot in Excel
XLOOKUP formula
14:50 - Write complex Excel Functions and Formulas with Copilot
17:03 - Learn more about Microsoft Copilot & Copilot in Excel
Check out this video ⬇️
https://youtu.be/wQY8STgqXy8

🔎 How to compare two sheets and find differences: several methods.
1. To highlight matching text data in two tables in Excel, you can use conditional formatting with a formula. Here's how you can set it up:

Assuming your tables are in columns A and B (left table in column A and right table in column B), starting from row 2, you can apply the following conditional formatting formula to the range in column A where your left table data is:

1. Select the range in column A where you want to apply the formatting.
2. Go to the "Home" tab in Excel.
3. Click on "Conditional Formatting" in the Styles group.
4. Select "New Rule."
5. Choose "Use a formula to determine which cells to format."
6. Enter the following formula:

 =ISNUMBER(MATCH(A2, $B:$B, 0))
 

This formula checks if the value in cell A2 exists in column B as text. If it does, the formula result will be true.

7. Click on the "Format" button, go to the "Fill" tab, and choose a green color.
8. Click "OK" to apply the formatting.
9. Click "OK" again to exit the Conditional Formatting Rules Manager.

This conditional formatting formula will color the cells in the left table that have matching text values in the right table in green.

2. Check out this video ⬇️
https://youtu.be/nrDOQ_VDmQA?si=nt94oulK6YnWOwvJ