Group items tagged

www.office.com/setup Blogs: Project 2016 has all the functionality and features you're used to, with some enhancements and the best new features from Office 2016. NOTE: The following feature updates are available to Project Online subscribers. They will first roll out to Office Insider participants. If you have a Project Online subscription, make sure you have the latest version of Office. MARCH 2017 TASK SUMMARY NAME FIELD With long lists of tasks, it can be difficult to know what a task is indented under in the overall project plan. The Task Summary Name field is a read-only field that shows the name of a task's summary task. Adding this field as a column in your Task view can help clarify your project's structure. To add this field, right-click the title of a column (to the right of where you want to add the field), select Insert Column, and then choose Task Summary Name from the drop-down list. Task Summary Name column - www.office.com/setup NOVEMBER 2016 TIMELINE BAR LABELS AND TASK PROGRESS Communicating project progress just got easier! Timeline bars can now be labeled, and task progress is shown right on the tasks themselves, making it simple to quickly illustrate your plan and the work in progress when sharing status. Timeline bars with labels and task progress - www.office.com/setup OCTOBER 2016 IN-APP FEEDBACK Have a comment or suggestion about Microsoft Office? We need your feedback to help us deliver great products. In Project, you can suggest new features, tell us what you like or what's not working by clicking File > Feedback. Click File > Feedback to offer comments or suggestions about Microsoft Project - www.office.com/setup SEPTEMBER 2015 MORE FLEXIBLE TIMELINES With Project 2016, not only can you leverage multiple timelines to illustrate different phases or categories of work, but you can also set the start and end dates for each timeline separately, to paint a clearer overall picture of the work involved. Formatted timeline in Project

www.office.com/setup Blogs: New to Visio? This tutorial will help get you started with Visio 2016. We'll take you through starter diagrams to give you an idea of what diagrams look like. Then we'll take you through the four basic steps to creating your own diagram. START VISIO Click the Start button, type Visio, and then click the Visio icon to open the program. (If Visio is open already, clickFile > New.) LOOK AT THE STARTER DIAGRAMS Before you dig in and start making things yourself, let's show you a couple starter diagrams that Visio has made for you. That way you can get an idea of what diagrams look and feel like in the program. Click Categories. Categories link - www.office.com/setup Click Flowchart. Flowchart category thumbnail - www.office.com/setup Now pay attention to this step: single-click the Basic Flowchart thumbnail. Basic Flowchart thumbnail - www.office.com/setup Let's explain what this dialog is all about. Visio Basic Flowchart thumbnails: 1 blank template, and 3 starter diagrams - www.office.com/setup You choose the blank template when you have some experience with Visio (like after you've made a few practice diagrams). But if you don't have any experience, choose one of the other three starter diagrams. Double-click one of the starter diagram thumbnails. This is a starter diagram. Visio 2016 comes with many starter diagrams to give you ideas and examples. You can customize this starter diagram by typing your own text, adding your own shapes, and so on. Also, take a look at the tips and tricks. These help you work with the diagram. Let's open another starter diagram. Click File > New > Categories > Network. Single-click the Basic Network thumbnail. Basic Network thumbnail - www.office.com/setup Double-click one of the two starter diagram thumbnails. This is just another example of what you can do with Visio. On your own, go to File > New > Categories and explore the various starter diagrams in Visio. Not all diagrams have them, but many of the

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links. design view - www.office.com/setup Select Email table field and under data type options, select Hyperlink. select hyperlink - www.office.com/setup Repeat the procedure for assigning Hyperlink data field for other fields as well. hyperlink other - www.office.com/setup Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data. hyerplinks created - www.office.com/setup Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink. edit hyperlink - www.office.com/setup It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK. edit hyperlink 1] - www.office.com/setup Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted. email open - www.office.co

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. Throughout this tutorial, we will be using a sample database. If you would like to follow along, you'll need to download our Access 2016 sample database. You will need to have Access 2016 installed on your computer in order to open the example. Watch the video below to learn more about the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data. Watch the video below to learn more about Excel. GETTING TO KNOW EXCEL If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface. THE EXCEL INTERFACE When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks. From the Excel Start Screen, locate and select Blank workbook to access the Excel interface. The Excel Start screen - www.office.com/setup Click the buttons in the interactive below to become familiar with the Excel interface. - www.office.com/setup WORKING WITH THE EXCEL ENVIRONMENT The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel. Each tab will have one or more groups. Groups on the ribbon - www.office.com/setup Some groups will have an arrow you can click for more options. Some groups have a menu for more options - www.office.com/setup Click a tab to see more commands. Tabs on the ribbon - www.office.c

