Microsoft office 2016 tutorial free.Microsoft Training

Looking for:

Microsoft office 2016 tutorial free

This method can be the most efficient when there are many users. None Select this option to save the username and password in the connection file. Important: Avoid saving logon information when connecting to data sources. This information may be stored as plain text, and a malicious user could access the information to compromise the security of the data source. Select Finish to close the Data Connection Wizard. Decide how you want to import the data, and then select OK.

For more information about using this dialog box, select the question mark? You can connect to a specific offline cube file if it has been created on the database server. You can also import data into Excel as either a Table or a PivotTable report. In the Navigator pane select the database, and then select the cube or tables you want to connect. Click Load to load the selected table into a worksheet, or click Edit to perform additional data filters and transformations in the Power Query Editor before loading it.

Note: Before you can connect to an Oracle database using Power Query , you need the Oracle client software v8. If you want to import data using native database query, specify your query in the SQL Statement box.

For more information, see Import data from database using Native Database Query. For more information about advanced connector options, see Oracle Database. Select the driver that matches your Power Query installation bit or bit. For more information, see Import data from a database using Native Database Query. For more information about advanced connector options, see MySQL database.

Select the driver that matches your Office version bit or bit. For more information, see Which version of Office am I using? Also make sure you have the provider registered in the machine configuration that matches the most recent.

NET version on your device. For more information about advanced connector options, see PostgreSQL. Select the driver that matches your Excel installation bit or bit. By default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection. Note: Before you can connect to a Teradata database, you need the.

This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription. If you are a Microsoft subscriber, make sure you have the latest version of Office. You will need an SAP account to login to the website and download the drivers. If you are unsure, contact the SAP administrator in your organization. The server name should follow the format ServerName:Port.

Optionally, if you want to import data using native database query, Select Advanced options and in the SQL Statement box enter the query. Azure SQL Database is a high-performing, fully managed, scalable relational database built for the cloud and used for mission-critical applications. For more information about advanced connector options, see Azure SQL database. Azure Synapse Analytics combines big data tools and relational queries by using Apache Spark to connect to Azure data services and the Power Platform.

You can load millions of rows in no time. Then, you can work with tabular data by using familiar SQL syntax for queries. For more information, see What is Azure Synapse Analytics. For more information about advanced connector options, see Azure Synapse Analytics. Azure HDInsight is used for big data analysis when you need to process large amounts of data. It supports data warehousing and machine learning; you can think of it as a data flow engine.

Select your cluster in the Navigator dialog, and then find and select a content file. Select Load to load the selected table, or Edit to perform additional data filters and transformations before loading it. If you are connecting to the Blob storage service for the first time, you will be prompted to enter and save the storage access key.

Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then select the Manage Access Key icon on the bottom of the page.

Select the copy icon to the right of the primary key, and then paste the value in the Account Key box. The Azure Storage provides storage services for a variety of data objects. For more information, see Introduction to Table storage.

Azure Data Lake Storage Gen 1 combines different data warehouses into a single, stored environment. You can use a new generation of query tools to explore and analyze data, working with petabytes of data. For more information, see Azure Data Lake Storage. Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. It can handle large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more.

For more information, see What is Azure Data Explorer. In the Azure Data Explorer Kusto dialog box, enter appropriate values. Each prompt provides helpful examples to walk you though the process.

You can import Datasets from your organization with appropriate permission by selecting them from the Power BI Datasets pane, and then creating a PivotTable in a new worksheet. The Power BI Datasets pane appears. If many Datasets are available, use the Search box.

Select the arrow next to the box to display keyword filters for versions and environments to target your search. Select a Dataset and create a PivotTable in a new worksheet.

Select the 2. As an alternative to 2. For more information about advanced connector options, see SharePoint Online list. If you have many objects, use the Search box to locate an object or use he Display Options along with the Refresh button to filter the list. Select or clear the Skip files with errors checkbox at the bottom of the dialog box. If you select the Advanced option, you can append certain additional parameters to the query to control what data is returned.

If you aren’t signed in using the Microsoft Work or School account you use to access Dataverse for Apps, select Sign in and enter the account username and password. The Salesforce Objects dialog box appears. Select either Production or Custom. If you select Custom , enter the URL of a custom instance. For more information about advanced connector options, see Salesforce Objects. Because Salesforce Reports has API limits retrieving only the first 2, rows for each report, consider using the Salesforce Objects connector to work around this limitation if needed.

The Salesforce Reports dialog box appears. For more information about advanced connector options, see Salesforce Reports. Make sure you have the latest version of the Adobe Analytics connector.

Microsoft Query has been around a long time and is still popular. In many ways, it’s a progenitor of Power Query. For more information, see Use Microsoft Query to retrieve external data.

By default, the most general URL is selected. Select Anonymous if the SharePoint Server does not require any credentials. Select Organizational account if the SharePoint Server requires organizational account credentials. For more information about advanced connector options, see SharePoint list. Select Marketplace key if the OData feed requires a Marketplace account key. Click Organizational account if the OData feed requires federated access credentials. For Windows Live ID, log into your account.

For more information about advanced connector options, see OData feed. HDFS connects computer nodes within clusters over which data files are distributed and you can access these data files as one seamless file stream. Enter the name of the server in the Server box, and then select OK. In the Active Directory Domain dialog box for your domain, select Use my current credentials , or select Use alternate credentials and then enter your Username and Password.

After the connection succeeds, use the Navigator pane to browse all the domains available within your Active Directory, and then drill down into Active Directory information including Users, Accounts, and Computers. In the next dialog box, select from Default or Custom , Windows , or Database connection options, enter your credentials, and then select Connect. In the Navigator pane, select the tables or queries that you want to connect to, then select Load or Edit.

For more information about advanced connector options, see ODBC data source. In the Navigator dialog box, select the database, and tables or queries you want to connect to, and then select Load or Edit. Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, Note: If this is the first time you’ve connected to Facebook, you will be asked to provide credentials. Sign in using your Facebook account, and allow access to the Power Query application.

You can turn off future prompts by clicking the Don’t warn me again for this connector option. Note: Your Facebook username is different from your login email. Select a category to connect to from the Connection drop-down list. For example, select Friends to give you access to all information available in your Facebook Friends category. If necessary, click Sign in from the Access Facebook dialog, then enter your Facebook email or phone number, and password. You can check the option to remain logged in.

Once signed in, click Connect. After the connection succeeds, you will be able to preview a table containing information about the selected category. For instance, if you select the Friends category, Power Query renders a table containing your Facebook friends by name. You can create a blank query. You might want to enter data to try out some commands, or you can select the source data from Power Query:.

For more information, see Manage data source settings and permissions. This command is similar to the Get Data command on the Data tab of the Excel ribbon. This command is similar to the Recent Sources command on the Data tab of the Excel ribbon. When you merge two external data sources, you join two queries that create a relationship between two tables.

When you append two or more queries, the data is added to a query based on the names of the column headers in both tables.

The queries are appended in the order in which they’re selected. For more information, see Append queries Power Query. You can use the Power Query add-in to connect to external data sources and perform advanced data analyses.

The following sections provide steps for connecting to your data sources – web pages, text files, databases, online services, and Excel files, tables, and ranges.

Click the Power Query check box, then OK. The Power Query ribbon should appear automatically, but if it doesn’t, close and restart Excel. The following video shows the Query Editor window appearing after editing a query from an Excel workbook. The following video shows one way to display the Query Editor.

These automatic actions are equivalent to manually promoting a row and manually changing each column type. For example:. The following video shows the Query Editor window in Excel appearing after editing a query from an Excel workbook. If prompted, in the From Table dialog box, you can click the Range Selection button to select a specific range to use as a data source.

If the range of data has column headers, you can check My table has headers. The range header cells are used to set the column names for the query. Note: If your data range has been defined as a named range, or is in an Excel table, then Power Query will automatically sense the entire range and load it into the Query Editor for you. Plain data will automatically be converted to a table when it is loaded into the Query Editor.

You can use the Query Editor to write formulas for Power Query. You can also use the Query Editor to write formulas for Power Query. Note: While trying to import data from a legacy Excel file or an Access database in certain setups, you may encounter an error that the Microsoft Access Database Engine Microsoft.

The error occurs on systems with only Office installed. To resolve this error, download the following resources to ensure that you can proceed with the data sources you are trying to access. Microsoft Access Database Engine Redistributable. Access Database Engine Service Pack 1. In the Access Web dialog box, click a credentials option, and provide authentication values. Power Query will analyze the web page, and load the Navigator pane in Table View. If you know which table you want to connect to, then click it from the list.

For this example, we chose the Results table. Otherwise, you can switch to the Web View and pick the appropriate table manually.

In this case, we’ve selected the Results table. Click Load , and Power Query will load the web data you selected into Excel. Windows : This is the default selection. In the next dialog box, select from Default or Custom , Windows , or Database connection options, enter your credentials, then press Connect. In the Navigator pane, select the tables or queries that you want to connect to, then press Load or Edit. In the Browse dialog box, browse for or type a file URL to import or link to a file.

Follow the steps in the Navigator dialog to connect to the table or query of your choice. After the connection succeeds, you will be able to use the Navigator pane to browse and preview the collections of items in the XML file in a tabular form. Save Data Connection File and Finish.

In the Select the database that contains the data you want pane, select a database, then click Next. To connect to a specific cube in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list.

In the Import Data dialog box, under Select how you want to view this data in your workbook , do one of the following:.

To store the selected connection in the workbook for later use, click Only Create Connection. This check box ensures that the connection is used by formulas that contain Cube functions that you create and that you don’t want to create a PivotTable report. To place the PivotTable report in an existing worksheet, select Existing worksheet , and then type the cell reference of the first cell in the range of cells where you want to locate the PivotTable report.

You can also click Collapse Dialog to temporarily hide the dialog box, select the beginning cell on the worksheet that you want to use, and then press Expand Dialog. To place the PivotTable report in a new worksheet starting at cell A1, click New worksheet.

In the Access SharePoint dialog box that appears next, select a credentials option:. In the Navigator dialog, select the Database and tables or queries you want to connect to, then press Load or Edit. In the Active Directory Domain dialog box for your domain, click Use my current credentials , or Use alternate credentials. For Use alternate credentials authentication, enter your Username and Password. After the connection succeeds, you can use the Navigator pane to browse all the domains available within your Active Directory, and drill down into Active Directory information including Users, Accounts, and Computers.

See: Which version of Office am I using? If you aren’t signed in using the Microsoft Work or School account you use to access CDS for Apps, click Sign in and enter the account username and password.

If the data is good to be imported as is, then select the Load option, otherwise choose the Edit option to open the Power Query Editor. Note: The Power Query Editor gives you multiple options to modify the data returned. For instance, you might want to import fewer columns than your source data contains. Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then click on the Manage Access Key icon on the bottom of the page.

Click on the copy icon to the right of the primary key, and then paste the value in the Account Key box. Note: If you need to retrieve your key, return to the Microsoft Azure Portal , select your storage account, and click on the Manage Access Key icon on the bottom of the page. Click on the copy icon to the right of the primary key and paste the value into the wizard.

Make sure you have downloaded, installed, and activated the Power Query Add-In. For Use alternate credenitals authentication, enter your Username and Password. Power Query is not available in Excel However, you can still connect to external data sources. Step 1: Create a connection with another workbook. Near the bottom of the Existing Connections dialog box, click Browse for More. In the Select Table dialog box, select a table worksheet , and click OK.

You can rename a table by clicking on the Properties button. You can also add a description. Click Existing Connections , choose the table, and click Open.

In the Import Data dialog box, choose where to put the data in your workbook and whether to view the data as a Table , PivotTable , or PivotChart. In the Select Data Source dialog box, browse to the Access database. In the Select Table dialog box, select the tables or queries you want to use, and click OK.

You can click Finish , or click Next to change details for the connection. In the Import Data dialog box, choose where to put the data in your workbook and whether to view the data as a table, PivotTable report, or PivotChart.

Click the Properties button to set advanced properties for the connection, such as options for refreshing the connected data. Optionally, you can add the data to the Data Model so that you can combine your data with other tables or data from other sources, create relationships between tables, and do much more than you can with a basic PivotTable report.

Then, in the Import Text File dialog box, double-click the text file that you want to import, and the Text Import Wizard dialog will open. Original data type If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. If all of the items in each column are the same length, select Fixed width.

Start import at row Type or select a row number to specify the first row of the data that you want to import. File origin Select the character set that is used in the text file. In most cases, you can leave this setting at its default. If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set. For example, if your computer is set to use character set Cyrillic, Windows , but you know that the file was produced by using character set Western European, Windows , you should set File Origin to Preview of file This box displays the text as it will appear when it is separated into columns on the worksheet.

Delimiters Select the character that separates values in your text file. If the character is not listed, select the Other check box, and then type the character in the box that contains the cursor.

These options are not available if your data type is Fixed width. Treat consecutive delimiters as one Select this check box if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters.

Text qualifier Select the character that encloses values in your text file. When Excel encounters the text qualifier character, all of the text that follows that character and precedes the next occurrence of that character is imported as one value, even if the text contains a delimiter character. For example, if the delimiter is a comma , and the text qualifier is a quotation mark ” , “Dallas, Texas” is imported into one cell as Dallas, Texas.

If no delimiter character occurs between text qualifiers, Excel includes the qualifier character in the imported value. Hence, “Dallas Texas” using the quotation mark text qualifier is imported into one cell as “Dallas Texas”. Data preview Review the text in this box to verify that the text will be separated into columns on the worksheet as you want it. Data preview Set field widths in this section. Click the preview window to set a column break, which is represented by a vertical line. Double-click a column break to remove it, or drag a column break to move it.

Specify the type of decimal and thousands separators that are used in the text file. When the data is imported into Excel, the separators will match those that are specified for your location in Regional and Language Options or Regional Settings Windows Control Panel.

Column data format Click the data format of the column that is selected in the Data preview section. If you do not want to import the selected column, click Do not import column skip. After you select a data format option for the selected column, the column heading under Data preview displays the format. If you select Date , select a date format in the Date box. Choose the data format that closely matches the preview data so that Excel can convert the imported data correctly.

