Avoid PivotTable failures caused by merged cells, blank columns, and subtotals, with Power Query steps to clean the source data.
Calculating sales tax on prices is something you don't have to worry about if you use Excel. You can add a formula to the spreadsheet you use for invoices, bills of sale or quotes, and that's the end ...