Find new ideas and classic advice on strategy, innovation and leadership, for global leaders from the world's best business and management experts.

Last month, Google Sheets picked up additional Gemini functionality, gaining the ability call on Google’s AI to do things like explain how formulas work and automatically correct errors in formatting.

With the INDIRECT function, you can reference and consolidate key data points across sheets. It's a straightforward process ...