sppn.info Laws Panduan Microsoft Excel Pdf

PANDUAN MICROSOFT EXCEL PDF

Monday, May 20, 2019


Microsoft Excel , Microsoft Excel (Windows). Microsoft Excel to use another file type, such as a PDF or Excel workbook. It's easy to. that'll get you well on your way to 'Excel Guru Status' giving you not only the You can find more Microsoft Office training (including Excel, Word and Outlook. Microsoft, ActiveX, Excel, InfoPath, Microsoft Press, MSDN, OneNote, In the Publish as PDF or XPS dialog box, ensure that the Save as type.


Panduan Microsoft Excel Pdf

Author:BARABARA JULIANA
Language:English, Spanish, French
Country:Burkina
Genre:Biography
Pages:
Published (Last):
ISBN:
ePub File Size: MB
PDF File Size: MB
Distribution:Free* [*Regsitration Required]
Downloads:
Uploaded by: JUSTA

Excel is a program that you never quite finish learning about. There have been many improvements in appearance, but Microsoft has in. Microsoft Press books are available through booksellers and distributors Microsoft, Microsoft Press, Access, Encarta, Excel, Fluent, Internet Explorer, MS. Microsoft, Microsoft Press, encarta, excel, internet explorer, Outlook, trademarks of Microsoft Corporation in the united states and/or other.

Example of how to import data from multiple data sources in a workbook with Power Query The following GIF illustrates the process to import data from multiple data sources in a workbook with Power Query. Identify the source CSV file and double-click on it. Power Query displays a dialog box named after the CSV file. Identify the source text file and double-click on it.

Power Query displays a dialog box named after the text file.

Example of how to import data from a text file with Power Query The following GIF illustrates the process to import data from a text file with Power Query. Working with the Import Data dialog box The Import Data dialog box is similar to other dialog boxes you work with when carrying out common Excel processes, such as opening or saving a workbook.

Therefore, you can do the following: Browse to the folder where the file workbook, CSV or text is saved. Double-click on the appropriate file. The file-filtering criteria applied by Excel depend on the type of file you're working with Excel workbook vs. CSV or text. This includes, for example, regular Excel workbooks, templates and macro-enabled workbooks. Regardless of the precise Excel file type you work with, Power Query limits itself to working with data in cells.

Therefore, items such as PivotTables, charts or macros aren't imported. When you work with a text file: The Import Data dialog box displays only text files. Working with the Navigator dialog box Power Query displays the Navigator dialog box when you work with an Excel workbook. The Navigator dialog box has 3 main sections: Left: Available data sources.

Right bottom: Load, Edit and Cancel buttons. Available data sources On the left side of the Navigator dialog box, Power Query lists the data sources you can select inside the workbook you're working with selected with the Import Data dialog box. When working with an Excel workbook, these data sources are generally 1 of the following 3: A worksheet. An Excel Table. A named range. It's possible to connect Power Query to, for example, dynamic named ranges.

The process to work with this type of named range, however, differs from what I describe in this Power Query Tutorial. You can distinguish these different data sources based on the icon displayed by Power Query next to the source. Once you enable the option to select multiple items, Power Query displays checkboxes to the left of all data sources in the workbook. Use these checkboxes to select all the data sources you want to import.

Preview Once you select a data source from the list of available data sources, Power Query displays a preview of the data. Use this preview to confirm that the source data you chose is correct. You can specify how and where the data is loaded by following the process I describe further below. Edit: Launch the Query Editor and edit your query. You learn the basics of working with the Query Editor further below.

Cancel: Close the dialog box and cancel the process of importing data with Power Query. Working with the dialog box named after the source CSV or text file Power Query displays a dialog box named after the source file when you work with CSV or text files. This dialog box has 3 main sections: Top: Drop-down menus. Middle: Preview. Bottom: Load, Edit and Cancel buttons. The main difference between this dialog box and the Navigator dialog box in a previous section is the fact that the Navigator dialog box allows you to choose from the available data sources within a workbook.

CSV and text files contain text data only.

You don't have named ranges, Excel Tables, nor multiple worksheets to choose from. Therefore, when importing data from a CSV or text file, you don't select a data source within the file.

Results of importing data with Power Query Results when you import a single data source from a workbook, or a CSV or text file with Power Query The results of importing data with Power Query are similar when you import data from either of the following: A single data source from a workbook. A CSV file. After you complete the appropriate process described in previous sections , Excel does the following: Loads the imported data to an Excel Table in a new worksheet.

This task pane includes the query you just created. Results when you import data from multiple data sources in a workbook with Power Query After you complete the process I describe above to import data from multiple data sources in a workbook, Excel does the following: Loads the imported data to the Data Model.

This task pane has separate queries for each data source you selected. Edit a query with Power Query Power Query has several features that allow you to edit queries. This section introduces the topic. However, covering all options exceeds the scope of this Power Query Tutorial. The processes I explain below build on the basic procedures to import data from workbooks, CSV and text files I explain in previous sections.

Please refer to those sections as needed. Click Edit. Power Query launches the Query Editor. Edit your query. Example of how to edit a query when importing data from a workbook with Power Query The following GIF illustrates the process to edit a query when importing data from a workbook with Power Query. In this example, I set the data type of the first column as Date by following the process I describe further below.

Example of how to edit a query when importing data from a text file with Power Query The following GIF illustrates the process to edit a query when importing data from a text file with Power Query. General considerations about the process to edit a query with Power Query Begin the process of editing a query with Power Query You begin the process of editing a query with Power Query by clicking on the Edit button on the bottom right section of the appropriate dialog box.

Edit your query with the Query Editor The Query Editor is displayed in a new window and usually has 4 main sections: Ribbon. Preview pane. Query Settings task pane. You use the Query Editor to edit your data prior to completing the import process with Power Query. Covering all the edition possibilities you have exceeds the scope of this Power Query Tutorial. At a basic level, your goal with the Query Editor is to do the following: Determine the elements of the source data you work with.

This usually involves working with the columns displayed in the Preview pane of the Query Editor. Carry out the editions that are required to shape, clean and transform the source data into the data you need.

To set a column's data type with Power Query, follow these 3 steps from within the Query Editor: Click on the column whose data type you want to set. Right-click on the column header and, in the context menu, go to Change Type.

This is the process I follow in the example below. If the column you work with has an existing data type conversion, confirm whether you want to: Replace the existing conversion; or Add the new conversion as a separate step. The following GIF illustrates the process to set a column's data type as Date.

In some cases, such as when working with international date and number formats, you may have to carry out additional steps. For example, when I apply the process above to the CSV or text file source data examples, the Query Editor returns errors. To set a column's data type with Power Query when working with international date and number formats, you can usually follow these 5 steps from within the Query Editor: Click on the column whose data type you want to set.

Select the appropriate data type and locale using the drop-down lists in the Change Type with Locale dialog box. Click OK. Results of editing a query with the Query Editor The results of importing data and editing a query with Power Query are similar to those of just importing data without editing the query.

Results when you edit a query while importing a single data source from a workbook, or a CSV or text file with Power Query The results of importing data and editing a query with Power Query are similar when you import data from either of the following: A single data source from a workbook.

After you complete the appropriate process described in previous sections , Excel does the following: Loads the imported data to a new worksheet.

Results when you edit a query while importing data from multiple data sources in a workbook with Power Query After you complete the process I describe above to edit a query while importing data from multiple data sources in a workbook, Excel does the following: Loads the imported data to the Data Model.

This task pane has separate queries for each data source. Load the data you import with Power Query How Power Query loads your data by default The processes I describe in previous sections work with the default data-loading settings. These settings may vary depending on the source data you work with. For example: If you load data from a single data source in a workbook, or a CSV or text file: Power Query loads the data to a new worksheet.

If you load data from multiple data sources in a workbook: Power Query loads the data to the Data Model. Specify where and how Power Query loads your data You can specify where and how Power Query loads the data you import. You specify data-loading settings from either of the following: The Navigator dialog box when working with an Excel workbook or the dialog box named after the source CSV or text file when working with a CSV or text file.

The Query Editor.

Excel displays the Import Data dialog box. Select the loading settings you want to apply. I explain how you work with the Import Data dialog box below. An Excel Table. A named range. It's possible to connect Power Query to, for example, dynamic named ranges. The process to work with this type of named range, however, differs from what I describe in this Power Query Tutorial.

You can distinguish these different data sources based on the icon displayed by Power Query next to the source. Once you enable the option to select multiple items, Power Query displays checkboxes to the left of all data sources in the workbook. Use these checkboxes to select all the data sources you want to import. Preview Once you select a data source from the list of available data sources, Power Query displays a preview of the data.

Use this preview to confirm that the source data you chose is correct. You can specify how and where the data is loaded by following the process I describe further below. Edit: Launch the Query Editor and edit your query.

You learn the basics of working with the Query Editor further below. Cancel: Close the dialog box and cancel the process of importing data with Power Query. Working with the dialog box named after the source CSV or text file Power Query displays a dialog box named after the source file when you work with CSV or text files. This dialog box has 3 main sections: Top: Drop-down menus.

Microsoft Office

Middle: Preview. Bottom: Load, Edit and Cancel buttons. The main difference between this dialog box and the Navigator dialog box in a previous section is the fact that the Navigator dialog box allows you to choose from the available data sources within a workbook. CSV and text files contain text data only. You don't have named ranges, Excel Tables, nor multiple worksheets to choose from.

Therefore, when importing data from a CSV or text file, you don't select a data source within the file. Results of importing data with Power Query Results when you import a single data source from a workbook, or a CSV or text file with Power Query The results of importing data with Power Query are similar when you import data from either of the following: A single data source from a workbook.

A CSV file. After you complete the appropriate process described in previous sections , Excel does the following: Loads the imported data to an Excel Table in a new worksheet.

This task pane includes the query you just created. Results when you import data from multiple data sources in a workbook with Power Query After you complete the process I describe above to import data from multiple data sources in a workbook, Excel does the following: Loads the imported data to the Data Model.

This task pane has separate queries for each data source you selected.

Edit a query with Power Query Power Query has several features that allow you to edit queries. This section introduces the topic. However, covering all options exceeds the scope of this Power Query Tutorial. The processes I explain below build on the basic procedures to import data from workbooks, CSV and text files I explain in previous sections. Please refer to those sections as needed. Click Edit. Power Query launches the Query Editor. Edit your query. Example of how to edit a query when importing data from a workbook with Power Query The following GIF illustrates the process to edit a query when importing data from a workbook with Power Query.

In this example, I set the data type of the first column as Date by following the process I describe further below. Example of how to edit a query when importing data from a text file with Power Query The following GIF illustrates the process to edit a query when importing data from a text file with Power Query.

General considerations about the process to edit a query with Power Query Begin the process of editing a query with Power Query You begin the process of editing a query with Power Query by clicking on the Edit button on the bottom right section of the appropriate dialog box.

Excel notes pdf

Edit your query with the Query Editor The Query Editor is displayed in a new window and usually has 4 main sections: Ribbon. Preview pane. Query Settings task pane. You use the Query Editor to edit your data prior to completing the import process with Power Query. Covering all the edition possibilities you have exceeds the scope of this Power Query Tutorial.

At a basic level, your goal with the Query Editor is to do the following: Determine the elements of the source data you work with. This usually involves working with the columns displayed in the Preview pane of the Query Editor. Carry out the editions that are required to shape, clean and transform the source data into the data you need.

Examples of how ASAP Utilities will save you time and make YOU rock in Excel

To set a column's data type with Power Query, follow these 3 steps from within the Query Editor: Click on the column whose data type you want to set. Right-click on the column header and, in the context menu, go to Change Type. This is the process I follow in the example below. If the column you work with has an existing data type conversion, confirm whether you want to: Replace the existing conversion; or Add the new conversion as a separate step.

Key Highlights of VBA Tutorial PDF are

The following GIF illustrates the process to set a column's data type as Date. In some cases, such as when working with international date and number formats, you may have to carry out additional steps.

For example, when I apply the process above to the CSV or text file source data examples, the Query Editor returns errors. To set a column's data type with Power Query when working with international date and number formats, you can usually follow these 5 steps from within the Query Editor: Click on the column whose data type you want to set.

Select the appropriate data type and locale using the drop-down lists in the Change Type with Locale dialog box. Click OK. Results of editing a query with the Query Editor The results of importing data and editing a query with Power Query are similar to those of just importing data without editing the query.

Results when you edit a query while importing a single data source from a workbook, or a CSV or text file with Power Query The results of importing data and editing a query with Power Query are similar when you import data from either of the following: A single data source from a workbook.

After you complete the appropriate process described in previous sections , Excel does the following: Loads the imported data to a new worksheet. Results when you edit a query while importing data from multiple data sources in a workbook with Power Query After you complete the process I describe above to edit a query while importing data from multiple data sources in a workbook, Excel does the following: Loads the imported data to the Data Model.

This task pane has separate queries for each data source.

Load the data you import with Power Query How Power Query loads your data by default The processes I describe in previous sections work with the default data-loading settings. These settings may vary depending on the source data you work with.

For example: If you load data from a single data source in a workbook, or a CSV or text file: Power Query loads the data to a new worksheet. If you load data from multiple data sources in a workbook: Power Query loads the data to the Data Model. Specify where and how Power Query loads your data You can specify where and how Power Query loads the data you import.

You specify data-loading settings from either of the following: The Navigator dialog box when working with an Excel workbook or the dialog box named after the source CSV or text file when working with a CSV or text file.

The Query Editor. Excel displays the Import Data dialog box. Select the loading settings you want to apply. I explain how you work with the Import Data dialog box below. Example of how to specify data-loading settings from the Navigator dialog box or the dialog box named after the source CSV or text file The following GIF illustrates the process to specify where and how imported data is loaded from the Navigator dialog box or the dialog box named after the source CSV or text file.

In this example: I work with a CSV file. Instead of loading the imported data to a worksheet the default , I only create the connection. Example of how to specify data-loading settings from the Query Editor The following GIF illustrates the process to specify where and how imported data is loaded from the Query Editor.

In this example: I work with a text file. Work with the Import Data dialog box The Import Data dialog box has 3 main sections, where you specify the following: How you view the imported data in the Excel workbook. As an Excel Table.

As a Pivot Table Report. As a Pivot Chart. Where in the Excel workbook is the data loaded. In an existing worksheet. Whether the data is added to the Data Model. Results of specifying where and how imported data is loaded with Power Query After you complete the appropriate process described in previous sections , Excel does the following: Loads the imported data according to the settings you specify in the Load To dialog box.

In the examples above, I only created a connection. Therefore, the imported data isn't loaded to a worksheet. Combine the data you import from different files with Power Query There are different ways in which you can combine the data you import from different files with Power Query. In this Power Query Tutorial, I explain 2 common and similar methods to consolidate imported data: Create a new query.

Append data to an existing query. You combine or consolidate data imported from different files with the Append feature of Power Query. When you append data, you add the entries from 1 table to the end of another table.Pada Convert your PDF file silahkan pilih file pdf dengan tekan Select File , Output file silahkan pilih lokasi hasil convert , dan untuk mengubah pdf ke word silahkan klik tombol " Convert ".

The best course and tutorial, and how to learn and use Advanced Microsoft Excel Thanks, gan atas informasinya sangat bermanfaat. Start on. Power Query displays the Navigator dialog box.