3 Tricks to Separate the Number and Text from an Excel Column
You open a file and the whole list has been pasted into one single column: an order number, then a customer name, then another order number, then another name —
Blogs
Lawn Care Business KPI Dashboard in Power BI
The Lawn Care Business KPI Dashboard in Power BI puts 13 lawn care metrics on a single monthly scorecard, spread across 4 report pages and 5 KPI groups: Cost Control,
Cafe Daily Sales Data Entry System in Excel
The Cafe Daily Sales Data Entry System in Excel is a macro-enabled workbook with a 7-field sales form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding
Grocery Store Billing Data Entry System in Excel
The Grocery Store Billing Data Entry System in Excel is a macro-enabled workbook with a 7-field bill form, 4 VBA buttons, 4 live stat cards and 3 dropdown lists holding
Snow Removal Services KPI Scorecard in Excel
The Snow Removal Services KPI Scorecard in Excel puts 10 snow and ice management KPIs on a single tile-wall page, grouped into Operations, Service Quality, Financial and Fleet & Safety.
Pressure Washing Services KPI Scorecard in Excel
The Pressure Washing Services KPI Scorecard in Excel puts 10 pressure washing KPIs on a single tile-wall page, grouped into Sales & Revenue, Operations, Quality, Customer and Finance. It comes
Excavation Contractor KPI Scorecard in Excel
Ask the owner of an excavation company how last month went and you usually get a story. Two big site-prep jobs finished early, the long-reach excavator spent a week in
Tree Care Services KPI Dashboard in Excel
The Tree Care Services KPI Dashboard in Excel puts 15 tree care and arborist business KPIs from 4 groups on one monthly scorecard. For each KPI it shows MTD and
Snow Removal Services KPI Dashboard in Excel
The Snow Removal Services KPI Dashboard in Excel puts 14 snow and ice management KPIs from 8 groups on one monthly scorecard. For each KPI it shows MTD and YTD
Pressure Washing Services KPI Dashboard in Excel
The Pressure Washing Services KPI Dashboard in Excel puts 15 pressure washing KPIs from 8 groups on one monthly scorecard. For each KPI it shows MTD and YTD actual, target,