Learn Excel to excel

Follow @exceltoexcel

Dec 3 • 9 tweets • 4 min read

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…

Dynamic Monthly Calendar in Excel
youtube.com/shorts/h80IXkR…

Dynamic Yearly Calendar in Excel
youtube.com/shorts/SbKgLB6…

Gantt Charts in Excel
youtube.com/shorts/3qcBcBz…

Generate Barcodes in Excel
youtube.com/shorts/_BYL6VO…

Phone to WhatsApp link in Excel
youtube.com/shorts/PBIQNAC…

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

　

This Thread may be Removed Anytime!

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

More from @exceltoexcel

Learn Excel to excel

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…

Learn Excel to excel

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…

Learn Excel to excel

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…

Learn Excel to excel

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…

Learn Excel to excel

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…

Learn Excel to excel

Nov 5

7 must know Advanced Excel VLOOKUP Tricks
#excel #vlookup

1. 3D VLOOKUP
youtube.com/shorts/sDOja2t…

2. Case-sensitive VLOOKUP
youtube.com/shorts/TnxN0sj…

Follow Us on Twitter!