This dashboard tracks headcount, attrition, open positions and time to hire, along with the hiring funnel and the age distribution of employees.
#Excel #MicrosoftExcel #DataAnalysis #DataAnalytics #Spreadsheets #ExcelExpert #Freelance#HRAnalytics #PeopleAnalytics
I built an order entry form with dropdown lists, rules for quantity and date, and clear error messages. It uses xlookup to fill in product name, category and price automatically, so users make fewer mistakes and enter less by hand.
#DataValidation #XLOOKUP #Excel #ExcelFormulas...
I took a raw customer orders sheet with extra spaces, mixed text cases, duplicate rows, five different date formats and inconsistent phone numbers. I cleaned it into a consistent table and flagged the missing values for follow-up instead of guessing. I used trim, proper,...
This dashboard shows revenue, orders, average order value and profit margin, plus trends by month, category, region and weekday. It also lists the top products, so the main numbers are visible in one glance.
