Excel DATE Function Tips

Using SUMPRODUCT() To Validate Multiple Criteria In Columns

We have studied and used SUMIFS() and SUMPRODUCTS() function with their appropriates use. Just to recall, SUMIFS() work great when our data is in the shape of list or is in column.

10 Quick Time-Saving Excel Shortcuts & Mouse Tricks For Marketers

It is possible to copy a pattern of data in a very simple way. The data can be either numbers, text, dates or formatting.

14 Simple Excel Shortcuts, Tips & Tricks

Shortcut to include today Just press control key and semicolon (Ctrl + ;) in any cell, enter. This will enter today’s date in to the cell.

SUMPRODUCT 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.