To convert a column of all currency number characters to the Excel Currency format, select General. To convert a column of all number characters to the Excel Text format, select Text. To convert a column of all date characters, each date in the order of year, month, and day, to the Excel Date format, select Date , and then select the date type of YMD in the Date box.

Excel will import the column as General if the conversion could yield unintended results. If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General. This allows users to have a preview of how the option would affect the appearance of the object, without actually applying it.

The new Mini Toolbar is a small toolbar with basic formatting commands that appears within the document editing area, much like a context menu. When the mouse selects part of the text, Mini Toolbar appears close to selected text. It remains semi-transparent until the mouse pointer is hovered on it, to avoid obstructing what is underneath. Mini Toolbar is not customizable in Office , but can be turned off.

It is customizable, although this feature is limited, compared to toolbars in previous Office versions. Any command available in the entire Office application can be added to the Quick Access toolbar , including commands not available on the ribbon as well as macros. Keyboard shortcuts for any of the commands on the toolbar are also fully customizable, similar to previous Office versions. SmartArt, found under the Insert tab in the ribbon in PowerPoint, Word, Excel, and Outlook, is a new group of editable and formatted diagrams.

There are preset SmartArt graphics layout templates in categories such as list, process, cycle, and hierarchy. When an instance of a SmartArt is inserted, a Text Pane appears next to it to guide the user through entering text in the hierarchical levels.

Each SmartArt graphic, based on its design, maps the text outline, automatically resized for best fit, onto the graphic. There are a number of “quick styles” for each graphic that apply largely different 3D effects to the graphic, and the graphic’s shapes and text can be formatted through shape styles and WordArt styles. In addition, SmartArt graphics change their colors, fonts, and effects to match the document’s theme.

Such files are saved using an extra X letter in their extension. However, it can still save documents in the old format, which is compatible with previous versions. Alternatively, Microsoft has made available a free add-on known as the Microsoft Office Compatibility Pack that lets Office , XP, and open, edit, and save documents created under the newer format.

Files containing macros are saved with an extra M letter in their extension instead. However, due to legal objections from Adobe Systems , Office originally did not offer PDF support out of the box, but rather as a separate free download.

Office documents can also be exported as XPS documents. This is part of Service Pack 2 and prior to that, was available as a free plug-in in a separate download.

Microsoft backs an open-source effort to support OpenDocument in Office , as well as earlier versions up to Office , through a converter add-in for Word, Excel and PowerPoint, and also a command-line utility. Section 8. Peter Amstein and the Microsoft Office team are reluctant to make liberal use of extension mechanisms, even though provided in ODF 1.

They want to avoid all appearance of an embrace-extend attempt. In Office , Microsoft introduced the Document Inspector , an integral metadata removal tool that strips Word, Excel, and PowerPoint documents of information such as author name and comments and other “metadata”. In Microsoft Office , the Office Assistants were eliminated in favour of a new online help system. One of its features is the extensive use of Super Tooltips, which explain in about one paragraph what each function performs.

Some of them also use diagrams or pictures. These appear and disappear like normal tooltips, and replace normal tooltips in many areas. The Help content also directly integrates searching and viewing Office Online articles. Microsoft Office includes features geared towards collaboration and data sharing.

As such, Microsoft Office features server components for applications such as Excel, which work in conjunction with SharePoint Services , to provide a collaboration platform. NET 2. Excel server exposes Excel Services, which allows any worksheet to be created, edited and maintained via web browsers. It features Excel Web Access , the client-side component which is used to render the worksheet on a browser, Excel Calculation Service which is the server side component which populates the worksheet with data and perform calculations, and Excel Web Services that extends Excel functionalities into individual web services.

SharePoint can also be used to host Word documents for collaborative editing , by sharing a document. SharePoint can also be used to hold PowerPoint slides in a Slide Library , from which the slides can be used as a formatting template. It also notifies users of a slide automatically in case the source slide is modified. Also by using SharePoint, PowerPoint can manage shared review of presentations. Any SharePoint hosted document can be accessed from the application which created the document or from other applications such as a browser or Microsoft Office Outlook.

Microsoft Office also includes Groove , which brings collaborative features to a peer-to-peer paradigm. Groove can host documents, including presentations, workbooks and others, created in Microsoft Office application in a shared workspace, which can then be used in collaborative editing of documents. Groove can also be used in managing workspace sessions, including access control of the workspace.

To collaborate on one or more documents, a Workspace must be created, and then those who are to work on it must be invited.

Any file shared on the workspace are automatically shared among all participants. The application also provides real-time messaging, including one-to-one as well as group messaging, and presence features, as well as monitoring workspace activities with alerts, which are raised when pre-defined set of activities are detected. Groove also provides features for conflict resolution for conflicting edits.

Schedules for a collaboration can also be decided by using a built-in shared calendar, which can also be used to keep track of the progress of a project.

However, the calendar is not compatible with Microsoft Outlook. The Document Theme defines the colors, fonts and graphic effects for a document. Almost everything that can be inserted into a document is automatically styled to match the overall document theme creating a consistent document design.

Microsoft Office Outlook can also include an optional Business Contact Manager included on a separate installation disc in Office Small Business and above which allows management of business contacts and their sales and marketing activities.

Phone calls, e-mails, appointments, notes and other business metrics can be managed for each contact. It can also keep a track of billable time for each contact on the Outlook Calendar.

Based on these data, a consolidated report view can be generated by Microsoft Office Outlook with Business Contact Manager. The data can be further analyzed using Microsoft Office Excel. This data can also be shared using SharePoint Services. Microsoft Office SharePoint Server allows sharing and collaborative editing of Office documents. It allows central storage of documents and management of Office documents, throughout the enterprise.

These documents can be accessed either by the applications which created them, Microsoft Office Outlook , or a web browser. Documents can also be managed through pre-defined policies that let users create and publish shared content, through a SharePoint site.

SharePoint Server allows searching of all Office documents which are being managed by it, centrally, thereby making data more accessible. It also provides access control for documents. Specialized server components can plug into the SharePoint Server to extend the functionality of the server, such as Excel Services exposing data analysis services for Excel services.

Data from other data sources can also be merged with Office data. SharePoint also lets users personalize the SharePoint sites, filtering content they are interested in.

SharePoint documents can also be locally cached by clients for offline editing; the changes are later merged. Microsoft Office Forms Server allows InfoPath forms to be accessed and filled out using any browser, including mobile phone browsers. Forms Server also supports using a database or other data source as the back-end for the form. Additionally, it allows centralized deployment and management of forms.

Forms Server hosted forms also support data validation and conditional formatting, as does their InfoPath counterpart. It also supports advanced controls like Repeating section and Repeating table. However, some InfoPath controls cannot be used if it must be hosted on a Forms server. Microsoft Office Groove Server is for centrally managing all deployments of Microsoft Office Groove in the enterprise. It enables using Active Directory for Groove user accounts, and create Groove Domains , with individual policy settings.

It allows Groove workspaces to be hosted at the server, and the files in the workspaces made available for collaborative editing via the Groove client. It also includes the Groove Server Data Bridge component to allow communication between data stored at both Groove clients and servers and external applications. Microsoft Office Project Server allows one to centrally manage and coordinate projects.

It allows budget and resource tracking, and activity plan management. The project data and reports can also be further analyzed using Cube Building Service.

The project management data can be accessed from a browser as well. Microsoft Office Project Portfolio Server allows creation of a project portfolio, including workflows, hosted centrally, so that the information is available throughout the enterprise, even from a browser.

It also aids in centralized data aggregation regarding the project planning and execution, and in visualizing and analyzing the data to optimize the project plan. It can also support multiple portfolios per project, to track different aspects of it.

It also includes reporting tools to create consolidated reports out of the project data. Microsoft PerformancePoint Server allows users to monitor, analyze, and plan their business as well as drive alignment, accountability, and actionable insight across the entire organization. It includes features for scorecards, dashboards, reporting, analytics, budgeting and forecasting, among others. Even though the ribbon can be hidden, PC World wrote that the new “ribbon” interface crowds the Office work area, especially for notebook users.

As a result, users who were more familiar with the logic of the old menus would be somewhat frustrated with the new, more visually oriented ribbon. The ribbon cannot be moved from the top to the side of the page, as floating toolbars could be. Some users with experience using previous versions of Microsoft Office have complained about having to find features in the ribbon.

Others state that having learnt to use the new interface, it has improved the speed with which “professional-looking” documents can be created. Microsoft contractor Mike Gunderloy left Microsoft partially over his disagreement with the company’s “sweeping land grab ” including its attempt to patent the ribbon interface. He says “Microsoft itself represents a grave threat to the future of software development through its increasing inclination to stifle competition through legal shenanigans.

The new XML-based document file format in Microsoft Office is incompatible with previous versions of Microsoft Office unless an add-on is installed for the older version. PC World has stated that upgrading to Office presents dangers to certain data, such as templates, macros, and mail messages. The new Word features for bibliographies only support a small number of fixed citation styles.

Using XSLT, new styles can be added. Some extra styles, such as the standard Association for Computing Machinery publication format, are made freely available by third parties.

From Wikipedia, the free encyclopedia. Version of Microsoft Office. These four programs make up the Home and Student edition. Service Pack 3 Main article: Ribbon computing. Main article: OpenDocument software. Main article: Microsoft Word. Main article: Microsoft Outlook.

Main article: Microsoft Excel. Main article: Microsoft PowerPoint. Main article: Microsoft OneNote. Main article: Microsoft Access. Main article: Microsoft Publisher. Main article: Microsoft InfoPath. Main article: Microsoft Visio. Main article: Microsoft Project. Main article: Microsoft SharePoint Designer. Main article: Microsoft Office Forms Server. Main article: Microsoft Office Groove Server.

Main article: Microsoft Office Project Server. News Center. January 29, Archived from the original on September 24, Retrieved November 9, Computer World. Archived from the original on September 25, System requirements for the Office release. Archived from the original on September 14, Archived from the original on March 7, PC World. Archived from the original on November 10, DailyTech, LLC. Archived from the original on March 23, CIO Magazine.

Archived from the original on March 5, Microsoft TechNet. Wasif K Niazi. Retrieved March 10, Office Support. CBS Interactive. Archived from the original on March 12, Microsoft Support. Archived from the original on July 29, Retrieved June 17, August 27, Retrieved September 14, An Office User Interface Blog. Archived from the original on September 4, Retrieved October 30, Archived from the original on March 10, Retrieved August 13, Archived from the original on January 7, Retrieved November 10, Retrieved December 17, April 28, May 21, Archived from the original on August 5, Archived from the original on February 18, October 22, Retrieved February 5, Archived from the original on September 10, Archived from the original on May 24, Retrieved May 25, Archived from the original on July 3, I Started Something.

Нет. – Стратмор хмуро посмотрел на нее и двинулся к двери. – Но будем надеяться, что он этого не узнает.

Original data type If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. If all of the items in each column are the same length, select Fixed width. Start import at row Type or select a row number to specify the first row of the data that you want to import. File origin Select the character set that is used in the text file. In most cases, you can leave this setting at its default. If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set.

For example, if your computer is set to use character set Cyrillic, Windows , but you know that the file was produced by using character set Western European, Windows , you should set File Origin to Preview of file This box displays the text as it will appear when it is separated into columns on the worksheet. Delimiters Select the character that separates values in your text file. If the character is not listed, select the Other check box, and then type the character in the box that contains the cursor.

If no character or the apostrophe ‘ is specified as the text qualifier, “Dallas, Texas” is imported into two adjacent cells as “Dallas and Texas”.

If the delimiter character occurs between text qualifiers, Excel omits the qualifiers in the imported value. If no delimiter character occurs between text qualifiers, Excel includes the qualifier character in the imported value.

Hence, “Dallas Texas” using the quotation mark text qualifier is imported into one cell as “Dallas Texas”. Data preview Review the text in this box to verify that the text will be separated into columns on the worksheet as you want it. Data preview Set field widths in this section. Click the preview window to set a column break, which is represented by a vertical line.

Double-click a column break to remove it, or drag a column break to move it. Specify the type of decimal and thousands separators that are used in the text file. When the data is imported into Excel, the separators will match those that are specified for your location in Regional and Language Options or Regional Settings Windows Control Panel.

Column data format Click the data format of the column that is selected in the Data preview section. If you do not want to import the selected column, click Do not import column skip.

After you select a data format option for the selected column, the column heading under Data preview displays the format. If you select Date , select a date format in the Date box.

Choose the data format that closely matches the preview data so that Excel can convert the imported data correctly. To convert a column of all currency number characters to the Excel Currency format, select General. To convert a column of all number characters to the Excel Text format, select Text. To convert a column of all date characters, each date in the order of year, month, and day, to the Excel Date format, select Date , and then select the date type of YMD in the Date box.

Excel will import the column as General if the conversion could yield unintended results. If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General. If, in a column of dates, each date is in the order of year, month, and date, and you select Date along with a date type of MDY , Excel converts the column to General format. A column that contains date characters must closely match an Excel built-in date or custom date formats.

If Excel does not convert a column to the format that you want, you can convert the data after you import it. Convert numbers stored as text to numbers. Convert dates stored as text to dates. TEXT function. VALUE function. When you have selected the options you want, click Finish to open the Import Data dialog and choose where to place your data. Set these options to control how the data import process runs, including what data connection properties to use and what file and range to populate with the imported data.

The options under Select how you want to view this data in your workbook are only available if you have a Data Model prepared and select the option to add this import to that model see the third item in this list. If you choose Existing Worksheet , click a cell in the sheet to place the first cell of imported data, or click and drag to select a range.

If you have a Data Model in place, click Add this data to the Data Model to include this import in the model. For more information, see Create a Data Model in Excel. Note that selecting this option unlocks the options under Select how you want to view this data in your workbook. Click Properties to set any External Data Range properties you want. For more information, see Manage external data ranges and their properties. In the New Web Query dialog box, enter the address of the web page you want to query in the Address box, and then click Go.

In the web page, click the little yellow box with a red arrow next to each table you want to query. None The web data will be imported as plain text. No formatting will be imported, and only link text will be imported from any hyperlinks. Rich text formatting only The web data will be imported as rich text, but only link text will be imported from any hyperlinks.

