Top Tweets for #25daysofexcel
For the first time ๐ One of the reasons I decided to do a #25daysofexcel was to increase my confidence when applying for excel-related jobs, and it sure helped.
Day 25 of #25daysofexcel ๐ฅน
I analyzed a dataset today and created a dashboard with excel. Notably, my first completed unguided dashboard with Microsoft Excel ๐ซฃ
Dataset was gotten from this weekโs @datafrik_co #yearofdata challenge.
Day 24 of #25daysofexcel
I continued with DAX measures. For example the calculate function and time intelligence functions such as same period last year. These two functions were used to create the chart below.
Day 23 of #25daysofexcel
I learnt about power pivot, importing data into it, modeling data, analyzing data with power pivot, visualizing with cube functions and a brief introduction to DAX measures.
Day 22 of #25daysofexcel
Power query continued. I learnt how to clean, organize and analyze data using features such as replace values, spilt column, pivot/unpivot columns, group by, change data types, remove duplicates, add custom column/column from examples and so on.
Day 21 of #25daysofexcel
Till the end of this challenge, Iโll be looking into excel power tools. I started with Power Query today and revisited how to get and transform data from excel/database/folder/pdf. Also appended and merged queries in the power query editor.
Day 18 of #25daysofexcel
I revised the basics of dashboard planning and layout in excel. A few top tips for creating dashboards ๐๐พ
- Start with a clear goal
- Make use of appropriate metrics/KPIs
- Context matters
- Use the right visualization
Day 17 of #25daysofexcel
I created pivot tables and charts to answer questions from a sample data on the properties sold at auction for 2017 and 2018 in Melbourne, Australia.
Day 16 of #25daysofexcel
I continued with pivot tables by learning to group and sort pivot data, filter pivot data and perform calculations in pivots.
Day 15 of #25daysofexcel
I revised how to summarize data with pivot tables and how to customize pivot tables.
Day 14 of #25daysofexcel
Todayโs practice challenge was to create specialized charts using the sales report of a car retailer.
What type of charts can you identify?๐ฎโ๐จ
What I did Sample solution
Day 13 of #25daysofexcel
I continued with learning more specialized charts in excel. Created an interactive map chart and custom charts like a population chart and a gauge chart animated with macros.
The three charts are in the video ๐๐พ
Day 12 of #25daysofexcel
I delved into creating specialized charts in excel today. The likes of hierarchical charts (sunburst and treemaps), waterfall charts and funnel charts.
Day 11 of #25daysofexcel
Todayโs practice challenge was to create a range of visualizations using the different provided datasets on covid-19.
What I did Sample solution
Day 10 of #25daysofexcel. Today, I continued mastering chart techniques in excel. I practiced the use of area charts, scatter and bubble charts.
Day 9 of #25daysofexcel. I practiced creating line charts in excel and also use trendlines to forecast the data to a future date.
Day 8 of my #25daysofexcel
I created a tracker using a doughnut chart in excel. With the tracker, the % improvement in energy intensity of primary energy can be visualized for each country and across years.
Day 7 of #25daysofexcel
What I did today was to practice data viz using conditional formatting, macros, sparklines and custom number formats. The data is a service desk data and I created visuals for the trend in calls and satisfaction for each agent using sparklinesโฆ
Last Seen Hashtags on Sotwe
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.2M followers
Narendra Modi
@narendramodi
107M followers
Rihanna
@rihanna
97.8M followers
NASA
@nasa
92.2M followers
Justin Bieber
@justinbieber
91M followers
KATY PERRY
@katyperry
88M followers
Taylor Swift
@taylorswift13
81.8M followers
Lady Gaga
@ladygaga
73.3M followers
Virat Kohli
@imvkohli
70.4M followers
Kim Kardashian
@kimkardashian
69.9M followers
YouTube
@youtube
68.7M followers
Bill Gates
@billgates
64.1M followers
Neymar Jr
@neymarjr
63.2M followers
The Ellen Show
@theellenshow
62.4M followers
CNN
@cnn
61.9M followers
Selena Gomez
@selenagomez
61M followers
X
@x
60.8M followers