Examples of using Worksheet data in English and their translations into Vietnamese
{-}
-
Colloquial
-
Ecclesiastic
-
Computer
Use Excel Online to collaborate on worksheet data with other people.
How to save worksheet data as csv file with/ without double quotes?
Work with the data You can scroll through worksheet data, select it, and search for it.
Linking worksheet data and charts for use in other programs such as Microsoft PowerPoint and Word.
If you are only interested in saving the worksheet data into the new text file, click Yes.
Create a named range in Excel(optional-useful if you only want to link to some of the worksheet data).
Note: The labels are now connected to the worksheet data, but the sheet of labels is still blank.
A chart sheet is beneficial when you want to view a chart ora PivotChart separately from worksheet data or a PivotTable.
Note: The labels are now connected to the worksheet data, but the sheet of labels is still blank.
The new worksheet data can be linked to the source data, if you check Create a link with the active sheet option.
If you want to add a colorful background to all of your worksheet data, you can also use a picture as a sheet background.
By default, Excel determines the base units for the dateaxis based on the smallest difference between any two dates in the worksheet data.
For more information, see Work with worksheet data in OneDrive or Using Office Web Apps in SharePoint.
When you open a workbook in view mode in Excel Online,you can view and interact with the worksheet data to help you interpret it.
For PivotTables based on worksheet data, Excel retrieves new fields within the source range or named range that you specified.
By using Microsoft Office Excel Web Access in their browsers,other users can view and analyze the worksheet data that is shown.
Showing trends in your worksheet data can be useful, especially when you're sharing your data with other people.
As long as the columns you use in the worksheet line up with the columns that are displayed on the Tasks page,you can simply click in the task list and paste your worksheet data.
Connect the labels to your worksheet data Your address list is the data source that Microsoft Word uses in the mail merge.
A document theme is a predefined set of colors, fonts, and effects(such as line styles and fill effects)that will be available when you format your worksheet data or other items, such as tables, PivotTables, or charts.
Showing trends in your worksheet data can be useful, especially when you're sharing your data with other people.
This course is targeted for students who wish to gain the skills necessary to create macros, collaborate with others,audit and analyze worksheet data, incorporate multiple data sources, and import and export data. .
For example, when you use the following worksheet data to create a scatter chart and a line chart, you can see that the data is distributed differently.
Before you format the data on your worksheet, you may want to apply the document theme that you want to use,so that the formatting that you apply to your worksheet data can use the colors, fonts, and effects that are determined by that document theme.
For more information, see Add worksheet data to a Data Model using a linked table and Copy and paste rows into a Data Model in Power Pivot.
Using Microsoft Query, you can connect to external data sources, select data from those external sources, import that data into your worksheet,and refresh the data as needed to keep your worksheet data synchronized with the data in the external sources.….
Display worksheet data that includes pairs or grouped sets of values In a scatter chart, you can adjust the independent scales of the axes to reveal more information about the grouped values.
For additional editing options,or to modify legend entries without affecting the worksheet data, you can make changes to the legend entries in the Select Data Source dialog box.
After you create a PivotTable based on worksheet data, external data, or multiple tables, you can access the Field List to add, arrange, and remove fields in your PivotTable report at any time.
Then repeat this step to add other worksheets data into the All ranges box.