Microsoft excel 2016 step by step pdf free
Looking for:
Microsoft Excel Books - PDF Drive - Interesting tutorials |
Microsoft Excel Step by Step PDF - META IT BOOK - Other titles you might like
Microsoft for Mac, Office for Mac.Download free exercises on excel step by step in pdf materials
Highly recommended. Dates and date functions. Lookup functions. Follow the instructions to download this book's companion content. Part 1 includes files from Chapters ; Part 2 contains files from Chapters We've made every effort to ensure the accuracy of this book and its companion content.
Any errors that have been confirmed since this book was published can be downloaded below. Download the errata. If you find an error, you can report it to us through our Submit errata page. Sign in. Your cart. This eBook includes the following formats, accessible from your Account page after purchase: EPUB The open industry format known for its reflowable content and usability on supported mobile devices.
Downloads Follow the instructions to download this book's companion content. Click the Download button below to start the download. If prompted, click Save. Locate the. Right-click the file, click Extract All, and then follow the instructions. Download Part 1 Download Part 2.
Use the Accessibility Checker to analyze the presentation and find insufficient color contrast. It finds insufficient color contrast in text with or without highlights or hyperlinks in shapes, tables, or SmartArt with solid opaque colors. It does not find insufficient color contrast in other cases such as text in a transparent text box or placeholder on top of the slide background, or color contrast issues in non-textual content. PowerPoint supports the playback of video with multiple audio tracks.
It also supports closed captions and subtitles that are embedded in video files. Currently, only PowerPoint for Windows supports insertion and playback of closed captions or subtitles that are stored in files separate from the video.
For all other editions of PowerPoint such as PowerPoint for macOS or the mobile editions , closed captions or subtitles must be encoded into the video before they are inserted into PowerPoint. Supported video formats for captions and subtitles vary depending on the operating system that you're using. Each operating system has settings to adjust how the closed captions or subtitles are displayed.
For more information, see Closed Caption file types supported by PowerPoint. Closed captions, subtitles, and alternative audio tracks are not preserved when you use the Compress Media or Optimize Media Compatibility features.
Also, when turning your presentation into a video , closed captions, subtitles, or alternative audio tracks in the embedded videos are not included in the video that is saved. When you use the Save Media as command on a selected video, closed captions, subtitles, and multiple audio tracks embedded in the video are preserved in the video file that is saved. Videos include an audio track with video descriptions, if needed, for users who are blind or have low vision.
Videos that include dialogue also include closed captions, in-band closed captions, open captions, or subtitles in a supported format for users that are deaf or hard-of-hearing. For more information, refer to Add closed captions or subtitles to media in PowerPoint. You can save your presentation in a format that can be easily read by a screen reader or be ported to a Braille reader. Before converting a presentation into another format, make sure you run the Accessibility Checker and fix all reported issues.
When your presentation is ready and you've run the Accessibility Checker to make sure it is inclusive, you can try navigating the slides using a screen reader, for example, Narrator. Narrator comes with Windows, so there's no need to install anything. This is one additional way to spot issues in the navigation order, for example.
Press the Tab key to navigate the elements within the slide and fix the navigation order if needed. To move the focus away from the slide content, press Esc or F6. Rules for the Accessibility Checker.
Everything you need to know to write effective alt text. Use the Accessibility Reminder to notify authors of accessibility issues. Make your Word documents accessible to people with disabilities. Make your Excel documents accessible to people with disabilities. Make your Outlook email accessible to people with disabilities.
Closed Caption file types supported by PowerPoint. If you must use an image with text in it, repeat that text in the presentation. In the alternative text, briefly describe the image and mention the existence of the text and its intent.
Add alt text to visuals in Microsoft Add alt text to visuals in Office When someone who can see reads a slide, they usually read things, such as text or a picture, in the order the elements appear on the slide.
In contrast, 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. To make sure everyone reads the contents in the order you intend, it's important to check the reading order.
PowerPoint contains built-in slide layouts that you can apply to any slide. When you use them with a new slide, these layouts automatically make sure that the reading order works for everyone. Use built-in slide designs for inclusive reading order. To determine whether hyperlink text makes sense as standalone information and whether it gives readers accurate information about the destination target, visually scan the slides in your presentation.
For example, instead of linking to the text Click here , include the full title of the destination page. You can even use the URL of the page if it's short and descriptive, for example, www. Add hyperlink text and ScreenTips. Visually scan the slides in your presentation. Use an accessible slide design. Use strong contrast between text and background, so people with low vision can see and use the content. Use dark text on a white or off-white background, or reverse it and use white text on a dark background.
White and black schemes also make it easier for people who are colorblind to distinguish text and shapes. Use unique slide titles. They often see text merge or distort. For people who have dyslexia or have low vision, reduce the reading load. For example, they might benefit from familiar sans serif fonts, such as Arial or Calibri.
Include ample white space between sentences and paragraphs. Format text for accessibility. Video description makes video more accessible to individuals who are blind or visually impaired. The following procedures describe how to add alt text to visuals in your PowerPoint presentations in Microsoft Add alt text to images.
Add alt text to shapes. Add alt text to SmartArt graphics. Add alt text to charts. Make visuals decorative. For audio and video content, in addition to alt text, include closed captioning for people who are deaf or have limited hearing. To enable right-click on your Mac, make sure that the Secondary click option is selected in System Preferences. PowerPoint does not automatically generate alt texts for images. If you want to add an image that is an icon, screenshot, or other image that is not a photograph, you need to add the alt texts manually.
Tip: To spell check and correct a word you typed, just right-click the word and select from the suggested alternatives. Tip: You have to right-click somewhere inside the frame that surrounds the entire shape, not inside one of its parts. Tip: You have to right-click somewhere inside the frame that surrounds the entire SmartArt graphic, not inside one of its parts. Select a SmartArt graphic.
Type sentences to describe the SmartArt graphic and its context to someone who cannot see it. Tip: You have to right-click somewhere inside the frame that surrounds the entire chart, not inside one of its parts.
Select Edit Alt Text The Alt Text pane opens on the right side of the slide. If your presentation has visuals that are purely decorative, you can mark them as such without needing to write any alt text. When a screen reader finds such an image, it simply announces they are decorative, so the user knows they are not missing any information. Select a visual. Select the Mark as decorative check box. The text entry field becomes grayed out. The following procedures describe how to add alt text to visuals in your PowerPoint presentations in Office To make your presentations accessible to wider audiences, add alt texts to the images in your slides.
PowerPoint does not automatically generate alt texts. Tip: You can also select Generate a description for me to have Microsoft's cloud-powered intelligent services create a description for you. This takes a moment, after which you see the result in the text entry field. Remember to delete any comments PowerPoint added there, for example, "Description generated with high confidence. Tip: Include the most important information in the first line, and be as concise as possible.
Use the following procedure to add alt text to shapes, including shapes within a SmartArt graphic. The following procedures describe how to make the hyperlinks, text, and tables in your PowerPoint presentations accessible. Select Hyperlink. The text you selected displays in the Text to Display box. This is the hyperlink text. For example, this hyperlink text matches the title on the destination page: Templates and Themes for Office Online.
Use one of the included accessible templates to make sure that your slide design, colors, contrast, and fonts are accessible for all audiences.
In the Search all templates text field, type accessible templates and press Return. On the Table Design tab, select the Header Row check box. See Title a slide for related information. To restore all placeholders for the selected slide, on the Home tab, select Reset. Point the mouse at the border of the Title placeholder box so that the pointer becomes a four-headed move pointer. Use the Selection Pane to set the order in which the screen readers read the slide contents.
When the screen reader reads this slide, it reads the objects in the reverse of the order they are listed in the Selection Pane. In the Selection Pane , to change the reading order, drag and drop items to the new location. PowerPoint has built-in slide designs that contain placeholders for text, videos, pictures, and more.
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 see and people who use technology such as screen readers.
In the thumbnail pane, locate the place where you want to add the new slide, and then right-click. On the Design tab, expand the themes gallery, and select the slide layout that you want. PowerPoint automatically applies this layout to the new slide. Closed captions or subtitles must be encoded into the video before it is inserted into PowerPoint. PowerPoint does not support closed captions or subtitles that are stored in a separate file from the video file.
Videos include an audio track with video descriptions, if needed, for users that are blind or visually impaired. Videos that include dialogue also include closed captions, in-band closed captions, open captions, or subtitles in a supported format for users that are deaf or hard of hearing.
In the alt text, briefly describe the image and mention the existence of the text and its intent. Add alt text to images, tables, and shapes. The text in your presentations should be readable in High Contrast mode so that everyone, including people with visual disabilities, can see it well. Avoid using all capital letters, and excessive italics or underlines. To open the related tab, for example, the Picture tab, tap the Show Ribbon button. Tap Alt Text and type a description for the element.
For example, describe the content of the image. If your visuals are purely decorative and add visual interest but aren't informative, you can mark them as such without needing to write any alt text.
Examples of objects that should be marked as decorative are stylistic borders. To open the related tab, for example, the Picture tab, select the Show Ribbon button. Select the Mark as decorative toggle button, and then select Done. Use one of the included slide Themes to make sure that your slide design is accessible.
Most of the themes are designed for accessible colors, contrast, and fonts. To open the Home tab, tap the Show Ribbon button. To open the Table tab, tap the Show Ribbon button.
In alt text, briefly describe the image and mention the existence of the text and its intent. Add alt text to tables. The following procedures describe how to add alt text to visuals and tables in your PowerPoint presentations. To open the Picture tab, tap the Show Commands button.
To open the Shape tab, tap the Show Commands button. To open the Table tab, tap the Show Commands button. To open the formatting menu for the visual, tap the Show Commands button. To open the Home tab, tap the Show Commands button. Each operating system has settings you can use to adjust how the closed captions or subtitles are displayed.
The following table includes key best practices for creating PowerPoint for the web presentations that are accessible to people with disabilities. Visual content includes pictures, SmartArt graphics, shapes, groups, embedded objects, and videos.
Add alt text to shapes or embedded videos. Add hyperlink text. Change the text of a hyperlink. Circle or use animation to highlight information, rather than relying on laser pointers or color. Add shapes if color is used to indicate status. The text in your presentations should be readable so that everyone, including people with visual disabilities, can see it well.
Use the Accessibility Checker to find slides that don't have titles. People who use screen readers and other assistive technology hear slide text, shapes, and content read back in a specific order.
Use a logical reading order. To ensure that tables don't contain split cells, merged cells, or nested tables use the Accessibility Checker. Note: The Accessibility Checker inspects your presentation for all issues that can be fixed in the browser. For a complete inspection, open your presentation in the desktop app and use the desktop Accessibility Checker for Windows or Mac.
The following procedures describe how to add alt text to images and tables in your PowerPoint for the web presentations. The following procedures describe how to make the hyperlinks and tables in your PowerPoint for the web presentations accessible. Select the text to which you want to add the hyperlink, right-click, and select Link. The text you selected displays in the Display text box. In the Display text box, edit the text you want to appear for the hyperlink.
The following procedures describe how to make the slides in your PowerPoint for the web presentations accessible. Use one of the included accessible themes and templates to make sure that your slide design, colors, contrast, and fonts are accessible for all audiences. In your browser, go to Accessible PowerPoint template sampler. On the Accessible PowerPoint template page, select Download. The template sampler is downloaded to your device.
Open PowerPoint for the web in your browser, open the selected design, and create your presentation. In the Slide Layout dialog box, select a slide layout that includes title placeholders, and then select Change Layout.
The new layout is applied to the slides. In the PowerPoint desktop version, you can use the Selection pane to turn visibility on or off for titles and other objects on a slide. Improve accessibility with the Accessibility Checker.
Microsoft wants to provide the best possible experience for all our customers. If you have a disability or questions related to accessibility, please contact the Microsoft Disability Answer Desk for technical assistance. The Disability Answer Desk support team is trained in using many popular assistive technologies and can offer assistance in English, Spanish, French, and American Sign Language. Please go to the Microsoft Disability Answer Desk site to find out the contact details for your region.
If you are a government, commercial, or enterprise user, please contact the enterprise Disability Answer Desk. Office Accessibility. Make your PowerPoint presentations accessible to people with disabilities. In this topic 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 Best practices for making PowerPoint presentations accessible The following table includes key best practices for creating PowerPoint presentations that are accessible to people with disabilities.
What to fix How to find it Why fix it How to fix it Include alternative text with all visuals. Add alt text to visuals Make sure slide contents can be read in the order that you intend.
Try navigating your slides with a screen reader. Set the reading order of slide contents Use built-in slide designs for inclusive reading order, colors, and more Add meaningful and accurate hyperlink text and ScreenTips. Tips: In the Alt Text pane, spelling errors are marked with a red squiggly line under the word. Mac: Best practices for making PowerPoint presentations accessible The following table includes key best practices for creating PowerPoint presentations that are accessible to people with disabilities.
Add alt text to visuals in Microsoft Add alt text to visuals in Office Add alt text to visuals in Office Make sure slide contents can be read in the order that you intend. Set the reading order of slide contents When creating a new slide, use the built-in slide designs.
Use built-in slide designs for inclusive reading order Add meaningful hyperlink text and ScreenTips. Notes: For audio and video content, in addition to alt text, include closed captioning for people who are deaf or have limited hearing.
What to fix Why fix it How to fix it Include alternative text with all visuals and tables. Visual content includes pictures, shapes, charts, embedded objects, ink, and videos. Add alt text to images, tables, and shapes Ensure that color is not the only means of conveying information. Use an accessible slide design Use sufficient contrast for text and background colors. Use an accessible slide design Use a simple table structure for data only, and specify column header information.
Use table headers Use a larger font size 18pt or larger , sans serif fonts, and sufficient white space. Use an accessible slide design Format text for accessibility Make videos accessible to visually impaired and hearing-impaired users Subtitles typically contain a transcription or translation of the dialogue.
Select the element, for example, an image. Mark visuals as decorative If your visuals are purely decorative and add visual interest but aren't informative, you can mark them as such without needing to write any alt text.
Select the visual, for example, a picture or chart. Select Alt Text. Use an accessible slide design Use one of the included slide Themes to make sure that your slide design is accessible. Select a slide. Tap Themes and then select the theme you want. Use table headers Position the cursor anywhere in a table. Tap Style Options and then select Header Row.
Microsoft excel 2016 step by step pdf free. Microsoft Excel 2016 Step By Step
No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.
First Printing Microsoft Press books are available through booksellers and distributors worldwide. If you need support related to this book, email Microsoft Press Support at mspinput microsoft. The views, opinions and information expressed in this book, including URL and microsoft excel 2016 step by step pdf free Internet website references, may change without notice. Some examples depicted herein are provided for illustration only and are fictitious.
No real association or connection is intended or should be inferred. All other marks are property of their respective owners. Tell us what you think of this book and help Microsoft что adobe after effects cc 3d text free извиняюсь our products for you. Thank you! This Step by Step book has been designed so you can read it from the beginning to learn about Microsoft Excel and then build your skills as you learn to perform increasingly specialized procedures.
Or, if you prefer, you can jump in wherever you need microsoft excel 2016 step by step pdf free guidance for performing tasks. The how-to steps are delivered crisply and concisely —just the facts. Who this book is for Microsoft Excel Step by Step is designed for use as a learning and reference resource by home and business users of Microsoft Office apps who want to use Microsoft excel 2016 step by step pdf free to manage their data, create useful analyses and visualizations, and discover insights into their operations by using the rich business microsoft excel 2016 step by step pdf free analysis tools found in Excel.
The content of the book is designed to be useful for people who have previously used earlier versions of Excel and microsoft excel 2016 step by step pdf free people who are discovering Excel for the first time.
Each part is divided into chapters representing skill set areas, and each chapter is microsoft excel 2016 step by step pdf free into topics that group related skills. Each topic includes expository information followed by generic procedures. Follow the instructions on the webpage. You should install that app before working through the procedures and practice tasks in this book. You can open the files that are supplied for the practice tasks and save the finished versions of each file.
If you later want to repeat practice tasks, you can download the original practice files again. The following table lists the practice files for this book. If your settings are different, the ribbon on your screen might not look the same as the one shown in this book. As a result, exercise instructions that involve the ribbon might require a little adaptation. Simple procedural instructions use this format: 1. On the Insert tab, in the Illustrations group, click the Chart button.
If the command is in a list, our instructions use this format: 1. First click the specified tab, and then locate microsoft excel 2016 step by step pdf free specified group. Multistep procedural instructions use this format: 1. To select the paragraph that you want to format in columns, triple-click the paragraph. On the Layout tab, in the Page Setup group, click the Columns button to display a menu of column layout options. On the Columns menu, click Three.
On subsequent instances of instructions that require microsoft excel 2016 step by step pdf free to follow the same process, the instructions might подробнее на этой странице simplified in this format because the working location has already been established: 1.
Select the paragraph that you want to format in columns. Instructions in this book refer to Excel user interface elements that you click or tap on the screen as buttons, and to physical buttons that you press on a keyboard as keys, to conform to the standard terminology used in documentation for these products.
When the instructions tell you to enter information, you can do so by typing on a connected external keyboard, tapping an on-screen keyboard, or even speaking aloud, depending on your computer setup and your personal preferences. Get support and give feedback This topic provides information about getting help with this book and contacting us to provide feedback or report errors.
If you need to contact the Microsoft Press Support team, please send an email message to mspinput microsoft. We want to hear from you At Microsoft Press, your satisfaction is our top priority, and your feedback our most valuable asset.
The посетить страницу is short, and we read every one of your comments and ideas. Thanks in advance for your input! Set up a workbook. In this chapter Explore the editions of Excel Become familiar with new features in Excel Create workbooks Modify workbooks Modify worksheets Merge and unmerge cells Customize the Excel app window. For practice file download instructions, see the introduction.
When you microsoft excel 2016 step by step pdf free a new Excel workbook, the app presents a blank workbook that contains one worksheet. You can add or delete worksheets, hide worksheets within the workbook without deleting them, and change the order of your worksheets within the workbook. You can also copy a worksheet to another workbook or move the worksheet without leaving a copy of the worksheet in the first workbook. If you and your colleagues work with a large number of documents, you can define property values to make your workbooks easier to find when you and your colleagues attempt to locate them by using the Windows search box.
Another way to make Excel easier to use is by customizing the Excel app window to fit your work style. If you use a set of commands frequently, you can create a custom ribbon tab so they appear in one place. You can also hide, display, or change the order of the tabs on the ribbon. This chapter guides you through procedures related to creating and modifying workbooks, creating and modifying worksheets, merging and unmerging cells, and customizing the Excel app window.
Explore the editions of Excel The Microsoft Office suite includes apps that give you the ability to create and manage every type of file you need to work effectively at home, business, or school.
You can purchase the apps as part of a package that includes multiple apps or purchase most of the apps individually. That flexibility extends well beyond your personal computer. In addition to the traditional desktop edition of Excel, you can also use Excel Online in combination with Microsoft OneDrive formerly called SkyDrive. Excel The desktop version of Excel is installed directly on your computer.
The desktop version of the app includes all of the capabilities built microsoft excel 2016 step by step pdf free Excel You can purchase Excel as part of an Office app suite, as a separate app, or as part of the Office subscription package that lets you install the desktop versions of Office apps for both PCs and Macs over the Internet. Tip Office is a cloud-based subscription licensing solution. There are Office subscription levels that provide access to the full version of ExcelExcel Online, or both.
Office Online is available /43540.txt part of an Office subscription or for free as ссылка of the OneDrive cloud service. Excel Online displays your Excel and later files as they appear in the desktop version of the app and includes all of the functions you use to summarize your data.
You can also view and manipulate PivotTables, add charts, and format your data to communicate its meaning clearly. You can also use Excel Online to share your workbooks online, embed them as part of another webpage, and create web-accessible surveys that save user responses directly to an Excel workbook in your OneDrive account.
After you open a file by using Excel Online, you can choose to continue editing the file in your browser or open the file in the desktop app. When you open the file in your desktop app, any changes you save are written to the version of the file on your OneDrive account. This practice means that you will always have access to the most recent version of your file, regardless of where and how you access it. Excel Mobile Apps In addition to providing versions of Excel for your PC, Mac, or for use online, Microsoft also maintains versions of Excel for many mobile platforms.
If you own a Windows-based tablet, you can take advantage of the Office apps, all of which require Windows 7 or later. If you own an Android device, Office for Android can be installed on tablets and phones that are running Android Адрес страницы 4.
Become familiar with new features in Excel Excel includes all of the most useful capabilities included in previous versions of the app. If you want to search for instructions on how to perform an action, enter what you want to do in the new Tell Me box on the ribbon and press the Enter key to get the information you need. New chart types Excel introduces six new types of charts: waterfall, histogram, Pareto, box-and-whisker, treemap, and sunburst.
Each of these new chart types enhances your ability to summarize your data and convey meaningful information about your business. Slicer multi-select Slicers provide a visual reference to filters you have applied to Excel tables and PivotTables. In Excelyou had to use the Ctrl and Shift keys to select multiple values.
In Excelyou can click the Multi-Select button on the Slicer title bar to enable multiple selections without using the Ctrl or Shift key when you make your selections. Math entry In ExcelWordand PowerPointyou can now enter a mathematical formula into a file by using a stylus or a finger on a touch-sensitive microsoft excel 2016 step by step pdf free. Entering mathematical notation directly supplements the built-in Equation Editor and could save you significant time. Insights for Office Insights help you learn more about your content through sources such as Bing Snapshot, Wikipedia, Bing image search, and the Oxford dictionary.
The default new workbook in Excel has one worksheet, although you can add more worksheets if you want. When you start Excel, Excel посмотреть больше the Start screen.
Create new workbooks from the Start screen You can click one of the built-in templates available in Excel or create a blank workbook. After you start entering workbook values, you can save your work. When you save a file, you overwrite the previous copy of the file. If you have made changes that you want to save, but you also want to keep a copy of the file as it was microsoft excel 2016 step by step pdf free you saved it previously, you can save your file under a new name or in a new folder.
Tip To open the Save As dialog box by using a keyboard shortcut, press F You also can use the controls in the Save As dialog box to specify a different format for the new file and a different location in which to save the new version of the file. For example, if you work with a colleague who requires data saved in the Excel file format, you can save a file in that format from within the Save As dialog box. If you want to work with a file you created previously, you can open it by displaying the Open page of the Backstage view.
After you create a file, you can add information to make the file easier to find when you use the Windows search box to search for it. Each category of information, or property, stores specific information about your file. You can also edit your properties or delete any you no longer want to use. To create a new workbook 1. To save a workbook under a new name or in a new location 1. Display the Backstage view, and then click Save As.
On the Save As page of the Backstage view, click the folder where you want to save the workbook. In the Save As dialog box, in the File name box, enter a new name for the workbook. Save a new version of your file by using the Save As dialog box 4.
Comments
Post a Comment