Group items matching

in title, tags, annotations or url

www.office.com/setup Blogs: The following post will document how to setup a Windows 8 desktop for a cloud user for Office 365. I have already installed Windows 8 and created the local account for my test user. I have logged into the Office 365 portal and had the user change his password. The password for Office 365 and the password for the desktop are the same. Login to the desktop www.office.com/setup Click Desktop tile Open Internet Explorer Open the Office 365 Portal Site Login with the user account www.office.com/setup Click the gear icon Click Office 365 Settings www.office.com/setup Click Software www.office.com/setup INSTALL OFFICE Select 32-bit or 64-bit installation of Office Click Install www.office.com/setup Click run on the Office installer www.office.com/setup Click Yes to the UAC www.office.com/setup The installer will start to run www.office.com/setup Minimize Internet Explorer (but keep the page open) Click Next www.office.com/setup Accept or Deny the Office improvement www.office.com/setup Click Sign in www.office.com/setup Enter your Office365 Email account Click Next www.office.com/setup Click Organizational Account www.office.com/setup Enter your Office 365 password Click Sign in www.office.com/setup Click Next www.office.com/setup Select a look for Office Click Next www.office.com/setup The Office installation will finish up www.office.com/setup Completed www.office.com/setup SETUP OUTLOOK Navigate back to the start screen www.office.com/setup Click Outlook 2013 Click Next to add your email account www.office.com/setup Yes (default) Click Next www.office.com/setup Enter your Name, Office 365 email address and password Click Next www.office.com/setup Verify that you get three green checks and you are all setup Click Finish www.office.com/setup Outlook will launch and download any email that you have www.office.com/setup SETUP LYNC

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION This article is provided as a courtesy to our customers to help you configure your Outlook software to work with (mt) Media Temple's hosting solutions. Third-party software can not be supported directly by (mt) Media Temple. If you have further questions about configuring Outlook, please visit http://support.microsoft.com/. TIP: Check out our automated tool for easy email set up! Automatically configure email clients on your PC, Mac, or iOS device with just a few clicks. REQUIREMENTS Before you start, be sure you have these handy: Your domain name: example.com Your email address: username@example.com For more information, please read this article: Creating a POP/IMAP email account. Your email password. CONFIGURE OUTLOOK 2011 Open Outlook 2011. If this is your first time using Outlook 2011, you'll see a welcome banner like the one in Figure 1.Outlook-00.jpg - www.office.com/setup Figure 1: Click image for a larger view. If you are adding another email account to Outlook, from the top menu, click on Tools. Then click on Accounts. See Figure 2.Outlook11-01.jpg - www.office.com/setup Figure 2: Click image for a larger view. Click on the Email Account icon, see Figure 3.Outlook11-02.jpg Figure 3. This window is where you enter your email information, see Figure 4 below. Figure 4: Enter your email account information in this window. Enter Your Name as you want it to appear. Enter your full email address username@example.com in the Email address: field. Select POP3 or IMAP. We recommend IMAP. Learn more about the differences here. Enter your full email address, username@example.com, in the User Name field. Enter your email password in the Password: field. TIP: If you experience any difficulty with the default outgoing SMTP Port 25, you can check the box Override default port and enter 587. We also strongly recommend using SMTP and port 465 with Outlook. For more information, please see: Next, we'll configure your Outgoing s

www.office.com/setup Blogs: I've been installing Office 2013 on a lot of computers lately and I've ran into quite a few problems along the way. From annoying messages like "Sorry we ran into a problem" and "Something went wrong" to slow downloads, hanging at certain percentages during the install, it's been typical Microsoft problems all along the way. If you've been trying to install Office 2013 on Windows 8 or Windows 7 and you're running into issues, I'm going to try and give you as many possible solutions as I could find. If you run into a different issue not mentioned here, feel free to post a comment and let us know. It's also worth noting that you can't install Office 2013 on Windows Vista or Windows XP, it's just not possible. You'll get an error message like: This is not a valid Win32 application or We are sorry, you couldn't install your Office product because you don't have a modern Windows operating system. You need Microsoft windows 7 (or newer) to install this product or The procedure entry point K32GetProcessImageFileNameW could not be located in the dynamic link library KERNERL32.dll Now let's talk about some of the problems that can occur when installing Office 2013 on Windows 7 and Windows 8. FIX "SOMETHING WENT WRONG" OFFICE 2013 You might get this error if a first installation stalled and you ended up starting a second installation over the first one. You might also get this error if the computer restarted for some reason before the installation was finished. In this case, you should go to the Control Panel, click on Microsoft Office 2013 or Microsoft Office 365 and click on Change. Office 2013 change - www.office.com/setup Blogs Depending on your version of Office installed, you should either see an option called Repair or Online Repair. If you have Office 365, you'll see Online Repair and then the Repair option. Office 2013 repair - www.office.com/setup Blogs If, for some reason, this fails or

