DEV Community

Ramya .C
Ramya .C

Posted on

Day 28 of My Data Analytics Journey !

Today was a special day in my learning journey — I got the opportunity to take a seminar session on Microsoft Excel for my batch late joiners. Teaching others really helped me to strengthen my own understanding of the fundamentals.

Key Topics I Covered

Excel Ribbon → Different tabs and their role in organizing commands.

Toolbar & Tool Groups → How Excel groups related tools for quick access.

Formulas & Functions → Understanding how to use formulas efficiently.

Basic Shortcuts → Time-saving tips for working faster in Excel.


Formulas I Taught

SUM() → Add a range of numbers.

COUNT() → Count numeric values in a range.

COUNTIF() → Count based on a specific condition.

AVERAGE() → Find the mean of values.

MAX() / MIN() → Identify highest and lowest values.

Extra Insights I Shared

Why Excel is considered the foundation of data analytics.

Real-life examples of how formulas like COUNTIF and AVERAGE are used in business decision-making.

Importance of practicing Excel regularly to build confidence before diving into advanced analytics tools like SQL, Power BI, or Python.

My Takeaway

Explaining concepts to others gave me more clarity and boosted my confidence. I realized that teaching is one of the best ways to learn.

Top comments (0)