This option only applies if the preceding option is selected. If this option is selected, delimiters that don’t have any text between them will be considered one delimiter during the import process. If not selected, the data is imported in blocks of contiguous rows so that header rows will be recognized as such. If selected, dates are imported as text.

SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security.

Strong password: Y6dh! Weak password: house1. Passwords should be 8 or more characters in length. Under Select the database that contains the data you want , select a database. Under Connect to a specific table , select a specific table or view. Alternatively, you can clear the Connect to a specific table check box, so that other users who use this connection file will be prompted for the list of tables and views. Optionally, in the File Name box, revise the suggested file name. Click Browse to change the default file location My Data Sources.

Optionally, type a description of the file, a friendly name, and common search words in the Description , Friendly Name , and Search Keywords boxes. To ensure that the connection file is always used when the data is updated, click the Always attempt to use this file to refresh this data check box.

This check box ensures that updates to the connection file will always be used by all workbooks that use that connection file. To specify how the external data source of a PivotTable report is accessed if the workbook is saved to Excel Services and is opened by using Excel Services, click Authentication Settings , and then select one of the following options to log on to the data source:.

Windows Authentication Select this option to use the Windows user name and password of the current user.

This is the most secure method, but it can affect performance when many users are connected to the server. A site administrator can configure a Windows SharePoint Services site to use a Single Sign On database in which a user name and password can be stored.

This method can be the most efficient when many users are connected to the server. None Select this option to save the user name and password in the connection file. Security Note: Avoid saving logon information when connecting to data sources. Note: The authentication setting is used only by Excel Services, and not by Excel. Under Select how you want to view this data in your workbook , do one of the following:.

To place the data in an existing worksheet, select Existing worksheet , and then type the name of the first cell in the range of cells where you want to locate the data. Alternatively, click Collapse Dialog to temporarily collapse the dialog box, select the beginning cell on the worksheet, and then click Expand Dialog. To place the data in a new worksheet starting at cell A1, click New worksheet.

Optionally, you can change the connection properties and also change the connection file by clicking Properties , making your changes in the Connection Properties dialog box, and then clicking OK. If you are a developer, there are several approaches within Excel that you can take to import data:. You can use Visual Basic for Applications to gain access to an external data source. You can also define a connection string in your code that specifies the connection information.

The SQL. You can install the add-in from Office. Power Query for Excel Help. Import data from database using native database query. Use multiple tables to create a PivotTable. Import data from a database in Excel for Mac. Getting data docs. Import and analyze data. Import data. Import data from data sources Power Query. Select any cell within your data range. Select OK. Select Open. If your source workbook has named ranges, the name of the range will be available as a data set.

To work with the data in Power Query first, select Transform Data. Select the authentication mode to connect to the SQL Server database. Select the table or query in the left pane to preview the data in the right pane. Select Load or Transform. Enter the Server name, and then select OK. Notes: This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription. Select the Environment you want to connect to. Select or clear Include relationships column.

Select Continue. The Adobe Account dialog box appears. Select Basic if the OData feed requires your username and password. Select Save. Enter your domain in the Active Directory dialog box. Select Connect. Enter your connection string, and then select OK.

Click Open. In the Power Query ribbon tab, click From Table. Workbook File. Click the Power Query ribbon, then From Web. If the web page requires user credentials: In the Access Web dialog box, click a credentials option, and provide authentication values. Click Save. Click OK.

Databases “. Database “. Enter your connection string, then press OK. Click Load or Edit. Tables File. The Data Connection Wizard is displayed. This wizard has three panes. In the Query Editor, click Advanced Editor.

Document File. ToTable Source in “Converted to Table”. Click Connect. Next, enter your Account Key , and click Connect. In the Workbook Connections dialog box, click Add. Find your workbook, and click Open. Notes: Worksheets are referred to as “tables” in the Select Table dialog box You can only add one table at a time. You can use the Data Connection Wizard to connect to an Access database.

Click OK to finish. Step 1 of 3 Original data type If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited. Step 2 of 3 Delimited data Delimiters Select the character that separates values in your text file. Step 2 of 3 Fixed width data Data preview Set field widths in this section.

For example: To convert a column of all currency number characters to the Excel Currency format, select General. For example: If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General. Import Data Set these options to control how the data import process runs, including what data connection properties to use and what file and range to populate with the imported data.

Specify a target workbook: If you choose Existing Worksheet , click a cell in the sheet to place the first cell of imported data, or click and drag to select a range.

Choose New Worksheet to import into a new worksheet starting at cell A1 If you have a Data Model in place, click Add this data to the Data Model to include this import in the model. Click OK when you’re ready to finish importing your data. The web page opens in the New Web Query dialog box.

Set any options you want, then click Import. Treat consecutive delimiters as one This option only applies if the preceding option is selected.

Getting the most out of PowerPoint takes some time, but with a little experimentation, you can have a unique and effective presentation. See Step 1 below to get started. Create slideshows from templates or start from scratch. Add transitions between slides. Create solid or gradient backgrounds. Insert images and graphics.

Embed video. Did this summary help you? Yes No. Log in Social login does not work in incognito and private browsers. Please log in with your username or email to continue. No account yet? Create an account. Popular Categories. Arts and Entertainment Artwork Books Movies. Relationships Dating Love Relationship Issues.

Hobbies and Crafts Crafts Drawing Games. All Categories. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Settings. Learn why people trust wikiHow. Download Article Explore this Article parts. Related Articles.

Article Summary. Part 1. Choose between a blank presentation and a template. When you start a new PowerPoint file, you can either create a blank presentation or a template.

Blank presentations allow you to apply your own style, but this can be a time-consuming process. Templates can give your presentation a uniform style, but they may not suit your exact needs.

You can edit any aspect of a template, so feel free to choose one that mostly matches your vision and tweak it as you see fit. You can apply themes to your project at a later time after you’ve added content. Click the Design tab and select a theme.

It will be immediately applied to your project. You can access templates from the File tab. Click New and then browse the available templates. You can also download additional templates from a variety of resources online. Create your title slide. Your title is the first thing that your audience will see. It should be easy to read and give a basic overview about the topic of the presentation. Most presenters will include their or their group’s name on the title as well.

Add new slides for content. A blank slide will be added after the slide you are currently on. The slide will contain a title box and a text box. You can choose to use these or insert your own objects using the Insert tab. When adding a text box, you can click and drag to make it whatever size you’d like. You can then adjust this later by grabbing one of the corners with your cursor and then clicking and dragging again. You can click on any text box and start typing to begin adding text to your presentation.

You can format text just as you would in Word, with formatting options available in the Home tab. Navigate your presentation. You can use the frame on the left side of the window to quickly scroll through your slides.

Clicking any of them will open that slide so that you can edit it. You can click the Outline tab to see an outline tree of your presentation. Each slide will be labeled by the slide title. Preview your presentation. You can get a basic feel for the flow of your presentation at this point by pressing F5 to start the slide show. Click the mouse to advance the slides. Use the preview slide show to get an idea of how long the presentation is and how well information flows from one slide to the next.

Part 2. Once you have some content in your slides, you can start adding some effects to help make it a bit more interesting for your audience. Select a slide and click the Transitions tab. You will see a list of the most common transitions. You can also click the arrow at the end of the list to open the full listing of available transitions.

When you pick a transition, it will affect how that slide appears. For example, adding a transition to Slide 2 will affect how Slide 1 transitions into Slide 2. You will be able to see a preview in the slide editing window when you click each transition. Don’t add too much transitions to your presentation. This can be distracting to the audience and keeps them from focusing on your what is the most important which is your content.

Add backgrounds. After the download is complete, just double-click it and you can go through the installation process in a minute or two. Just select your desired language and click on Set as Default. Tags: change office language change office language how to change language on word Search for:. Proudly powered by WordPress.

How do I change it to English? No matter what the default language is, Office can easily be switched to the language of your choice. Open the Word program, click the File tab and choose Account. For more information such as the architecture of Office, click on the About Word button. A dialog box opens, showing you the full version number and if you are running bit or bit Office. When the Options dialogue box opens, select the Language tab. Just click that link and it will directly open the Language page in the Settings app.

Click the Install button to download the language pack and keyboard for that language. Just click that link and it will open the Language Accessory Pack for Office page with your web browser.

The Language Accessory Pack comes with both bit and bit versions. You need to download the appropriate one depending on the architecture of your Office. After the download is complete, just double-click it and you can go through the installation process in a minute or two.

Just select your desired language and click on Set as Default. Tags: change office language change office language how to change language on word Search for:. Proudly powered by WordPress.

Click Properties to set any External Data Range properties you want. For more information, see Manage external data ranges and their properties. In the New Web Query dialog box, enter the address of the web page you want to query in the Address box, and then click Go. In the web page, click the little yellow box with a red arrow next to each table you want to query.

None The web data will be imported as plain text. No formatting will be imported, and only link text will be imported from any hyperlinks. Rich text formatting only The web data will be imported as rich text, but only link text will be imported from any hyperlinks. This option only applies if the preceding option is selected.

If selected, dates are imported as text. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security.

Click Browse to change the default file location My Data Sources. Optionally, type a description of the file, a friendly name, and common search words in the Description , Friendly Name , and Search Keywords boxes. To ensure that the connection file is always used when the data is updated, click the Always attempt to use this file to refresh this data check box.

Windows Authentication Select this option to use the Windows user name and password of the current user. This is the most secure method, but it can affect performance when many users are connected to the server. A site administrator can configure a Windows SharePoint Services site to use a Single Sign On database in which a user name and password can be stored.

Optionally, you can change the connection properties and also change the connection file by clicking Properties , making your changes in the Connection Properties dialog box, and then clicking OK.

If you are a developer, there are several approaches within Excel that you can take to import data:. You can use Visual Basic for Applications to gain access to an external data source. You can also define a connection string in your code that specifies the connection information.

The SQL. You can install the add-in from Office. Power Query for Excel Help. Import data from database using native database query. Use multiple tables to create a PivotTable.

Import data from a database in Excel for Mac. Getting data docs. Import and analyze data. Import data. Import data from data sources Power Query. Select any cell within your data range. Select OK. Select Open. If your source workbook has named ranges, the name of the range will be available as a data set.

Select Load or Transform. Enter the Server name, and then select OK. Notes: This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription.

Select Connect. Enter your connection string, and then select OK. Click Open. In the Power Query ribbon tab, click From Table.

Workbook File. Click the Power Query ribbon, then From Web. If the web page requires user credentials: In the Access Web dialog box, click a credentials option, and provide authentication values. Click Save. Click OK. Databases “. Database “. Enter your connection string, then press OK. Click Load or Edit. Tables File. The Data Connection Wizard is displayed. This wizard has three panes. In the Query Editor, click Advanced Editor. Document File. ToTable Source in “Converted to Table”.

Click Connect. Next, enter your Account Key , and click Connect. In the Workbook Connections dialog box, click Add. Find your workbook, and click Open. Notes: Worksheets are referred to as “tables” in the Select Table dialog box You can only add one table at a time. You can use the Data Connection Wizard to connect to an Access database. Click OK to finish. Archived from the original on February 13, USA Today. Gannett Company. Archived from the original on May 13, Archived from the original on March 17, TechNet Library.

May 16, Archived from the original on January 18, Archived from the original on March 6, At Cubed. Archived from the original on June 15, Archived from the original on March 28, Karl Barksdale blog. January 15, Archived from the original on October 20, April 3, Archived from the original on March 9, October 15, Archived from the original on October 26, Archived from the original on December 12, December 15, Archived from the original on January 24, Retrieved May 17, Archived from the original on June 4, Archived from the original on January 9, February 21, Archived from the original on May 8, A Fresh Cup.

Archived from the original on September 11, Retrieved April 25, Archived from the original on June 27, Microsoft Support 3. December 14, Archived from the original on January 1, Nature Publishing Group. Archived from the original on March 3, If using Word , please create the document in Compatibility Mode i.

University of Waterloo. October 17, Archived from the original on November 7, Retrieved November 6, Inera Inc. June 22, Archived from the original on March 11, Information for Authors. American Association for the Advancement of Science. Archived from the original on October 15, Science can now accept manuscripts prepared in Word and its. However, we strongly discourage the use of the Word equation editor.

Instead please use Mathtype or Word’s legacy equation editor, which can be obtained through the “Insert” ribbon and the “Object menu” on the “text” panel. Microsoft Corporation. December 9, Archived from the original on December 19, Microsoft Office. History Microsoft Discontinued shared tools Accounting Docs. Authority control: National libraries Germany Czech Republic. Categories : software Microsoft software Products and services discontinued in Hidden categories: Webarchive template wayback links Use mdy dates from March Articles with short description Short description matches Wikidata All articles lacking reliable references Articles lacking reliable references from March Articles containing potentially dated statements from April All articles containing potentially dated statements Articles with GND identifiers Articles with NKC identifiers.

Namespaces Article Talk. Views Read Edit View history. Help Learn to edit Community portal Recent changes Upload file. Download as PDF Printable version. January 30, ; 15 years ago [1]. IA [3]. Microsoft Office Office suite. Viewer only. Picture Manager Communicator R2. Groove SharePoint Designer Volume licensing only [26]. LinkedIn Learning. Learn the basics Get going quickly and easily with Microsoft video training. Quick Starts Get up to speed in no time with these popular guides.

Collaborate Do your best work together. With Microsoft , you can collaborate with anyone, anywhere. Office for the web training Learn how to stay productive in Office from any browser with these brand new courses.

Not Helpful 13 Helpful Try going to app settings and select refresh. Select what you want to delete, click ok, and you are done. Not Helpful 8 Helpful Have your flash drive inserted into your computer first. From there, the easiest way is to open the PowerPoint presentation and click on the File button located at the top left of the window.

Then, select “Save As. On the left side, find your flash drive. Usually it’s the name located at the bottom. Select your drive and save the file. Not Helpful 1 Helpful 7. Power Point is used to make slide shows for teaching and informational purposes. Many teachers use Power Point during class to help their students take notes.

