Two decades after Excel introduced tables, Microsoft has finally made naming them less of a chore.

Use TAKE to extract the rows and columns you need, then combine it with other functions to build dynamic Excel reports.

Please note: All times are UK. Some content is provided by third parties, is subject to change, and is unverified. Copyright © 2026 BBC. The BBC is not responsible ...

Please note: All times are UK. Some content is provided by third parties, is subject to change, and is unverified. Copyright © 2026 BBC. The BBC is not responsible ...