Blog – Excel Training : excelogics.com

Lookup up from multiple tables using IF statement

Subject Line You will enjoy using VLOOKUP with IF statement. Overview Sometimes you may need to look...

Negative Positive icons using Conditional Formatting

Working Let’s understand with the working help of the example below (Table1: Sales Report) Table...

Combine VLOOKUP and CHOOSE with Multiple Criteria

Subject Line You don’t need a helper for lookup all the time Overview Sometimes you may need to get the...

Case Sensitive Lookup in Excel using Exact function

Subject Line Use Exact () for case sensitive values Overview As you already know a usual VLOOKUP () formula...

How to pull values from Pivot Table using GETPIVOTDATA()

Subject Line The magic of GETPIVOTDATA () will protect your values …. Overview Sometimes the management...

Lookup using INDEX () function and MATCH () function to lookup from the right hand side

Subject Line You’re right about it; you can lookup values from the right side Overview Sometimes you...

Lookup using built in LOOKUP () function from right side

Subject Line There’s an in-built function to lookup values from the right side Overview Sometimes you...

Using Drop Down lists as Lookup Values

Syntax =INDEX(data,MATCH(val,rows,0),MATCH(val,columns,0)) Let’s understand both the function INDEX function returns...

2 way lookup using INDEX(),MATCH(),MATCH() function.

Subject Line 2 way lookup is amazing Overview Sometimes you may want to lookup a value in a table using...

Create Multiple Pivot Tables with Show Report Filter Pages

Subject Line How to automate the pivot table in different reports? Overview As we know Pivot tables are used...

Multiple Chained Lookup

Multiple Chained Lookup Subject Line It’s wonderful to use VLOOKUP across multiple tables Overview You...

Calculated values in Pivot Table

Overview Would you want to learn about how to create summarized information in excel. You can create...

Linking a slicer to 2 Pivot tables from different data sources

Working Let’s understand how we can link one slicer to 2 Pivot tables based on different data sources...

Partial Lookup using Wildcard Characters and VLOOKUP

Overview Sometimes you may need to lookup values on matching patterns or search on part of the value...

Advanced formula in name manager

Subject Line Provide your own Name for range of cells Overview Sometimes you may need to use ranges in...

How to Get VLOOKUP to Return a 0 Instead of #NA

Subject Line Customizing the (hash) #N/A error Overview Sometimes when you don’t find the lookup value...

Heat Map using Conditional Formatting

Subject Line Colourful Comparative View of Data Overview Sometimes you may want to compare data by using...

What are calculation options and their use

Overview With the help of Calculation Option you can choose to calculate formulas automatically or manually. If...

Three way Lookup

Syntax =INDEX(data,MATCH(val,rows,0),MATCH(val,columns,0)) Let’s understand both the function INDEX function returns...

Find the 2nd,3rd,4th or Nth Value in excel

Overview Sometimes you may need to look up the 2nd,3rd,4th or Nth value from a table i.e. based on the...

Replace Blank Cells with Zeros in Excel Pivot Tables

Working Let’s understand with an example of Sales table. We have a report (Figure1: Sales by Sales Person...

How to surprise your boss with Sparklines

Overview Sparklines is a fast and very convenient tool for analysis the dynamics of any data ranges....

Highlight cells using custom formula

Overview Sometimes you may want to make specific data stand out in your spreadsheet and capture the viewer’s...

How to insert data into excel from SQL Server

Subject Line Import SQL data in Excel Overview Sometimes you may have to Import data from other sources...

How to insert data into excel from SQL Server

Subject Line Import SQL data in Excel Overview Sometimes you may have to Import data from other sources...

Advanced formula in name manager

Subject Line Provide your own Name for range of cells Overview Sometimes you may need to use ranges in...

Repeat Rows and Columns as Titles on Every Printed Pages in Excel

Subject Line How to Print Headers on All Pages Overview You can print pages in excel using Print option...

Custom Grouping in Pivot Table

Working Let’s take an example of Sales information which looks as below. We want to summarize sales amount...

Create combination chart

Subject Line Combo offer for charts Overview Sometimes you may have to show different type of information...

Advanced filter complex criteria

Advanced filter complex criteria Subject Line Use Advanced Filter for simplification of complex search Overview Sometimes...

Gantt chart in excel

Supported by a robust sales force and tight cost controls, Pharm Ltd. experienced sustained...

Link slicers to Two Pivot tables based on the same data source

Supported by a robust sales force and tight cost controls, Pharm Ltd. experienced sustained...

A digital prescription for the pharma industry

Supported by a robust sales force and tight cost controls, Pharm Ltd. experienced sustained...