It can also be used by students or business people during presentations. Not Helpful 2 Helpful 5. Yes, you can. Go to Insert in the menu bar and click Audio. This will allow you to insert an audio file into your PowerPoint presentation. Not Helpful 2 Helpful 4. I am doing photos for slide shows and want to place a footer under each picture. This footer should appear with the same size font and color. How so I make a master slide that will do this?

Open the View menu, select Slide Master, then create a text box on the master slide or the specific slide templates where you want a footer. This is where you set the text properties so it’s consistent throughout your presentation. Select Close Master View to return to the presentation.

Not Helpful 0 Helpful 0. Include your email address to get a message when this question is answered. By using this service, some information may be shared with YouTube. Submit a Tip All tip submissions are carefully reviewed before being published. You Might Also Like How to. How to. Co-authors: Updated: February 22, Categories: PowerPoint Presentations.

Article Summary X 1. Nederlands: Een presentatie maken met PowerPoint. Thanks to all authors for creating a page that has been read , times. The first time I learned PowerPoint was for Windows Now I’m disabled and I see a job opening that I’m able to get, so I need to get a heads up on Word too.

More reader stories Hide reader stories. Is this article up to date? Cookies make wikiHow better. Open the Word program, click the File tab and choose Account. For more information such as the architecture of Office, click on the About Word button.

A dialog box opens, showing you the full version number and if you are running bit or bit Office.

Free Office Tutorials at GCFGlobal.Get Office apps for Mac

Modern workplace training. Learn how to get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization. Whether you’re new to Office or simply want to refresh your skills, you’re in the right place. Our lessons offer a mix of text, video, interactives, and challenges to practice what you learn. Microsoft Office. Whether you’re new to Office or simply want to refresh your skills, you’re in the right place. Office Excel The Get & Transform experience was not available in Excel , so you can use an Office Data Connection .odc) file to connect to a Microsoft SQL Server database from an Excel workbook. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance. Microsoft Office (codenamed Office 12) is an office suite for Windows, developed and published by replace.me was officially revealed on March 9, and was the 12th version of Microsoft replace.me was released to manufacturing on November 3, ; it was subsequently made available to volume license customers on November 30, , and later to retail on . Feb 22, · You can edit any aspect of a template, so feel free to choose one that mostly matches your vision and tweak it as you see fit. You can apply themes to your project at a later time after you’ve added content. Click the Design tab and select a theme. It will be immediately applied to your project.

Last Updated: February 22, Approved. Microsogt create this article, 37 people, some anonymous, worked to edit and improve it over time. This article has 21 testimonials from our readers, earning it our reader-approved status. This article has been creetimes. Learn more Do you want to make your presentation one to microsoft office 2016 tutorial free PowerPoint gives you the tutoriak to create a powerful visual tutoria that can help make your presentation the best it can be.

Getting the most out 2019 for outlook account free microsoft prompting PowerPoint takes some time, but with a little experimentation, you can tutogial a unique and effective presentation.

See Step 1 below to get started. Create slideshows from templates or start from scratch. Add transitions between slides. Create solid or gradient backgrounds. Insert images and graphics. Embed video. Did this summary microsoft office 2016 tutorial free you? Yes No. Log in Social login does not work in incognito and private browsers. Please log in with your username or email to continue. No account yet? Create an account. Popular Categories.

Arts and Entertainment Artwork Books Movies. Relationships Dating Love Relationship Issues. Hobbies and Crafts Crafts Drawing Games. All Categories. Edit this Article. We use cookies to make wikiHow great. By using our site, you agree to our cookie policy. Cookie Нажмите сюда. Learn why people trust wikiHow.

Download Article Explore this Article parts. Related Articles. Article Summary. Part 1. Choose between a blank presentation and a template. When tuforial start a new PowerPoint file, you can either create a blank presentation or a template. Blank presentations allow you to apply your own style, but this can be a time-consuming process. Templates can give your presentation a uniform style, but they may not suit your exact needs.

You can edit any aspect of a template, so feel free to choose one that mostly matches your vision and tweak it as you see fit. You как сообщается здесь apply themes to your project at a later time after you’ve added content.

Click the Design tab and select a theme. It will be immediately applied to your project. You can access templates from the File tab. Click New and then browse the tutorisl templates. You can also download additional templates from mircosoft variety of resources online.

Create your title slide. Your title is the first thing that your audience will see. It should be easy to read and give a basic overview about tutofial topic of the presentation. Most presenters will include their 201 their group’s name on the title as well.

Add new slides for content. A blank slide will be added after the slide you are currently on. The slide will contain a title box and a text box. You can choose to use these or insert your own objects using the Insert tab. When adding a text box, you моему freegamepick games download for pc вас click and drag to make it whatever size you’d like. You can then adjust this later by grabbing one of the corners with your cursor and then clicking and dragging again.

You can click on any text box and start typing to begin adding text to your presentation. You can format text just as you would in Word, with formatting options available in the Home tab. Navigate your presentation. You can use the frame on the left side of the window to quickly scroll through your slides. Clicking any of them will open that slide so that you can edit it. You can click the Outline tab to see an outline tree of your presentation.

Each slide will be labeled by the slide title. Preview your presentation. You can get a basic feel for the flow offce your presentation at this point by microosoft F5 to start the slide show. Click the mouse to advance the slides. Use the preview slide show to get an microsoft office 2016 tutorial free of how long the presentation is and how well information flows from one slide to the next. Part 2.

Once you have some content in your slides, you can start adding some effects to tutoorial make it a bit more interesting for your audience.

Select a slide and click the Transitions tab. You will see a list of the most common transitions. You can also click the arrow at the end of the list to open the full listing of available transitions. Microsoft office 2016 tutorial free you pick a transition, it will affect how that slide appears. For example, adding a transition to Slide 2 will affect how Slide 1 transitions into Slide 2.

You will be able ttorial see a preview in the slide editing window when you click each transition. Don’t add too much transitions to your presentation.

This can be distracting to the audience and keeps them from focusing on your microsoft office 2016 tutorial free адрес the most important vree is your content. Add backgrounds. Plain white is skin for windows 10. If your presentation is offixe text on tutoorial plain white background, half of your audience will be asleep before you reach the third slide.

Use subtle backgrounds to add a little visual flair to your project. Right-click on a blank section of your slide microeoft select “Format Background”, or click the Microsoft office 2016 tutorial free tab and the click the arrow icon next to “Background” on the far right. Choose your fill type. You can choose a imcrosoft color, a gradient fill, a picture background, or a pattern fill.

Selecting each choice will display several options for microsoft office 2016 tutorial free, such as fill color, picture location, microsoft office 2016 tutorial free settings, and more. Experiment until you find the background that fits your presentation. By default, the background will only be applied to your active slide.

Click the “Apply to All” button to apply your background choices to every slide. Make sure that your text is miccrosoft easily readable with the background you miicrosoft. Add images.

Adding pictures, diagrams, and other visual aids can help the audience grasp the ideas of your presentation and drive your point home. Images break up the 0216 of text and help keep the audience from tuning out. Click the Insert tab. There will be a microsoft office 2016 tutorial free number of options when it comes to inserting objects.

Click the Microsoft office 2016 tutorial free button to insert a picture from a file on your computer. You can click the Photo Album button to insert an entire album of photos into the slide as well. Use the Charts button to insert easy-to-read charts that will help the audience understand your data. Once you choose your Chart type, Excel will open, allowing you to enter in your data or copy it from an existing spreadsheet. Use the Shapes button to insert pre-made shapes or dray your own. You can use the microsoft office 2016 tutorial free to outline important text or create arrows and other visual indicators.

Microsoft Visio is the most popular diagramming software, however, there are alternatives that are often as good and in some cases, free. For simple diagramming requirements, the following tools should work just fine. Gliffy Gliffy is a popular online diagramming tool. Gliffy supports floor plans, venn diagrams. An easy way to learn Office Automation Tool – Free Course. Free tutorial. Rating: out of 5 (2, ratings) 33, students. Reviews. Instructors. Students will become master on Microsoft Word after taking this course because i have cover every smallest to complex topics in M S Word Students will become confident to. Microsoft Office (codenamed Office 12) is an office suite for Windows, developed and published by replace.me was officially revealed on March 9, and was the 12th version of Microsoft replace.me was released to manufacturing on November 3, ; it was subsequently made available to volume license customers on November 30, , and later to retail on .
Feb 22, · You can edit any aspect of a template, so feel free to choose one that mostly matches your vision and tweak it as you see fit. You can apply themes to your project at a later time after you’ve added content. Click the Design tab and select a theme. It will be immediately applied to your project. Whether you’re new to Office or simply want to refresh your skills, you’re in the right place. Our lessons offer a mix of text, video, interactives, and challenges to practice what you learn. Microsoft Office. Whether you’re new to Office or simply want to refresh your skills, you’re in the right place. Office Excel Modern workplace training. Learn how to get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization.

Free Microsoft Office Tutorials at GCFGlobal.Office 2016

Click the Install button to download the language pack and keyboard for that language. Just click that link and it will open the Language Accessory Pack for Office page with your web browser. The Language Accessory Pack comes with both bit and bit versions.

You need to download the appropriate one depending on the architecture of your Office. After the download is complete, just double-click it and you can go through the installation process in a minute or two.

NET Framework from here. Select your PDF file, and then click Open. The Navigator dialog box opens your PDF and displays available tables. For more information about advanced connector options, see PDF. You can import data from several files having a similar schema and format from a folder.

Then, you can append the data into one table. In the Browse dialog box, locate the folder, and then select Open. For detailed steps, see Import data from a folder with multiple files. For more information about advanced connector options, see Folder.

You can import data from several files having a similar schema and format from a SharePoint library. In the SharePoint Folder dialog box, enter the root URL for the SharePoint site not including any reference to a library, and then navigate to the library.

For more information about advanced connector options, see SharePoint folder. Optionally, you can specify a Database Name as well. If you want to import data using a native database query, specify your query in the SQL Statement box. Windows This is the default selection. Select this if you want to connect using Windows authentication. After you select this, specify a user name and password to connect to your SQL Server instance.

By default, the Encrypt connection check box is selected to signify that Power Query connects to your database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. If a connection to your SQL Server is not established using an encrypted connection, Power Query prompts you to connect using an unencrypted connection. Click OK in the message to connect using an unencrypted connection.

For more information about advanced connector options, see SQL Server database. In the Import Data dialog box, browse for and locate the Access database file.

Select the file, and then select Open. The Navigator dialog box appears. If you have many tables and queries, use the Search box to locate an object or use the Display Options along with the Refresh button to filter the list. For more information about advanced connector options, see Access database. Note When you use a workbook connected to a SQL Server Analysis Services database, you may need additional information to answer specific product questions, such as reference information about multidimensional expressions MDX , or configuration procedures for an online analytical processing OLAP server.

Under Log on credentials , do one of the following, then click Next :. To use your current Windows user name and password, click Use Windows Authentication. To enter a database user name and password, click Use the following User Name and Password , and then type your user name and password in the corresponding User Name and Password boxes. Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols.

Weak passwords don’t mix these elements. For example, Y6dh! Passwords should contain 8 or more characters. A pass phrase that uses 14 or more characters is better.

It is critical that you remember your password. If you forget your password, Microsoft cannot retrieve it. Store the passwords that you write down in a secure place away from the information that they help protect. Select Next to go to the second wizard screen. Its title is Select Database and Table. To connect to a specific cube file in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. In the Select the database that contains the data you want box, select a database, and then click Next.

Click Next to go to the third wizard screen. Click Browse to change the default file location of My Data Sources , or check for existing file names. In the Description , Friendly Name , and Search Keywords boxes, type a description of the file, a friendly name, and common search words all are optional. To ensure that the connection file is used when the PivotTable is refreshed, click Always attempt to use this file to refresh this data. Selecting this check box ensures that updates to the connection file will always be used by all workbooks that use that connection file.

You can specify how a PivotTable is accessed if the workbook is saved to Excel Services and is opened by using Excel Services. If you want to ensure that the same data is accessed whether you open the workbook in Excel or Excel Services, make sure that the authentication setting in Excel is the same. Select Authentication Settings , and select one of the following options to log on to the data source:. Windows Authentication Select this option to use the Windows username and password of the current user.

This is the most secure method, but it can affect performance when there are many users. A site administrator can configure a SharePoint site to use a Single Sign On database where a username and password can be stored. This method can be the most efficient when there are many users. None Select this option to save the username and password in the connection file. Important: Avoid saving logon information when connecting to data sources. This information may be stored as plain text, and a malicious user could access the information to compromise the security of the data source.

Select Finish to close the Data Connection Wizard. Decide how you want to import the data, and then select OK. For more information about using this dialog box, select the question mark? You can connect to a specific offline cube file if it has been created on the database server.

You can also import data into Excel as either a Table or a PivotTable report. In the Navigator pane select the database, and then select the cube or tables you want to connect. Click Load to load the selected table into a worksheet, or click Edit to perform additional data filters and transformations in the Power Query Editor before loading it. Note: Before you can connect to an Oracle database using Power Query , you need the Oracle client software v8.

If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import data from database using Native Database Query.

For more information about advanced connector options, see Oracle Database. Select the driver that matches your Power Query installation bit or bit. For more information, see Import data from a database using Native Database Query. For more information about advanced connector options, see MySQL database. Select the driver that matches your Office version bit or bit. For more information, see Which version of Office am I using?

Also make sure you have the provider registered in the machine configuration that matches the most recent. NET version on your device. For more information about advanced connector options, see PostgreSQL. Select the driver that matches your Excel installation bit or bit. By default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection.

Note: Before you can connect to a Teradata database, you need the. This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription. If you are a Microsoft subscriber, make sure you have the latest version of Office. You will need an SAP account to login to the website and download the drivers. If you are unsure, contact the SAP administrator in your organization. The server name should follow the format ServerName:Port. Optionally, if you want to import data using native database query, Select Advanced options and in the SQL Statement box enter the query.

Azure SQL Database is a high-performing, fully managed, scalable relational database built for the cloud and used for mission-critical applications. For more information about advanced connector options, see Azure SQL database. Azure Synapse Analytics combines big data tools and relational queries by using Apache Spark to connect to Azure data services and the Power Platform.

You can load millions of rows in no time. Then, you can work with tabular data by using familiar SQL syntax for queries. For more information, see What is Azure Synapse Analytics.

