Master Advanced Excel Techniques

Looking to take your Excel skills to the next level and be more productive?
Our free webinar on Advanced Excel with Simon Hurst, Excel guru and EwB course author, will cover: An introduction to advanced techniques in Excel, Functions with superpowers: SUMPRODUCT() and MOD(), Advanced techniques in practice: Range Names, Tables, Advanced, Form Controls and VBA in an automation project, PowerPivot and interactive dashboards. If you'd like our '100 Most-Useful Excel Tips' for FREE, look below:

Want our 100 Definitive Most-Useful Excel Tips? You can get them here: 

For more courses, check out our website below!

[mahmouddesoky]

28:00 Why did it change True to 1 And false to Zero without using the - - ?

[satyabanukil]

I have two separate excel files. In file No.1, there are two coloumns
which are Serial and Name. In the file No.2, there are Sl. No., Name and
their personal information. I want that in the first file if I select
any name, the personal details of the of the selected person second file
will automatically open display personal details of the selected name
in the first file. If there are more than one person with same name,
then all such names will also display retrieving data from the second
file.
Is it possible.

[satyabanukil]

I have two separate excel files. In file No.1, there are two coloumns
which are Serial and Name. In the file No.2, there are Sl. No., Name and
their personal information. I want that in the first file if I select
any name, the personal details of the of the selected person second file
will automatically open display personal details of the selected name
in the first file. If there are more than one person with same name,
then all such names will also display retrieving data from the second
file.
Is it possible.