Thread Reader
Share this page!
×
Tweet
Share
Email
Learn Excel to excel
Follow @exceltoexcel
Learn #Excel, #GoogleSheets with Daily #Office Tips Excel | Sheets Tips, Tricks, Tutorials, Lessons, and much more
Add to My Authors
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…
Jan 21
•
12 tweets
•
5 min read
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…
Dec 10, 2022
•
11 tweets
•
5 min read
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…
Dec 3, 2022
•
7 tweets
•
2 min read
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…
Dec 3, 2022
•
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…
Nov 26, 2022
•
9 tweets
•
6 min read
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…
Nov 20, 2022
•
7 tweets
•
6 min read
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…
Nov 19, 2022
•
10 tweets
•
3 min read
8 must-know Excel Chart designs and tricks
#excel
#excelcharts
Add Target Line in Excel Charts
youtube.com/shorts/6G2PbXB…
Nov 12, 2022
•
11 tweets
•
3 min read
9 must-know Excel SUM Functions Tricks
#excel
1.
Excel DSUM Function
youtube.com/shorts/x5yIV8Q…
Nov 5, 2022
•
9 tweets
•
3 min read
7 must know Advanced Excel VLOOKUP Tricks
#excel
#vlookup
1.
3D VLOOKUP
youtube.com/shorts/sDOja2t…