For more information about advanced connector options, see Azure Synapse Analytics. Azure HDInsight is used for big data analysis when you need to process large amounts of data.

It supports data warehousing and machine learning; you can think of it as a data flow engine. Select your cluster in the Navigator dialog, and then find and select a content file. Select Load to load the selected table, or Edit to perform additional data filters and transformations before loading it. If you are connecting to the Blob storage service for the first time, you will be prompted to enter and save the storage access key.

Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then select the Manage Access Key icon on the bottom of the page. Select the copy icon to the right of the primary key, and then paste the value in the Account Key box.

The Azure Storage provides storage services for a variety of data objects. For more information, see Introduction to Table storage. Azure Data Lake Storage Gen 1 combines different data warehouses into a single, stored environment. You can use a new generation of query tools to explore and analyze data, working with petabytes of data.

For more information, see Azure Data Lake Storage. Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. It can handle large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more. For more information, see What is Azure Data Explorer. In the Azure Data Explorer Kusto dialog box, enter appropriate values. Each prompt provides helpful examples to walk you though the process.

Select the arrow next to the box to display keyword filters for versions and environments to target your search. Select a Dataset and create a PivotTable in a new worksheet. Select the 2. As an alternative to 2. For more information about advanced connector options, see SharePoint Online list. If you have many objects, use the Search box to locate an object or use he Display Options along with the Refresh button to filter the list. Select or clear the Skip files with errors checkbox at the bottom of the dialog box.

If you select the Advanced option, you can append certain additional parameters to the query to control what data is returned. If you aren’t signed in using the Microsoft Work or School account you use to access Dataverse for Apps, select Sign in and enter the account username and password.

The Salesforce Objects dialog box appears. Select either Production or Custom. If you select Custom , enter the URL of a custom instance. For more information about advanced connector options, see Salesforce Objects. Because Salesforce Reports has API limits retrieving only the first 2, rows for each report, consider using the Salesforce Objects connector to work around this limitation if needed. The Salesforce Reports dialog box appears.

For more information about advanced connector options, see Salesforce Reports. Make sure you have the latest version of the Adobe Analytics connector. Sign in with you Adobe Analytics Organizational account, and then select Connect.

For more information about advanced connector options, see Adobe Analytics. Select Advanced , and then In the Access Web dialog box, enter your credentials. For more information about advanced connector options, see Web. Microsoft Query has been around a long time and is still popular. In many ways, it’s a progenitor of Power Query. For more information, see Use Microsoft Query to retrieve external data. By default, the most general URL is selected.

Select Anonymous if the SharePoint Server does not require any credentials. Select Organizational account if the SharePoint Server requires organizational account credentials. For more information about advanced connector options, see SharePoint list. Select Marketplace key if the OData feed requires a Marketplace account key.

Click Organizational account if the OData feed requires federated access credentials. For Windows Live ID, log into your account. For more information about advanced connector options, see OData feed. HDFS connects computer nodes within clusters over which data files are distributed and you can access these data files as one seamless file stream. Enter the name of the server in the Server box, and then select OK.

In the Active Directory Domain dialog box for your domain, select Use my current credentials , or select Use alternate credentials and then enter your Username and Password. After the connection succeeds, use the Navigator pane to browse all the domains available within your Active Directory, and then drill down into Active Directory information including Users, Accounts, and Computers.

In the next dialog box, select from Default or Custom , Windows , or Database connection options, enter your credentials, and then select Connect. In the Navigator pane, select the tables or queries that you want to connect to, then select Load or Edit. For more information about advanced connector options, see ODBC data source.

In the Navigator dialog box, select the database, and tables or queries you want to connect to, and then select Load or Edit. Get started with Tips. Work together. Check it out. Get now.

See all. Watch videos. Take training. Learn how to get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization.

Start here.

Microsoft Office codenamed Office 12 [5] is an office suite for Windows , developed and published by Microsoft. It was officially revealed on March 9, and was the 12th version of Microsoft Office. It was released to manufacturing on November 3, ; [6] it was subsequently made available to volume license customers on November 30, , [7] [8] and later to retail on January 30, , [1] shortly after the completion of Windows Vista.

The ninth major release of Office for Windows, Office was preceded by Office and succeeded by Office Office introduced a new graphical user interface called the Fluent User Interface , which uses ribbons and an Office menu instead of menu bars and toolbars. The new formats are intended to facilitate the sharing of information between programs, improve security, reduce the size of documents, and enable new recovery scenarios.

Office is incompatible with Windows and earlier versions of Windows. Office includes new applications and server-side tools, including Microsoft Office Groove , a collaboration and communication suite for smaller businesses, which was originally developed by Groove Networks before being acquired by Microsoft in Also included is SharePoint Server , a major revision to the server platform for Office applications, which supports Excel Services , a client-server architecture for supporting Excel workbooks that are shared in real time between multiple machines, and are also viewable and editable through a web page.

Its designer-oriented counterpart, Microsoft Expression Web , is targeted for general web development. However, neither application has been included in Office software suites. Speech recognition functionality has been removed from the individual programs in the Office suite, as Windows Speech Recognition was integrated into Windows Vista. Windows XP users must install a previous version of Office to use speech recognition features.

Mainstream support for Office ended on October 9, , and extended support ended on October 10, It included an updated user interface, better accessibility support, improvements in the robustness of the platform, and greater functionality.

Office was released to volume licensing customers on November 30, , and to the general public on January 30, Since the initial release of Microsoft Office , three service packs containing updates as well as additional features have been released. Microsoft Office Service Packs are cumulative, so previous Service Packs are not a prerequisite for installation. Microsoft Office Service Pack 1 was released on December 11, Eligible employees of companies with volume license agreements for Microsoft Office receive additional tools, including enterprise content management , electronic forms, Information Rights Management capabilities and copies for use on a home computer.

The new user interface UI , officially known as Fluent User Interface , [28] [29] has been implemented in the core Microsoft Office applications: Word , Excel , PowerPoint , Access , and in the item inspector used to create or edit individual items in Outlook.

These applications have been selected for the UI overhaul because they center around document authoring. The Office button, located on the top-left of the window, replaces the File menu and provides access to functionality common across all Office applications, including opening, saving, printing, and sharing a file. It can also close the application. Users can also choose color schemes for the interface. A notable accessibility improvement is that the Office button follows Fitts’s law.

The ribbon , a panel that houses a fixed arrangement of command buttons and icons, organizes commands as a set of tabs , each grouping relevant commands. The ribbon is not user customizable in Office Each application has a different set of tabs that exposes functions that the application offers.

For example, while Excel has a tab for the graphing capabilities, Word does not; instead it has tabs to control the formatting of a text document. Within each tab, various related options may be grouped together. The ribbon is designed to make the features of the application more discoverable and accessible with fewer mouse clicks [34] as compared to the menu-based UI used prior to Office Moving the mouse scroll wheel while on any of the tabs on the ribbon cycles—through the tabs.

The ribbon can be minimized by double clicking the active section’s title, such as the Home text in the picture below.

Third party add-ins, however, can bring menus and toolbars back to Office or customize the ribbon commands. Some tabs, called Contextual Tabs , appear only when certain objects are selected. Contextual Tabs expose functionality specific only to the object with focus. For example, selecting a picture brings up the Pictures tab, which presents options for dealing with the picture.

Similarly, focusing on a table exposes table-related options in a specific tab. Contextual Tabs remain hidden except when an applicable object is selected. Microsoft Office also introduces a feature called Live Preview , which temporarily applies formatting on the focused text or object when any formatting button is moused-over.

The temporary formatting is removed when the mouse pointer is moved from the button. This allows users to have a preview of how the option would affect the appearance of the object, without actually applying it. The new Mini Toolbar is a small toolbar with basic formatting commands that appears within the document editing area, much like a context menu.

When the mouse selects part of the text, Mini Toolbar appears close to selected text. It remains semi-transparent until the mouse pointer is hovered on it, to avoid obstructing what is underneath. Mini Toolbar is not customizable in Office , but can be turned off. It is customizable, although this feature is limited, compared to toolbars in previous Office versions.

Any command available in the entire Office application can be added to the Quick Access toolbar , including commands not available on the ribbon as well as macros. Keyboard shortcuts for any of the commands on the toolbar are also fully customizable, similar to previous Office versions.

SmartArt, found under the Insert tab in the ribbon in PowerPoint, Word, Excel, and Outlook, is a new group of editable and formatted diagrams. There are preset SmartArt graphics layout templates in categories such as list, process, cycle, and hierarchy.

When an instance of a SmartArt is inserted, a Text Pane appears next to it to guide the user through entering text in the hierarchical levels. Each SmartArt graphic, based on its design, maps the text outline, automatically resized for best fit, onto the graphic.

There are a number of “quick styles” for each graphic that apply largely different 3D effects to the graphic, and the graphic’s shapes and text can be formatted through shape styles and WordArt styles. In addition, SmartArt graphics change their colors, fonts, and effects to match the document’s theme.

Office documents can also be exported as XPS documents. This is part of Service Pack 2 and prior to that, was available as a free plug-in in a separate download. Microsoft backs an open-source effort to support OpenDocument in Office , as well as earlier versions up to Office , through a converter add-in for Word, Excel and PowerPoint, and also a command-line utility.

Section 8. Peter Amstein and the Microsoft Office team are reluctant to make liberal use of extension mechanisms, even though provided in ODF 1. They want to avoid all appearance of an embrace-extend attempt.

In Office , Microsoft introduced the Document Inspector , an integral metadata removal tool that strips Word, Excel, and PowerPoint documents of information such as author name and comments and other “metadata”. In Microsoft Office , the Office Assistants were eliminated in favour of a new online help system.

One of its features is the extensive use of Super Tooltips, which explain in about one paragraph what each function performs. Some of them also use diagrams or pictures. These appear and disappear like normal tooltips, and replace normal tooltips in many areas.

The Help content also directly integrates searching and viewing Office Online articles. Microsoft Office includes features geared towards collaboration and data sharing. As such, Microsoft Office features server components for applications such as Excel, which work in conjunction with SharePoint Services , to provide a collaboration platform. NET 2.

Excel server exposes Excel Services, which allows any worksheet to be created, edited and maintained via web browsers. It features Excel Web Access , the client-side component which is used to render the worksheet on a browser, Excel Calculation Service which is the server side component which populates the worksheet with data and perform calculations, and Excel Web Services that extends Excel functionalities into individual web services.

Also by using SharePoint, PowerPoint can manage shared review of presentations. Any SharePoint hosted document can be accessed from the application which created the document or from other applications such as a browser or Microsoft Office Outlook.

To collaborate on one or more documents, a Workspace must be created, and then those who are to work on it must be invited. Any file shared on the workspace are automatically shared among all participants. The application also provides real-time messaging, including one-to-one as well as group messaging, and presence features, as well as monitoring workspace activities with alerts, which are raised when pre-defined set of activities are detected.

Groove also provides features for conflict resolution for conflicting edits. Schedules for a collaboration can also be decided by using a built-in shared calendar, which can also be used to keep track of the progress of a project. However, the calendar is not compatible with Microsoft Outlook. The Document Theme defines the colors, fonts and graphic effects for a document. Almost everything that can be inserted into a document is automatically styled to match the overall document theme creating a consistent document design.

The new Office Theme file format. Similar themes are also available for data reports in Access and Project or shapes in Visio. Quick Styles are galleries with a range of styles based on the current theme. There are quick styles galleries for text, tables, charts, SmartArt, WordArt and more. Microsoft Office Outlook can also include an optional Business Contact Manager included on a separate installation disc in Office Small Business and above which allows management of business contacts and their sales and marketing activities.

You can import data into Excel from a wide variety of data sources microsoft office 2016 tutorial free the sections that follow show you how. For more information on what to do with your data once it’s imported, see How data journeys through Excel.

You can create a query from an Excel table, named range, or dynamic array in the current workbook. Importing dynamic arrays requires a Microsoft subscription. For more information on dynamic arrays, see Dynamic array formulas and spilled array behavior. If prompted, in the Create Table dialog micrlsoft, you can select the Range Selection officf to select a specific range to use as a data source.

If the table or range micrsooft data has column microsoft office 2016 tutorial free, select My table has headers. The header cells are used to define the column names for the query. For more information, see Import from an Excel Table. In the Excel Browse dialog box, browse for or type a path microsoft office 2016 tutorial free the file that you want to query. For more information about advanced connector options, see Excel Workbook. The following procedure shows the basic steps.

For more detailed coverage, see Import or export text. In the Comma-Separated Values Browse dialog box, browse for or type a path to the file that you want to query.

Note: If you are importing vmware workstation 8 free from a Tjtorial file, Power Query will automatically ttutorial column delimiters including column names and types. For example, if you imported the example CSV file below, Power Query automatically uses the first row as the column names and changes each column data type.

The following procedure shows microsoft office 2016 tutorial free basic steps of importing data. Cree more detailed coverage, see Import XML data. After the connection succeeds, use the Navigator pane to browse and preview the collections of items in the XML file in a tabular form. For more information about advanced connector options, see XML. The Import Data dialog box appears.

For more information about advanced connector options, see JSON. NET Framework 4. You can download the latest. NET Framework from вот ссылка. Select your PDF file, and microsoft office 2016 tutorial free click Open. The Navigator dialog box opens your PDF and displays available tables.

For more information about advanced connector options, see PDF. You can import data from several files having a similar schema and format from a folder.

Then, you can append the data into one table. In the Browse dialog box, locate the folder, and then select Open.

For detailed steps, see Import data from a folder with multiple files. For more information about advanced tutoorial options, microsoft office 2016 tutorial free Folder.

Optionally, you can specify a Database Name as well. If windows 10 change login screen free want to import microsoft office 2016 tutorial free using a native database query, specify your query in the SQL Statement box.

Windows This is the default selection. Select this if you want to connect using Windows authentication. After you select this, specify a user microsoft office 2016 tutorial free and password to connect to your SQL Server instance.

By default, offife Encrypt connection check box is selected to signify that Power Query mkcrosoft to microsoft office 2016 tutorial free database using an encrypted connection. If you do not want to connect using an encrypted connection, clear this check box, and then click Connect. If a connection to your SQL Http://replace.me/3836.txt is not established using an encrypted connection, Power Query prompts you to connect using tuorial unencrypted connection.

