How to do Calculations in MS Word Using Excel?

2 minutes, 22 seconds Read

In Excel, we can do lots of calculations but in MS Word we can’t do it because there is no formula like in excel. With the help of excel, we can do calculations in MS Word.

How to Insert Excel in MS Word?

In MS word to insert excel open the word blank file or the word file in which you want to insert.
 Go to the 'Insert' tab and under the tables group click on the 'Table' now the dropdown will appear in that click on the 'Excel Spreadsheet'
Insert Excel sheet in MS Word - Edutaxtuber

Shortcut to Insert Excel file

To insert excel in MS Word via shortcut key, you need to press the following key:

‘ALT + N + T + X’

Shortcut key to insert excel in MS word- Edutaxtuber

How to do Calculations?

Double click on the excel sheet inserted, you will find all the excel tab and you can do lots of calculations like excel.

To exit from the excel view click anywhere outside in the word document in the blank page.

How to do calculations in MS Word using Excel? - Edutaxtuber

Now with the help of this you can easily do calculations and add table that will do calculations using excel formula.


FAQs

Can I do Calculations in MS Word?


Yes, generally you can’t do calculations like as we do calculations in excel but using excel in MS Word we can do calculations.

How to Insert Excel Spreadsheet in MS Word?


Go to the ‘Insert’ tab and under the tables group click on the ‘Table’ now the dropdown will appear in that click on the ‘Excel Spreadsheet’

What is Shortcut Key to Insert Excel Spreadsheet in MS Word?


‘ALT + N + T + X’

For Latest Updates & Learning Join Our YouTube Channel: Join Now


Also read other articles @ EduTaxTuber

How To Create Multiple Ledgers in Tally Prime?
In this article, we will discuss that how we can create multiple ledgers in Tally Prime. If we create multiple ledgers then we can save our time on the other hand If we create a single ledger then it will …
TallyPrime: Important Shortcut Key ALT + G or GO To
In this article, we will discuss the new and unique shortcut key ALT + G or GO To in the TallyPrime. With the help of the ALT + G shortcut key, you can navigate in tally anywhere. ALT + G …
Income Taxpayers can now use the co-browsing feature: e-filing
co-browsing feature Income taxpayers can now use the co-browsing feature: As per the latest news on Income Tax Portal that is "Co-browsing feature is now available for the taxpayer", so in this article, we will understand what is co-browsing feature …
Tax Audit Report Due Date Extended to 7th October 22 for Assessment Years 22-23
CBDT Extended the Tax Audit Due Date to 7th October 2022 Tax Audit Report Due Date Extended to 7th October 22: CBDT extends the due date for filing of various reports of audit for Assessment Year 2022-23 from 30th September, …

If you want to make the lower case, The Excel LOWER function Converts all uppercase letters in a text string to lowercase. It ignores space, numbers, and punctuation. Visit this link – Excel LOWER Function.

The Excel PROPER function Capitalizes the first letter in a text string and any other letters in the text that follow any character other than a letter. It Converts all other letters to lowercase letters. Visit this link – Excel PROPER Function

Create TDS Nature of Payment

From the gateway of Tally press “C” then select “TDS Nature of Payments” under the Statutory Masters and press Enter. OR Press “ALT + G” select Create Master press Enter and select “TDS Nature of Payment” under the Statutory Masters and hit the enter button.

How To Check PM- Kisan Samman Nidhi Yojna Beneficiary Status

In this article we will see in detail how to check “PM- Kisan Samman Nidhi Yojna” beneficiary status i.e. whether money is received or not. You can check it Online. You can check in three ways i.e using 1. Aadhar Number, 2. Bank Account Number, and 3. Mobile Number.…. Read More

author

EduTaxTuber Team

We are here to help for every updates related to everything...👍📙👍📗

Similar Posts

Leave a Reply