Course Description
Learn data analysis fundamentals, Excel, and basic SQL for business insights.
What You Will Learn
-
Excel for data analysis
-
Data cleaning
-
Basic statistics
-
Introduction to SQL
-
Data visualization basics
Technical Requirements
Course Syllabus
- Introduction to Excel interface and spreadsheet environment.
- Data entry and formatting − Conditional Formatting
- Basic formulas and functions − Logical Functions
- Pivot tables and charts
- Advanced formulas and conditional formatting
- Data validation and sorting techniques
- Introduction to VBA (Visual Basic for Applications)
- Macro creation and automation