Share this page!

Learn Excel to excel Profile picture
Twitter logo
Jan 28 • 17 tweets • 5 min read
Learn to work with Date and Time in Excel like a PRO with these tutorials:
1. Make Dynamic Yearly Calendar in Excel
youtube.com/shorts/SbKgLB6…
2. Make Dynamic Monthly Calendar in Excel
youtube.com/shorts/h80IXkR…
3. Calculate Age in Excel
youtube.com/shorts/0uxJccN…
4. Calculate Difference between Two Dates in Excel: Get Number of Years Months Days
youtube.com/shorts/GjT7gGe…
5. Calculate Expiry Date or Due Date in Excel
youtube.com/shorts/D8ljowM…
6. Calculate Quarters from dates in Excel
youtube.com/shorts/-Ro7zkO…
7. Calculate Working Days between two Dates in Excel: Find Workdays Excluding Holidays & Weekends
youtube.com/shorts/aT3ccWF…
8. Count Dates by Weekdays in Excel: Count Day of Week in list of Dates with Excel Formula: Best Method
youtube.com/shorts/8sm7C7F…
9. Count Dates by Year in Excel in the list of dates
youtube.com/shorts/PwAS3JI…
10. Count Specific Day / Days of Week between two dates in Excel: Count Saturdays Sundays Fridays Monday
youtube.com/shorts/snOnieC…
11. Count Weekends Between Two Dates in Excel - Count Total number of Weekend Days
youtube.com/shorts/P-OGrJD…
12. Format dates in Excel to get Day name Month name and Year numbers from dates
youtube.com/shorts/iZFsqua…
13. Find Month Name from the Date Value in Excel using Formula
youtube.com/shorts/cCRRdm9…
14. How to Convert Date to Fiscal Year Quarter in Excel
youtube.com/shorts/nHKyni7…
15. How to List or Fill Weekdays or Weekends Only Dates in Excel
youtube.com/shorts/qmdZ4Wf…
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

Learn Excel to excel Profile picture
Jan 21
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…
Read 12 tweets
Learn Excel to excel Profile picture
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
Learn Excel to excel Profile picture
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
Learn Excel to excel Profile picture
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
Learn Excel to excel Profile picture
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
Learn Excel to excel Profile picture
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

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!

Send Email!

:(