Navigating with Index in Excel
Are you a data analyst? Do you work on tons and tons of data with numerous amounts of sheets in …
Microsoft Excel: MIN, MAX vs SMALL, LARGE functions
MIN() & MAX() As we already know MIN() and MAX() functions gives the minimum or maximum number from a given …
Microsoft Excel: MIN, MAX vs SMALL, LARGE functions Read More »
Microsoft Excel- Paste Special, Format Numbers
Paste Special in Excel If you are copying some data from any other database or worksheet you have variety of …
Multi Column Vlookup
Test Yourself Let’s look at how to use VLOOKUP to get results from the same Lookup Value in multiple columns. …
VLOOKUP FUNCTION
Test yourself VLOOKUP is one of Excel’s most popular and useful functions. VLOOKUP allows us to look up a value …
Microsoft Excel- Page Break Preview, Set Orientation, Remove Spaces
Page Break Preview Page Break view is a very useful tool when determining the boundaries of the workbook to be …
Microsoft Excel- Page Break Preview, Set Orientation, Remove Spaces Read More »
IF STATEMENTS – Microsoft Excel
One of the most important functions in MS-Excel is the IF Statement. It evaluates a certain condition and based on …
Excel- Format Background, Special Number, Column Width
Microsoft Excel- Format Background, Special Numbers and set Column Width Excel provides various features for personalizing your workbook. One of …
Excel- Format Background, Special Number, Column Width Read More »
Excel- Font colors with Paste Special
Changing font colors using Paste Special: Paste Special in Excel If you are copying some data from any other database …
Microsoft Excel_Aggregate Functions
Aggregate Functions such as SUM(), AVERAGE(), MIN(), MAX(), COUNT() & COUNTA() can be executed over a set of data (values) …
