Quick Answer: When Should You Use Excel Instead Of Word And Vice Versa?

Can you insert an Excel file into a Word document?

Go to Insert > Text > Object.

Go to Create from file > Browse, and locate the file you want to insert in the Word document.

To add the file as a linked object, select Link to file, and then select OK.

To add the file as an embedded object, select Display as icon, and then select OK..

Is Word or Excel better for tables?

If it contains mostly words and phrases, Word is typically the best option. For working with mostly numbers and making calculations, Excel is the best tool for the task. For more detailed instructions on using Forms check out our Word 2016 Templates & Forms guide.

What is difference between Excel and Word?

The two applications in the Microsoft Office suite are Microsoft Excel and Microsoft Word. … Word is a text processor firstly, whereas Excel is primarily used for computational equations. The MS Word program utilizes text, images, icons, hyperlinks, items for the presentation of results, etc.

When should you not use Excel?

5 Things You Should Stop Doing with Microsoft ExcelForms. There are several reasons to avoid using Excel for forms. … Project Management. Excel is often used for project planning, usually for small to midsize projects. … Big Data Analysis. … Shared Task Management. … Approval Processes. … Wrapping Up.

How do I make a good table in Excel?

10 Secrets for Creating Awesome Excel TablesCreate a Table in Any of Several Ways. You can create a table from the Insert tab or (as here) from the Home tab, where you can choose a style at the same time. … Remove the Filter Arrows. Microsoft. … Take the Format but Ditch the Table. … Fix Ugly Column Headings. … Add New Rows to a Table.

How do I automatically convert Excel to Word?

To insert linked Excel data in a Word table:Open the Excel source file.Select the data you wish to place in the Word file.Press Ctrl + C or right-click and choose Copy.Open the Word destination document.Place your insertion point where you want the Excel data to appear.More items…