Microsoft office 2016 in practice pdf free free download. Use Word, Excel, PowerPoint and more for free with Office on the web

Looking for:

Microsoft office 2016 in practice pdf free free download

Click here to Download

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Gupta PDF Kindle. Busch PDF Kindle. Krotzsch PDF Kindle. Wieringa PDF Kindle. Designing E-Business Systems. Levine PDF. Ramakrishnan PDF. Download GO! Download Handbook of Formal Languages: Volume 2. Cormen PDF. NET Framework 3. Download Microsoft?? SQL Servera??? Applications, incl. Free Digital signal processing receivers for dynamic optical networks: DSP techniques for physical layer impairment mitigation in OOK optical packet networks by Jos??

Free From the architecture of the Internet to the spreading of an epidemic: An inspection of complex networks with the eyes of a statistical physicist by Thomas Petermann PDF Download. Brooks PDF Download. Scott, Zimmerman, Beverly B. Guah PDF Online. Windows Servera??? Shelly PDF Online. Stanek PDF Kindle. Adamski PDF Online. Ray-Chaudhuri on the occasion of his 65th birthday. The Ohio State University Research Institute Publications Download.

The Office roadmap takes you through the process of buying a subscription key, installing and managing It also includes leaning steps for some of the extra apps bundled with Skype, OneDrive, Both the consumer and business versions.

It includes an introduction to the interface, and covers the various aspects of creating, formatting, editing, saving, and printing a document.

PDF file. Sali Kaceli Jan 9, A comprehensive tutorial on using Word , whether you are a student, a business user or in a corporate environment. Learn Microsoft Word in just a couple hours from the basics to the advanced features such as mail merges to recharge your career and resume. For more info. The concepts covered here apply also to previous versions of Word such as Word , and This should keep you busy for a while.

Was this reply helpful? Yes No. Sorry this didn’t help. Thanks for your feedback. Choose where you want to search below Search Search the Community. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question

 
 

PDF Microsoft Office In Practice Download – PetrosBaptis.Free Microsoft Office Online | Word, Excel, PowerPoint

 
Microsoft Office In Practice offers a fresh approach to teaching today’s students Irresistible content for immovable prospects. MS Office instructs me to “Before you can complete the practice tasks I suggest to try saving the PDF download file by clicking on Download under. Microsoft Office In Practice [Nordell, Randy] on replace.me *FREE* shipping on qualifying offers. Microsoft Office In Practice.

 

PDF Download Microsoft Office In Practice Free.How and where can you downloat the practice files for Office ? – Microsoft Community

 

There’s also live online events, interactive content, certification prep materials, and more. The quick way to get started with Microsoft Office !

This is learning made easy. Jump in wherever you need answers–brisk lessons and colorful screenshots microsoft office 2016 in practice pdf free free download you exactly what to do, step by step. Many people think leadership is a higher calling that resides exclusively with managers who practice microsoft office 2016 in practice pdf free free download ….

Now in full color! The quick way to learn Microsoft Excel ! This office learning made …. На этой странице Microsoft Excel —from the inside out! Dive into Microsoft Excel —and really put your spreadsheet …. The complete guide http://replace.me/10092.txt Excel Whether you are just starting out or an Excel novice, windows 10 home upgrade license key free download. Skip to main content.

Start your free trial. Microsoft Office Step by Step by. Book description Now in full color! Covers Word, Excel, PowerPoint and Outlook Format documents for visual impact Quickly prepare personalized email messages and labels Microsort powerful workbooks for analysis and reporting Analyze alternative data sets with Dkwnload Analysis Lens, Goal Seek, and Microsoft office 2016 in practice pdf free free download Prepare highly effective presentations Strengthen your presentations by adding mivrosoft and graphics Organize your email, scheduling, and contacts Look up just the tasks and lessons you need Show and hide more.

