Browsing all articles in Guides

# How to Embed 8 If Statements into 1

Zaheer    Guides     ,

MS Excel If function is very useful in the decision making process while you are considering your spreadsheets. It helps in generating and in testing if the data or the state of your spreadsheet is true or false. The function will carry out an action if the condition or state of your spreadsheet is true or false. If the condition is true then the function will carry out the specific task you have embedded on the function. These actions can be the execution of specific formulas, insertion of certain text or statements, or to leave the cell blank.

In order for the IF function to it needs to have a comparison for it to function. The most common comparison of IF function is the greater or leer than values. These symbols >/< is commonly used to create expressions which means a number is greater than a number, or vice versa. This expression can be true or false which will depend greatly on the IF function for the action to be done.

There are three basic parts of an IF function in Excel. These parts are the comparison function, what action will be taken if the function is true, and what action will be taken if the function is false. Also, there is a built-in wizard that could help you in making your own IF function Excel. To go to the function select on Insert menu and choose Function. After, click on the Logical function from the drop-down selection. Now, click-on the IF function and hit OK.

On the Function Arguments dialogue box, input on the Logical test box, Value if true, and Value if false your arguments or the functions for you formula. Right after inputting the IF functions, click OK. Logical test answers what you are asking. Example of a logical test question could be “Is the value in Column C greater than the value in Column D?” In the Value if true asks the question what you want to display if the answer to the question is true. In the Value of false it answers the question what you want to display if the answer is false.

To create IF statements the arguments must be separated by commas, an example would be =IF (A1>B2,”yes”,”no”) formula and place it on the C3 cell. This means that IF the value of A1 is greater than that of the value of B2 the C3 cell will show a yes answer and if the result is opposite the answer on the cell would be no. Remember that if you want the text to be displayed on the cell you must include the text with the quotation marks on the formula itself. On the other hand, if you will be using numbers then you do not have to enclose it with quotation marks.

You can also use the IF statements in assessing your workers performances, such as in deciding whether to fire them or give them a raise. You can enclose on the quotation marks, such as the one above with the words fired or rise. There are definitely numerous ways to make use of IF statements.

You can also repeat the IF statements or formula on the rest of the rows or columns. In case the IF statement is on the C2 cell then all you have to do is to point on the C2 cell on its corner. Wait until a black cross appears and then drag it down or right to left, depending on the cells you want to contain the same arguments or statements. Also, you can do the simpler way such as point on the corner of the cell and double click to have the same statements on the succeeding columns. Likewise, if you are to update the first or source cell of the statement you can do that and do the same process to have an update on all the cells.

The IF function or statements can be useful in Excel 2007, Excel 2003, and even for Excel 2000 version. Also, the maximum IF function of seven can be nested on the arguments for it to elaborately create and construct tests. If you are planning or aiming to do more than seven statements you can consider using LOOKHUP, VLOOKUP, and HLOOKUP functions.

# How to Edit a Recorded Macro?

Even if you recorded your Excel macros perfectly and they have been very helpful with your work, you may still have to modify them. Imagine having more data to add to the reports. Imagine your company expanding. There are a million ways that would want you to edit the wonderful macros you had created. And of course expanding and excelling is a good thing, so bear with it!

The good part is that you do not have to create the entire record again. You can modify the existing one. The bad part is, in order to make the modifications and additions; you need Visual Basic Applications which is another program. Luckily, the program is no rocket science. You just need to understand some basic stuff and can get it installed. Once you do that, life will be much, much easier.

Here is how you edit a macro created already in your computer.

• First go to the “start” menu and find Microsoft Excel. Open and through “file” open a new spreadsheet.
• On the toolbar at the top of the new spreadsheet, find “window”. Click here and go to “unhide”. This would bring your personal macro workbook forward. You need to unhide the workbook to make the intended changes to the data.
• To open the workbook you will have to click on “personal. XLS”. Click OK.
• To access the created records, go to “tools” and select “macro”; go to “macros” and the records in the personal workbook will be listed. From here you can choose the one you want to modify and it would open when you chose to edit it.
• Here is when the Visual Basic program comes in.

