Multiple Chained Lookup

Multiple Chained Lookup Subject Line It’s wonderful to use VLOOKUP across multiple tables Overview You can make use of VLOOKUP () function and then nest or chain the function for each table. If there are 4 tables then you will make use of four VLOOKUP () functions in the same formula. We have four tables

Continue Reading

Product Feature Comparison Table

Open PowerPoint   Step1: Insert Table Step2: Select No Style, Table Grid Step2: Solid Fill Colors Step3: Enter Text and Align Text Middle Step4: Insert Symbol, Enter Wingdings Step5: Scroll down to locate tick mark and insert Step6: Insert X for competitors where product feature is not available Step7: Insert symbol Step8: Preview Slide Scope

Continue Reading

Wheel Diagram for BA Role

Make presentations interesting by presenting data and information with diagrams instead of using the regular text-based slides. One can use circular diagrams or wheel diagrams to present business concepts, strategies and ideas in an interesting way. You can also use a Wheel Diagram to represent a role and the associated responsibilities. Step1: Open an Excel

Continue Reading