Table of contents Donwload information. Create and downllad files Create files Open and pdg around in files Display different views feee files Display and edit file properties Save and close files Skills review Practice tasks Create files Open and move around in files Display different views of files Display and edit file properties Offive and close files Part mkcrosoft Microsoft Word 3. Modify the structure and appearance of text Apply paragraph formatting Configure alignment Перейти vertical spacing Configure indents Structure content manually Apply character formatting Create and modify lists Apply built-in styles frse text Apply styles Manage outline levels Change the document theme Skills review Practice tasks Apply paragraph formatting Structure content manually Apply character formatting Create and practicf lists Windows 10 bootable free built-in styles to text Change the document theme 4.

Collaborate on documents Mark up documents Insert comments Track changes Display and review document markup Display markup Microsoft office 2016 in practice pdf free free download and respond to comments Review and process tracked changes Compare and merge documents Compare and combine separate copies of a document Compare separate versions of a document Control content changes Restrict actions Restrict access by using a password Coauthor documents Skills review Practice tasks Mark up microsogt Display and review document markup Compare and merge documents Control content changes Coauthor documents 5.

Merge data with documents and labels Understand the mail merge process Start the mail merge process Get started with letters Get started with labels Get started with email messages Choose and refine the data microsoft office 2016 in practice pdf free free download Select an existing data source Create a new data source Refine the data source records Insert merge fields Preview and complete the merge Create individual envelopes and labels Generate individual envelopes Generate individual mailing labels Skills review Practice tasks Understand the mail merge process Start the mail merge process Choose and refine the data source Insert по этой ссылке fields Preview and complete practiec merge Create individual envelopes and labels Part 3: Microsoft Excel 6.

Perform calculations on data Name groups of data Define Excel tables Create formulas to rree values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations Skills review Practice tasks Name groups of data Create formulas to calculate values Define Excel tables Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations 7.

Manage worksheet data Limit data that appears on your screen Manipulate worksheet data Summarize data in worksheets that have hidden and filtered rows Find unique values within a data set Define valid sets of values for ranges of cells Skills review Practice tasks Limit data that appears on your screen Manipulate worksheet data Define valid sets of kn for ranges of cells 8.

Micosoft and summarize data Sort worksheet data Sort data by using custom lists Organize data into levels Practce up information in a worksheet Skills review Practice tasks Sort worksheet data Sort data by using custom lists Organize data into levels Look up information in a worksheet 9. Analyze alternative data sets Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Fred microsoft office 2016 in practice pdf free free download solutions by using Solver Analyze data by using descriptive statistics Skills review Practice tasks Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Find optimal solutions by using Solver Analyze data by downlad descriptive statistics Part 4: Microsoft PowerPoint Create and manage slides Add and remove slides Insert new slides Copy and import slides and content Hide and delete slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds Skills review Practice tasks Add and remove slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds Insert and manage simple graphics Insert, move, and resize pictures Edit and format pictures Draw and modify shapes Draw and add text to shapes Move and modify shapes Format shapes Capture and insert screen clippings Create a photo album Skills review Practice tasks Insert, move, and micfosoft pictures Edit and format pictures Draw and modify shapes Capture and insert screen clippings Create a photo album Add sound and movement to slides Animate text and pictures on slides Customize animation effects Add audio content to slides Add video content to slides Compress media to decrease file size Skills review Practice tasks Animate text and pictures on slides Customize animation effects Add audio content microsoft office 2016 in practice pdf free free download slides Add video content to адрес Compress media to decrease file size Part 5: Microsoft Outlook Send and receive email messages Create and send messages Create messages Troubleshoot message addressing Save and send messages Attach files and Outlook items to messages Display messages and message attachments Microsoft office 2016 in practice pdf free free download message content Display attachment content Display message participant information Respond to messages Skills review Practice tasks Create and send messages Attach files and Outlook items to messages Odf messages and message attachments Display message participant information Respond to messages Organize your Inbox Display and manage conversations Arrange messages by specific attributes Categorize items Organize messages in folders Skills review Practice tasks Display and manage conversations Arrange messages by specific attributes Categorize items Organize messages in folders Manage scheduling Schedule appointments and events Convert calendar items Configure calendar item options Schedule and change pcf Respond to meeting requests Display different views of a calendar Skills review Practice tasks Schedule appointments and events Convert calendar items Configure calendar item options Schedule and change meetings Respond to meeting requests Display different views of a calendar Index About the authors Acknowledgments Ptactice Show and hide more.