The language for visual basic program is not very different from the English syntax, as we have nouns and adjectives. In Visual Basic Application, the nouns are termed as “objects” and their qualities which would be the adjectives in common English or any other language are called the “properties” of that object. So, if you need that an object should have a desired property. You type the name of the object, followed by the property with a period between the two: object.property. Likewise, when you want one of the objects to follow a “method”, type in the name of the object, period, and then the method. It is simple but you need to understand these basics so that it does not hinder the editing rather than aiding it. Also note that when the Visual Basic Application is run, the names that you entered when you first created the macro will have additional codes assigned by the program. This is what you have to do. Copy the code, no matter whether or not you understand the code itself, and paste it five times in the column. To save the changes, go to file and click on Save Personal.XLS. Now go to “file” again and click “Close”. Now you can have the files and the Visual Basic Application closed down and the changed data will be saved in the same storage directory/ personal macro workbook.

This is all there is to editing the macro record. Once you are done with the above series of steps, you have successfully edited the macro. Now you should go back and double check if the method is working or not. Launch Microsoft excel again, and go to “file” and “new”. From here, if you remember the shortcut key you had specified earlier, press ctrl key followed by the shortcut code which is usually a letter or a symbol. The macro record will open and you can see if whether or not it is the edited version. The new names will also show in addition to the old ones.

In case you do not remember the shortcut key, go to “tools” and select “macro”, from here, click “macros” and from the list chose the one you want to double check. Click “run” and the corrected or edited version will be presented in case the editing was successful.

Skills like these require you to master them through sufficient practice. Once you do that, editing would not be difficult at all. So move ahead with the ease your computer has provided you!

# How to Record a Macro

Zaheer    Guides     ,

Tired of repeating operations while managing data? It is very understandable. Repeating the very same mathematical operation on all the numbers in s data sheet can be very frustrating.  Excel spreadsheets can be managed wonderfully, repeating tasks and getting frustrated can be successfully prevented in Microsoft Excel using Macro. Now here is how you record and use a macro and manage data without making your life miserable. The following steps are for recording simple macro in Microsoft Excel.

First open the Excel application. This should be simple. You go to the “start” menu on your screen and follow “all programs”. Find Microsoft Excel and click to open.

Now, go to “file” and then “new” to open a new spreadsheet, “save as” to keep the new workbook saved by a different name to avoid any confusion.

Find the “tools” button at the top menu bar of the new spread sheet and click. Here click “macro” following the temptation but avoid the “record macro” button for the time and go to “security” from there instead. Macro requires the use to set a security level. Ideally, you should set the security to medium. So. Click “medium” and it will be done. Click Okay to finish off this part of the business. The menu would close.

Now, go to the favorite button again. “Tools” menu followed by Macro again would show you a button “record macro”. Now you will be asked to enter the desired name:  you could have your company’s name or initials. Note, however, that the initial character has to be a letter and the rest is up to you: you can sue letters or numbers and signs if you please. You cannot have spaces between characters though.

In the “Shortcut key” section, you would be required to type in a shortcut symbol to use to stimulate macro immediately. This could be the first character of the name you selected for the application.

You would now be required to specify where you want to place the file. In the “store macro in” option you will have to select the destination. For an example, consider “store in… personal macro workbook”.

Find the descriptions section below and briefly describe the macro. After this you can save and close simply by clicking OK.

The recording formally comes now. A tiny window would pop up and it would show a blue icon. Whenever you want to stop recording, you can press the blue icon.

Here you would start entering say the titles related to the name of the managers in column A, first row. As soon as you are done entering the names, you need to click the blue icon to stop.

You can double check the recording now because once you have completed the above steps correctly, you are done. For double checking open a fresh Microsoft Excel window and press the keys Ctrl + (the selected shortcut code) and you will be directed to the macro you had recorded. Make sure you remember the code for shortcut to make the job easier.

