Extracting Data From Text

by on September 11, 2017

Extracting data from Text Previously we wrote about how to combine text from different cells. It’s time to look at the opposite of how to extract data from text from cells into different cells. We will use different functions and each function will be defined in a short text. First Example: Extracting First or Second […]

Combine text from different cells

by on September 11, 2017

Combine text from different cells Have you ever thought about or find yourself in a situation to combine text from different cells. In MS Excel, Text in different cells can be combined with the help of more than one function. We will lay down a step by step procedure to combine text from different cells.¬†For […]

Relative and Absolute Cell References

by on September 8, 2017

Relative and Absolute Cell References Having knowledge about what Relative and Absolute Cell References means and how to use it will save you lots of time. In excel by default, all cell references are Relative. It means, cells changed when you copy the formula to the rows or columns. Absolute cell references do not change […]

Vlookup formula from Multiple Tables

by on September 8, 2017

Vlookup formula from Multiple Tables We have learned Vlookup formula in case of a single table. Now its turn to retrieve data with the help of Vlookup formula from Multiple Tables. We will be using a combination of vlookup and other functions to get the job done. In excel, there is more than one option […]

Excel Dashboards

by on August 26, 2017

Objectives of Dashboards The Purpose of the Management Reports is to provide analysis, insights into business operation in a short time. Majority excel dashboards are one pager, means all the key indicators are stored in one place which makes the management job much easier for key decision based on the available reports. ¬†Since dashboards include […]