Excel Template (No VBA)

par IgeS
Type de fichier non supporté

Sales Invoice. This template uses Excel native formulas to collect information from different data sources/ tabs (order list, pricelist, customer recrods) in the same workbook. • Extracts unique items per transaction based on two criteria (Customer Name and Month) • Computes discounts based on volume of order • Dynamic formatting (e.g. shifts Sub Total, Tax and Total Rows based on the number of items listed) • See video demo

image of username IgeS Flag of Philippines Manila, Philippines

Me concernant

Adept in developing Excel reporting tools and templates that eliminates redundancy and improve accuracy and efficiency of daily functions. Meticulously mined and transformed multifaceted data that simplifies its interpretation and analyzes. • Data Analysis • Reports Automation (Excel VBA) • Excel Template Design

$8 $ US / h

22 évaluations