AiSolutionPK | Excel + SQL Data Analyst

Excel + SQL Data Analyst

Learn Microsoft Excel and SQL from basics to advanced level, covering data analysis, pivot tables, functions, and real-world database queries.

Duration: 6 weeks

E+S

Excel Basics: Learn worksheet navigation, data entry, formatting, and custom number formats for clean data presentation.
Functions & Formulas: Master SUM, AVERAGE, IF, VLOOKUP, INDEX, MATCH, and nested formulas to automate calculations.
Data Validation & Tables: Apply validation rules, structured references, and dynamic tables to manage large datasets.
Charts & Visualization: Create bar, line, pie, and combo charts to represent data insights effectively.
PivotTables & Advanced Features: Summarize and analyze data with PivotTables, PivotCharts, and slicers.
SQL Basics: Introduction to relational databases, SELECT queries, filtering with WHERE, and ordering data with ORDER BY.
Intermediate SQL: Learn JOINs (INNER, LEFT, RIGHT), GROUP BY with HAVING, and aggregate functions like COUNT and SUM.
Advanced SQL in Context: Apply subqueries, text/numeric functions, and export SQL results to Excel for combined analysis.