Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. 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 working with tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 working with forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire

www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 working with forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire order you would also have to look at the

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: As you add more slides to a presentation, it can be difficult to keep everything organized. Fortunately, PowerPoint offers tools to help you organize and prepare your slide show. Optional: Download our practice presentation. Watch the video below to learn more about managing slides in PowerPoint. ABOUT SLIDE VIEWS PowerPoint includes several different slide views, which are all useful for various tasks. The slide view commands are located in the bottom-right of the PowerPoint window. There are four main slide views. The different slide view commands - www.office.com/setup Normal view: This is the default view, where you create and edit slides. You can also move slides in the Slide Navigation pane on the left. Normal View - www.office.com/setup Slide sorter view: In this view, you'll see a thumbnail version of each slide. You can drag and drop slides to reorder them quickly. Slide Sorter - www.office.com/setup Reading view: This view fills the PowerPoint window with a preview of your presentation. It includes easily accessible navigation buttons at the bottom-right. Reading View - www.office.com/setup Slide show view: This is the view you'll use to present to an audience. This command will begin the presentation from the current slide. You can also press F5 on your keyboard to start from the beginning. A menu will appear in the bottom-left corner when you move the mouse. These commands allow you to navigate through the slides and access other features, such as the pen and highlighter. Playing a slide show - www.office.com/setup OUTLINE VIEW Outline view shows your slide text in outline form. This allows you to quickly edit your slide text and view the content of multiple slides at once. You could use this layout to review the organization of your slide show and prepare to deliver your presentation. TO VIEW AN OUTLINE: From the View tab, click the Outline View command. Clicking the Outline V

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: As you add more slides to a presentation, it can be difficult to keep everything organized. Fortunately, PowerPoint offers tools to help you organize and prepare your slide show. Optional: Download our practice presentation. Watch the video below to learn more about managing slides in PowerPoint. ABOUT SLIDE VIEWS PowerPoint includes several different slide views, which are all useful for various tasks. The slide view commands are located in the bottom-right of the PowerPoint window. There are four main slide views. The different slide view commands - www.office.com/setup Normal view: This is the default view, where you create and edit slides. You can also move slides in the Slide Navigation pane on the left. Normal View - www.office.com/setup Slide sorter view: In this view, you'll see a thumbnail version of each slide. You can drag and drop slides to reorder them quickly. Slide Sorter - www.office.com/setup Reading view: This view fills the PowerPoint window with a preview of your presentation. It includes easily accessible navigation buttons at the bottom-right. Reading View - www.office.com/setup Slide show view: This is the view you'll use to present to an audience. This command will begin the presentation from the current slide. You can also press F5 on your keyboard to start from the beginning. A menu will appear in the bottom-left corner when you move the mouse. These commands allow you to navigate through the slides and access other features, such as the pen and highlighter. Playing a slide show - www.office.com/setup OUTLINE VIEW Outline view shows your slide text in outline form. This allows you to quickly edit your slide text and view the content of multiple slides at once. You could use this layout to review the organization of your slide show and prepare to deliver your presentation. TO VIEW AN OUTLINE: From the View tab, click the Outline View command. Clicking the Outline

www.office.com/setup Blogs: Excel 2016 includes a powerful new set of features based on the Power Query technology, which provides fast, easy data gathering and shaping capabilities and can be accessed through the Get & Transform section on the Data ribbon. Today, we are pleased to announce 10 new data transformation and connectivity features that have been requested by customers. These updates are available as part of an Office 365 subscription. If you are an Office 365 subscriber, find out how to get these latest updates. If you have Excel 2010 or Excel 2013, you can take advantage of these updates by downloading the latest Power Query for Excel add-in. Updates include the following new or improved data connectivity and transformation features: Web Connector-UX support for specifying HTTP Request Headers. OData Connector-support for "Select Related Tables" option. Oracle Connector-improved Navigator preview performance. SAP HANA Connector-enhancements to parameter input UX. Query Dependencies view from Query Editor. Query Editor ribbon support for scalar values. Add custom column based on function invocation. Expand & Aggregate columns provide support for "Load More" values. Convert table column to a list-new transformation. Select as you type in drop-down menus. WEB CONNECTOR-UX SUPPORT FOR SPECIFYING HTTP REQUEST HEADERS With this update, we have added support for specifying HTTP Request Headers within the Web connector dialog. Users can specify header name/value pairs from the Advanced mode in this dialog. november-2016-updates-for-get-transform-in-excel-1 - www.office.com/setup ODATA CONNECTOR-SUPPORT FOR "SELECT RELATED TABLES" OPTION In this update, we have added relationship detection support for OData V4 feeds. When connecting to OData V4 feeds, users will be able to use the Select Related Tables button in the Navigator dialog to help you easily select all the tables needed for your reports. november-2016-updates-for-get-

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

