MS Word Course > Working with column and table

Inserting Excel Workbook in Word

78.3k

Excel worksheets are often included in many different kinds of documents. They can be used for an array of tasks, such as analyzing data, preparation of reports and presentations, organizing projects, and more. When you write a new Excel table view layout sheet, it is useful to insert the worksheet in the active table view so that it appears at the top. However, if you open another table view with other sheets already open or even if you switch to another tab in Excel than what you should close first (like a different workbook or a different workbook from which you opened this one), the old worksheet will not be "disappeared" from the active table view. In most cases, if your intent is to delete this old sheet from the active workbook's worksheet range unless there.

In the MS Word, there is a function called "Inserting Excel" which allows users to insert Excel worksheets right into MS Office. This is a very useful feature for many people because it allows them to work on spreadsheets while still being able to read and write in MS Word.Many people use Excel in their word processing applications and they often do not know how to embed it. The problem with this function is that it does not allow you to add formula or charts. This causes a few problems when a user wants to add some formulas or charts into the worksheet so they can easily create reports from it. They have no choice but to use another method of adding formulas on the fly rather than using this function.

A spreadsheet is a collection of all the data that you need to work with in one document. This document can be saved as an Excel spreadsheet or an Open Office spreadsheet. It has a wide range of uses, including data analysis, budgeting and finance, inventory management and much more. Ms Word is the default word processor for Microsoft Office suite. It also has all the features you need to create professional looking. There are 2 ways to insert a chart from an Excel spreadsheet into Ms word. One is by using the Microsoft Word Chart Wizard. The other is by using the Insert Data option in the toolbar of Ms Word. Insert Data option in the toolbar of Ms Word: - Click on any table cell that has data that you want to show on your chart. - If you are not sure where it is, then scroll down until you see the table icon on the left side of your screen, which will be colored blue and have a T icon next to it. - Once you click on it, a menu will appear with six options - Select Data Source, Insert Table, Insert Chart, Convert Text To Number or Date, Paste Link To External Source and Import Data From File.

Learner's Ratings

4.4

Overall Rating

  • 64%
  • 23%
  • 6%
  • 4%
  • 3%

Reviews

R
Ramiz Yaqub
5

Highly Recommended Course

K
Kehkashan Khan
4

Mera video chalta hi nahi h pls do something

S
Sakshi Chopra
5

Good course👍

S
Soni
5

Every topic is explained very well.

Heena khatoon
5

Better understanding and easy to learn . Nice teaching👍👍

R
RAJKUMAR
5

RAJKUMAR

Mohit Nakum
5

👍👍👍

S
Shivani Saxena
5

Thanks

R
Rupesh Rohidas Mahale
5

This Websits is very useful for me and better understanding and easy to learn

S
Sayed Mohammed Abdul Khaliq
4

nice

Show More
Recommended Courses
Course Content

  1. Home Screen in MS Word
    2m 28s
  2. How to use LearnVern
    3m 20s
  3. Opening Files in MS Word
    2m 2s
  4. Editing PDF in MS Word
    2m 50s

  1. Adding Text to File in MS Word
    4m 33s
  2. Selecting Text Using Mouse in MS Word
    4m 3s
  3. Cut Copy Paste in MS Word
    6m 1s
  4. Find Replace in MS Word
    6m 31s
  5. Undo Redo in MS Word
    4m 58s

  1. Introduction to Fonts in MS Word
    8m 5s
  2. Changing Fonts Formatting in MS Word
    9m 25s
  3. Changing Case of Selected Text in MS Word
    2m 44s
  4. Special Effects to Text in MS Word
    6m 9s

  1. Paragraph Alignment in MS Word
    2m 46s
  2. Line Paragraph Spacing in MS Word
    5m 53s
  3. Keeping Text Together in MS Word
    4m 45s
  4. Applying Paragraph Shading and Border in MS Word
    4m 38s
  5. Indentation in MS Word
    7m 24s

  1. Page Margins in MS Word
    7m 42s
  2. Header and Footer in MS Word
    7m 6s
  3. Adding Section in MS Word
    4m 46s
  4. Page Color Border Watermark in MS Word
    6m 29s

  1. Applying Theme in MS Word
    5m 54s
  2. Changing Styles in MS Word
    5m 41s
  3. Navigation in MS Word
    2m 22s

  1. Creating Bullets and Number in MS Word
    4m 33s
  2. Editing Bullets and Numbering in MS Word
    2m 11s
  3. Multilevel List in MS Word
    2m 18s

  1. Dividing Text to Columns in MS Word
    5m 32s
  2. Creating New Table in MS Word
    6m 23s
  3. Converting Existing Data to Table in MS Word
    3m 51s
  4. Formatting Table in MS Word
    6m 9s
  5. Inserting Rows and column in MS Word
    6m 17s
  6. Merge Split Cells in MS Word
    7m 27s
  7. Sorting in MS Word
    5m 4s
  8. Converting Table to Text in MS Word
    3m 39s
  9. Inserting Excel Workbook in Word
    5m 41s

  1. Inserting Image and Shapes in MS Word
    6m 59s
  2. Position Resize of Image in MS Word
    4m 29s
  3. Inserting Images to Table in MS Word
    4m 20s
  4. Wrap Text in MS Word
    5m 21s
  5. Picture Formating in MS Word
    6m
  6. Adjusting Photos in Document in MS Word
    9m 37s
  7. Selecting Wordart in MS Word
    5m 28s
  8. Working with Chart in MS Word
    9m 44s
  9. Inserting SmartArt in MS Word
    8m 21s
  10. Working with Screenshot in MS Word
    2m 38s

  1. Creating Macro in MS Word
    6m 37s
  2. Editing Macro in MS Word
    2m 58s

  1. Spelling Errors in MS Word
    7m 18s
  2. Proofing Document in MS Word
    3m 44s

  1. Ready for Sharing in Word
    4m 59s
  2. Send as PDF in MS Word
    2m 36s
  3. Password Protected in MS Word
    2m 55s
Enroll For Free