countifs

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

An interactive Excel dashboard that analyzes 4 years (2022-2025) of ecommerce sales data, covering revenue, quantity, orders, customer ratings and delivery performance, with Year and Quarter filters.

Excel-based Sales Operations Analytics project using lookup functions, data cleaning, conditional aggregation, PivotTables, and advanced formulas to analyze sales performance and business data.

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

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 Sales Operations Analytics project using lookup functions, data cleaning, conditional aggregation, PivotTables, and advanced formulas to analyze sales performance and business data.

attendance tracker using MS Excel

Perform element-wise evaluation of one or more input arrays according to provided predicate functions and count the number of elements for which all predicates respectively return `true`.