Excel FILTER Function is now my FAVOURITE function
Here are NINE examples how FILTER function has simplified super complex tasks for us!

#excel #learnexcel #excelfunctions #exceltips #exceltricks #office365 #excel365
1. How to use FILTER Function to filter data dynamically
youtube.com/shorts/AwKsb5V…
2. Find common values between two lists or columns
youtube.com/shorts/HlF72AH…
3. FILTER function with wildcards for partial match
youtube.com/shorts/RXm_YmH…
4. Filter non-adjacent columns with FILTER Function
youtube.com/shorts/aGLfHkY…
5. Use FITLER function with multiple AND / OR Criteria
youtube.com/shorts/a_zExgP…
6. Searchable Excel Drop down lists
youtube.com/shorts/0pHOX_q…
7. Excel Drop down lists without blanks
youtube.com/shorts/iSPlI8i…
8. Hide used or already selected item from Drop down
youtube.com/shorts/m4_RTds…
9. Compare two columns to find and return differences
youtube.com/shorts/5kLod2-…
Subscribe: bit.ly/3z2rzRw for daily #Excel tips

Don't forget to follow
@exceltoexcel

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Learn Excel to excel

Learn Excel to excel Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @exceltoexcel

Dec 3
5 Excel Drop-down List Tutorials [Beginner to Pro]
How to make drop-down list MANUALLY in Excel
[Achievement Level: Even a kid can do it!]
youtube.com/shorts/tXOovKn…
How to make drop-down list from data range in Excel
[Achievement Level: Excel Learner]
youtube.com/shorts/pM2I9qR…
Read 7 tweets
Dec 3
7 *IMPOSSIBLE* looking Excel / GSheets tricks that are POSSIBLE!
#excel #learnexcel #exceltips #exceltricks #office365 #excel365
Attendance Sheet with Checkboxes in GSheets
youtube.com/shorts/M6YLt7Y…
Advance Attendance Sheet in Excel
[With Overtime, Paid Leaves, Half day calculations]
youtube.com/shorts/PsXIdQI…
Read 9 tweets
Nov 26
8 *NEW* Excel Functions that are changing the game!
#excel #learnexcel #excetricks #exceltips
1. UNIQUE Function
- Use UNIQUE Function to remove duplicates: youtube.com/shorts/xgf4Zps…
- Drop-down lists without duplicates: youtube.com/shorts/z-Ok5hS…
- Combine/merge multiple lists without duplicates: youtube.com/shorts/l8ObRSG…
2. FILTER Function
- Use FILTER Function to filter data: youtube.com/shorts/AwKsb5V…
- Find common values between lists: youtube.com/shorts/HlF72AH…
- Use FILTER with AND / OR Criteria: youtube.com/shorts/a_zExgP…
- Select and Filter Multiple non-adjacent Columns: youtube.com/shorts/aGLfHkY…
Read 9 tweets
Nov 20
5 must-know Excel skills
#excel #learnexcel #exceltricks #exceltips
1. Learn keyboard + mouse shortcuts:
- Ctrl + E [Flash Fill]:
youtube.com/shorts/uzPo_CP…
- Ctrl + = [Auto Sum]:
youtube.com/shorts/feldd-P…
- Rearrange columns quickly:
youtube.com/shorts/bvUhr1A…
- ALT + O + A [Quick format]:
youtube.com/shorts/HHFTv2f…
2. Make drop-down lists in Excel:
- Make lists manually:
youtube.com/shorts/tXOovKn…
- Make lists from data:
youtube.com/shorts/pM2I9qR…
- Dependent drop-down lists:
youtube.com/shorts/TkrGq7S…
Read 7 tweets
Nov 19
8 must-know Excel Chart designs and tricks
#excel #excelcharts
Add Target Line in Excel Charts
youtube.com/shorts/6G2PbXB…
Make Actual vs Target Charts in Excel
youtube.com/shorts/TjZW_8J…
Read 10 tweets
Nov 12
9 must-know Excel SUM Functions Tricks
#excel
1. Excel DSUM Function
youtube.com/shorts/x5yIV8Q…
2. VLOOKUP + SUM Functions
youtube.com/shorts/I12zVxg…
Read 11 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

:(