As an alternative you can go to Microsoft Excel, and select tools, and then click on macro, and ten macros, from where you will have to select a directory or store where you had placed the record. Let’s just say, in the “macros” section you will find “personal macro workbook” and if you click there, you will have the list of records that you had stored in that folder. Of course the shortcut method is easier, but this is the longer route and requires you to know where the desired record has been saved by you.

These are the series of simple steps you need to follow in order to record a simple macro. In fact, when you learn this it is a very good idea to practice it and get the hang of it. This is so because as you excel, literally, you will need to record more complex macros and that would require a strong base. For complex records, there are complex techniques and procedures to record them. Gradually, you will see how the system works for you and it is not going to be a big deal at all by the end of the day. Learning afterwards can be facilitated by prior practice so go for it!

# How to Create a PowerPivot?

Through PowerPivot service application you give meaning to your data recorded in Excel sheets. With PowerPivot you can stay connected as a group and get help in running your business smoothly and keep an eye on the progress throughout.  Creating a PowerPivot service application for your Excel data is simple and easy. Here are some simple instructions along with some every important tips that you could use to create and configure the service application. However, keep in mind that creating multiple service application would require you to fulfill what the system needs. So, in case you do not need the multiple applications, it is okay to avoid creating them as you would be required to put in effort otherwise.

• Go to application management menu.
• Find the “manage service applications” in the central administration and click there.
• Here, you will find the Service Applications ribbon. Click New in this ribbon.
• If the PowerPivot software is correctly installed, you will now see a SQL Server PowerPivot Service. You have to click here to find the “create new PowerPivot service application”.
•  It is here that you will be required to enter the name of the application. By default the name is PowerPivotServiceApplication<number>. The number would obviously be provided to you. This may not apply if you go for multiple service applications: in that case you would need to give a descriptive name so that the administrators can understand the applications better.
• It is recommendable to go to the application pool and create your own application pool with a managed account. The domain user account has to be specified so make sure you do not skip this part because it would enable to update passwords and other such information much more conveniently as you would now be able to use SharePoint’s additional features for managing accounts.
• Note that in Database Server the databases are configured by the SQL Server Database Engine b default. You can stick to it or change it replacing it by another SQL server that you find more suitable to your interests and use.
• It is desirable to choose a database name that is unique rather than having the default set name continued. This would make your work more recognizable and for yourself a lot easier to manage.
• Then comes the database authentication. By default, it is windows authentication that is set. You can change it to another SQL authentication as you please. Again for this purpose, having an access to SharePoint’s features is very helpful.
• Finally stay connected by choosing the checkbox for service connection. It is particularly important to select the checkbox if it is the first time that you are creating the application.
• Finally, click “OK” and you will see the newly created application among the already existing ones, ready to be used.

You would now need to understand how to configure the PowerPivot service application and also need to learn how to connect it to a web application for better connectivity. For configuring the service application, you again have to proceed through the Central Administrator and follow the series of simple steps. The process is to an extent self explanatory and user friendly.  The major things you need to look at include the timeout and the pool size. Make sure you are well aware of the database load timeout and the configuration pool timeout. The pool size in question would be the maximum user pool size and the pool size for the maximum administrative connection.

Likewise, for connecting the PowerPivot service applications to a network you follow the same starting point: the Central Administration. Again you are lead to the default settings which you have a liberty to change in accordance with your needs and priorities. The main step is dealing with the editing of group associations as of course this is what connectivity is mostly about.

Fortunately, through the Central administrator you can edit the settings of the PowerPivot service applications anytime you want. This gives you enough chance to suit your needs and improve the system according to your business requirements. This is how easy to use the application is. So get started today.

# How to Use Slicers

Zaheer    Guides     ,

Dealing with massive data sheets on excel can be really messy. Particularly when you want to select some values for a process and skip other entries, the job can be really frustrating. In a long spreadsheet, where the entries to be skipped from an operation are spread in a random fashion, a slicer can be of great use to you.

It is not difficult at all to use slicers in Microsoft excel. Slicers have a set of buttons that allow you to filter the data in the Power Pivot tables. With the Slicers, you do not need to open individual lists and in the drop down look for the exact item that you want to filter out. Slicers hence make it simple and easy to manage your data filtering in Power Pivot, Microsoft Excel. In addition there is a clear labeling on the slicer that shows how the data has been filtered. This features helps you see which items have been left out and how the filtering process has been done.

