3 Feb 2024
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.
3
1
17
523
3 Feb 2024
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.
3
5
19
781
2 Feb 2024
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.
6
12
395
1 Feb 2024
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.
3
16
446
31 Jan 2024
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.
2
8
313
30 Jan 2024
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.
4
10
403
27 Jan 2024
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
1
5
10
358
26 Jan 2024
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.
5
13
349
25 Jan 2024
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.
1
2
4
264
23 Jan 2024
Day 15 of #25daysofexcel
I revised how to summarize data with pivot tables and how to customize pivot tables.
3
12
323
22 Jan 2024
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
1
4
13
421
21 Jan 2024
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 👇🏾
8
20
526
20 Jan 2024
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.
ALT Sunburst chart
ALT Treemap chart
ALT Waterfall chart
ALT Funnel chart
7
15
556
19 Jan 2024
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
2
2
8
443
17 Jan 2024
Day 10 of #25daysofexcel. Today, I continued mastering chart techniques in excel. I practiced the use of area charts, scatter and bubble charts.
3
8
257
16 Jan 2024
Day 9 of #25daysofexcel. I practiced creating line charts in excel and also use trendlines to forecast the data to a future date.
5
13
498
14 Jan 2024
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.
10
18
619
13 Jan 2024
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…
1
3
6
366