www.office.com/setup Blogs: Microsoft Office files are still very common, but if you're more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive-if you know how. On the desktop, you'll need to use the Google Chrome browser and an official Chrome extension to edit Microsoft Office documents, using Google Drive's Office Compatibility Mode (OCM). You can edit them like that, or convert them to Google Docs format, which will provide more features. (Don't worry-even if you convert them to Google Docs format, you can re-download them in Microsoft Office format later). You can also edit Microsoft Office files using the Google Drive app and the Google Docs, Google Sheets, and Google Slides apps on iOS or Android. We'll show you both methods in the guide below. HOW TO WORK WITH MICROSOFT OFFICE FILES ON GOOGLE DRIVE ON A PC OR MAC Let's start with the desktop. If the Office file you want to edit and share is still on your PC's hard drive, you can easily upload it to Google Drive and open it for editing in Chrome using a Chrome extension. Open Chrome, go to the Office Editing for Docs, Sheets & Slides extension page, click "Add to Chrome", and follow the on-screen instructions to install it. 01_adding_extension_to_chrome - www.office.com/setup Blogs Once the extension is installed, drag the Office file onto the Chrome window until you see a copy icon as shown below. For my example throughout this article, I'm going to use a Word/Google Docs file, but the procedure is the same for Excel/Google Sheets files and PowerPoint/Google Slides files. 04_dragging_word_file_onto_chrome - www.office.com/setup The first time you drag an Office file onto the Chrome window, the following dialog box displays. Click "Got it" to close the window. You won't see this dialog box again. 05_office_editing_popup - www.office.com/setup Blogs The Office file is uploaded to your Google Drive account and