While using a regular slicer to filter multiple entries, you cannot see the details of filtered items. Instead the slicer displays only that the data has been filtered. It does not show which items are left out and by what rule. To see the details you would have to drop the menu down and see the residual items. Like many programs there are slicers of different levels that operate on multiple levels of complexity. So, you can go for the one that fulfils the requirements for your job and tasks.

Typically, the slicers used in Power Pivot are associated with it since the beginning. Still, it is possible to sue an independent or online slicer and then attach it to the Power Pivot in your computer as you work on it. Most people use the slicers already attached to Power Pivot. You have a choice to suit yourself.

A typical Power Pivot slicer has the following set of buttons:

a-       A slicer header: this is an indication of the categories if the items being dealt with.

b-      A filtering button: this is not selected and shows the items that are not being filtered.

c-       Another filtering button: this is selected and shows the items included in the filter

d-      A clear button: by clearing you remove the filter from the data

e-      The scroll bar and border moving buttons allow you to fix the visible dimensions on the screen for your use.

Using tips:

In order to sue the slicers in Microsoft Excel, make sure you have a created a slicer and it is attached to Power Pivot; also you should have made a copy of the slicer and have it associated too. Use a slicer that already exists and attach it to another Power Pivot. As mentioned you can also create a separate slicer and then attach the stand alone to Power Pivot for further usage of the filtering component. Also note that each slicer you create is specified for one Power Pivot page, and for a different file, you would have to create a different slicer and get it attached to that particular file. Cumbersome in the beginning it might be, but as you get the hang of it, you would realize the effort is completely worth it. Luckily, in some cases you can share the slicers. This can be done when in a single report you have a number of Power Pivots. In such a scenario, you can share a filter for all of

Formatting Slicers

Working with slicers does not have to be dry and boring against the stereotypical concept of numeral data and data sheets. You can format an existing slicer too, by following simple steps:

Click on the slicer that you want to give a different outlook. From here you can find the “slicers tools” option and click on the options button. You will be presented with some available styles and for further designs you can click “more” button given and access further styles for your slicer. On and off you can change the look and avoid the monotony which is very prominent in this kind of work. Enjoy as you excel on Microsoft Excel.

# How to Set Cell Data types

What you enter in the Microsoft Excel spreadsheets is read by the program as general data, text, or numeric data. But there are limitations to each, and you obviously have to suit your own needs and preferences while using Microsoft Excel. The cell data type can be interpreted by Microsoft in different ways: numeric, general or text. The interesting thing is that even if you enter numerals you can have the program read the data as text. But why would you want to do that?

As a fact, Microsoft Excel automatically fixes the number that we enter. This is much like Microsoft word correcting some simple errors as we continue to type. Likewise Excel modifies the numerals so that they make sense. For example if I type in 0210 so Excel would automatically eliminate the first zero since it is meaningless to have that character. Bu if I want to keep it, I would have to change some settings. What is required in that Microsoft does not read the data as numbers? Once it does not interpret the data as numeric, it would not be bothered about the number sequence and corrections.

The “types” function in Microsoft Excel 2007 is a very useful feature as it allows you to determine and set the cell data type. The data you need to have in an Excel spreadsheet can be all numbers or numbers and letter or maybe just letters. With the type feature you can easily form formulas as a formula consist of both numbers and letters usually. The syntax for the type function that you need to know in order to use is TYPE (value). Here the value can be any type of data entry like a number or text for example.

Now here is how value type is encoded in this way. The following numbers show the corresponding value types.

• 1 is for numbers
• 2 is for text
• 4 is for logical value: which means that the content is in terms of a true or false
• For an error value, the code is 16
• Finally, for a range or array of contents, the value 64 is used.

Converting data types