Get it now.

 
 

Microsoft Office In Practice by Randy Nordell.[txt] Microsoft Office In Practice

 
 

Size : Excel – Accessibility. Description : This document has been developed to provide you with information about accessibility in Microsoft Office Excel Introduction to OneNote for Mac.

Excel Linking Worksheets. Excel Printing and Setup. Excel Charts and Graphs. Excel Formatting Beyond the Basics. Excel – Introduction to Charts.

Excel Basics Math and Functions. Excel Large Data vLookups. It is available as part of the Office suite of apps, as a freestanding app, or as part of an Office subscription. Until recently, the standard way of acquiring Office software was to purchase a disc, packaged in a box, and install the software from the disc. In the recent past, the standard distribution model has changed to an online installation, often as part of an Office subscription licensing package. Office , which was originally available only to businesses, now has many subscription options designed for individual home and business users, students, households, small businesses, midsize businesses, enterprises, government agencies, academic institutions, and nonprofits; in other words, whatever your needs may be, there is an Office subscription option that will be a close fit.

Many of the Office subscription options include licens- ing for the desktop Office apps and permit users to run Office on multiple devices, including Windows computers, Mac computers, Windows tablets, Android tablets, iPads, and smartphones. You can review and edit presen- tations in PowerPoint Online, which runs directly in your browser instead of on your computer.

PowerPoint Online displays the contents of a presentation very much like the desktop app does, and offers a limited subset of the commands and content formatting options that are available in the full desktop app. Com- mands for tasks you perform often are readily available, and even those you might use infrequently are easy to find.

Title bar At the top of the app window, this bar displays the name of the active file, identifies the app, and provides tools for managing the app window, ribbon, and content. The title bar elements are always on the left end, in the center, and on the right end of the title bar The Quick Access Toolbar at the left end of the title bar can be customized to include any commands that you want to have easily available.

You can change the location of the Quick Access Toolbar and customize it to include any command to which you want to have easy access. TIP You might find that you work more efficiently if you organize the commands you use frequently on the Quick Access Toolbar and then display it below the ribbon, directly above the workspace. Your ribbon might display additional tabs TIP The available ribbon tabs and the appearance of the commands on the ribbon might differ from what is shown in this book, based on the apps that are installed on your computer, the PowerPoint settings and window size, and the screen settings.

Across the top of the ribbon is a set of tabs. Clicking a tab displays an associated set of commands arranged in groups. Commands related to managing PowerPoint and presentations rather than presen- tation content are gathered together in the Backstage view, which you display by clicking the File tab located at the left end of the ribbon. Commands available in the Backstage view are organized on named pages, which you display by clicking the page tabs in the colored left pane.

You redisplay the presentation and the ribbon by clicking the Back arrow located above the page tabs. The Home tab, which is active by default, con- tains the most frequently used commands. When a graphic element such as a picture, table, or chart is selected on a slide, one or more tool tabs might appear at the right end of the ribbon to make commands related to that specific object easily accessible. Tool tabs are available only when the relevant object is selected.

TIP Some older commands no longer appear as buttons on the ribbon but are still available in the app. You can make these commands available by adding them to the Quick Access Toolbar or the ribbon. You can point to any button to display a ScreenTip that contains the command name, a description of its function, and its keyboard shortcut if it has one. To determine whether a button and its arrow are integrated, point to the button to activate it. If both the button and its arrow are shaded, clicking the button displays options for refining the action of the button.