www.office.com/setup Blogs: 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 ta

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Every PowerPoint presentation is composed of a series of slides. To begin creating a slide show, you'll need to know the basics of working with slides. You'll need to feel comfortable with tasks such as inserting a new slide, changing the layout of a slide, arranging existing slides, changing the slide view, and adding notes to a slide. Optional: Download our practice presentation. Watch the video below to learn more about slide basics in PowerPoint. UNDERSTANDING SLIDES AND SLIDE LAYOUTS When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you'll need to choose a slide layout that fits your content. Different slide layouts - www.office.com/setup Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content. In the example below, the slide has placeholders for the title and content. A slide with empty placeholders - www.office.com/setup TO INSERT A NEW SLIDE: Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts. From the Home tab, click the bottom half of the New Slide command. Clicking the bottom half of the New Slide command - www.office.com/setup Choose the desired slide layout from the menu that appears. Choosing a slide layout - www.office.com/setup The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart. The new slide - - www.office.com/setup To change the layout of an existing slide, click the Layout command, then choose the desired layout. Applying a new layout to a

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Every PowerPoint presentation is composed of a series of slides. To begin creating a slide show, you'll need to know the basics of working with slides. You'll need to feel comfortable with tasks such as inserting a new slide, changing the layout of a slide, arranging existing slides, changing the slide view, and adding notes to a slide. Optional: Download our practice presentation. Watch the video below to learn more about slide basics in PowerPoint. UNDERSTANDING SLIDES AND SLIDE LAYOUTS When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you'll need to choose a slide layout that fits your content. Different slide layouts - www.office.com/setup Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content. In the example below, the slide has placeholders for the title and content. A slide with empty placeholders - www.office.com/setup TO INSERT A NEW SLIDE: Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts. From the Home tab, click the bottom half of the New Slide command. Clicking the bottom half of the New Slide command - www.office.com/setup Choose the desired slide layout from the menu that appears. Choosing a slide layout - www.office.com/setup The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart. The new slide - - www.office.com/setup To change the layout of an existing slide, click the Layout command, then choose the desired layout. Applying a new layout to a

www.office.com/setup Blogs: Previews of PowerPoint2013 show that it will be easier to create and share professional presentations with a range of new and improved features. 1. NEW RANGE OF DESIGN THEMES Powerpoint 2013 start screen - www.office.com/setup Easier inclusion of videos, or pictures to give a more professional edge to presentations. Easy access to a collection of new themes available via the start screen. The ability to quickly change themes using theme variants. Alignment Guides have been added that make it easier to align text boxes, graphics and shapes with text. Merge Shapes tools -2013 includes Union, Combine, Fragment, Intersect, and Subtract tools making it easier for the user to merge two or more shapes into the shape required. 2. IMPROVEMENTS TO THE PRESENTER'S VIEW AND ORGANISATION OF THE PRESENTATION. The One click Slide Zoom allows the user to zoom in and out on diagram, or chart. The addition of a presenter's Navigation Grid, making it easier for the presenter to switch slides within a sequence using a navigation grid that the audience cannot see. The ability to easily project a presentation on a second screen using Auto-extend. 3. IMPROVED COLLABORATION WITH EASIER SHARING AND CO-AUTHORING. The Reply Comment feature. PowerPoint 2013 makes it easier to add and track comments next to the relevant section of text. Everyone working on the presentation can follow the discussion easily and act on any suggestions. Collaboration and Sharing. With Microsoft's emphasis on improved collaboration, the new default setting means that presentations are saved online to SkyDrive or SharePoint . This allows the author to send a link to the same file to everyone involved, complete with personalised viewing and editing permissions, so that everyone is working on the same version. The PowerPoint Web App Co-authoringfeature via PowerPoint Web. 2013 makes it easier for several people to work on the same presentation at the same time from the desktop or in bro