If the data you receive has numbers written in the form of text you may want to change the data type to make the spreadsheet more bearable! By default the numeric entries are right aligned in the cells. So when you see numbers aligned to the left you can easily tell. At other moments you may want to change a numeric format so that Excel treats it as text. This may be so because if an entry is treated as a number you cannot add a preceding zero as it would vanish automatically. Now if you modify the system such that the numeric entries are being treated as text, first they would be left aligned, and then you know you can add numbers as you please and there is no automatic emission of any zero for example.

Now, here is how set the data type:

• General to text: To change the data from general to text, you only need to add an apostrophe before the number. With an apostrophe Microsoft Excel will read the numeric entries that you then enter as text and you can change them as you please.
• Text to general: To deal with a text data that you want to be read as general data, you only have to click in the cell and simply hit the Enter key. And you are done: your text data will now be read by Excel as a general data.

This is how you use the program feature and keep your data the way you want it to be presented. The data type is thus decided by you and Excel follows. Moreover, there are some special software programs that help managing the cell data type. The usage and installation is easy and you do not even have to know the simple codes and techniques to switch the cell data type in your Microsoft excel spreadsheets. As you find the task doable, you should proceed. Follow the above steps or get a good program installed that could help you define data types.

There are many features available in Microsoft Excel that could help you in making your presentations. One of the features is that you can make use of charts in presenting numerical data. There are a lot of choices of charts that you can use which includes column, line, pie, etc. Also, when you decide to change your data, the data of your chart will automatically be changed or updated. You do not need to refresh the workspace.

In inserting a chart, click on option on the Insert tab Chart group. Choose then the type of chart you feel convenient. The type of chart you will be using can also be presented in a 2 dimensional or 3 dimensional form. Sub-types of bars are also seen in the selection. Also, excel allows you to collaborate different charts in one worksheet.

Likewise, before you start anything with linking charts to cells first learn the basics. There are a lot of components in a chart. Some are already shown in a default chart while the other components can be added. First, the chart are refers to the entire chart. Next, the plot area is where the axis, title, and marks are seen and located. The next area is the data points where the variables are plotted and is now represented by a bar, line, pie etc. The data series connects the data points in the chart. The axis, horizontal and vertical contains the variables an the categories of the data. The box which contains the designated color or patterns for your data is called the legend. The one that contains the titles of the chart or charts is the title. Lastly, you have the data label which is used to classify the information regarding you variables.

In order for you to add a title on a current chart or an axis you have to select the chart sheet first and select on where you want the title to be placed. Select and click-on the Chart menu and select Chart Options. Take heed that the Chart menu will only be available if you are able to select an existing chart. Now, find the Titles tabs and enter the title which you think is right for the title box. If you wan to insert a line break on your existing chart title, just pint on the on the chart title and hit enter to begin editing. This is also the same if you want change the font style and font size of you current title. Also, if you want to format the current text, click on the Format menu and select Selected Chart Tittles or Selected Axis Title. Likewise, in changing the font click on Font tab and select on the format you prefer.

Now, on linking your current or existing chart or axis to a worksheet cell click first the chart sheet or the embedded chart. The chart sheet is the workbook that only has the chart. Having a separate sheet for your table is useful when you view the chart. Also, the embedded chart is the chart which you have on your worksheet together with the data. This will also be useful if you plan to print your data together with the table.

After, select on the formula bar and input an equal sign. The formula bar is where you get to input or change the variables and formulas in a selected cell. This is found at top of the workplace on the Excel. Also, you can enter a reference for you worksheet. This includes the name of the work sheet, then an exclamation point, and hit enter.

Also, linking chart title to worksheets could come very handy if you are using the same chart mostly or at the same time. This will automatically change your existing data which will make the two simultaneously relate. There are a lot of links you can have on your chart such as chart title, the X-axis and Y-axis title in secondary and primary form, and the different labels of data. Having charts on your worksheet is helpful in presenting your numerical data in large numbers be understood easily.

# How to Create a Pie Chart