Click OK tutlrial the message to connect using an unencrypted connection. For more information microsoft office 2016 tutorial free advanced connector options, see SQL Server database. In the Import Data dialog box, browse for and microsift the Access database file. Select the file, and then select Open. The Navigator dialog box appears.

If you have many tables and queries, use the Search box to locate an object or use the Display Options along with the Refresh button to filter the list. For microsoft office 2016 tutorial free information about advanced connector options, see Access database. Note When you use a workbook connected to a SQL Server Analysis Services ttutorial, you may need additional information to answer specific product ofdice, such as reference information about multidimensional expressions MDXor configuration procedures for an online analytical processing OLAP server.

To use your current Windows user name and password, click Use Windows Authentication. To enter a database user name and password, click Use the following User Ofifce and Passwordand then type your user name and password in the corresponding User Name and Password boxes. Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols.

Weak passwords don’t mix these elements. For example, Y6dh! Passwords should contain 8 or more characters. A pass phrase that uses 14 or microsoft office 2016 tutorial free characters is better. It is critical that microsot remember your password.

If you forget your password, Microsoft cannot retrieve it. Store the passwords that you write microsoft office 2016 tutorial free in a secure place away from the information that they help protect. Select Next to go to the second wizard screen. Its title is Select Database and Table. To connect to a specific cube file in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. In the Select the database that contains the data you want box, select a database, microsoft office 2016 tutorial free then click Next.

Click Next to как сообщается здесь to the third wizard screen. Click Browse to change the default file location of My Data Sourcesor check for existing file names. In the DescriptionFriendly Nameand Search Keywords boxes, type a description of the file, microxoft friendly name, and common search words all are optional. To ensure that the connection file microoft used when the PivotTable is refreshed, click Always attempt to use this file to refresh this data.

Selecting this check box ensures that updates to the connection file will always be used by all workbooks that use that connection file. You can specify microsoft office 2016 tutorial free a PivotTable is accessed officr the workbook is saved to Excel Services and is opened by using Excel Services. If you want to ensure that the same data is accessed whether you microsofr the workbook microsoft office 2016 tutorial free Excel or Excel Services, make sure that the authentication setting in Excel is the same.

Select Authentication Settingsand select one of the following options to log on to the data source:. Windows Authentication Select здесь option to use the Windows username and password of the current user. This is the most secure method, but it can affect performance when there are many users. A site administrator can configure a SharePoint site to use a Single Microsofh On database where a username and password can be stored.

This method can be the most efficient when there are many users. None Select this option to save the username and password in the connection file. Important: Avoid saving logon information when connecting to data sources. This microsoft office 2016 tutorial free may be stored as plain text, and a malicious user tuorial access the information to compromise the frer of the data source.

Select Finish to close the Data Connection Wizard. Decide how you want to import the data, and then select OK. For more information microsoft office 2016 tutorial free using this dialog box, select the question mark? You can connect to a specific offline cube file if it has been created on the database server. You can also import data into Excel as either a Нынешний windows 10 download for pc 64 bit full version free знаю or a PivotTable report.

In micrpsoft Navigator pane select the database, and then select the cube or tables you want otfice connect. Click Load to load the selected table into a worksheet, or click Edit to perform additional data filters and transformations in the Power Query Editor before loading it.

Note: Before you can connect to an Oracle database using Power Queryyou need the Oracle client software v8. If you want http://replace.me/27367.txt import data using native database query, specify freee query in the SQL Statement box. For more information, see Import data from officd using Native Database Query.

For more information about advanced connector options, see Oracle Database. Select the driver that matches your Power Query installation bit or bit. For more information, see Import data from microeoft database using Native Database Query. For frree information about advanced connector options, see MySQL database.

Start now. Download now. Get started. Get started with Tips. Work together. Check it out. Get now. See all. Watch videos. Take training. Learn how microsoft office 2016 tutorial free get more work done, from anywhere on any device with Microsoft and Windows Discover how industry professionals leverage Microsoft to communicate, collaborate, and improve productivity across the team and organization. Start here. Switch from G Suite. Frwe Starts. Microsoft Accessibility Help.

Microsoft office 2016 tutorial free Accessibility Training. Office training. LinkedIn Learning. Learn the basics Get going quickly and easily with Microsoft video training. Quick Starts Get up to speed in no по этому сообщению with these popular guides. Microsot Do your best work together. With Microsoftyou здесь collaborate oftice anyone, anywhere.

Office for the web training Learn how to stay productive in Office from microsoft office 2016 tutorial free browser with these brand new courses. Cheat sheets Get up to speed fast with these quick references and keyboard shortcuts. Infographics Get inspired with cool new infographics for your favorite Office apps. For small businesses Watch these short, easy videos to help you set up Microsoft Modern workplace training Learn how to get more work done, from anywhere on any device with Microsoft and Windows More training Office training LinkedIn Turorial.

Get support. Join the discussion. Buy Microsoft

Note When you use a workbook connected to a SQL Server Analysis Services database, you may need additional information to answer specific product questions, such as reference information about multidimensional expressions MDX , or configuration procedures for an online analytical processing OLAP server.

The first page of the Data Connection Wizard appears. Its title is Connect to Database Server. Tip: If you know the name of the offline cube file that you want to connect to, you can type the complete file path, file name, and extension. Under Log on credentials , do one of the following, then click Next :. To use your current Windows user name and password, click Use Windows Authentication. To enter a database user name and password, click Use the following User Name and Password , and then type your user name and password in the corresponding User Name and Password boxes.

Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don’t mix these elements.

For example, Y6dh! Passwords should contain 8 or more characters. A pass phrase that uses 14 or more characters is better. It is critical that you remember your password. If you forget your password, Microsoft cannot retrieve it. Store the passwords that you write down in a secure place away from the information that they help protect. Select Next to go to the second wizard screen. Its title is Select Database and Table.

To connect to a specific cube file in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. In the Select the database that contains the data you want box, select a database, and then click Next. Click Next to go to the third wizard screen. Click Browse to change the default file location of My Data Sources , or check for existing file names.

In the Description , Friendly Name , and Search Keywords boxes, type a description of the file, a friendly name, and common search words all are optional. To ensure that the connection file is used when the PivotTable is refreshed, click Always attempt to use this file to refresh this data.

Selecting this check box ensures that updates to the connection file will always be used by all workbooks that use that connection file. You can specify how a PivotTable is accessed if the workbook is saved to Excel Services and is opened by using Excel Services. If you want to ensure that the same data is accessed whether you open the workbook in Excel or Excel Services, make sure that the authentication setting in Excel is the same.

Select Authentication Settings , and select one of the following options to log on to the data source:. Windows Authentication Select this option to use the Windows username and password of the current user. This is the most secure method, but it can affect performance when there are many users. A site administrator can configure a SharePoint site to use a Single Sign On database where a username and password can be stored.

Click Load to load the selected table into a worksheet, or click Edit to perform additional data filters and transformations in the Power Query Editor before loading it. Note: Before you can connect to an Oracle database using Power Query , you need the Oracle client software v8.

If you want to import data using native database query, specify your query in the SQL Statement box. For more information, see Import data from database using Native Database Query. For more information about advanced connector options, see Oracle Database. Select the driver that matches your Power Query installation bit or bit.

For more information, see Import data from a database using Native Database Query. For more information about advanced connector options, see MySQL database. Select the driver that matches your Office version bit or bit. For more information, see Which version of Office am I using? Also make sure you have the provider registered in the machine configuration that matches the most recent. NET version on your device. For more information about advanced connector options, see PostgreSQL.

Select the driver that matches your Excel installation bit or bit. By default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection.

Note: Before you can connect to a Teradata database, you need the. This feature is only available in Excel for Windows if you have Office or later, or a Microsoft subscription.

If you are a Microsoft subscriber, make sure you have the latest version of Office. You will need an SAP account to login to the website and download the drivers. If you are unsure, contact the SAP administrator in your organization. The server name should follow the format ServerName:Port. Optionally, if you want to import data using native database query, Select Advanced options and in the SQL Statement box enter the query.

Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then select the Manage Access Key icon on the bottom of the page.

Select the copy icon to the right of the primary key, and then paste the value in the Account Key box. The Azure Storage provides storage services for a variety of data objects.

For more information, see Introduction to Table storage. Azure Data Lake Storage Gen 1 combines different data warehouses into a single, stored environment.

You can use a new generation of query tools to explore and analyze data, working with petabytes of data. For more information, see Azure Data Lake Storage. Azure Data Explorer is a fast and highly scalable data exploration service for log and telemetry data. It can handle large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more. For more information, see What is Azure Data Explorer.

The Power BI Datasets pane appears. If many Datasets are available, use the Search box. Select the arrow next to the box to display keyword filters for versions and environments to target your search. Select a Dataset and create a PivotTable in a new worksheet. Select the 2. As an alternative to 2. For more information about advanced connector options, see SharePoint Online list.

If you have many objects, use the Search box to locate an object or use he Display Options along with the Refresh button to filter the list. Select or clear the Skip files with errors checkbox at the bottom of the dialog box. If you select the Advanced option, you can append certain additional parameters to the query to control what data is returned.

For more information about advanced connector options, see Salesforce Objects. Because Salesforce Reports has API limits retrieving only the first 2, rows for each report, consider using the Salesforce Objects connector to work around this limitation if needed.

The Salesforce Reports dialog box appears. For more information about advanced connector options, see Salesforce Reports. Make sure you have the latest version of the Adobe Analytics connector.

Sign in with you Adobe Analytics Organizational account, and then select Connect. For more information about advanced connector options, see Adobe Analytics. Select Advanced , and then In the Access Web dialog box, enter your credentials. For more information about advanced connector options, see Web. Microsoft Query has been around a long time and is still popular. In many ways, it’s a progenitor of Power Query. For more information, see Use Microsoft Query to retrieve external data.

For more information about advanced connector options, see SharePoint list. Select Marketplace key if the OData feed requires a Marketplace account key. Click Organizational account if the OData feed requires federated access credentials.

For Windows Live ID, log into your account. For more information about advanced connector options, see OData feed. HDFS connects computer nodes within clusters over which data files are distributed and you can access these data files as one seamless file stream. Enter the name of the server in the Server box, and then select OK.

Sign in using your Facebook account, and allow access to the Power Query application. You can turn off future prompts by clicking the Don’t warn me again for this connector option. Note: Your Facebook username is different from your login email. Select a category to connect to from the Connection drop-down list. For example, select Friends to give you access to all information available in your Facebook Friends category.

If necessary, click Sign in from the Access Facebook dialog, then enter your Facebook email or phone number, and password. You can check the option to remain logged in. Once signed in, click Connect. After the connection succeeds, you will be able to preview a table containing information about the selected category. For instance, if you select the Friends category, Power Query renders a table containing your Facebook friends by name.

You can create a blank query. You might want to enter data to try out some commands, or you can select the source data from Power Query:. For more information, see Manage data source settings and permissions.

This command is similar to the Get Data command on the Data tab of the Excel ribbon. This command is similar to the Recent Sources command on the Data tab of the Excel ribbon.

When you merge two external data sources, you join two queries that create a relationship between two tables. When you append two or more queries, the data is added to a query based on the names of the column headers in both tables. The queries are appended in the order in which they’re selected. For more information, see Append queries Power Query. You can use the Power Query add-in to connect to external data sources and perform advanced data analyses.

The following sections provide steps for connecting to your data sources – web pages, text files, databases, online services, and Excel files, tables, and ranges. Click the Power Query check box, then OK. The Power Query ribbon should appear automatically, but if it doesn’t, close and restart Excel. The following video shows the Query Editor window appearing after editing a query from an Excel workbook.

The following video shows one way to display the Query Editor. Make sure that your text is still easily readable with the background you choose.

Click the Picture button to insert a picture from a file on your computer. You can click the Photo Album button to insert an entire album of photos into the slide as well. Use the Charts button to insert easy-to-read charts that will help the audience understand your data. Once you choose your Chart type, Excel will open, allowing you to enter in your data or copy it from an existing spreadsheet.

Use the Shapes button to insert pre-made shapes or dray your own. You can use the shapes to outline important text or create arrows and other visual indicators. Avoid drowning your presentation with pictures. If it looks too busy, the audience will have a hard time parsing your written information.

Add links. You can add links to your slides that will allow you to quickly access websites or email addresses. This can be especially useful if you are distributing the presentation and want people to be able to easily view related webpages or send you an email. To add a link, place your cursor in a text box and then click the Hyperlink button on the Insert tab.

You can choose to link to a file on your computer, a webpage, an email address, or even another slide in your presentation. You can add video files to your slides. This can be useful for reports or any other video file that may relate to your presentation. The video file will play when the slide appears. While it’s not as straightforward, you can embed YouTube videos as well.

See this guide to learn how. Part 3. Keep the number of slides to a minimum. Extremely long presentations will bore your audience, even if they are obsessed with your subject matter. Extraneous slides with little to no content will also make the presentation drag and wear on the audience’s interest.

Try to keep your presentation short and sweet, and make sure you are using the space on each slide to it’s maximum potential. Choose a good font size. Presentations are designed to be read, otherwise it would just be a speech. Make sure that your audience will be able to easily read what you have written. A 10 point font may look okay when you’re sitting at your computer, but when it’s projected on the screen, people may be leaning forward in their seats straining to read.

On a related note, make sure that your font choice is readable as well. Curvy and extravagant fonts may look cool, but they’ll make your audience just stop caring if they can’t read it.

Apply a consistent, subtle style. The best presentations are those that have a consistent, deliberate style. When in doubt, use one of the templates for a guide. Triple-check for spelling and grammar errors. If you misspell a word, you might not notice it, but someone in your audience will be sure to spot it.

Spelling and grammar mistakes will lower your credibility, even subconsciously, so you’ll want to work extra hard to ensure that everything is written clearly and correctly. A fresh set of eyes are much more likely to catch mistakes that you gloss over. The PowerPoint is only part of your presentation. The other part is you! Take some time and practice your talking points as well as moving through the slides. Work on your timing and ensure that each slide accurately sums up your talking points.

