Sommige informatie wordt in het Engels weergegeven.
Over mij
Microsoft Excel
VLOOKUP, XLOOKUP (concepts)
INDEX & MATCH
IF, IFS, COUNTIF, SUMIF, SUMIFS
Text Functions (LEFT, RIGHT, MID, TRIM, REPLACE, etc.)
Date & Time Functions
Pivot Tables & Pivot Charts
Dashboards
Data Cleaning & Conditional Formatting
SQL (PostgreSQL)
SELECT, WHERE, ORDER BY
GROUP BY, HAVING
JOINS
Aggregate Functions
CASE
INSERT, UPDATE, DELETE
UNION & UNION ALL
Basic Database Management
Data Analysis
Data Cleaning
Business Insights
Report Preparation
KPI Analysis... Lees meer