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
22Nov2014

Excel shortcuts: Tips and tricks to speed up in Excel

Learning Excel keyboard shortcuts will improve your speed and productivity in a big way. Most of the daily routines in the excel worksheets can be done using keyboard shortcuts. This blog contains nearly all the shortcuts which can be helpful while working with Excel. Excel shortcuts and tips:   How to know the Excel shortcut key
  • 22 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Excel Keyboard Shortcuts,
Read more
18Nov2014

INDIRECT function in Excel: How to dynamically refer multiple sheets?

INDIRECT function in Excel returns the reference specified by a text string. The syntax for this excel function is as follows. Formula Syntax: INDIRECT( ref_text, [a1] ) ref_text can be the range of cells or a named range. [a1] can be TRUE or FALSE. TRUE is used to indicate that ref_text is in R1C1 style
  • 18 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, indirect function in excel,
Read more
13Nov2014

Introduction to Advanced Filter in Excel

Advanced filter in Excel depends on the user defined criteria that can applied to many columns of data. Advanced Filter is used to perform complex filtering which is not possible using the basic auto filter function. To access Advanced Filter, click on DATA tab in Excel ribbon and click on Advanced in sort and filter
  • 13 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • advanced filter, Excel Consultant, Excel Expert,
Read more
11Nov2014

How to apply Conditional formatting in Excel?

Conditional formatting in Excel is used to highlight a cell or value/text in the cell, when certain conditions are met. Conditional Formatting can quickly spot trends and patterns in your data with bars, colors and icons by visually highlights important values. Conditional formatting is based on the cell rules we amend. We can do a
  • 11 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Conditional formatting in Excel, Excel Consultant, Excel Expert,
Read more
15Oct2014

How to use LOOKUP functions in Excel – by our Excel Expert

The process of looking up specific values in a data set is the most common task in Excel. If your intent is to become an Excel Expert someday then you will need a good understanding of all the lookup formulas available in Microsoft Excel. There are 6 lookup functions in excel: LOOKUP, VLOOKUP, HLOOKUP, (INDEX
  • 15 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Hlookup, Index, Lookup, Match, Offset, Vlookup,
Read more
09Oct2014

Is Wrap text not working in Excel? Read the following blog by Excel Expert.

Is wrap text not working in Excel? The reason is Microsoft Excel cannot wrap merged cells automatically. We need to follow a few steps to make the wrap text work in Excel. Go ahead and read the blog to see how the issue can be resolved. Step 1: Merge the cells and enter the text In this
  • 9 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Merge cells, Wrap text,
Read more
01Oct2014

How to calculate accrued interest using Microsoft Excel?

ACCRINT To calculate accrued interest, Excel has a function called ACCRINT. Using this function, we can calculate accrued interest for a security paying periodic interest. Go ahead and read through to know how and when the function can be used. ACCRINT function in Excel returns the accrued interest for a security that pays interest on
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • accrint, accrued interest,
Read more
Older Posts >>