www.office.com/setup Blogs: Last year, we released Microsoft Bookings to customers in the U.S. and Canada, introducing an easy way for small businesses to schedule and manage appointments with their customers. Today, we are pleased to announce that we're beginning to roll out the service to Office 365 Business Premium subscribers worldwide. Based on your feedback, we are bringing several new features to Bookings: Add your Office 365 calendar to Bookings-Connect your Office 365 calendar to Bookings, so that the times you are busy will automatically be blocked in your public Booking page. Add buffer time before and after your appointments-Do you need prep time before or after an appointment? Adding buffer time to a service automatically blocks that time in your Booking page too. Bookings apps for your iOS and Android phone-Now you can book an appointment, contact a customer or check a staff member's appointments while away from the office. Customize your Booking page-We added more color customization options, so you can better personalize your Booking page. These new capabilities will start showing up automatically in Bookings in the coming weeks. Let's take a detailed look at what's new. ADD YOUR OFFICE 365 CALENDAR TO BOOKINGS One of the top pieces of feedback we've heard is that you want to be able to add events from your Office 365 calendar to Bookings. So, we added integration between these calendars to help you avoid booking customer meetings during the time you've set aside for personal appointments, staff and partner meetings or other aspects of running your business. To add Office 365 calendars to Bookings, click the Staff tab on the left navigation panel. On the Staff details page, select the Events on Office 365 calendar affect availability checkbox. www.office.com/setup Add Office 365 calendar events to Bookings. Once you activate this option, the system automatically blocks busy times on the Bookings calendar and on the self-ser

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

Max Design page that shows how to make a navigation bar with a gradient green color scheme.

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: Whenever you use the Internet, you use hyperlinks to navigate from one webpage to another. If you want to include a web address or email address in your PowerPoint presentation, you can choose to format it as a hyperlink so a person can easily click it. It's also possible to link to files and other slides within a presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting hyperlinks in PowerPoint. ABOUT HYPERLINKS Hyperlinks have two basic parts: the address of the webpage, email address, or other location they are linking to, and the display text (which can also be a picture or a shape). For example, the address could be http://www.youtube.com, and YouTube could be the display text. In some cases, the display text might be the same as the address. When you're creating a hyperlink in PowerPoint, you'll be able to choose both the address and the display text or image. TO INSERT A HYPERLINK: Select the image or text you want to make a hyperlink. Right-click the selected text or image, then click Hyperlink. Alternatively, you can go to the Insert tab and click the Hyperlink command. - www.office.com/setup The Insert Hyperlink dialog box will open. - www.office.com/setup If you selected text, the words will appear in the Text to display field at the top. You can change this text if you want. Type the address you want to link to in the Address field. Click OK. The text or image you selected will now be a hyperlink to the web address. - www.office.com/setup TO INSERT A HYPERLINK TO AN EMAIL ADDRESS: Right-click the selected text or image, then click Hyperlink. The Insert Hyperlink dialog box will open. On the left side of the dialog box, click Email Address. - www.office.com/setup Type the email address you want to connect to in the Email Address box, then click OK. - www.office.com/setup PowerPoint often recognizes email and web addresses as you type and will format them as hyperlin

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: 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 N

www.office.com/setup Blogs: Part 1: Add An Account Go to Microsoft Office 365 Admin Center. From the top menu, click Admin and select Office 365. www.office.com/setup Blogs From the left navigation, go to USERS > Active Users and then click the + button. www.office.com/setup Blogs Specify Delegate Account information, including a temporary password, and then click Create. www.office.com/setup Blogs Note: Licenses automatically assign to the account. Unassign the license (9) because the Delegate Account does not require a license. Record the Delegate Account credentials (username and password). These credentials are also sent to the email address specified in the previous page. www.office.com/setup Blogs Click Close. Click the Delegate Account display name to configure additional settings. www.office.com/setup Blogs From the left navigation, click settings and then assign the Delegate Account the Service administrator role and specify an Alternate email address. www.office.com/setup Blogs Part 2: Assign Specialized Roles To The Delegate Account From the upper right corner of the screen, choose Admin > Exchange to open the Exchange Admin Center. www.office.com/setup Blogs Click permissions and then the + button to create a New Role Group. www.office.com/setup Blogs Type delegation_service as the name of the new role group. www.office.com/setup Blogs Under Roles, click the + button. www.office.com/setup Blogs Add the ApplicationImpersonation and Mailbox Search roles. www.office.com/setup Blogs Under Members, click the + button. www.office.com/setup Blogs Add the newly created Delegate Account. www.office.com/setup Blogs Click Save. Office 365 updates the organization settings. www.office.com/setup Blogs Sign out of Microsoft Office 365. Part 3: Change The Delegate Account Password Sign in to Microsoft Office 365 using the new Delegate Account credentials. www.office.com/setup Blogs Change the temporary Delegate Account password to a permanent one. www.office.com/se

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