You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Integrated customer and product data in Excel's orders worksheet using INDEX, MATCH, and IF functions with absolute referencing. The project showcased adept Excel skills, featuring dynamic pivot tables and an interactive dashboard with timeline filters for insightful coffee sales analytics.
Store marketing campaign data is used to create an excel dashboard and to use insights from it to identify the age group that maximizes the sales revenue.
These files contain different uses of excel Formule and functions like statistical, logical, conditional, absolute reference, relative reference, Vlookup, Hlookup, Index_Match ETC.