sumifs

Professional Excel training workbook covering 57 formulas — Text, Lookup, Statistical, Financial, Logic, and Math formulas with real-world examples

Dashboard de vendas Xbox Game Pass em Excel: KPIs, SUMIFS e simulação de cenários | Xbox Game Pass sales dashboard in Excel

Excel data analysis: 400 simulated e-commerce orders in a 3-sheet workbook (Raw Data, Summary, Dashboard) - SUMIFS, INDEX/MATCH, dynamic charts, no macros

I will introduce some basic concepts of excel with practical and describe function

Comprehensive 3-month sales data analysis and dynamic summary dashboard built using advanced SUMIF and SUMIFS formulas in Microsoft Excel.

Analyze 6 months of sales data (May-Oct 2025) for an Indian electronics company to identify trends, top products, and regional performance.

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.

Excel-based analytics project solving business questions across orders, customers, and sales rep data using lookups, pivot tables, and advanced formulas.

Practicing essential Excel analyst formulas like CONCATENATE, RIGHT LEFT MID, IFERROR, SUMIFS, INDEX, SUMIFS, SEQUENCE, EDATE, and more for data analysis tasks.

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.

Interactive Excel Dashboard analyzing Sales & Profit trends using SUMIFS, Combo Box, and Dynamic Charts.

Excel - Data Cleaning, updation, pivot tables and charts

Practicing key Excel formulas to analyze job salary data using general, math, and statistical functions for data analyst learning.

Interactive Excel commercial cost reporting dashboard featuring budget reconciliation, variance analysis, KPI reporting and executive dashboards for a simulated civil engineering portfolio.