Group items tagged

www.office.com/setup Blogs: Whenever you work with Excel, you'll enter information-or content-into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice workbook. Watch the video below to learn more about the basics of working with cells. UNDERSTANDING CELLS Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. cell C5 - www.office.com/setup Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: Cell range A1:A8cell range A1:A8 - www.office.com/setup Cell range A1:F1 cell range A1:F1 - www.office.com/setup Cell range A1:F8 cell range A1:F8 - www.office.com/setup If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how. TO SELECT A CELL: To input or edit cell content, you'll first need to select the cell. Click a cell to select it. In our example, we'll select cell D9. A border will app

www.office.com/setup Blogs: Once your slide show is complete, you'll need to learn how to present it to an audience. PowerPoint offers several tools and features to help make your presentation smooth, engaging, and professional. Optional: Download our practice presentation. Watch the video below to learn more about presenting your slide show. PRESENTING A SLIDE SHOW Before you present your slide show, you'll need to think about the type of equipment that will be available for your presentation. Many presenters use projectors during presentations, so you might want to consider using one as well. This allows you to control and preview slides on one monitor while presenting them to an audience on another screen. TO START A SLIDE SHOW: There are several ways you can begin your presentation: Click the Start From Beginning command on the Quick Access Toolbar, or press the F5 key at the top of your keyboard. The presentation will appear in full-screen mode. clicking the Start From Beginning command on the Quick Access Toolbar - www.office.com/setup Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Switching to Slide Show view from the Status bar in the lower-right corner - www.office.com/setup Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options. starting a presentation from the Slide Show tab - www.office.com/setup TO ADVANCE AND REVERSE SLIDES: You can advance to the next slide by clicking your mouse or pressing the spacebar on your keyboard. Alternatively, you can use or arrow keys on your keyboard to move forward or backward through the presentation. You can also hover your mouse over the bottom-left and click the arrows to move forward or backward. hovering the mouse to access navigation buttons in Slide Show view - www.office.com/setup TO STOP A SLIDE SHOW: You can

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: When you're working with longer presentations, it can be difficult and time consuming to locate a specific word or phrase. PowerPoint can automatically search your presentation using the Find feature, and it allows you to quickly change words or phrases using the Replace feature. Optional: Download our practice presentation. Watch the video below to learn more about the basics of using Find and Replace in PowerPoint. TO FIND TEXT: From the Home tab, click the Find command. www.office.com/setup A dialog box will appear. Enter the text you want to find in the Find what: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. www.office.com/setup You can also access the Find command by pressing Ctrl+F on your keyboard. TO REPLACE TEXT: At times, you may discover that you've repeatedly made a mistake throughout your presentation-such as misspelling someone's name-or that you need to exchange a particular word or phrase for another. You can use the Replace feature to make quick revisions. From the Home tab, click the Replace command. www.office.com/setup A dialog box will appear. Type the text you want to find in the Find what: field. Type the text you want to replace it with in the Replace with: field, then click Find Next. www.office.com/setup If the text is found, it will be selected. Review the text to make sure you want to replace it. If you want to replace it, select one of the replace options. Replace will replace individual instances, and Replace All will replace every instance. In our example, we'll use the Replace option. www.office.com/setup The selected text will be replaced. www.office.com/setup PowerPoint will move to the next instance of the text in the presentation. When you are finished replacing text, click Close to exit the dialog box. When it comes to using Replace All, it's important to remember that it could find matches you didnâ

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: 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: If you're new to PowerPoint, you'll need to learn the basics of working with text. In this lesson, you'll learn how to cut, copy, paste, and format text. Optional: Download our practice presentation. Watch the video below to learn more about the basics of working with text in PowerPoint. TO SELECT TEXT: Before you can move or arrange text, you'll need to select it. Click next to the text you want to select, drag the mouse over the text, then release your mouse. The text will be selected. www.office.com/setup Blogs COPYING AND MOVING TEXT PowerPoint allows you to copy text that is already on a slide and paste it elsewhere, which can save you time. If you want to move text, you can cut and paste or drag and drop the text. TO COPY AND PASTE TEXT: Select the text you want to copy, then click the Copy command on the Home tab. www.office.com/setup Blogs Place the insertion point where you want the text to appear. Click the Paste command on the Home tab. www.office.com/setup Blogs The copied text will appear. TO CUT AND PASTE TEXT: Select the text you want to move, then click the Cut command. www.office.com/setup Blogs Place the insertion point where you want the text to appear, then click the Paste command. www.office.com/setup Blogs The text will appear in the new location. You can access the cut, copy, and paste commands by using keyboard shortcuts. Press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste. TO DRAG AND DROP TEXT: Select the text you want to move, then click and drag the text to the desired location. www.office.com/setup Blogs The text will appear in the new location. www.office.com/setup Blogs FORMATTING AND ALIGNING TEXT Formatted text can draw your audience's attention to specific parts of a presentation and emphasize important information. In PowerPoint, you have several options for adjusting your text, including size and color. You can also adjust the alignment of the

