15Dec2014

Time Card Calculator – Payroll template (with California Overtime rules)

Do you handout payslips to your employees on a weekly basis? Are you having a tough time calculating the pay based on California Overtime rules? Wondering how does the 7th day rule work in California? Then this time card calculator is for you. It will help you in calculating weekly payroll taking care of all
  • 15 Dec, 2014
  • Excel for Commerce
  • 2 Comments
  • CA overtime rules, Payroll template, Time card,
Read more
09Dec2014

How to use SUMPRODUCT function in Excel

SUMPRODUCT function in Excel returns the sum of the products of the corresponding ranges or arrays. Let’s check the syntax for this function. Formula Syntax: SUMPRODUCT (array 1, [array 2], [array 3], …) The arrays in the formula are the ranges of the cells that we wish to multiply.   SUMPRODUCT function in Excel: Let’s
  • 9 Dec, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, SumProduct,
Read more
02Dec2014

How to create dynamic dropdown list in Excel?

Dynamic dropdown list in Excel: Dynamic dropdown list in excel falls under Data Validation. This can be accessible in Data Tools section in Data tab in excel ribbon as shown in the image below. Data Validation picks from a list of rules to limit the type of data that can be entered in a cell.
  • 2 Dec, 2014
  • Excel for Commerce
  • 0 Comments
  • Dependent dropdown, Dynamic dropdown, Excel Consultant, Excel Expert,
Read more