This Excel Trick Lets You Work Across Sheets Without Switching Between Tabs

Microsoft Excel offers many ways for you to manipulate and organise data, including using multiple "sheets" or tabs within the same spreadsheet file. Occasionally, you may find it useful to be able to quickly add sums across tabs. Luckily, Excel has a function for this too. Produced by Daniel Goodman and Walter Hickey. Originally published in July 2013.

NOW WATCH: Tech Insider videos

Want to read a more in-depth view on the trends influencing Australian business and the global economy? BI / Research is designed to help executives and industry leaders understand the major challenges and opportunities for industry, technology, strategy and the economy in the future. Sign up for free at

Tagged In