www.office.com/setup Blogs: Andy Wolber shows you how to edit Word, Excel, and PowerPoint documents stored on Google Drive from your desktop or mobile device. Office and Drive - www.office.com/setup Many organizations that rely on Google Apps also use Microsoft Office applications. Mass conversion of highly formatted documents, complex spreadsheets, or animated presentations may not always be practical. As a result, people still open and edit Word, Excel, and PowerPoint documents after a move to Google Apps. Microsoft Office files, however, no longer need to be stored on your local computer, server, or even on MIcrosoft's OneDrive. Google Drive stores Microsoft Word, Excel, and PowerPoint files much like any file server. And Google encrypts the files when you upload them to Drive, and it stores the files in an encrypted state, too. Google also offers several ways to edit Microsoft Office files stored on Google Drive. Edit capabilities vary by operating system. Here's a look at the options as of August 2015. EDIT WITH MICROSOFT OFFICE The most full-featured way to edit a Word, Excel, or PowerPoint file stored on Google Drive is with Microsoft Office, of course. People who use Office on Windows may open Office files from Google Drive with a plug-in. Simply install the Google Drive plug-in for Microsoft Office, and Google Drive will display as a file storage location in Word, Excel, and PowerPoint (Figure A). From within your Office app, open a file on Google Drive, make your changes, then save the file back to Google Drive. Figure A Figure A - www.office.com/setup OPEN MICROSOFT OFFICE FILES STORED ON GOOGLE DRIVE WITH A GOOGLE-CREATED PLUG-IN. You can also open an Office file stored on Google Drive from your Chrome browser-on either Windows or a Mac. First, install the Google Drive app for your system. Next, start Chrome and browse to your file on Google Drive (http://drive.google.com). Right-click (or, [Ctrl]+click) on a Word, Excel, or PowerPoint documen

www.office.com/setup Blogs: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -

www.office.com/setup Blogs: Microsoft Office 2016 for Windows has landed and it brings many smart new features, including co-authoring with real-time collaboration, simplified sharing, a great feature search engine called Tell Me, and much more. The Mac version of Office 2016 has actually been around for a few months already. If you have an Office 365 subscription, you can get it now for free and we show you how below.A Microsoft Office 2016 Preview: Smart & Subtle Changes A Microsoft Office 2016 Preview: Smart & Subtle ChangesOffice 2016 for Mac was just released and the Windows version will follow in the fall. We show you the new look and features of the world's most popular productivity suite. Will you upgrade?READ MORE Alternatively, you can buy it at the Microsoft store (different packages available and Microsoft has a guide for installing it) or your local retailer and if you're unsure, we have a guide for what Office suite to get. Note that if you're running Office 2010 on Windows 10, you can get a 50% discount on a one year subscription of Office 365 Home; simply use the Get Office app in Windows 10. Get Office - www.office.com/setup Before you overspend your budget, remember you can get Microsoft Word for free and you can choose from many free alternatives for the entire Microsoft suite.This Is How You Can Get Microsoft Word for Free This Is How You Can Get Microsoft Word for FreeDo you really want the entire Microsoft Office suite? If all you need is Word without the fancy features, Microsoft will give it to you for free. Here is how.READ MORE FIND OUT YOUR VERSION OF OFFICE Unsure whether you have an Office 365 subscription? You can look up your status. Open a file, any Office document, then navigate to File > Account and under you'll see whether you have an Office 365 subscription. Office 2016 Account - www.office.com/setup Here is a complete list of ways to check your version of Office from Microsoft. YOUR UPGRADE WILL BE FINAL Before you

Download prospectuses of universities and colleges across the world. Admission Times has the world largest university database and all the prospectuses are free to download. Admission Times expert advice will help you finding the right course, right university and the right career path. Discover universities across the world and share this page across your friends.

If you have already some knowledge on programming, you perhaps want to find job in some companies. But, when you see that finding a job at the right place is difficult right now, you may desire becoming a trainer to teach computer programming. Now, the foremost question, which may arise in your mind, is- how to become personal trainer.

www.office.com/setup Blogs: If you are still using Microsoft Office 2003, you should be aware that Official support has long ended. If you are using Office 2007, support is due to end in 2 short years. Microsoft Office 2016, the latest Windows-based version of the major technology company's application suite, is scheduled for a release sometime in spring, 2015. However, we already know quite a bit about the product, thanks to a preview and testing program that Microsoft has been running. Here are 6 details to look forward to, ahead of the product's mainstream release: 1. Better Security Microsoft Office 2016 will emphasize the value of better security parameters. In addition to a file-level encryption functionality, new data loss protection tools inside of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint will warn users when they attempt to save confidential files to unsafe locations. Microsoft Outlook will also be more secure, thanks to a multi-factor authentication feature. Similarly, the application suite will have stronger information rights management tools that let you limit what people can do with your documents or emails after you've shared access with them. For example, you can allow access to a certain document to expire after a set period of time, and prevent it from being forwarded. These tools will also stop people from copying and pasting information out of Microsoft Office 2016 applications. 2. Business Intelligence Features Microsoft Excel lives up to its name in Microsoft Office 2016. The latest version of this application features a built-in business intelligence tool called Power Query. This tool can dramatically change the way that you approach your data. Using it, you can quickly combine your own numbers with figures from public databases like Data.gov and Microsoft Azure Marketplace. After doing this, the application has another tool that lets you create detailed visualizations of the combined data. The data analysis tool

www.office.com/setup Blogs: Another tool you can use to connect to a webpage, file, email address, or slide is called an action button. Action buttons are built-in shapes you can add to a presentation and set to link to another slide, play a sound, or perform a similar action. When someone clicks or hovers over the button, the selected action will occur. Action buttons can do many of the same things as hyperlinks. Their easy-to-understand style makes them especially useful for self-running presentations at booths and kiosks. Optional: Download our practice presentation. Watch the video below to learn more about using action buttons in your presentations. INSERTING ACTION BUTTONS You can insert action buttons on one slide at a time, or you can insert an action button that will show up on every slide. The second option can be useful if you want every slide to link back to a specific slide, like the title page or table of contents. TO INSERT AN ACTION BUTTON ON ONE SLIDE: Click the Insert tab. Click the Shapes command in the Illustrations group. A drop-down menu will appear with the action buttons located at the very bottom. - www.office.com/setup Select the desired action button. Insert the button onto the slide by clicking the desired location. The Action Settings dialog box will appear. Select the Mouse Click or Mouse Over tab. Selecting the Mouse Click tab means the action button will perform its action only when clicked. Selecting the Mouse Over tab will make the action button perform its action when you move the mouse over it. - www.office.com/setup In the Action on click section, select Hyperlink to:, then click the drop-down arrow and choose an option from the menu. - www.office.com/setup Check the Play Sound box if you want a sound to play when the action button is clicked. Select a sound from the drop-down menu, or select Other sound to use a sound file on your computer. When you're done, click OK. - www.office.com/setup TO INSERT AN ACTION BUTTON ON A

www.office.com/setup Blogs: PowerPoint allows you to insert a video onto a slide and play it during your presentation. This is a great way to make your presentation more engaging for your audience. You can even edit the video within PowerPoint and customize its appearance. For example, you can trim the video's length, add a fade in, and much more. Optional: Download our practice presentation. Watch the video below to learn more about inserting videos in PowerPoint. TO INSERT A VIDEO FROM A FILE: In our example, we'll insert a video from a file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example video and save it to your computer. From the Insert tab, click the Video drop-down arrow, then select Video on My PC. Inserting a video from a file - www.office.com/setup Locate and select the desired video file, then click Insert. Selecting a video to insert - www.office.com/setup The video will be added to the slide. The inserted video - www.office.com/setup With the Screen Recording feature on the Insert tab, you can create a video of anything you are doing on your computer and insert it into a slide. the Screen Recording button on the Insert tab - www.office.com/setup TO INSERT AN ONLINE VIDEO: Some websites-like YouTube-allow you to embed videos into your slides. An embedded video will still be hosted on its original website, meaning the video itself won't be added to your file. Embedding can be a convenient way to reduce the file size of your presentation, but you'll also need to be connected to the Internet for the video to play. Inserting an online video - www.office.com/setup WORKING WITH VIDEOS TO PREVIEW A VIDEO: Click a video to select it. Click the Play/Pause button below the video. The video will begin playing, and the timeline next to the Play/Pause button will advance. The Play/Pause button and the timeline - www.office.com/setup To jump to a different part of the video, click anywhe

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint allows you to add audio to your presentation. For example, you could add background music to one slide, a sound effect to another, and even record your own narration or commentary. You can then edit the audio to customize it for your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting audio in PowerPoint. TO INSERT AUDIO FROM A FILE: In our example, we'll insert an audio file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example file and save it to your computer (music credit: Something Small (Instrumental) by Minden, CC BY-NC 3.0). From the Insert tab, click the Audio drop-down arrow, then select Audio on My PC. Inserting audio from a file - www.office.com/setup Locate and select the desired audio file, then click Insert. Selecting the desired audio file - www.office.com/setup The audio file will be added to the slide. The inserted audio file - www.office.com/setup RECORDING YOUR OWN AUDIO Sometimes you may want to record audio directly into a presentation. For example, you might want the presentation to include narration. Before you begin, make sure you have a microphone that is compatible with your computer; many computers have built-in microphones or ones that can be plugged in to the computer. TO RECORD AUDIO: From the Insert tab, click the Audio drop-down arrow, then select Record Audio. Clicking Record Audio - www.office.com/setup Type a name for the audio recording if you want. Renaming the audio recording - www.office.com/setup Click the Record button to start recording. Clicking the Record button - www.office.com/setup When you're finished recording, click the Stop button. Clicking the Stop button - www.office.com/setup To preview your recording, click the Play button. Previewing the recording - www.office.com/setup When you're done, click OK. The au

SmartArt allows you to communicate information with graphics instead of just using text. There are a variety of styles to choose from, which you can use to illustrate different types of ideas. Watch the video below to learn more about working with SmartArt. TO INSERT A SMARTART GRAPHIC: Select the slide where you want the SmartArt graphic to appear. From the Insert tab, select the SmartArt command in the Illustrations group. selecting the SmartArt command on the Insert tab - www.office.com/setup A dialog box will appear. Select a category on the left, choose the desired SmartArt graphic, then click OK. choosing a SmartArt graphic - www.office.com/setup The SmartArt graphic will appear on the current slide. the inserted smartart - www.office.com/setup You can also click the Insert a SmartArt Graphic command in a placeholder to add SmartArt. Inserting a SmartArt Graphic from a placeholder - www.office.com/setup TO ADD TEXT TO A SMARTART GRAPHIC: Select the SmartArt graphic. The text pane will appear to the left Enter text next to each bullet in the text pane. The text will appear in the corresponding shape. It will be resized automatically to fit inside the shape. adding text to the SmartArt graphic - www.office.com/setup You can also add text by clicking the desired shape and then typing. This works well if you only need to add text to a few shapes. However, for more complex SmartArt graphics, working in the text pane is often quicker and easier. adding text directly in the shapes of the SmartArt instead of the text pane - www.office.com/setup TO REORDER, ADD, AND DELETE SHAPES: It's easy to add new shapes, change their order, and even delete shapes from your SmartArt graphic. You can do all of this in the text pane, and it's a lot like creating an outline with a multilevel list. For more information on multilevel lists, you may want to review our Lists lesson. To demote a shape, select the desired bullet, then press the Tab key. The bullet will move to the

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson. TO INSERT A CHART: Select the Insert tab, then click the Chart command in the Illustrations group. - www.office.com/setup A dialog box will appear. Select a category from the left pane, an

www.office.com/setup Blogs: Today, we are pleased to announce the availability of Microsoft Forms for our Office 365 Education customers. Forms is the result of direct feedback from educators that they want to have a quizzing function with Office 365 Education. Educators told us they need an easy way to assess student progress on an ongoing basis. They also told us they want an assessment solution that will save them time, help differentiate instruction for all students and provide quiz takers with real-time personalized feedback. We designed Forms to be super easy so that anyone could confidently create a form and easily see results as they come in. Forms lets anyone with an Office 365 Education account create and/or respond to quizzes. What makes Forms unique and so valuable for educators is the automatic grading and in-quiz feedback functionality. Automatic grading does exactly what the name implies and greatly reduces the time spent grading. In-quiz feedback is a feature that lets quiz authors personalize messages depending how a student answers a question. For example, if a student answers a question incorrectly they may get a message, such as: "The answer is incorrect. I suggest you review chapter four as this will be on the final." HOW FORMS WORKS When an instructor wants to assess how well the students understand a given topic, they can quickly author a quiz directly from their desktop or mobile web browser. The instructor simply determines the questions they would like to ask and then chooses an answer type, such as multiple choice, text or a rating. The Forms authors can then send a link or QR code to quiz takers or embed the quiz into a web page, blog or Learning Management System (LMS), and recipients can complete the quiz on phones, tablets or PCs. And with the real-time feedback in Forms, the instructor can very quickly see where the class may need additional instruction or could advance more rapidly. Forms responses can also be exported to Mi

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Access is a database creation and management program. To understand Access, you must first understand databases. In this lesson, you will learn about databases and how they are used. You will familiarize yourself with the differences between data management in Microsoft Access and Microsoft Excel. Finally, you will get a look ahead at the rest of the Access tutorial. Watch the video below to learn more about databases in Access. WHAT IS A DATABASE? A database is a collection of data that is stored in a computer system. Databases allow their users to enter, access, and analyze their data quickly and easily. They're such a useful tool that you see them all the time. Ever waited while a doctor's receptionist entered your personal information into a computer, or watched a store employee use a computer to see whether an item was in stock? If so, then you've seen a database in action. The easiest way to understand a database is to think of it as a collection of lists. Think about one of the databases we mentioned above: the database of patient information at a doctor's office. What lists are contained in a database like this? To start with, there's a list of patients' names. Then there's a list of past appointments, a list with medical history for each patient, a list of contact information, and so on. This is true of all databases, from the simplest to the most complex. For instance, if you like to bake you might decide to keep a database containing the types of cookies you know how to make and the friends you give these cookies to. This is one of the simplest databases imaginable. It contains two lists: a list of your friends, and a list of cookies. An illustration of two lists - www.office.com/setup However, if you were a professional baker, you would have many more lists to keep track of: a list of customers, a list of products sold, a list of prices, a list of orders, and so on.

www.office.com/setup Blogs: Office 2016 isn't just about new Microsoft Word and PowerPoint layouts. The new productivity suite has a ton of amazing new tricks and features that are designed to make your work (and play) a lot easier. If you still think of Office as something you tinkered with to write terms papers back on Windows 95, well you're in for a treat. Download the new Office 2016 and you'll get access to tools that automatically separate important and unimportant emails, connect to your social media accounts to help you plan your weekend, and help you plan group trips and activities. For the business user, there are a ton of new Office features that help you better communicate, collaborate and create. I'll walk you through some of these new features and how you can use them to improve your Office 2016 experience. 1. CLUTTER Our SPAM folders are amazing. They collect emails from retailers and businesses with whom we don't want to have any contact whatsoever. But what about that uncle you just can't stand? Or that annoying coworker who constantly asks you to go to lunch? With Clutter for Outlook, your email usage signals whether or not emails should actually enter your inbox. For example: if you never, ever open your uncle's emails, Clutter will automatically send those incoming messages to a folder where they will land alongside your annoying coworker's lunch requests. You can access this folder anytime and move messages back to the normal old inbox. If you're worried you'll miss something important, don't fret. Clutter sends you a weekly digest that tells you exactly what was hidden. You can then command Clutter to never pull in that type of content again. 2. SKYPE INTEGRATION Office 2016 - www.office.com/setup Office 2016 Microsoft has made cloud document collaboration possible (years and years after Google, but I digress). Now, you and a friend can edit a Microsoft Word document simultaneously without having to save and share the document via emai