Relearning Excel | Day 6 π
Today's topic was Sales Analysis using Excel formulas.
I learned how to:
1. Extract unique values using UNIQUE.
2. Calculate sales based on conditions using SUMIFS.
3. Compare sales across countries.
#Excel#DataAnalysis#OtiiTheAnalyst
1. Conditional Formatting highlights important values using rules, colour scales, data bars and icons. It helps spot duplicates, unusual values and a lot more.
2. Pivot Tables summarise data using Rows, Columns, Values and Filters, making comparisons and calculations easier.
Today's Day 5 of relearning Excel. π
Today's topic was Conditional Formatting and Pivot Tables for EDA.
I learned how these tools help us explore datasets, identify patterns, highlight unusual values and summarise data to generate insights.
A few things to remember ππ»
#Excel
5 months into learning data analytics, and I'm still learning and relearning.
I guess learning never really ends!
Thank you, @DabereNnamani , for a wonderful webinar. I learned more about cold pitching, AI strategy and leveraging AI, among other interesting topics.
Day 4 of Relearning Excel
Today's topic was Excel Pivot Tables.
A few things I learned:
1. They summarise large datasets without writing formulas.
2. They help uncover insights and create reports.
3. They can be refreshed and customised.
#RelearningExcel#Excel#DataAnalysis
Moving to EDA (Exploratory Data Analysis).
It helps in exploring datasets, identifying patterns and discovering trends in the data.
Things to study while conducting EDA:
1. Missing values
2. Duplicates
3. Unusual values
4. Patterns
5. Distribution
Relearning Excel | Day 5 π
Today's topics were Descriptive Statistics and EDA.
Descriptive Statistics is summarising a dataset and understanding its characteristics using numerical measurements.
Key measurements:
1. Mean (Average)
2. Median
3. Minimum & Maximum
4. Range
#XL
A few things to do before using Pivot Table
1. Ensure your data is properly organised.
2. Every column must have a header.
3. Avoid empty rows and columns.
4. Remove total and subtotal rows from your source data.
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
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
Cleaning steps I practised:
β’ Remove symbols: Select column > Replace Values; replace the unwanted symbol with a blank.
β’ Fill blanks: Transform > Fill > Down copies the value above into empty cells.
β’ Set headers: Home > Use First Row as Headers.
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
Power Query can be used in different ways:
1. Web scraping: Connecting to a website to retrieve data from a webpage.
2. Business data: Connecting to a local file or network location to retrieve data.