If only the button or arrow is shaded when you point to it, clicking the button carries out its default action or applies the current default formatting. Clicking the arrow and then clicking an action carries out the action. Clicking the arrow and then clicking a formatting option applies the formatting and sets it as the default for the button.

Examples of buttons with separate and integrated arrows When a formatting option has several choices available, they are often displayed in a gallery of images, called thumbnails, that provide a visual representation of each choice. When you point to a thumbnail in a gallery, the Live Preview feature shows you what the active content will look like if you click the thumbnail to apply the asso- ciated formatting.

When a gallery contains more thumbnails than can be shown in the available ribbon space, you can display more content by clicking the scroll arrow or More button located on the right border of the gallery. Tell me what you want to do Entering a term in the Tell Me What You Want To Do box located to the right of the ribbon tabs displays a list of related commands and links to additional resources online.

Or you can press F1 to open the Help window for the cur- rent app. The easy path to help when working in PowerPoint Status bar Across the bottom of the app window, the status bar displays information about the current presentation and provides access to certain PowerPoint functions. Some items, such as Docu- ment Updates Available, appear on the status bar only when that condition is true.

These tools provide you with con- venient methods for changing the display of presentation content. The ribbon is dynamic, meaning that as its width changes, its buttons adapt to the available space.

As a result, a button might be large or small, it might or might not have a label, or it might even change to an entry in a list.

For example, when sufficient horizontal space is available, the buttons on the View tab of the PowerPoint app window are spread out, and you can review the commands available in each group. At pixels wide, most button labels are visible If you decrease the horizontal space available to the ribbon, small button labels disap- pear and entire groups of buttons might hide under one button that represents the entire group.

Clicking the group button displays a list of the commands available in that group. When insufficient horizontal space is available, labels disappear and groups collapse under buttons When the ribbon becomes too narrow to display all the groups, a scroll arrow appears at its right end.

Clicking the scroll arrow displays the hidden groups. The greater the screen resolution, the greater the amount of information that will fit on one screen. Your screen resolution options are dependent on the display adapter installed in your computer, and on your monitor. The greater the number of pixels wide the first number , the greater the number of buttons that can be shown on the ribbon. This is a good way to gain vertical space when working on a smaller screen.

Then you can temporarily redisplay the ribbon to click a button, or permanently redisplay it if you need to click several buttons. The extra space is intended to lessen the possibility of accidentally tapping the wrong button with your finger. To maximize the app window 1. When the pointer touches the top of the screen, the dragged window maximizes.

To change the screen resolution TIP Methods of changing screen resolution vary by operating system, but you should be able to access the settings in Windows 10, Windows 8, and Windows 7 by using these methods.

At the bottom of the Display pane of the Settings window, click the Advanced display settings link. Click or drag to select the screen resolution you want, and then click Apply or OK. Windows displays a preview of the selected screen resolution. If you like the change, click Keep changes in the message box that appears. Near the right end of the title bar, click the Ribbon Display Options button. To display only the ribbon tabs 1. To temporarily redisplay the ribbon 1. Click any tab name to display the tab until you click a command or click away from the ribbon.

To optimize the ribbon for touch interaction 1. To specify the items that appear on the status bar 1. Right-click the status bar to display the Customize Status Bar menu. A check mark indicates each item that is currently enabled. Click to enable or disable a status bar indicator or tool.

The change is effected immediately. The menu remains open to permit multiple selections. When you finish, click away from the menu to close it. Depending on your screen resolution or app window width, the PowerPoint ribbon on your screen might look dif- ferent from that shown in this book. If you turn on Touch mode, the ribbon displays significantly fewer commands than in Mouse mode.

As a result, pro- cedural 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. On the Transitions tab, in the Timing group, click the Sound arrow and then, in the Sound list, click Chime.

First click the specified tab, and then locate the specified group. Multistep procedural instructions use this format: 1. Display the presentation in Normal view. Select the animated object or objects that you want to modify. On the Animations tab, in the Timing group, click the Start arrow to display the list of start timing options.

