Professional Excel training workbook covering 57 formulas — Text, Lookup, Statistical, Financial, Logic, and Math formulas with real-world examples
-
Updated
Apr 26, 2026
Professional Excel training workbook covering 57 formulas — Text, Lookup, Statistical, Financial, Logic, and Math formulas with real-world examples
Comprehensive financial analysis of customer invoices built with Excel. Utilizes formulas (SUMIFS, COUNTIFS), pivot tables, and a range of charts (Pie, Bar, and Scatter) to assess payment delays and evaluate revenue concentration risk.
Interactive Excel Dashboard analyzing Sales & Profit trends using SUMIFS, Combo Box, and Dynamic Charts.
Kumpulan proyek data yang saya kerjakan secara profesional. Beberapa data disamarkan dan dimodifikasi untuk alasan privasi. Repository ini menampilkan pendekatan analisis, workflow, dan insight yang digunakan. | A collection of professional data projects with anonymized data, focusing on analysis workflow and insights.
Practicing essential Excel analyst formulas like CONCATENATE, RIGHT LEFT MID, IFERROR, SUMIFS, INDEX, SUMIFS, SEQUENCE, EDATE, and more for data analysis tasks.
Analyze 6 months of sales data (May-Oct 2025) for an Indian electronics company to identify trends, top products, and regional performance.
Practicing key Excel formulas to analyze job salary data using general, math, and statistical functions for data analyst learning.
Excel - Data Cleaning, updation, pivot tables and charts
Add a description, image, and links to the sumifs topic page so that developers can more easily learn about it.
To associate your repository with the sumifs topic, visit your repo's landing page and select "manage topics."