Excel Easy

Slicers in Excel

Slicers in Excel Use slicers in Excel to quickly and easily filter pivot tables. Connect multiple slicers to multiple pivot tables to create awesome reports.

Not Equal To Operator in Excel

Not Equal To in Excel In Excel, means not equal to. The operator in Excel checks if two values are not equal to each other. Let's take a look at a few examples.

Freeze Panes in Excel

Freeze Panes in Excel If you have a large table of data in Excel, it can be useful to freeze rows or columns. This way you can keep rows or columns visible while scrolling through the rest of the worksheet.

SUMPRODUCT function in Excel

SUMPRODUCT function in Excel To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel's powerful SUMPRODUCT function.

NPV formula in Excel

NPV formula in Excel The correct NPV formula in Excel uses the NPV function to calculate the present value of a series of future cash flows and subtracts the initial investment.

Contains Specific Text

Contains Specific Text in Excel To check if a cell contains specific text, use ISNUMBER and SEARCH in Excel. There's no CONTAINS function in Excel.

Remove Spaces in Excel

Remove Spaces in Excel The TRIM function in Excel removes leading spaces, extra spaces and trailing spaces. Use the SUBSTITUTE function to remove all spaces or non-breaking spaces.

Date and Time in Excel VBA

Date and Time in Excel VBA Learn how to work with dates and times in Excel VBA. To declare a date, use the Dim statement. To initialize a date, use the DateValue function.

Percent Change Formula in Excel

Percent Change Formula in Excel The percent change formula is frequently used in Excel. First, let's understand the formula. Next, let's calculate the monthly and total percent change over a period of time.

Substring in Excel

Substring in Excel There's no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel to extract substrings.