Day 3 of relearning Excel π
Today, I learnt essential Excel formulas and how to properly use COUNTIFS, SUMIFS, AVERAGEIF, MAX, MIN, LARGE, MAXIFS and MINIFS.
I also learnt about nesting: passing the output of one formula into another. CHOOSECOLS can also be used for this.
#X
1
12
When using multiple conditions, start each condition with a bracket and always multiply it by the next condition.
You can also hardcode a condition or link it to a cell and use it as the input cell.
#Excel #DataAnalytics #OtiiTheAnalyst
10
Day 2 of relearning Excel: Power Query.
Power Query is a software for data cleaning and data transformation. Its options are in the Data ribbon.
I now understand better how to clean messy data with less stress. More in the comments π
#Excel #PowerQuery #DataAnalytics
3
54
Hello, X! π
I'm Clara, a Data Analyst passionate about turning data into insights and helping businesses make better decisions.
I'll document my progress as I learn and relearn.
I'm open to connecting and learning from y'all.
#DataAnalytics #OtiiTheAnalyst #Anticipate
1
2
45
When people call me manipulative I keep quiet..
Because I know how well I manipulate datasets using power query π...@DabereNnamani
#DataAnalytics #relatable
1
39
My first proper Python assignment π
It wasn't as easy as I thought π but I figured it out one step at a time.
Not me finally getting the hang of this, I guess the learning is finally starting to show π₯Ή
#Python #DataAnalytics
1
5
72
My little proof of progress in what Iβve been learning and building so far. πβ¨
#DataAnalyst #ProgressJourney
Building my skills as a Data Analyst π
Iβve been learning SQL and getting hands-on with querying datasets to turn raw data into insights.
Grateful to @Betechified for the learning opportunity. Still learning, building & growing. π»β¨
#SQL #DataAnalytics #LearningInPublic
1
5
127


