Top Tweets for #LearnWithDD
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.
To insert a new column, place your cursor on the row which you want to create a new column beside and right click. When the options pop up, click on the "insert" option. A new row will come up.
The same rule applies for a new column.
#LearnwithDD #7daysExcel #Digitaleydrive.
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
My first video drum course goes live on the @graphyapp tonight at 12am, registrations are open so block your seat soon ππ»https://t.co/yqhCwqnw1z
#LearnwithDD #DrumTutorials #GraphybyUnacademy #DarshanDoshiOnlineLessons
Last Seen Hashtags on Sotwe
NoLimit()
Seen from United States
nolimit() +filter:native_video
MallardMonday
Seen from United States
helevier helena
Seen from Italy
horsed
Seen from Brazil
editbugil
Seen from Indonesia
k9θ°ζ
Seen from Korea
μΉμ
Seen from Singapore
Hairy
Seen from France
ΨͺΨ§ΩΨ¬ΩΩΨ§ΩΩ
Seen from Netherlands
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