7 Jul 2025
โ
Day 11 of #100DaysOfExcel โ PQ Cleanup
Cleaned up the messy โCountryโ column in my Netflix data
๐น Split multiple countries into separate rows
โ ๏ธ Faced errors from blanks & nulls
๐ ๏ธ Fixed it using Advanced Editor filters
#PowerQuery #DataCleaning #NetflixData #ExcelTips
1
4
99
6 Jul 2025
๐ง Day 10 of #100DaysOfExcel โ Formula Check
Started using basic Excel formulas to scan my Netflix dataset.
Quick and effective โ data speaks when you ask the right questions. ๐ก
#ExcelTips #100DaysOfExcel #NetflixDataset #LearnExcel #DataCleaning
1
1
2
74
4 Jul 2025
๐ Day 9 of #100DaysOfExcel โ Data Inspection
Kicked off the cleaning phase of my Netflix dataset ๐
Explored the structure, scanned key columns, and got familiar with the data.
Smart analysis starts with smart inspection
#Excel #DataCleaning #NetflixDataset #LearningInPublic
1
1
4
95
22 Mar 2023
Did you know? The count function un Excel applys only with inputs that are numbers but not the text inputs
#caasitechacademy
#CDA
#100daysofexcel
5
66
1 Feb 2023
The best way to insert and manipulate date and Time in Excel is using the accurate data typea and thinking constructively
#caasitechacademy
#CDA
#100daysofexcel
3
48
25 Jan 2023
The most important in Excel is to work smart not hard look for tips to do the most in few steps. Today I learned the important of designing skills in Excel.
#caasitechacademy
#CDA
#100daysofexcel
6
50
25 Jan 2023
Day 6 of #100daysofexcelchallenge I just discovered that you can always pin your excel workbooks In an excel list
#100daysofexcel
#CDA
#caasitechacademy
4
56
24 Jan 2023
Knowing the pattern and how your business is moving especially knowing the product that sales best is very important.Tree map chart in excel provides a hierarchical view of your data and makes it easy to spot patterns. #caasitechacademy #100DaysOfexcel #CDA
5
67
24 Jan 2023
Day 5 of #100daysofexcel
Have you ever imagined yourself excelling at most things using Excel?
#CDA
#caasitechacademy
#excel
6
98
24 Jan 2023
Going through a course and practicing are night and day did you no you can unhide multiples sheets at once using custom view ?
#caasitechacademy
#CDA
#100daysofexcel
6
66
23 Jan 2023
Ever wonder how the foundation of a database is built? Well An entity-relationship diagram, or ER diagram, is essential for modeling the data stored in a database. It is the basic design upon which a database is built. #caasitechacademy #cda #100DaysOfexcel
10
120
23 Jan 2023
A macro is an action or a set of actions that can be repeated many times.
#caasitechacademy
#100daysofexcel
#CDA
6
69
20 Jan 2023
Today I relearned my very first notion in Excel the hard way that is make sure you save your work.
Also did you know you can not do every chart type with pivot tables?
#caasitechacademy
#CDA
#100daysofexcel
5
111
19 Jan 2023
Before you start to create a PivotTable you need to make sure you have a proper dataset. Which means:
- Each column has a header
- There are no empty columns in between
- There are no totals in the middle of the dataset.
#caasitechacademy
#100daysofexcel
#CDA
3
63
18 Jan 2023
Day 4 of #100daysofexcel
Your data could be #sorted from either ascending or descending order using sort command in an excel sheet.
#100daysofexcel
#caasitechacademy
#excel
6
152
16 Jan 2023
Day 3 of #100daysofexcel
Did you know that paste special could copy and #transpose(T) a table in an excel sheet?
#100daysofexcel
#caasitechacademy
#excel
7
148
9 Jan 2023
Day 2 of #100daysofexcel challenge๐ช๐ฟ
Did you know that paste special has different paste options, like paste values and others? follow for more on #100daysofexcelchallenge
#pastespecialinexcel
4
32
8 Jan 2023
I restarted Advance Excel 100daysofexcel Challenge starting today
#100daysofexcelchallenge
#excel
2
108
15 Dec 2022
Successfully created a pivot table but don't know how to display hidden part of the table, Slicers allow you to see which fields in the PivotTable are being shown and which are hidden.
#caasitechacademy
#100daysofexcel
#CDA
1
10
82
14 Dec 2022
Querying large amounts of data can sometime be frustrating but PivotTable gives you an interactive way to quickly summarize large amounts of data in many user-friendly ways.
#caasitechacademy
#100daysofexcel
#CDA
1
8