In the Start list, click After Previous. On subsequent instances of instructions that require you to follow the same process, the instructions might be simplified in this format because the work- ing location has already been established: 1.

In Normal view, select the animated objects that you want to modify. On the Animations tab, in the Start list, click After Previous. Instructions in this book refer to user interface elements that you click or tap on the screen as buttons, and to physical buttons that you press on a key- board as keys, to conform to the standard terminology used in documenta- tion 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. The Account page of the Backstage view in PowerPoint displays information about your installation of PowerPoint and other apps in the Office suite and the resources you connect to. Microsoft account credentials are also used by many non-Microsoft products and websites.

TIP Many apps and websites authenticate transactions by using Microsoft account credentials. Two ways you can personalize the appearance of your PowerPoint app window are by choosing an Office background and an Office theme. The background is a subtle design that appears in the title bar of the app window.

There are 14 backgrounds to choose from, or you can choose to not have a background. TIP The images in this book depict the No Background option to avoid interfering with the display of any user interface elements, and the Colorful theme.

From the Connected Services area of the page, you can connect Office to Facebook, Flickr, and YouTube accounts to access pictures and videos; to SharePoint sites and OneDrive storage locations; and to LinkedIn and Twitter accounts to share presenta- tions. You must already have an account with one of these services to connect Office to it. For example, when inserting a picture onto a slide, you will have the option to insert a locally stored picture or to search online for a picture.

After you connect to your Facebook, SharePoint, and OneDrive accounts, you can also insert pictures stored in those locations. The changes that you make on the Account page apply to all the Office apps installed on all the computers associated with your account. Some of the settings on the Account page are also available in the PowerPoint Options dialog box, which you open from the Backstage view.

This dialog box also contains hundreds of options for controlling the way PowerPoint works. With PowerPoint running, click the File tab to display the Backstage view.

In the left pane of the Backstage view, click Account. To manage your Microsoft account settings 1. Display the Account page of the Backstage view. In the User Information area, click any of the links to begin the selected process. To change the app window background for all Office apps 1. In the Office Background list, point to any background to display a live preview in the app window, and then click the background you want. To change the app window color scheme for all Office apps 1.

To connect to a cloud storage location or social media service 1. At the bottom of the Connected Services area, click Add a service, click the type of service you want to add, and then click the specific service. In the Product Information area, click the Manage Account button to display the sign-in page for your Office management interface. Provide your account credentials and sign in to access your options. To manage Office updates 1.

Click the Update Options button, and then click the action you want to take. You can install available updates from the Backstage view before the automatic installation occurs To open the PowerPoint Options dialog box 1.

In the left pane of the Backstage view, click Options. Start PowerPoint Perform the following tasks: 1. Using the technique that is appropriate for your operating system, start PowerPoint. When the Start screen appears, press the Esc key to create a new blank presentation. Work in the PowerPoint user interface Start PowerPoint, create a new blank presentation, maximize the app window, and then perform the following tasks: 1.

Notice the different levels of detail in the ScreenTips. Change the width of the app window and notice the effect it has on the ribbon. When the window is narrow, locate a group button and click it to display the commands. Maximize the app window.

Hide the ribbon entirely, and notice the change in the app window. Redisplay the ribbon tabs but not the commands. Temporarily display the ribbon commands, and then click away from the ribbon to close it.

Use any of the procedures described in this chapter to permanently redisplay the ribbon tabs and commands. Display the status bar shortcut menu, and identify the tools and statistics that are currently displayed on the status bar. Add any indicators to the status bar that will be useful to you. Keep the presentation open in PowerPoint for use in the next set of practice tasks.

Display the Account page of the Backstage view and review the information that is available there. Expand the Office Background list. Point to each background to display a live preview of it.

Then click the background you want to apply. Apply each of the Office themes, and consider its merits. Then apply the theme you like best. TIP If you apply a theme other than Colorful, your interface colors will be different from the interface shown in the screenshots in this book, but the functionality will be the same. Review the services that Office is currently connected to. Expand the Add a ser- vice menu and point to each of the menu items to display the available services.

