Skills and Certifications
Data Analysis & Visualization Tools
Microsoft Excel Course for Data & Business Analytics
[Verfication link]
Comprehensive course from Tutorials Point (Completed April 2024)
- Basics: Tables, Named Ranges, Data Types, Error Handling
- Essentials: Filtering, Sorting, Data Validation, Conditional Logic, Nesting
- Lookup Functions: VLOOKUP, INDEX/MATCH, XLOOKUP
- Advanced Functions: INDIRECT, OFFSET, Dynamic Arrays
- What-If Analysis: Data Table, Goal Seek, Scenario Manager
- Statistical Analysis: Linear Regression, Trend Analysis
- Data Storytelling: Communicating Insights with Data
- Excel Charts: Creating and Customizing Charts for Effective Visualization
- Pivot Tables: Creating Dashboards and Advanced Techniques
- Modern Excel: DAX, Power Query, Power Pivot
- Dashboard Reporting: Designing Informative and Interactive Dashboards
- Advanced Excel: Real-world Scenario Examples and Problem Solving
Data Analysis in Excel
[View certificate]Comprehensive course on Data Analysis with Excel | Making actionable insights and predictions from business data | Uncovering hidden patterns | Mastering pivot tables| Transforming raw data into business knowledge | Case Study: | (Data Camp 2024)
Data Preparation in Excel
[View certificate]Prepare and clean raw data | Import data from different sources | Prepare data by filtering, deduping, and organizing columns and rows | Manipulating dates and text strings | Logical functions and nested formulas | Lookup functions: VLOOKUP, HLOOKUP, INDEX and MATCH , XLOOKUP | Using and PivotTables (Data Camp 2023)