Microsoft Excel offers a lot of variety of charts you can use for your data to be presented easier and less complicated. But the excellent type of chart for you to display data points. It is also easier to distinguish sizes in a pie chart because these sizes are proportionate to the total of the items. It is also needed that in arranging the data on the worksheet must only be one column or row. There are also a lot of thins to be considered when you decide to use a pie chart in plotting data. First is that you must have one series of data to be plotted. Negative values and zero values could not be plotted on a pie chart. Also, a maximum of only seven categories can be plotted and that these seven categories are represented by the different parts on the pie chart.

There are also subtypes of a pie chart from which you can choose from. These types are the pie chart in 3-D, pie of pie charts or bar of pie, and exploded pie which can also be in3-D. The first type of pie chart can display the sizes of the data or values in 2-D or 3-D. Also, you can remove or move parts of the pie manually. You can also choose the pie of pie chart or the bar of pie chart which allows you to present extracted data from the main pie chart. This is very helpful in displaying parcel of the main pie chart for you to easily differentiate the values. The last subtype is the exploded pie chart emphasizes on the values of the individual parts and can also be in3-D. in this subtype, you cannot move the parts of the pie.

In creating a pie chart, first open you worksheet which contains the data you will be using for your pie chart. After opening, select the values you would want to plot or input on the pie chart. Select the Insert tab found on the top pf the workplace. Click on the Charts group and select the Pie. Select on the Pie in 3-D from the 3-D Pie. Now, click on the plot are. The plot area is where the axes, categories, labels, and all the data are located. The Chart Tools shows the selection on the Design, Layout, and Format tabs for the pie chart. Click on the Design tab, after click-on the Chart Layouts group and select the layout you prefer for your pie chart. There are different layouts you can choose from for you pie chart. Also, you can change and choose your design from the Chart Style group. After deciding on the design of your pie chart you can also change its formatting such as its shape styles and effects.

To be able to customize the display of data points on your pie chart first position the primary and secondary charts adjacent to one another. The primary pie chart is located at the left side and is larger than the secondary chart which is located at the right side. In changing the charts, you cannot do it separately because the values or data are interrelated. Also, the lines for connection are automatically connected but you are still allowed to change the default format of the line and even remove it if you like.

To be able to change the data series of the current pie chart first select the data series. Now, click on the Format menu and click-on Selected Data Series and click on the Options tab. To specifically have the data you want to see on the secondary chart select on the Split Series by selection.  If you want to change or adjust the number of data points which is shown on the secondary chart you can select on the Second plot contains the last values box for you to split the position of the series.

If you want to change the size of the secondary chart you can increase or decrease it by selecting the Size of second plot box. Also, you can remove the lines connecting the primary and secondary pie chart in the Series line check box. For you to be able to make the colors of the data points the same, select on the Vary colors by slice check box.

# How to Change a Chart Type, Once Created

Microsoft offers a variety of commands for you variables or data. On e of this is the creation of graphs from the data you have gathered of imputed. And it is even greater because you can still change the type of graph even right after inputting the data.

In Microsoft, you can still change the type of chart of your current chart for mostly of the 2-D charts available. You can also change and select from the available chart types for a single data series. Let us first see how to change a default chart in Microsoft Graph. To change the default type of chart find on the menu bar the Chart and click on the Chart Type. Now, on the Standard Types tab or on the Custom Types tab and select and click on the type of chart you prefer. You can also create your own chart types or select form the Custom Types tab which contains the present default chart types and the customized types of the charts. After selecting, click on Set as Default Chart and hit Yes.

You can also make use of the chart you have selected and make it as a default chart type. First, find the Chart menu and click on the Chart Type. It will then let you view on the Custom Types tab, select and click on Set As Default Chart and then hit Yes. You can also add a name for your default chart. In the Add Custom Chart Type dialogue box type on the Name box the name of your default chart and also, type a description the Description dialogue box and hit OK.

Also, in Microsoft 2003 you can change the Excel default chart by first point and right-click on the current chart. The list of commands will appear then choose Chart Type from the selection. Now, you can choose from the available chart types and sub types of the charts from the current or available list of charts. After choosing the preferred chart type, click on Set as Default Chart which is found at the bottom of dialogue box of the Chart Type.