WWW.OFFICE.COM/SETUP BLOGS: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER. pcw office primary 2 - www.office.com/setup www.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more. Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve. Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged. office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft Microsoft says its new collaborative workflow reflects how people do things now, from study groups

WWW.OFFICE.COM/SETUP BLOGS: START THE SHOW INSTANTLY We've all seen too much of presenter's laptop screens, full of messy icon-strewn desktops or unread emails, as they try to start a PowerPoint presentation. Get right to it by naming the file with a .PPS (or .PPSX) file extension. That's a PowerPoint Show, and a quick double click on it goes right into the slideshow, not PowerPoint editing mode. Click Esc to exit the slideshow. www.office.com/setup Blogs: There comes a time in almost every young (or old) office worker's life where the cubicle must give way to the boardroom, or worse, to the dais. That means speaking in public, and more often than not, that speaking is usually accompanied by slides. Such presentations are ingrained in the public consciousness, from watching big-name CEOs spew speeds-and-feeds about new gadgets, to fascinating TED talks on every topic under the sun. Even teachers in the classroom give lessons in a way the old blackboard could never convey. It's fair to say that the vast majority of those presentations are created using PowerPoint, the presentation tool that's a staple of the Microsoft Office suite. The site SlideNirvana.com estimates that PowerPoint is on at least 1 billion (with a B!) computers worldwide. If even a third of them use the software, that's still the equivalent of the entire population of the United States making slide-based exhibitions. And most of them suck. Perhaps that's not quantifiable, but so many articles are written on that fact-and so many of us live through them-it's hard to argue the (power)point. Likewise, many, many articles and entire books are written on how to make effective presentations. This is not one of those stories. This collection of tips is all about the vagaries of the powerful PowerPoint software itself. It's meant for those with a grasp of the basics and beyond who are looking for that extra little goose to get the most out of the program. We hope with these tricks-some of which wi

