Top Tweets for #7daysofExcel
NOTE: Both COUNT and COUNTA function will ignore empty cells.
I hope you have learnt.π€
#LearnwithDD #DigitaleyDrive #7daysofExcel
Excel is no longer a mysteryβitβs a powerful tool I now make use of like a pro.But this is just the beginning. Letβs keep learning, growing, and mastering new skills togetherππ₯
Thank you for following along! π
#LearnWithDD #DigitaleyDrive #7DaysOfExcel
PS: I do not own a right to this image, I downloaded it to give a pictorial representation of my explanation.
By the way, Happy International Women's Day. β€οΈ
#LearnwithDD #DigitaleyDrive #7daysofExcel.
2οΈβ£ PROPER: Capitalizes the first letter of each word.
- Example: If A2 = "oluwadara oladipupo", PROPER makes it "Oluwadara Oladipupo".
- Formula: =PROPER(A2)
Combine them for super clean text:
=PROPER(TRIM(A2))
learnwithDD #digitaleydrive #7daysofexcel
4. Paste Transpose
This option allows you to change the orientation of the copied data. If the data was in rows, it will be pasted into columns and if the data was in columns, it will be pasted into rows.
#LearnwithDD #DigitaleyDrive #7daysofExcel.
Using the formula:
`=TEXTJOIN(" ", TRUE, A2, B2, C2)`
The result will be:
Oladipupo Oluwadara Abigeal
#LearnWithDD #DigitaleyDrive #7DaysOfExcel
β¦ Click any cell in your data range.
β¦ Go to Insert and Select Timeline (under Tables).
β¦ Choose the date column you want to filter.
β¦ Click OK, then adjust the slider to explore your data by time!
#LearnWithDD #DigitalEyeDrive #7DaysOfExcel
πππ² π: πππ¬πππ«π’π§π ππ’π¦ππ₯π’π§π π
π’π₯πππ«π¬ π’π§ ππ±πππ₯
I learnt how to filter your data by date effortlessly using Timeline Filter in Excel.
And I'll show you! β¬οΈ
@Digitaleydrive SHORTCUT
After copying, press Alt + E + S + E (one after the other) to open Paste Special and check Transpose in a flash! β‘
This has been a timesaverβno more manual copy-pasting!π
#learnwithDD #digitaleydrive #7daysofexcel
*DAY 1*
How to un-hide your pivot table field list:
Right-click on any cell in your pivot table and select "show field list" on the context menu. Your Pivot table field list will appear on the right side of your screen.
#LearnwithDD #digitaleydrive #7daysofExcel
And just like that, the magic happens! β¨
Filters saved me hours todayβno more scrolling through endless rows! π₯
#learnwithDD #digitaleydrive #7daysofexcel
Last Seen Hashtags on Sotwe
souγγε₯½γγͺδΊΊγ¨ηΉγγγγ
Seen from United States
gacha18edit
Seen from Canada
omegle
Seen from United States
faraway
Seen from Italy
Ω
ΩΩΨ©
Seen from United Kingdom
ι²εΊ
Seen from Netherlands
MomSon filter:native_video
Seen from Germany
ometv
Seen from Germany
hslut
Seen from United States
η·ε
Seen from Indonesia
Trends for you
Most Popular Users
Elon Musk 
@elonmusk
240.8M followers
Barack Obama
@barackobama
119.2M followers
Donald J. Trump
@realdonaldtrump
111.7M followers
Cristiano Ronaldo
@cristiano
111.1M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.8M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91M followers
KATY PERRY
@katyperry
87.9M followers
Taylor Swift
@taylorswift13
81.8M followers
Lady Gaga
@ladygaga
73.3M followers
Virat Kohli
@imvkohli
70.3M followers
Kim Kardashian
@kimkardashian
69.9M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
64M followers
Neymar Jr
@neymarjr
63.1M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.9M followers
Selena Gomez
@selenagomez
61M followers
X
@x
60.8M followers