In Microsoft Excel 2007, you can still change the current type of your chart instead of doing all over again. First, open your current worksheet that already has the current chart you want to change. After doing so, right-click on the chart that you want to change the type and select on Change Chart Type which will show-up on the center of the workspace. Next, select and click-on chart type you want to set on your current chart. The command is seen on the left side of the dialogue box with the name Change Char Type. After selecting the chart type you prefer it will then be on orange highlights. Hit OK and close the Change Chart Type dialogue box.

Also, you can change the type of chart in mostly of the 2-D charts to give it a new look. You can also do the changes by combining different chart types.  For 3-D charts you are only given the freedom to change the type of chart as a whole.  Also, to change a chart type, you must already have a current chart on an existing file.

Open your existing file with a current or existing chart. Click on the area of your existing chart for the selection of the chart tools to appear. For data series, select and click on the chart type.  Take heed that in changing the chart type of a data series you can only do it once. You can not simultaneously change the chart type of a data series; you have to do the process all over again for each data series.  If you wan to update or change the design of your chart you can click on the Design and on the Type select and click on Change Chart Type.  On the dialogue box of the Change Chart Type select a chart type on the first dialogue box. After, select and click on the subtype which you would prefer to use.  Also, you can use the available templates or if you have saved one you can also use it by clicking on Templates and select the one you want to use.

# How To Export A Microsoft Excel Table To Microsoft Word

To write down a document tables can be needed to present data for various purposes. There are powerful features to create tables in Microsoft Word. You can create tables according to your need and insert data in the table. You can format the table according to your need. However, if the data are kept in Excel worksheets, you can use the data in the Word document in various ways. If you feel it is time consuming to create new tables and entering data into the table in the Word document, then you can import the data from the Excel Spreadsheet.

Simple way to export a Microsoft Excel table to Microsoft Word is copy-paste. Open the Excel file then activate the worksheet where the table is. Select the range of data. You can do it by dragging the mouse or pressing the Shift + Arrow keys of the keyboard. After selecting the range or the table copy it by pressing the button from the Clipboard group in the Home tab, or you can use the CTRL + C from the keyboard to copy the selection.

Then open the Word document where you want to set the table. Set the cursor in the position where you want to paste the table. Then click on the Paste button in the Clipboard group. The data will be pasted with the table. To keep link with the source table you should choose the Paste Special from the list that will appear after clicking the down arrow of the Paste button. You can choose any of the option Paste or Paste link. To view the table as a still image select Paste; then select Picture (Enhanced Metafile) or Bitmap from the list. To size the image click on it, then use the mouse pointer to drag the sides of the image.

In many cases, you may need to present the updated excel data in the table. For this the table should be linked with the source file. When a change will be made in the source file, changes will be viewed in the word table also. To do this select the Paste link, then choose the Excel Worksheet Object and click ok. The table will be pasted in the document with the link to the source file. If a change is occurred in the source file, the changes will be viewed in the table. This type of link is very helpful where you will have to work with continuously changeable data. There is another way to do this. Just paste the table by clicking on the Paste button or pressing CTRL + V. There a small icon will appear at the bottom of the table. Click on it and select the option “Keep source formatting and link to excel”. To view as picture select the Paste as Picture option. To make the table more attractive, choose the option “Match destination table style and link to Excel.” Select the table by clicking on the top left symbol of the table. Then click on the Design tab. Then select the table style that you like. There are many lucrative styles in the Design tab. To delete the table, select the table the go to the Layout tab, click on Delete then Delete table. The table with data will be deleted.

You can import the object from the Word also. Open the Word file; then click on the Insert tab. Click on the Object in the Text group. Then click on the Create from File tab. Then click on Browse and select the excel file from where you want to import the table. Double click on the file, the file will be selected. Then check the Link to file check box. Then click ok. The table will be pasted there. If any changes occur in the excel file the changes will be viewed in the Word table also. To view just the link to the source table, check the Display as Icon check box. Then click ok. This will insert an icon in the Word document, by clicking on the icon you can enter into the source file. To know more things about using excel table data, associated help files of the Office software can help you.