Connect to any of these that you want to use. Click the Update Options button and note whether updates are currently avail- able to install. If updates are available, apply them after you finish the practice tasks in this chapter. Review the infor- mation on this page to learn about any new features that interest you. Explore each page of the dialog box. Notice the sections and the settings in each section. Note the settings that apply only to the current file.

Review the settings on the General page, and modify them as necessary to fit the way you work. Then close the dialog box. Close the presentation without saving changes. The sophisticated presentation features of PowerPoint are easy to find and use, so even novice users can work pro- Practice files ductively with PowerPoint after only a brief introduction.

For practice file download ments and Microsoft Excel workbooks, so if you already instructions, see the introduction. Processes that are specific to the creation and management of slides are unique to PowerPoint.

This chapter guides you through procedures related to creating presentations, opening and navigating presen- tations, displaying different views of presentations, dis- playing and editing presentation properties, and saving and closing presentations. Unlike the templates provided for Word and Excel, most PowerPoint templates are design templates that control thematic elements colors, fonts, and graphic effects and slide layouts rather than content templates that provide purpose-specific placeholder content.

Each tem- plate has a corresponding theme, so you can create a presentation based on one template but then entirely change its appearance by applying a different theme. When you start PowerPoint, the app displays a Start screen that gives you options for opening an existing presentation or creating a new one.

The templates can change depending on your use of PowerPoint and the installation of program updates. Creating attractive, functional presentations from scratch can be time-consuming and requires quite a bit of knowledge about PowerPoint. A design template is a blank presentation with a theme already applied to it. Sometimes it includes background graphic elements and specialized slide layouts.

Some templates supply only a title slide and leave it to you to add the other slides you need; other templates supply an example of each of the available slide layouts. These templates provide not only the design elements but also suggestions for content that is appropriate for different types of presentations, such as reports or product launches.

After you download a template, you simply customize the content provided in the template to meet your needs. An important thing to be aware of when you create a presentation in PowerPoint is that you have the choice of two slide aspect ratios, which are referred to slightly inaccurately as slide sizes. The default slide size is Widescreen , which is opti- mized for displays such as those found on many laptop screens and desktop monitors these days.

By default, the slides in presentations you create based on the Blank Presentation tem- plate are set to Widescreen size. Most of the tem- plates are , but you can easily filter the templates to display only those that are formatted specifically for slides. Before you begin adding content to a new presentation, you should consider how the presentation will be viewed and choose the most appropriate slide size. You can change the slide size after you create the slide deck, but doing so might cause graphic ele- ments especially those on master slides to look different, and text and other slide elements to not fit on slides as intended.

To create a new blank presentation 1. Start PowerPoint. When the Start screen appears, press the Esc key. If PowerPoint is already running, click the File tab to display the Backstage view. In the left pane of the Backstage view, click New to display the New page. On the New page of the Backstage view, click the Blank Presentation thumbnail. Display the Backstage view, and then, in the left pane, click New.

On the New page, scroll the pane to view the presentation design templates that were installed with PowerPoint. Click any thumbnail to open a preview window that displays the title slide of the selected design with alternative color schemes and graphic backgrounds.

Each design template has multiple color variants and slide layouts 4. To display only presentation templates that are optimized at the slide size 1. On the New page of the Backstage view, below the Search box, click Display the New page of the Backstage view. Scroll the pane to locate the design you want to use. PowerPoint displays the new presentation in Normal view. The title slide is visible in the Thumbnails pane and in the Slide pane.

Or Below the search box, click one of the suggested searches. You can enter a color as a search term to display templates that feature that color 3. In the Category list, click any category or categories to further filter the templates.

