Introduction to Data Analysis
Introduction
Unlock the power of data with this beginner-friendly course designed to help you build a strong foundation in data analysis. You will learn how to organize and analyze data using Excel, apply essential mathematical operations, manipulate text efficiently, and perform conditional analysis to extract meaningful insights. Perfect for professionals, students, and anyone looking to enhance their analytical skills.
Tables
- Creating and formatting tables
- Sorting and filtering data
- Using structured references
Mathematical Operations
- Basic arithmetic functions
- Applying formulas for analysis
- Working with percentages and averages
Text Functions
- Combining and splitting text
- Using functions like LEFT, RIGHT, MID
- Cleaning and preparing text data
Conditional Analysis
- Applying IF statements
- Using conditional formatting
- Logical functions for decision-making
Curriculum
- 1 Section
- 4 Lessons
- 1 Week
Mohamed Yahia
Professional Summary
Mohamed Yahia is a Certified Management Accountant (CMA) and Microsoft/IBM-certified Data Analyst with 15+ years of corporate expertise in financial analysis, budgeting, and data-driven decision-making. As a Budget & Financial Analysis Manager at Telecom Egypt, he oversees multi-million-dollar budgets, designs executive dashboards, and transforms raw data into strategic insights using Power BI, Excel, and SQL.
A dedicated educator, Mohamed has 5+ years of training experience, teaching professionals to master financial modeling, Power BI visualization, and advanced Excel techniques. His unique blend of CMA expertise (Master’s in Accounting) and cutting-edge data certifications (Nanodegree, IBM, Microsoft) bridges the gap between finance and analytics.
Key Qualifications
• Power BI & Excel: 15+ years building dynamic reports, KPIs, and forecasting models.
• Certifications: Microsoft Certified: Power BI Data Analyst Associate | IBM Data Analyst Professional Certificate | Udacity Nanodegree.
• Taught 100+ professionals to pass CMA exams and deploy Power BI/Excel solutions.
• Winner of Telecom Egypt’s Leadership Award for data-driven presentations.
Education & Certifications
• Certified Management Accountant (CMA)
• Master’s in Accounting (Damanhour University)
• Microsoft Certified: Power BI Data Analyst Associate
• IBM Data Analyst Professional Certificate | Udacity Data Analyst Nanodegree
• IBM Data Analyst Professional Certificate
• Data Analyst Nano Degree.
Round 1
You might be interested in
-
Intermediate
-
Active
-
18 Students
-
16 lessons
-
Intermediate
-
Active
-
22 Students
-
13 lessons
-
Intermediate
-
Active
-
12 Students
-
4 lessons
-
Expert
-
Coming Soon
-
0 Students
-
12 lessons
Login with your site account
Not a member yet? Register now
Register a new account
Are you a member? Login now