Here we have 2 excel file. In first 2014 we have data and in second combine of all sheets. There are different 14 sheets. JR, SR, Std 1, Std 2, Std 3, Std 4, Std 5, Std 6, Std 7, Std 8, Std 9, Std 10, Std 11, Std 12. Now in anther workbook where […]
Here is sample of Financial Transaction Report with different column like Segment, Country, Product, Discount, Unit sold, Manufacturing Price, Sale Price, Gross Sales, Discounts, Sales, COGS, Profit, Date, these are different columns. Now we want report by segment by sum of Unit sold and by sum of Sales. Now we may see that report calculated […]
Here a sample video of cost trend analysis where row for August 2016 details would be added manually to data entry blue colored table in row #9. Columns like month, name, assembly, date, materials, printing and shipping and few columns calculated automatically without any Excel formulas in next green colored table. This green colored table […]