Make your own notes or memorize your presentation; reading off of your slides while you are giving your presentation is a big no-no. See this guide for more information on giving a successful presentation, either in class or at the office. It depends on the kind of diagram.

If it’s saved as an image a jpg, or png , you can import it like a picture. If it’s something more complicated, PowerPoint may not have the functionality to support it.

Not Helpful 3 Helpful Use animation if you can. Do research on current trends with the youth and use these to make your presentation more interesting. Pop culture references are great for this, relate your presentation to TV shows, movies, popular books, etc. Not Helpful 1 Helpful You would just attach the PowerPoint presentation to the email by selecting the “attach file” option in your email. Not Helpful 2 Helpful There should be an option that says “outline.

Not Helpful 5 Helpful You will need a projector that you can connect to your computer. Most offices and schools have one. Not Helpful 13 Helpful Try going to app settings and select refresh. Select what you want to delete, click ok, and you are done.

Not Helpful 8 Helpful Have your flash drive inserted into your computer first. From there, the easiest way is to open the PowerPoint presentation and click on the File button located at the top left of the window. Then, select “Save As. On the left side, find your flash drive. Download Center. November 8, Archived from the original on February 10, Retrieved February 11, Archived from the original on April 20, Retrieved April 17, Open Document Alliance.

ODF Alliance. May 19, Archived from the original on January 19, Retrieved May 22, Archived from the original on January 3, Retrieved May 23, Sun Microsystems. Retrieved January 27, Heise Online.

July 4, Archived from the original on July 11, Retrieved July 6, SD Times. Archived from the original on July 18, Document Interop Initiative. Rightmost frame: Implementation Notes List.

Retrieved January 10, May 5, Office Interoperability. Rob Weir: An Antic Disposition. Archived from the original on November 30, Orcmid’s Lair. August 3, Archived from the original on September 2, Archived from the original on January 26, Unicode, Inc. April 4, Archived PDF from the original on February 6, Retrieved December 19, Retrieved October 2, May 12, Archived from the original on May 21, John Bryntze’s Knowledge Base. Archived from the original on November 22, Retrieved May 2, Retrieved November 11, SuperSite for Windows.

Archived from the original on October 9, Retrieved September 17, Archived from the original on April 13, Retrieved July 15, Archived from the original on February 19, Retrieved July 26, Archived from the original on December 4, Archived from the original on November 12, Archived from the original on April 1, Retrieved November 14, Archived from the original on February 8, Retrieved December 4, Archived from the original on June 19, Retrieved July 27, Archived from the original on April 22, Archived from the original on June 21, Archived from the original on February 13, USA Today.

Gannett Company. Archived from the original on May 13, Archived from the original on March 17, TechNet Library. May 16, Archived from the original on January 18, Archived from the original on March 6, At Cubed. Archived from the original on June 15, Archived from the original on March 28, Karl Barksdale blog.

January 15, Archived from the original on October 20, April 3, Archived from the original on March 9, October 15, Archived from the original on October 26, Archived from the original on December 12, December 15, Archived from the original on January 24, Retrieved May 17, Archived from the original on June 4, Archived from the original on January 9, February 21, Archived from the original on May 8, A Fresh Cup.

Archived from the original on March 3, If using Word , please create the document in Compatibility Mode i. University of Waterloo. October 17, Archived from the original on November 7, Retrieved November 6, Inera Inc. June 22, Archived from the original on March 11, Information for Authors. American Association for the Advancement of Science. Archived from the original on October 15, Science can now accept manuscripts prepared in Word and its. However, we strongly discourage the use of the Word equation editor.

Instead please use Mathtype or Word’s legacy equation editor, which can be obtained through the “Insert” ribbon and the “Object menu” on the “text” panel.

Microsoft Corporation. December 9, Archived from the original on December 19, Microsoft Office. History Microsoft Discontinued shared tools Accounting Docs. Authority control: National libraries Germany Czech Republic. Categories : software Microsoft software Products and services discontinued in Hidden categories: Webarchive template wayback links Use mdy dates from March Articles with short description Short description matches Wikidata All articles lacking reliable references Articles lacking reliable references from March Articles containing potentially dated statements from April All articles containing potentially dated statements Articles with GND identifiers Articles with NKC identifiers.

Namespaces Article Talk. Views Read Edit View history. Help Learn to edit Community portal Recent changes Upload file.

Just click that link and it will directly open the Language page in the Settings app. Click the Install button to download the language pack and keyboard for that language. Just click that link and it will open the Language Accessory Pack for Office page with your web browser. The Language Accessory Pack comes with both bit and bit versions. The options under Select how you want to view this data in your workbook are only available if you have a Data Model prepared and select the option to add this import to that model see the third item in this list.

If you choose Existing Worksheet , click a cell in the sheet to place the first cell of imported data, or click and drag to select a range. If you have a Data Model in place, click Add this data to the Data Model to include this import in the model. For more information, see Create a Data Model in Excel. Note that selecting this option unlocks the options under Select how you want to view this data in your workbook. Click Properties to set any External Data Range properties you want.

For more information, see Manage external data ranges and their properties. In the New Web Query dialog box, enter the address of the web page you want to query in the Address box, and then click Go. In the web page, click the little yellow box with a red arrow next to each table you want to query. None The web data will be imported as plain text. No formatting will be imported, and only link text will be imported from any hyperlinks.

Rich text formatting only The web data will be imported as rich text, but only link text will be imported from any hyperlinks. This option only applies if the preceding option is selected.

If this option is selected, delimiters that don’t have any text between them will be considered one delimiter during the import process. If not selected, the data is imported in blocks of contiguous rows so that header rows will be recognized as such. If selected, dates are imported as text. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security.

Optionally, in the File Name box, revise the suggested file name. Click Browse to change the default file location My Data Sources. Optionally, type a description of the file, a friendly name, and common search words in the Description , Friendly Name , and Search Keywords boxes.

To ensure that the connection file is always used when the data is updated, click the Always attempt to use this file to refresh this data check box.

None Select this option to save the user name and password in the connection file. Security Note: Avoid saving logon information when connecting to data sources. Note: The authentication setting is used only by Excel Services, and not by Excel.

Under Select how you want to view this data in your workbook , do one of the following:. To place the data in an existing worksheet, select Existing worksheet , and then type the name of the first cell in the range of cells where you want to locate the data. Alternatively, click Collapse Dialog to temporarily collapse the dialog box, select the beginning cell on the worksheet, and then click Expand Dialog. To place the data in a new worksheet starting at cell A1, click New worksheet.

Using a connection string is useful, for example, when you want to avoid requiring system administrators or users to first create a connection file, or to simplify the installation of your application. The SQL. You can install the add-in from Office. Power Query for Excel Help. Import data from database using native database query. Use multiple tables to create a PivotTable. Import data from a database in Excel for Mac.

Getting data docs. Import and analyze data. Import data. Import data from data sources Power Query. Select any cell within your data range. Select OK. Select Open. If your source workbook has named ranges, the name of the range will be available as a data set.

Select the Environment you want to connect to. Select or clear Include relationships column. Select Continue. The Adobe Account dialog box appears. Select Basic if the OData feed requires your username and password. Select Save. Enter your domain in the Active Directory dialog box. Select Connect. Enter your connection string, and then select OK. Click Open. In the Power Query ribbon tab, click From Table.

Enter your connection string, then press OK. Click Load or Edit. Tables File. The Data Connection Wizard is displayed.

This wizard has three panes. In the Query Editor, click Advanced Editor. Document File. ToTable Source in “Converted to Table”.

You can use the Data Connection Wizard to connect to an Access database. Click OK to finish. Step 1 of 3 Original data type If items in the text file are separated by tabs, colons, semicolons, spaces, or other characters, select Delimited.

Step 2 of 3 Delimited data Delimiters Select the character that separates values in your text file. Step 2 of 3 Fixed width data Data preview Set field widths in this section.

Step 3 of 3 Click the Advanced button to do one or more of the following: Specify the type of decimal and thousands separators that are used in the text file. Specify that one or more numeric values may contain a trailing minus sign. For example: To convert a column of all currency number characters to the Excel Currency format, select General.

For example: If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General.

Import Data Set these options to control how the data import process runs, including what data connection properties to use and what file and range to populate with the imported data.

Specify a target workbook: If you choose Existing Worksheet , click a cell in the sheet to place the first cell of imported data, or click and drag to select a range. Choose New Worksheet to import into a new worksheet starting at cell A1 If you have a Data Model in place, click Add this data to the Data Model to include this import in the model.

Click OK when you’re ready to finish importing your data. The web page opens in the New Web Query dialog box. Set any options you want, then click Import. Treat consecutive delimiters as one This option only applies if the preceding option is selected.

Use the same import settings for the entire section This option only applies if the preceding option is selected. Disable date recognition If selected, dates are imported as text. Disable Web Query redirections If selected, redirects will be ignored. If not selected, redirects will be processed. The Data Connection Wizard starts. Archived from the original on March 23, CIO Magazine. Archived from the original on March 5, Microsoft TechNet. Wasif K Niazi. Retrieved March 10, Office Support. CBS Interactive.

Archived from the original on March 12, Microsoft Support. Archived from the original on July 29, Retrieved June 17, August 27, Retrieved September 14, An Office User Interface Blog.

Archived from the original on September 4, Retrieved October 30, Archived from the original on March 10, Retrieved August 13, Archived from the original on January 7, Retrieved November 10, Retrieved December 17, April 28, May 21, Archived from the original on August 5, Archived from the original on February 18, October 22, Retrieved February 5, Archived from the original on September 10, Archived from the original on May 24, Retrieved May 25, Archived from the original on July 3, I Started Something.

Retrieved March 19, Jensen Harris’ blog. Archived from the original on February 12, Microsoft Office website. Retrieved March 31, Retrieved March 4, Network World. Archived from the original on May 9, Archived from the original on May 15, Archived from the original on November 1, Retrieved October 26, Archived from the original on September 27, Archived from the original on December 31, Archived from the original on February 14, Archived from the original on February 9, Retrieved June 3, Archived from the original on December 18, Archived from the original on April 2, Archived from the original on April 29, Retrieved May 1, Download Center.

November 8, Archived from the original on February 10, Retrieved February 11, Archived from the original on April 20, Retrieved April 17, Open Document Alliance. ODF Alliance. May 19, Archived from the original on January 19, Retrieved May 22, Archived from the original on January 3, Retrieved May 23, Sun Microsystems. Retrieved January 27, Heise Online. July 4, Archived from the original on July 11, Retrieved July 6, SD Times. Archived from the original on July 18, Document Interop Initiative.

Rightmost frame: Implementation Notes List. Retrieved January 10, May 5, Office Interoperability. Rob Weir: An Antic Disposition. Archived from the original on November 30, Orcmid’s Lair. August 3, Archived from the original on September 2, Archived from the original on January 26, Unicode, Inc. April 4, Archived PDF from the original on February 6, Retrieved December 19, Retrieved October 2, May 12, With Microsoft , you can collaborate with anyone, anywhere.

Office for the web training Learn how to stay productive in Office from any browser with these brand new courses. Cheat sheets Get up to speed fast with these quick references and keyboard shortcuts. Infographics Get inspired with cool new infographics for your favorite Office apps. For small businesses Watch these short, easy videos to help you set up Microsoft Modern workplace training Learn how to get more work done, from anywhere on any device with Microsoft and Windows More training Office training LinkedIn Learning.

Get support.

Templates can give your presentation a uniform style, but they may not suit your exact needs. You can edit any aspect of a template, so feel free to choose one that mostly matches your vision and tweak it as you see fit. You can apply themes to your project at a later time after you’ve added content.

Click the Design tab and select a theme. It will be immediately applied to your project. You can access templates from the File tab. Click New and then browse the available templates. You can also download additional templates from a variety of resources online.

Create your title slide. Your title is the first thing that your audience will see. It should be easy to read and give a basic overview about the topic of the presentation. Most presenters will include their or their group’s name on the title as well.

Add new slides for content. A blank slide will be added after the slide you are currently on. The slide will contain a title box and a text box.

You can choose to use these or insert your own objects using the Insert tab. When adding a text box, you can click and drag to make it whatever size you’d like. You can then adjust this later by grabbing one of the corners with your cursor and then clicking and dragging again. You can click on any text box and start typing to begin adding text to your presentation. You can format text just as you would in Word, with formatting options available in the Home tab.

Navigate your presentation. You can use the frame on the left side of the window to quickly scroll through your slides. Clicking any of them will open that slide so that you can edit it. You can click the Outline tab to see an outline tree of your presentation. Each slide will be labeled by the slide title. Preview your presentation. You can get a basic feel for the flow of your presentation at this point by pressing F5 to start the slide show.

Click the mouse to advance the slides. Use the preview slide show to get an idea of how long the presentation is and how well information flows from one slide to the next. Part 2. Once you have some content in your slides, you can start adding some effects to help make it a bit more interesting for your audience. Select a slide and click the Transitions tab. You will see a list of the most common transitions. You can also click the arrow at the end of the list to open the full listing of available transitions.

If your presentation is standard text on a plain white background, half of your audience will be asleep before you reach the third slide. Use subtle backgrounds to add a little visual flair to your project. Right-click on a blank section of your slide and select “Format Background”, or click the Design tab and the click the arrow icon next to “Background” on the far right. Choose your fill type. You can choose a solid color, a gradient fill, a picture background, or a pattern fill.

Selecting each choice will display several options for it, such as fill color, picture location, gradient settings, and more. Experiment until you find the background that fits your presentation. By default, the background will only be applied to your active slide.

Click the “Apply to All” button to apply your background choices to every slide. Make sure that your text is still easily readable with the background you choose.

Add images. Adding pictures, diagrams, and other visual aids can help the audience grasp the ideas of your presentation and drive your point home. Images break up the monotony of text and help keep the audience from tuning out. Click the Insert tab. There will be a large number of options when it comes to inserting objects. Click the Picture button to insert a picture from a file on your computer. You can click the Photo Album button to insert an entire album of photos into the slide as well.