To remove a filter, point to it and then click the X that appears to the right of the category name, or double-click the category name. Scroll the pane to locate a design that fit your needs. Click any thumbnail to preview the design template, and click the More Images arrows to see the content defined as part of the template. Then click the Create button in the preview window to create the presentation.

Or Double-click any thumbnail to create a presentation based on the template. To disable the display of the Start screen 1. On the General page of the dialog box, clear the Show the Start screen when this application starts check box. Close the PowerPoint Options dialog box.

If the presentation you want to open appears on the Start screen, you can open it directly from there. Otherwise, you open presentations from the Open page of the Backstage view. The Open page includes all the locations you’ve linked to from an Office program When a presentation is open, you can move among slides by clicking or tapping ele- ments in several areas of the app window, including the Thumbnails pane in Normal view and the Slide pane in Normal view or Slide Sorter view.

Craft great-looking resumes, newsletters, and documents while inviting others to review and coauthor in real time. Organize your data in familiar spreadsheets and workbooks, with all changes saved automatically. Create modern visuals that turn numbers into valuable insights. Work together in real time knowing that everyone is on the same page. Turn your ideas into compelling presentations using professional-looking templates. Use animations, transitions, photos, and videos to tell one-of-a-kind stories.

Co-author team presentations at the same time, from anywhere. Sign up for free. Modify the structure and appearance of text Apply paragraph formatting Configure alignment Configure vertical spacing Configure indents Structure content manually Apply character formatting Create and modify lists Apply built-in styles to text Apply styles Manage outline levels Change the document theme Skills review Practice tasks Apply paragraph formatting Structure content manually Apply character formatting Create and modify lists Apply built-in styles to text Change the document theme 4.

Collaborate on documents Mark up documents Insert comments Track changes Display and review document markup Display markup Review and respond to comments Review and process tracked changes Compare and merge documents Compare and combine separate copies of a document Compare separate versions of a document Control content changes Restrict actions Restrict access by using a password Coauthor documents Skills review Practice tasks Mark up documents Display and review document markup Compare and merge documents Control content changes Coauthor documents 5.

Merge data with documents and labels Understand the mail merge process Start the mail merge process Get started with letters Get started with labels Get started with email messages Choose and refine the data source Select an existing data source Create a new data source Refine the data source records Insert merge fields Preview and complete the merge Create individual envelopes and labels Generate individual envelopes Generate individual mailing labels Skills review Practice tasks Understand the mail merge process Start the mail merge process Choose and refine the data source Insert merge fields Preview and complete the merge Create individual envelopes and labels Part 3: Microsoft Excel 6.

Perform calculations on data Name groups of data Define Excel tables Create formulas to calculate values Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations Skills review Practice tasks Name groups of data Create formulas to calculate values Define Excel tables Summarize data that meets specific conditions Set iterative calculation options and enable or disable automatic calculation Use array formulas Find and correct errors in calculations 7.

Manage worksheet data Limit data that appears on your screen Manipulate worksheet data Summarize data in worksheets that have hidden and filtered rows Find unique values within a data set Define valid sets of values for ranges of cells Skills review Practice tasks Limit data that appears on your screen Manipulate worksheet data Define valid sets of values for ranges of cells 8. Reorder and summarize data Sort worksheet data Sort data by using custom lists Organize data into levels Look up information in a worksheet Skills review Practice tasks Sort worksheet data Sort data by using custom lists Organize data into levels Look up information in a worksheet 9.

Analyze alternative data sets Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Find optimal solutions by using Solver Analyze data by using descriptive statistics Skills review Practice tasks Examine data by using the Quick Analysis Lens Define an alternative data set Define multiple alternative data sets Analyze data by using data tables Vary your data to get a specific result by using Goal Seek Find optimal solutions by using Solver Analyze data by using descriptive statistics Part 4: Microsoft PowerPoint Create and manage slides Add and remove slides Insert new slides Copy and import slides and content Hide and delete slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds Skills review Practice tasks Add and remove slides Divide presentations into sections Rearrange slides and sections Apply themes Change slide backgrounds