www.office.com/setup Blogs: ML Gomes is getting a new PC running Windows 8, and wants to know which version of Microsoft Office is best for her needs Microsoft office - www.office.com/setup Blogs Which version of Microsoft Office is best with Windows 8? Photograph: Justin Sullivan/Getty Images Which version of Microsoft Office should I use on Windows 8? I am buying a new laptop and need to use Outlook. ML Gomes Microsoft usually brings out new versions of Office to match new versions of Windows, and Windows 8 is no exception. The new Office 2013 is designed to work with Windows 8, and both have a similar modern styling that puts the emphasis on your content rather than Microsoft's software. Also, both are designed to work with cloud (online) services, particularly Microsoft's SkyDrive. However, other things have changed now that Microsoft is not a software company but a cloud-based "devices and services company". As chief executive Steve Ballmer said last year, this "impacts how we run the company, how we develop new experiences, and how we take products to market for both consumers and businesses." Under the old system, you could buy a copy of Microsoft Office on DVD, and use it without an internet connection. Under the new system, you buy a Product Key, which is 25 alphanumeric characters long. Entering the code online enables you to download your copy of Office, or activate a free trial version pre-installed on your new PC. FREE OFFICE WEB APPS The good news is that under the new system, most home users don't need to pay anything for Microsoft Office: they can use the free, cloud-based service in the form of Microsoft Office web apps. Sign up for an email address at Outlook.com, and you get free web-based email, a contacts book (People), a calendar, and 7GB of online storage in SkyDrive. (Outlook.com has replaced Hotmail, so you can use a Hotmail address, if you already have one.) Log on, click SkyDrive, and you can create and edit files in the four main Of

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: The new admin center reached general availability one month ago. This was a big milestone in our mission to provide you with a first-class admin experience, with tools that enable you to efficiently manage all aspects of the service. We continue to evolve the admin center. This month, we focused on providing you with additional usage insights, including new usage reports, the preview of the Office 365 adoption content pack in Power BI and more role-based permissions through a new Power BI admin role. Here's a summary of the October updates: NEW USAGE REPORTS STARTING TO ROLL OUT TODAY In March, we launched the new reporting dashboard in the Office 365 admin center that makes it easier for you to efficiently monitor your service, identify issues, plan training and report back on the investment to your management. Today, we are happy to announce four new usage reports for active users, Email clients, Skype for Business clients and Office 365 Groups, that provide you with additional insights about how users in your organization are using and adopting Office 365. Here's a look at each report: Active Users report-Lets you see which of your users actively use one or more of the different Office 365 services. This report is especially helpful for admins to identify users for whom they might want to plan some additional training and communication. Often, after being assigned an Office 365 license, users need a helping hand to get started with the different services. They might not know how to activate the product or how the product can help them to be more productive. The image below shows all users that are licensed for one or more products and the last date they used any of those products. By clicking the Column icon, admins can modify the table to see which license has been assigned to a user, as well as when the license was assigned to the user. admin-center-october-1 - www.office.com/setup Blogs Skype for Business clients used r

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint files are called presentations. Whenever you start a new project in PowerPoint, you'll need to create a new presentation, which can either be blank or from a template. You'll also need to know how to open an existing presentation. Watch the video below to learn more about creating and opening presentations in PowerPoint. TO CREATE A NEW PRESENTATION: When beginning a new project in PowerPoint, you'll often want to start with a new blank presentation. Select the File tab to go to Backstage view. Clicking the File tab - www.office.com/setup Select New on the left side of the window, then click Blank Presentation. Creating a new presentation - www.office.com/setup A new presentation will appear. TO CREATE A NEW PRESENTATION FROM A TEMPLATE: A template is a predesigned presentation you can use to create a new slide show quickly. Templates often include custom formatting and designs, so they can save you a lot of time and effort when starting a new project. Click the File tab to access Backstage view, then select New. You can click a suggested search to find templates or use the search bar to find something more specific. In our example, we'll search for the keyword chalkboard. Searching for templates - www.office.com/setup Select a template to review it. Selecting a template - www.office.com/setup A preview of the template will appear, along with additional information on how the template can be used. Click Create to use the selected template. Creating a new presentation with a template - www.office.com/setup A new presentation will appear with the selected template. It's important to note that not all templates are created by Microsoft. Many are created by third-party providers and even individual users, so some templates may work better than others. TO OPEN AN EXISTING PRESENTATION: In addition to creating new presentations, you'll often need to open a presentation that was previ

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook-either with a blank workbook or a predesigned template-or open an existing workbook. Watch the video below to learn more about creating and opening workbooks in Excel. ABOUT ONEDRIVE Whenever you're opening or saving a workbook, you'll have the option of using your OneDrive, which is the online file storage service included with your Microsoft account. To enable this option, you'll need to sign in to Office. To learn more, visit our lesson on Understanding OneDrive. OneDrive on the Open tab - www.office.com/setup TO CREATE A NEW BLANK WORKBOOK: Select the File tab. Backstage view will appear. Click the File tab to go to the Backstage view. - www.office.com/setup Select New, then click Blank workbook. Click Blank workbook in the New tab. - www.office.com/setup A new blank workbook will appear. TO OPEN AN EXISTING WORKBOOK: In addition to creating new workbooks, you'll often need to open a workbook that was previously saved. To learn more about saving workbooks, visit our lesson on Saving and Sharing Workbooks. Navigate to Backstage view, then click Open. Open in the Backstage view - www.office.com/setup Select Computer, then click Browse. Alternatively, you can choose OneDrive to open files stored on your OneDrive. Browse - www.office.com/setup The Open dialog box will appear. Locate and select your workbook, then click Open. The Open dialog - www.office.com/setup If you've opened the desired workbook recently, you can browse your Recent Workbooks rather than search for the file. Open a recent workbook - www.office.com/setup TO PIN A WORKBOOK: If you frequently work with the same workbook, you can pin it to Backstage view for faster access. Navigate to Backstage view

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Word files are called documents. Whenever you start a new project in Word, you'll need to create a new document, which can either be blank or from a template. You'll also need to know how to open an existing document. Watch the video below to learn more about creating and opening documents in Word. TO CREATE A NEW BLANK DOCUMENT: When beginning a new project in Word, you'll often want to start with a new blank document. Select the File tab to access Backstage view. clicking the File tab - www.office.com/setup Select New, then click Blank document. creating a new blank document - www.office.com/setup A new blank document will appear. TO CREATE A NEW DOCUMENT FROM A TEMPLATE: A template is a predesigned document you can use to create a new document quickly. Templates often include custom formatting and designs, so they can save you a lot of time and effort when starting a new project. Click the File tab to access Backstage view, then select New. Several templates will appear below the Blank document option. You can also use the search bar to find something more specific. In our example, we'll search for a flyer template. searching for a specific template - www.office.com/setup When you find something you like, select a template to preview it. clicking a template to preview it - www.office.com/setup A preview of the template will appear. Click Create to use the selected template. creating a document from a template - www.office.com/setup A new document will appear with the selected template. You can also browse templates by category after performing a search. browsing templates by category - www.office.com/setup TO OPEN AN EXISTING DOCUMENT: In addition to creating new documents, you'll often need to open a document that was previously saved. To learn more about saving documents, visit our lesson on Saving and Sharing Documents. Navigate to Backstage view, then click Open. clicking the Open

