Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:

#excel #exceltips #exceltricks #exceltutorials #excelformulas
1. Prevent Duplicate Data Entries in Excel with Custom Data Validation
youtube.com/shorts/oOgZLxB…
2. Make Budgets with spending limits in Excel
youtube.com/shorts/6kw8_ba…
3. Multi-column data validation lists
pakaccountants.com/multiple-colum…
4. Excel Data validation lists without blanks
youtube.com/shorts/iSPlI8i…
5. Shrinkable data validation lists
youtube.com/shorts/m4_RTds…
6. Searchable data validation lists
youtube.com/shorts/0pHOX_q…
7. Data validation lists without duplicates from duplicate data
youtube.com/shorts/z-Ok5hS…
8. Dynamic dependent data validation lists
youtube.com/shorts/TkrGq7S…
9. Make your first data validation list QUICKLY!
youtube.com/shorts/pM2I9qR…
10. Make data validation lists manually
youtube.com/shorts/tXOovKn…
Subscribe: bit.ly/3z2rzRw for daily #Excel tips

Don't forget to follow @exceltoexcel on twitter

• • •

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 10, 2022
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…
Read 11 tweets
Dec 3, 2022
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, 2022
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, 2022
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, 2022
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, 2022
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

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!

:(