Use the Charts button to insert easy-to-read charts that will help the audience understand your data. Once you choose your Chart type, Excel will open, allowing you to enter in your data or copy it from an existing spreadsheet.

See this guide to learn how. Part 3. Keep the number of slides to a minimum. Extremely long presentations will bore your audience, even if they are obsessed with your subject matter.

Extraneous slides with little to no content will also make the presentation drag and wear on the audience’s interest. Try to keep your presentation short and sweet, and make sure you are using the space on each slide to it’s maximum potential. Choose a good font size. Presentations are designed to be read, otherwise it would just be a speech.

Make sure that your audience will be able to easily read what you have written. A 10 point font may look okay when you’re sitting at your computer, but when it’s projected on the screen, people may be leaning forward in their seats straining to read. On a related note, make sure that your font choice is readable as well.

Curvy and extravagant fonts may look cool, but they’ll make your audience just stop caring if they can’t read it. Apply a consistent, subtle style. The best presentations are those that have a consistent, deliberate style. When in doubt, use one of the templates for a guide. Triple-check for spelling and grammar errors. If you misspell a word, you might not notice it, but someone in your audience will be sure to spot it.

It depends on the kind of diagram. If it’s saved as an image a jpg, or png , you can import it like a picture. If it’s something more complicated, PowerPoint may not have the functionality to support it.

Not Helpful 3 Helpful Use animation if you can. Do research on current trends with the youth and use these to make your presentation more interesting. Pop culture references are great for this, relate your presentation to TV shows, movies, popular books, etc. If you are connecting to the Blob storage service for the first time, you will be prompted to enter and save the storage access key.

Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then select the Manage Access Key icon on the bottom of the page.

Select the copy icon to the right of the primary key, and then paste the value in the Account Key box. The Azure Storage provides storage services for a variety of data objects.

For more information, see Introduction to Table storage. Azure Data Lake Storage Gen 1 combines different data warehouses into a single, stored environment.

It can handle large volumes of diverse data from any data source, such as websites, applications, IoT devices, and more. For more information, see What is Azure Data Explorer.

In the Azure Data Explorer Kusto dialog box, enter appropriate values. Each prompt provides helpful examples to walk you though the process. You can import Datasets from your organization with appropriate permission by selecting them from the Power BI Datasets pane, and then creating a PivotTable in a new worksheet. The Power BI Datasets pane appears. If many Datasets are available, use the Search box. Select the arrow next to the box to display keyword filters for versions and environments to target your search.

Select a Dataset and create a PivotTable in a new worksheet. Select the 2. As an alternative to 2. For more information about advanced connector options, see SharePoint Online list. If you have many objects, use the Search box to locate an object or use he Display Options along with the Refresh button to filter the list. Select or clear the Skip files with errors checkbox at the bottom of the dialog box. If you select the Advanced option, you can append certain additional parameters to the query to control what data is returned.

Select either Production or Custom. If you select Custom , enter the URL of a custom instance. For more information about advanced connector options, see Salesforce Objects.

Because Salesforce Reports has API limits retrieving only the first 2, rows for each report, consider using the Salesforce Objects connector to work around this limitation if needed. The Salesforce Reports dialog box appears. For more information about advanced connector options, see Salesforce Reports.

Make sure you have the latest version of the Adobe Analytics connector. Sign in with you Adobe Analytics Organizational account, and then select Connect. For more information about advanced connector options, see Adobe Analytics.

Select Advanced , and then In the Access Web dialog box, enter your credentials. For more information about advanced connector options, see Web. Microsoft Query has been around a long time and is still popular. In many ways, it’s a progenitor of Power Query.

For more information, see Use Microsoft Query to retrieve external data. By default, the most general URL is selected.

Select Anonymous if the SharePoint Server does not require any credentials. Select Organizational account if the SharePoint Server requires organizational account credentials.

In the Active Directory Domain dialog box for your domain, select Use my current credentials , or select Use alternate credentials and then enter your Username and Password.

Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, Note: If this is the first time you’ve connected to Facebook, you will be asked to provide credentials. Sign in using your Facebook account, and allow access to the Power Query application. You can turn off future prompts by clicking the Don’t warn me again for this connector option.

Note: Your Facebook username is different from your login email. Select a category to connect to from the Connection drop-down list.

For example, select Friends to give you access to all information available in your Facebook Friends category. If necessary, click Sign in from the Access Facebook dialog, then enter your Facebook email or phone number, and password. You can check the option to remain logged in. Once signed in, click Connect. After the connection succeeds, you will be able to preview a table containing information about the selected category.

For instance, if you select the Friends category, Power Query renders a table containing your Facebook friends by name. You can create a blank query.

You might want to enter data to try out some commands, or you can select the source data from Power Query:. For more information, see Manage data source settings and permissions. This command is similar to the Get Data command on the Data tab of the Excel ribbon. This command is similar to the Recent Sources command on the Data tab of the Excel ribbon.

You can use the Power Query add-in to connect to external data sources and perform advanced data analyses. The following sections provide steps for connecting to your data sources – web pages, text files, databases, online services, and Excel files, tables, and ranges. Click the Power Query check box, then OK. The Power Query ribbon should appear automatically, but if it doesn’t, close and restart Excel. The following video shows the Query Editor window appearing after editing a query from an Excel workbook.

The following video shows one way to display the Query Editor. These automatic actions are equivalent to manually promoting a row and manually changing each column type. For example:.

The following video shows the Query Editor window in Excel appearing after editing a query from an Excel workbook. If prompted, in the From Table dialog box, you can click the Range Selection button to select a specific range to use as a data source. If the range of data has column headers, you can check My table has headers.

The range header cells are used to set the column names for the query. Note: If your data range has been defined as a named range, or is in an Excel table, then Power Query will automatically sense the entire range and load it into the Query Editor for you.

Plain data will automatically be converted to a table when it is loaded into the Query Editor. You can use the Query Editor to write formulas for Power Query. You can also use the Query Editor to write formulas for Power Query. Note: While trying to import data from a legacy Excel file or an Access database in certain setups, you may encounter an error that the Microsoft Access Database Engine Microsoft. The error occurs on systems with only Office installed.

To resolve this error, download the following resources to ensure that you can proceed with the data sources you are trying to access.

Microsoft Access Database Engine Redistributable. Access Database Engine Service Pack 1. In the Access Web dialog box, click a credentials option, and provide authentication values.

Power Query will analyze the web page, and load the Navigator pane in Table View. If you know which table you want to connect to, then click it from the list.

For this example, we chose the Results table. Otherwise, you can switch to the Web View and pick the appropriate table manually. In this case, we’ve selected the Results table. Click Load , and Power Query will load the web data you selected into Excel. Windows : This is the default selection. In the next dialog box, select from Default or Custom , Windows , or Database connection options, enter your credentials, then press Connect.

In the Navigator pane, select the tables or queries that you want to connect to, then press Load or Edit. In the Browse dialog box, browse for or type a file URL to import or link to a file. Follow the steps in the Navigator dialog to connect to the table or query of your choice. After the connection succeeds, you will be able to use the Navigator pane to browse and preview the collections of items in the XML file in a tabular form. Save Data Connection File and Finish. In the Select the database that contains the data you want pane, select a database, then click Next.

To connect to a specific cube in the database, make sure that Connect to a specific cube or table is selected, and then select a cube from the list. In the Import Data dialog box, under Select how you want to view this data in your workbook , do one of the following:. To store the selected connection in the workbook for later use, click Only Create Connection. This check box ensures that the connection is used by formulas that contain Cube functions that you create and that you don’t want to create a PivotTable report.

To place the PivotTable report in an existing worksheet, select Existing worksheet , and then type the cell reference of the first cell in the range of cells where you want to locate the PivotTable report. You can also click Collapse Dialog to temporarily hide the dialog box, select the beginning cell on the worksheet that you want to use, and then press Expand Dialog. To place the PivotTable report in a new worksheet starting at cell A1, click New worksheet.

To verify or change connection properties, click Properties , make the necessary changes in the Connection Properties dialog box, and then click OK. You can either use Power Query or the Data Connection wizard. In the Access SharePoint dialog box that appears next, select a credentials option:. In the Navigator dialog, select the Database and tables or queries you want to connect to, then press Load or Edit.

In the Active Directory Domain dialog box for your domain, click Use my current credentials , or Use alternate credentials. For Use alternate credentials authentication, enter your Username and Password. After the connection succeeds, you can use the Navigator pane to browse all the domains available within your Active Directory, and drill down into Active Directory information including Users, Accounts, and Computers. See: Which version of Office am I using?

If you aren’t signed in using the Microsoft Work or School account you use to access CDS for Apps, click Sign in and enter the account username and password. If the data is good to be imported as is, then select the Load option, otherwise choose the Edit option to open the Power Query Editor. Note: The Power Query Editor gives you multiple options to modify the data returned. For instance, you might want to import fewer columns than your source data contains. Note: If you need to retrieve your storage access key, browse to the Microsoft Azure Portal , select your storage account, and then click on the Manage Access Key icon on the bottom of the page.

Click Load to load the selected table, or click Edit to perform additional data filters and transformations before loading it. The following sections provide steps for using Power Query to connect to your data sources – web pages, text files, databases, online services, and Excel files, tables, and ranges. Make sure you have downloaded, installed, and activated the Power Query Add-In. For Use alternate credenitals authentication, enter your Username and Password.

Power Query is not available in Excel However, you can still connect to external data sources. Step 1: Create a connection with another workbook. Near the bottom of the Existing Connections dialog box, click Browse for More. In the Select Table dialog box, select a table worksheet , and click OK. You can rename a table by clicking on the Properties button.

You can also add a description. Click Existing Connections , choose the table, and click Open. In the Import Data dialog box, choose where to put the data in your workbook and whether to view the data as a Table , PivotTable , or PivotChart. In the Select Data Source dialog box, browse to the Access database. In the Select Table dialog box, select the tables or queries you want to use, and click OK. You can click Finish , or click Next to change details for the connection.

In the Import Data dialog box, choose where to put the data in your workbook and whether to view the data as a table, PivotTable report, or PivotChart. Click the Properties button to set advanced properties for the connection, such as options for refreshing the connected data.

Optionally, you can add the data to the Data Model so that you can combine your data with other tables or data from other sources, create relationships between tables, and do much more than you can with a basic PivotTable report.

File origin Select the character set that is used in the text file. In most cases, you can leave this setting at its default.

If you know that the text file was created by using a different character set than the character set that you are using on your computer, you should change this setting to match that character set. For example, if your computer is set to use character set Cyrillic, Windows , but you know that the file was produced by using character set Western European, Windows , you should set File Origin to Preview of file This box displays the text as it will appear when it is separated into columns on the worksheet.

Delimiters Select the character that separates values in your text file. If the character is not listed, select the Other check box, and then type the character in the box that contains the cursor. These options are not available if your data type is Fixed width. Treat consecutive delimiters as one Select this check box if your data contains a delimiter of more than one character between data fields or if your data contains multiple custom delimiters. Text qualifier Select the character that encloses values in your text file.

When Excel encounters the text qualifier character, all of the text that follows that character and precedes the next occurrence of that character is imported as one value, even if the text contains a delimiter character. For example, if the delimiter is a comma , and the text qualifier is a quotation mark ” , “Dallas, Texas” is imported into one cell as Dallas, Texas.

If no character or the apostrophe ‘ is specified as the text qualifier, “Dallas, Texas” is imported into two adjacent cells as “Dallas and Texas”. If the delimiter character occurs between text qualifiers, Excel omits the qualifiers in the imported value. If no delimiter character occurs between text qualifiers, Excel includes the qualifier character in the imported value.

If you select Date , select a date format in the Date box. Choose the data format that closely matches the preview data so that Excel can convert the imported data correctly. To convert a column of all currency number characters to the Excel Currency format, select General. To convert a column of all number characters to the Excel Text format, select Text.

To convert a column of all date characters, each date in the order of year, month, and day, to the Excel Date format, select Date , and then select the date type of YMD in the Date box. Excel will import the column as General if the conversion could yield unintended results. If the column contains a mix of formats, such as alphabetical and numeric characters, Excel converts the column to General. If, in a column of dates, each date is in the order of year, month, and date, and you select Date along with a date type of MDY , Excel converts the column to General format.

A column that contains date characters must closely match an Excel built-in date or custom date formats. If Excel does not convert a column to the format that you want, you can convert the data after you import it. Convert numbers stored as text to numbers. Convert dates stored as text to dates. TEXT function.

VALUE function. When you have selected the options you want, click Finish to open the Import Data dialog and choose where to place your data. Set these options to control how the data import process runs, including what data connection properties to use and what file and range to populate with the imported data. The options under Select how you want to view this data in your workbook are only available if you have a Data Model prepared and select the option to add this import to that model see the third item in this list.

For more information, see Create a Data Model in Excel. Note that selecting this option unlocks the options under Select how you want to view this data in your workbook. Click Properties to set any External Data Range properties you want. For more information, see Manage external data ranges and their properties. In the New Web Query dialog box, enter the address of the web page you want to query in the Address box, and then click Go.

If not selected, the data is imported in blocks of contiguous rows so that header rows will be recognized as such. If selected, dates are imported as text. SQL Server is a full-featured, relational database program that is designed for enterprise-wide data solutions that require optimum performance, availability, scalability, and security.

Alternatively, you can clear the Connect to a specific table check box, so that other users who use this connection file will be prompted for the list of tables and views.

To ensure that the connection file is always used when the data is updated, click the Always attempt to use this file to refresh this data check box. This check box ensures that updates to the connection file will always be used by all workbooks that use that connection file.

To specify how the external data source of a PivotTable report is accessed if the workbook is saved to Excel Services and is opened by using Excel Services, click Authentication Settings , and then select one of the following options to log on to the data source:.

This method can be the most efficient when many users are connected to the server. None Select this option to save the user name and password in the connection file.

Microsoft office 2016 tutorial free.Microsoft Training

Looking for:

Free Office Tutorials at GCFGlobal.Get Office apps for Mac

Free Microsoft Office Tutorials at GCFGlobal.Office 2016

Submit a Comment Cancel reply

Contáctanos

Encuéntranos

Enlaces

Nosotros

Servicios

Productos

Políticas de privacidad

Hablemos