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 to get more work done, microsoft outlook tutorial 2013 pdf free 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. Quick Starts. Microsoft Accessibility Help. Office Accessibility Training. Office training. LinkedIn Learning.
Learn the basics Get going quickly and easily microsoft outlook tutorial 2013 pdf free Microsoft video training. Quick Starts Get up to speed in no time with these popular guides. Collaborate Do your best work together.
With Microsoftyou can collaborate with anyone, anywhere. Office for the web training Learn how to stay ссылка 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. Join the discussion. Buy Microsoft
Microsoft Outlook download free tutorial in pdf
You can import data into Excel from a wide variety of data sources and 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 box, you can select the Range Selection button to select a specific range to use as a data source.
If the table or range of data has column headers, 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 to 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 data from a CSV file, Power Query will automatically detect 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 the basic steps of importing data. For 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 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.
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.
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.
Microsoft outlook tutorial 2013 pdf free. outlook 2013 tutorial pdf PDF,Doc ,Images
This topic gives you step-by-step instructions and best practices for making your PowerPoint presentations accessible and unlock your content to everyone, including people with disabilities. PowerPoint has many features built-in that help people with different abilities to read and author documents. In this topic, you learn, for example, how to work with the Accessibility Checker to tackle accessibility issues while you’re creating your presentation.
You’ll also learn how to add alt texts to images so that people using screen readers are able to listen to what the image is all about. You can also read about how to use slide design, fonts, colors, and styles to maximize the inclusiveness of your slides before you share or present them to your audience. Best practices for making PowerPoint presentations accessible. Check accessibility while you work. Create accessible slides. Avoid using tables. Add alt text to visuals.
Create accessible hyperlink text and add ScreenTips. Use accessible font format and color. Use captions, subtitles, and alternative audio tracks in videos. Save your presentation in a different format. Test accessibility with a screen reader. The following table includes key best practices for creating PowerPoint presentations that are accessible to people with disabilities.
To find missing alternative text, use the Accessibility Checker. Use the Accessibility Checker to find slides that have possible problems with reading order. A screen reader reads the elements of a slide in the order they were added to the slide, which might be very different from the order in which things appear.
Set the reading order of slide contents. Use built-in slide designs for inclusive reading order, colors, and more. To determine whether hyperlink text makes sense as standalone information, visually scan the slides in your presentation. Tip: You can also add ScreenTips that appear when your cursor hovers over text or images that include a hyperlink. Turn on the Color filter switch, and then select Grayscale.
Visually scan each slide in your presentation for instances of color-coding. People who are blind, have low vision, or are colorblind might miss out on the meaning conveyed by particular colors. Use an accessible presentation template. To find insufficient color contrast, use the Accessibility Checker.
Strong contrast between text and background makes it easier for people with low vision or colorblindness to see and use the content. Use accessible font color. To find slides that do not have titles, use the Accessibility Checker. People who are blind, have low vision, or a reading disability rely on slide titles to navigate. For example, by skimming or using a screen reader, they can quickly scan through a list of slide titles and go right to the slide they want.
Give every slide a title. Hide a slide title. If you must use tables, create a simple table structure for data only, and specify column header information.
To ensure that tables don’t contain split cells, merged cells, or nested tables, use the Accessibility Checker. Use table headers. To find potential issues related to fonts or white space, review your slides for areas that look crowded or illegible. Make videos accessible to people who are blind or have low vision or people who are deaf or hard-of-hearing. Subtitles typically contain a transcription or translation of the dialogue.
Closed captions typically also describe audio cues such as music or sound effects that occur off-screen. Video description means audio-narrated descriptions of a video’s key visual elements. These descriptions are inserted into natural pauses in the program’s dialogue. Video description makes video more accessible to people who are blind or have low vision. Include accessibility tags to PDF files you create from your presentation. The tags make it possible for screen readers and other assistive technologies to read and navigate a document.
Top of Page. The Accessibility Checker is a tool that reviews your content and flags accessibility issues it comes across. It explains why each issue might be a potential problem for someone with a disability. The Accessibility Checker also suggests how you can resolve the issues that appear. In PowerPoint, the Accessibility Checker runs automatically in the background when you’re creating a document. If the Accessibility Checker detects accessibility issues, you will get a reminder in the status bar.
The Accessibility pane opens, and you can now review and fix accessibility issues. For more info, go to Improve accessibility with the Accessibility Checker. Tip: Use the Accessibility Reminder add-in for Office to notify authors and contributors of accessibility issues in their documents. With the add-in, you can quickly add reminder comments that spread awareness of accessibility issues and encourage the use of the Accessibility Checker.
For more info, go to Use the Accessibility Reminder to notify authors of accessibility issues. The following procedures describe how to make the slides in your PowerPoint presentations accessible. For more info, go to Video: Create accessible slides and Video: Design slides for people with dyslexia. Use one of the accessible PowerPoint templates to make sure that your slide design, colors, contrast, and fonts are accessible for all audiences.
They are also designed so that screen readers can more easily read the slide content. In the Search for Online templates and themes text field, type accessible templates and press Enter. One simple step towards inclusivity is having a unique, descriptive title on each slide, even if it isn’t visible. A person with a visual disability that uses a screen reader relies on the slide titles to know which slide is which. Use the Accessibility ribbon to make sure every slide has a title.
For instructions, go to Title a slide and expand the “Use the Accessibility ribbon to title a slide” section. You can position a title off the slide. That way, the slide has a title for accessibility, but you save space on the slide for other content. For instructions, go to Title a slide and expand the “Put a title on a slide, but make the title invisible” section. If you want all or many of your slide titles to be hidden, you can modify the slide master.
For instructions, go to Title a slide and expand the “Systematically hide slide titles” section. If you’ve moved or edited a placeholder on a slide, you can reset the slide to its original design. All formatting for example, fonts, colors, effects go back to what has been assigned in the template. Restoring the design might also help you find title placeholders which need a unique title.
To restore all placeholders for the selected slide, on the Home tab, in the Slides group, select Reset. Some people with visual disabilities use a screen reader to read the information on the slide. When you create slides, putting the objects in a logical reading order is crucial for screen reader users to understand the slide. Use the Accessibility Checker and the Reading Order pane to set the order in which the screen readers read the slide contents. When the screen reader reads the slide, it reads the objects in the order they are listed in the Reading Order pane.
For the step-by-step instructions how to set the reading order, go to Make slides easier to read by using the Reading Order pane. PowerPoint has built-in, predesigned slide designs that contain placeholders for text, videos, pictures, and more. They also contain all the formatting, such as theme colors, fonts, and effects.
To make sure that your slides are accessible, the built-in layouts are designed so that the reading order is the same for people who use assistive technologies such as screen readers and people who see. For more info, go to Video: Use accessible colors and styles in slides.
Expand the Themes gallery and select the slide layout that you want. PowerPoint automatically applies this layout to the presentation. In general, avoid tables if possible and present the data another way, like paragraphs with headings. Tables with fixed width might prove difficult to read for people who use Magnifier, because such tables force the content to a specific size. This makes the font very small, which forces Magnifier users to scroll horizontally, especially on mobile devices.
If you have to use tables, use the following guidelines to make sure your table is as accessible as possible:. If you have hyperlinks in your table, edit the link texts, so they make sense and don’t break mid-sentence. Make sure the slide content is easily read with Magnifier.
Screen readers keep track of their location in a table by counting table cells. Blank cells in a table could also mislead someone using a screen reader into thinking that there is nothing more in the table. Use a simple table structure for data only and specify column header information. Screen readers also use header information to identify rows and columns. Visual content includes pictures, SmartArt graphics, shapes, groups, charts, embedded objects, ink, and videos.
In alt text, briefly describe the image, its intent, and what is important about the image.
Microsoft outlook tutorial 2013 pdf free. Outlook 2013 Quick Start Guide
Video training for Outlook You can download these video tutorials or watch them online. Check out the new Outlook training. Beginner. Microsoft Outlook Client (Primary program to access Office ). 1. Select MS Ribbon Video Tutorial ( Minutes): Add Signature to Email. PDF] Microsoft Outlook free tutorial for Beginners. Source:replace.me