You have 15 minutes of your Senior Manager's time. Your goal: encourage his/her participation on Yammer. What are the three items you would focus on? Sounds like an awesome challenge, doesn't it? This was exactly the challenge that one of our customers Ernst Décsey, Intranet Manager from UNICEF posed in the YCN, Yammer Champion Community. His question was greeted with a flurry of amazing responses, which we just had to share here (with participants' permissions of course!)

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A theme is a predefined combination of colors, fonts, and effects. Different themes also use different slide layouts. You've already been using a theme, even if you didn't know it: the default Office theme. You can choose from a variety of new themes at any time, giving your entire presentation a consistent, professional look. Optional: Download our practice presentation. Watch the video below to learn more about applying themes in PowerPoint. WHAT IS A THEME? In PowerPoint, themes give you a quick and easy way to change the design of your presentation. They control your primary color palette, basic fonts, slide layout, and other important elements. All of the elements of a theme will work well together, which means you won't have to spend as much time formatting your presentation. Each theme uses its own set of slide layouts. These layouts control the way your content is arranged, so the effect can be dramatic. In the examples below, you can see that the placeholders, fonts, and colors are different. The Frame theme and the Integral theme - www.office.com/setup If you use a unique slide layout-such as Quote with Caption or Name Card-and then switch to a theme that does not include that layout, it may give unexpected results. Every PowerPoint theme-including the default Office theme-has its own theme elements. These elements are: Theme Colors: There are 10 theme colors, along with darker and lighter variations, available from every Color menu. Theme Colors - www.office.com/setup Theme Fonts: There are two theme fonts available at the top of the Font menu under Theme Fonts. Theme Fonts - www.office.com/setup Theme Effects: These affect the preset shape styles. You can find shape styles on the Format tab whenever you select a shape or SmartArt graphic. Theme Effects - www.office.com/setup When you switch to a different theme, all of these elements will update to reflect the new them

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: If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database. In this lesson, you will learn how to create, modify, and print reports. 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 creating reports. TO CREATE A REPORT: Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries. Open the table or query you want to use in your report. We want to print a list of cookies we've sold, so we'll open the Cookies Sold query. The Cookies Sold query - www.office.com/setup Select the Create tab on the Ribbon. Locate the Reports group, then click the Report command. Clicking the Report command - www.office.com/setup Access will create a new report based on your object. It's likely that some of your data will be located on the other side of the page break. To fix this, resize your fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit. Resizing fields in the report - www.office.com/setup To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report, then click OK. Saving and naming the report - www.office.com/setup Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you w

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: In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you'll learn how to design and create a multi-table query. 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 how to create a multi-table query (Part 1). Watch the video below to learn more about joins and query criteria (Part 2). DESIGNING A MULTI-TABLE QUERY Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it. A one-table query can be simple enough to make up as you go along, but to build anything more powerful you'll need to plan the query in advance. PLANNING A QUERY When planning a query that uses more than one table, you should go through these four steps: Pinpoint exactly what you want to know. If you could ask your database any question, what would it be? Building a query is more complicated than just asking a question, but knowing precisely what question you want to answer is essential to building a useful query. Identify every type of information you want included in your query results. Which fields contain this information? Locate the fields you want to include in your query. Which tables are they contained in? Determine the criteria the information in each field needs to meet. Think about the question you asked in the first step. Which fields do you need to search for specific information? What information are you looking for? How will you search for it? This process might seem abstract at first, but as we go through the process of planning our own multi-table query you sho

ACCESS 2016: DESIGNING A SIMPLE QUERY MARCH 27, 2017 TRAINING / WWW.OFFICE.COM/SETUP ADMIN LEAVE A COMMENT WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: The real power of a relational database lies in its ability to quickly retrieve and analyze your data by running a query. Queries allow you to pull information from one or more tables based on a set of search conditions you define. In this lesson, you will learn how to create a simple one-table query. 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 designing a simple query in Access. WHAT ARE QUERIES? Queries are a way of searching for and compiling data from one or more tables. Running a query is like asking a detailed question of your database. When you build a query in Access, you are defining specific search conditions to find exactly the data you want. HOW ARE QUERIES USED? Queries are far more powerful than the simple searches or filters you might use to find data within a table. This is because queries can draw their information from multiple tables. For example, while you could use a search in the customers table to find the name of one customer at your business or a filter on the orders table to view only orders placed within the past week, neither would let you view both customers and orders at once. However, you could easily run a query to find the name and phone number of every customer who's made a purchase within the past week. A well-designed query can give information you might not be able to find out just by examining the data in your tables. When you run a query, the results are presented to you in a table, but when you design one you use a different view. This is called Query Design view, and it lets you see how your query is put

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: FREE RESOURCES FOR LEARNING OFFICE FOR MAC www.office.com/setup Blogs: Our Microsoft Office tutorials are some of the most popular courses we offer. These tutorials, however, are designed for those using Office on computers with Microsoft Windows, so perhaps it's no surprise that we frequently hear from learners who want to know why we don't offer tutorials on Office for Mac. While Office for Mac shares a lot of functionality with the Windows version, its interface and design are different enough that we would need to create entirely new courses. Image of Office for Mac 2011 Product Box - www.office.com/setup With our small staff, it would be a real challenge to produce the same kind of detailed tutorials for the Mac-friendly Office we provide for the Windows version. We may consider adding some type of Office for Mac tutorial in the future, but for now we'd like to share a number of excellent-and mostly free!-resources that can help you learn how to use Office for Mac. Office 2016 for Mac is very similar to the Windows version. So if you have Office 2016 for Mac, check out our Office 2016 tutorial. FREE OFFICE FOR MAC TUTORIALS If you're using Office for Mac, the Office for Mac team has provided great series of tutorials and how-to guides to help you get started and even learn advanced skills: If you're just getting started, check out the Office 2016 for Mac Quick Start Guides, which provide an overview of each Office for Mac product. If you're looking for even more, the Office for Mac Blog and YouTube channel provide the latest news and step-by-step videos to guide you through. If you're using an earlier version of Office for Mac, check out the video below from the Office for Mac team on the Word 2011 Interface. Of course, you can also find help on the Microsoft Office for Mac Support page from the Office community and support team. If you need additional support, you might consider purchasing a subscription to Lynda.com to

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

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

Today's post was written by Jacob Guttman, IT Manager, Menchies It's hard to believe it when you look at our rapid growth, but Menchies is still a very young company. We were founded in 2007 with a single store in Valley Village, California. Now, we have more than 300 franchise locations around the world. Maintaining connections between Menchies headquarters, the franchise community, and our guests is critical to our success. In the past, we used hosted services for email, collaboration, and document management. And we used a separate, Java-based application for instant messaging. One of the most persistent challenges I faced was trying to support our company's growth with a set of applications that weren't tightly linked together and that didn't fit the day-to-day work needs of our employees. An increasing number of our employees want to be able to access email and other applications on a range of different devices, including their smartphone or tablet. Ultimately, they want to be able to connect with colleagues and seamlessly move information between applications without having to think much about the underlying technology. When we started looking at moving to a new productivity and collaboration solution, the major factors influencing our decision were ease of use, anywhere access, simplified administration, and cost-effective scalability. As we took a closer look at Microsoft Office 365, it was the obvious choice. And, with help from our partner Cal Net Technology Group, we were able to make the switch to Office 365 quickly and easily. With Office 365, we get online access to all of the capabilities we need-email, calendaring, document management, and unified communications-all rolled into one solution. And it automatically works together with the Microsoft Office tools that our employees use every day. One great example of how Office 365 supports the business needs of Menchies and fits the way our people like to work is through our use of Micro

Small businesses have enough to focus on without having to spend time and energy worrying about email, data storage or backup servers. In fact, most small businesses don't know or understand what a server is. The good news is that in today's technology environment, they don't need to. This is because more small businesses are rapidly moving from outdated technology solutions to Web-based solutions to power their company, also known as "moving to the cloud." By moving to cloud solutions like Office 365, small businesses find they can concentrate their resources on growing their business rather than trying to solve technical issues. Large enterprises typically have entire divisions dedicated to supporting and keeping their IT infrastructure up and running. Even though small businesses don't have this luxury, they can still punch above their weight by choosing the enterprise-grade IT services in Office 365 to help solve their most top-of-mind business challenges.