Excel DATE Function Tips

SUMPRDOUCT Function In Excel

SUMPRODUCT is yet another function that comes to rescue, whether we want to validate a criteria or want to sum against a list of requirements

Excel Training Online

Excel is an electronic spreadsheet. It is used to stire large amount of numerical data, perform numerous calculations, manage and update them.

Displaying Large Data Sets With Sparkline In Excel

Our paper is designed to accommodate two-dimensional charts, or at best 3 dimensional charts. But those charts are produced at the expense of understandability and appearance of them. What if you want to produce so many to them to accommodate cross-tabbed data?

Conversion Of Date To Text In Excel

Both date as well as time is stored in the form of numbers in Excel. This allows the user to utilize these dates as well as times for the purpose of calculations.

Using RANDBETWEEN For Dates In Microsoft Excel

The RANDBETWEEN function is available for use in Microsoft Excel. The function is used to generate randomized dates between a specified start date and end date.

New Power Pivot updates in the 2016 version of Microsoft Excel

The Office 365 subscription comes with new Power Pivot updates for the features in the 2016 version of Microsoft Excel.

How to Enable Conditional Data Entry in Excel using Data Validation

Sometimes when you are creating worksheets with data inputs, you may want to restrict the data input format (i.e. numbers, decimals, date, text etc.) and their range.