Automation

Marksheet Data Here we have one Source file, and one excel sheet when combined data is coming In source folder there are different 9 years data, and each have 14 sheets. There named as Junior to Standard 12. same in other also Now in anther workbook where it is combined all sheet form each excel […]

Lead Dashboard from Microsoft Form to Excel Dashboard #microsoftforms #microsoftexcel

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 […]