Productivity? Sweet www.office.com/setup Blogs: Office 2016 for Mac was a long time coming, but it brings plenty of new features and better feature parity with the Windows version than ever. Microsoft has done a lot to streamline the experience, with a customizable, collapsible Ribbon as well as cross-platform keyboard shortcuts, but with any major Office update, there's bound to be a learning curve. These tips for Word, PowerPoint, Excel, Outlook, and OneNote should come in handy, and if you're stumped about anything specific, let us know in the comments. Office 2016 is available for Office365 subscribers, with a wider release coming in September. Don't forget to save! This is probably our most important tip: Don't forget to save! When Apple introduced Auto Save and Versions into OS X, many Mac users started losing our ingrained habit of hitting Command-S often. Unfortunately, Office 2016 (except for OneNote-more on that in a bit) doesn't take advantage of Auto Save. So don't forget to save often. Versioning is also missing, but on the plus side, fans of Save As will find the command in its rightful place in the File menu. Store your files in OneDrive or SharePoint If you need access to your files from anywhere, Office 2016's built-in OneDrive & SharePoint integration makes cloud storage simple. To save to your OneDrive or SharePoint account, click the Online Locations button in the lower-left corner of a Save dialog box. Choose your existing account from the list, or click the Plus button to add another location. What's the difference? Glad you asked. OneDrive is a consumer product for cloud storage, like iCloud Drive. Aimed more at businesses, SharePoint acts like an intranet, letting teams share and collaborate on files. Office 2016 for Mac: Ribbon - www.office.com/setup See larger image Maximize your workspace The redesigned Ribbon in Office 2016 unifies the look and functionality across all platforms. It also takes up a lot of space, and c

Yana Terukhova is a Product Marketing Manager on the Microsoft Visio team. Visually displaying always up-to-date information on clearly laid out diagrams helps to communicate information effectively. In this post, we will see how to connect data from external sources to a diagram. Linking data to Visio diagrams was first introduced in 2007 and has been overwhelmingly popular. We've improved the functionality since then and the capability has become increasingly more powerful. Associating data with shapes on a diagram does not require any code. There's a simple wizard which guides you through linking your data source to your diagram. Once you've linked data to diagram shapes, apply data graphics to shapes-text, data bars, icons, or color by value conditional formatting-to visually display numerical data. The important point here is that data-linked diagrams are dynamic; the data graphics change when data is refreshed in the source (like Excel).

Inserting images in a word file exemplifies the true meaning of the word document. It helps the document to be more artistic as it includes images and drawings. With the help of images, the word document can be understood in a better way.Whenever we wish to insert a picture/image in a word document, we can copy-paste the image from any directory to the word file but inserting through the conventional method must be preferred. In this article, we'll follow certain steps on how to insert and move a picture from your computer in Microsoft Word 2016: Step 1: Type "word 2016" in the Windows Search Bar located next to the Start icon. Click on the first option provided. insert-picture-office-2016-1-min - www.office.com/setup Step 2: Click on "Insert" tab located at the top left corner of the "Word" window. After clicking, a ribbon toolbar will appear providing numerous options like paging options, tables, illustrations, symbols etc. Click on "Pictures". insert-picture-office-2016-2-min - www.office.com/setup Step 3: After clicking, a window will open on your desktop asking you to insert any picture as per your choice. To select your desired picture, click on it & click on the "Insert" button located at the bottom of the window. You can also select multiple pictures at once. For instance, we have selected "birthday-candles". insert-picture-office-2016-3-min - www.office.com/setup Step 4: Now, the image is placed on the word page. You can reduce/enlarge the size of the image by clicking on the "circle" icon located at all corners of the image. Dragging these icons "towards" & "away" from the image will make it "smaller" & "larger" respectively. You can also rotate the image 360° by using the "rotate" icon located at the top of the image. Click on the icon & drag the cursor in your desired direction to rotate the image. insert-picture-office-2016-4-min - www.office.com/setup Step 4: If you need different

