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!

Nguồn: https://pub-ed-inquiry.org/

Xem thêm bài viết: https://pub-ed-inquiry.org/category/cong-nghe

2 thoughts on “Master Advanced Excel Techniques”

  • Satyaban Ukil says:

    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.

  • Satyaban Ukil says:

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>