Autoplay Next video from Max length

Excel - Discover the Hidden Calculation Feature in Microsoft Word | Word Tutorial - Episode 473

779 views · Published 11 May 2009 · 2:33 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Microsoft Excel Tutorial: Discover the Hidden Calculation Feature in Microsoft Word.

Welcome back to the MrExcel podcast! In this episode, I am joined by Tony Johans from England, who is another word expert. Tony showed me a mind-blowing feature in Word that allows us to do calculations within a table. I was so amazed by this that I had to share it with all of you on the podcast.

It's incredibly simple to calculate numbers in a table in Word, just like in Excel. All you need to do is insert a field by going to the "Insert" menu and selecting "Field". Then, click on the "Formula" button and the calculation you want will be automatically inserted for you. It's that easy! And the best part is, if you change any of the numbers in the table, the calculation will automatically update. But if you want to manually update the calculation, simply select the field and press F9.

But that's not all, Tony also showed me a handy trick with the "Tools Calculate" feature. We added it to the toolbar and now we can quickly perform any calculation we want, right below the table. For example, we can easily find the square of a number by selecting it and clicking on the "Tools Calculate" button on the status bar. It's amazing how many hidden features are waiting to be discovered in Word.

I am always blown away by the expertise of people here at Microsoft. By talking to experts from different groups, we can learn so many amazing things. So thank you, Tony, for showing us how to calculate in Word without having to switch over to Excel. I hope you all found this episode helpful and stay tuned for more exciting tips and tricks on the MrExcel podcast. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Sure it is easy to add up a column of numbers in Excel, but did you know that you can do this in Microsoft Word as well? Our guest host today is Word MVP Tony Jollans. In Episode 473, Tony shows you how to add up a column of numbers in Word.

Table of Contents:
(00:00) Introduction to the MrExcel podcast with Bill Jelen in Seattle.
(00:21) Tony Johans demonstrates how to do calculations in Word.
(00:38) Inserting a field to calculate numbers in a table.
(01:02) Using the "Tools Calculate" feature to quickly perform calculations.
(01:59) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Calculating in Word without switching to Excel
Expert tips for calculating in Word
Hidden calculation feature in Word
How to do calculations in Word
Learning new things at Microsoft
Microsoft Word calculation features
Updating calculations in Word
Using Tools Calculate in Word
Utilizing tables for calculations in Word
Word tips and tricks for calculations
Word tutorial on inserting fields and formulas
YouTube video on calculating numbers in Word

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152402/

Excel - Discover the Hidden Calculation Feature in Microsoft Word | Word Tutorial - Episode 473

More from this channel