We aim to make SkyDrive the place for all your documents, notes, photos, videos and other files. With the release of Windows 8 and Windows RT back in October, more and more people every day are using SkyDrive for their most important files through the SkyDrive app, as well as through SkyDrive integration in File Explorer. Of course, there are great SkyDrive experiences for Windows devices, but being the place for all your files means we invest a significant amount of effort ensuring you have a great experience across all the devices you want to use. Today, we're excited to release v3.0 of the SkyDrive app for iOS that includes improved photo features, an updated UI, and a number of other new features and enhancements. You can install or update the SkyDrive app for iOS now via iTunes. Here are the updates we've made to v3.0 of the SkyDrive app for iOS: Support for iPhone 5 and iPad Mini Updated app icons and user experience Works better with your photos: Download full resolution photos to your iPhone or iPad Control the size of photos you upload and download Photo metadata is retained when you upload to SkyDrive Opening and saving files to SkyDrive works better with other apps on your iOS devices Many other small changes, bug fixes and performance improvements

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

WWW.OFFICE.COM/SETUP BLOGS: USING THE FORMAT PAINTER IN POWERPOINT AND WORD www.office.com/setup Blogs: Themes can be a great way to make your PowerPoint presentation or Word document look nice, but sometimes you might want to add custom design elements to your project. Custom formatting can be tedious, though, especially when you're doing a lot of it. For instance, take this PowerPoint slide. Let's say you've applied a series of effects to the photo on the left, and now you'd like to do the same to the photo on the right. Screenshot of Microsoft PowerPoint - www.office.com/setup You could try to remember all of the effects applied and apply them to the second photo as well-or you could save some time and use the Format Painter. The Format Painter is a tool in Word and PowerPoint that lets you copy all of the formatting from one object and apply it to another one. Think of it as copying and pasting for formatting. USING THE FORMAT PAINTER Select the object with the formatting you want to copy. Screenshot of Microsoft PowerPoint - www.office.com/setup Click the Format Painter icon. It may be located in a slightly different place, depending on your version of Office, but it always looks like a paintbrush. Screenshot of Microsoft PowerPoint - www.office.com/setup Select the object you want to apply the formatting to. The object will be formatted. Screenshot of Microsoft PowerPoint - www.office.com/setup See? Simple! That was much quicker than applying the individual effects one at a time. If you want, you can even use the Format Painter to apply the formatting to multiple objects. Just double-click the Format Painter icon instead of clicking it once. Screenshot of Microsoft PowerPoint - www.office.com/setup Even though weonly looked at using the Format Painter for photos in PowerPoint, you can use it for anything you can apply formatting to in Word or PowerPoint. This includes text, table cells, and shapes. Once you start using it, you'll be surprised how often

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: After creating a form, you might want to modify its appearance. Formatting your forms can help make your database look consistent and professional. Some formatting changes can even make your forms easier to use. With the formatting tools in Access, you can customize your forms to look exactly the way you want. In this lesson, you will learn how to add command buttons, modify form layouts, add logos and other images, and change form colors and fonts. 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 formatting forms in Access. FORMATTING FORMS Access offers several options that let you make your forms look exactly the way you want. While some of these options-like command buttons-are unique to forms, others may be familiar to you. COMMAND BUTTONS If you want to create a way for users of your form to quickly perform specific actions and tasks, consider adding command buttons. When you create a command button, you specify an action for it to carry out when clicked. By including commands for common tasks right in your form, you're making the form easier to use. Access offers many different types of command buttons, but they can be divided into a few main categories: Record Navigation command buttons, which allow users to move among the records in your database Record Operation command buttons, which let users do things like save and print a record Form Operation command buttons, which allow users to quickly open or close a form, print the current form, and perform other actions Report Operation command buttons, which offer users a quick way to do things like preview or mail a report from the current record TO ADD A COMMAND BUTTON TO A FORM: In Form Layou

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want. In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access. 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 modifying queries. MODIFYING QUERIES Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results. TO MODIFY YOUR QUERY: When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears. Switching to Design View with the View command on the Ribbon - www.office.com/setup In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right. Switching to Design View using the View Icon - www.office.com/setup Once in Desig

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