Group items tagged

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Indenting text adds structure to your document by allowing you to separate information. Whether you'd like to move a single line or an entire paragraph, you can use the tab selector and the horizontal ruler to set tabs and indents. Optional: Download our practice document. Watch the video below to learn more about how to use indents and tabs in Word. INDENTING TEXT In many types of documents, you may want to indent only the first line of each paragraph. This helps to visually separate paragraphs from one another. - www.office.com/setup It's also possible to indent every line except for the first line, which is known as a hanging indent. - www.office.com/setup TO INDENT USING THE TAB KEY A quick way to indent is to use the Tab key. This will create a first-line indent of 1/2 inch. Place the insertion point at the very beginning of the paragraph you want to indent. - www.office.com/setup Press the Tab key. On the Ruler, you should see the first-line indent marker move to the right by 1/2 inch. The first line of the paragraph will be indented. - www.office.com/setup If you can't see the Ruler, select the View tab, then click the check box next to the Ruler. - www.office.com/setup INDENT MARKERS In some cases, you may want to have more control over indents. Word provides indent markers that allow you to indent paragraphs to the location you want. - www.office.com/setup The indent markers are located to the left of the horizontal ruler, and they provide several indenting options: First-line indent marker adjusts the first-line indent Hanging indent marker adjusts the hanging indent Left indent marker moves both the first-line indent and hanging indent markers at the same time (this will indent all lines in a paragraph) TO INDENT USING THE INDENT MARKERS Place the insertion point anywhere in the paragraph you want to indent, or select one or more paragraphs. - www.office.com/set

www.office.com/setup Blogs: Indenting text adds structure to your document by allowing you to separate information. Whether you'd like to move a single line or an entire paragraph, you can use the tab selector and the horizontal ruler to set tabs and indents. Optional: Download our practice document. Watch the video below to learn more about how to use indents and tabs in Word. INDENTING TEXT In many types of documents, you may want to indent only the first line of each paragraph. This helps to visually separate paragraphs from one another. - www.office.com/setup It's also possible to indent every line except for the first line, which is known as a hanging indent. - www.office.com/setup TO INDENT USING THE TAB KEY A quick way to indent is to use the Tab key. This will create a first-line indent of 1/2 inch. Place the insertion point at the very beginning of the paragraph you want to indent. - www.office.com/setup Press the Tab key. On the Ruler, you should see the first-line indent marker move to the right by 1/2 inch. The first line of the paragraph will be indented. - www.office.com/setup If you can't see the Ruler, select the View tab, then click the check box next to the Ruler. - www.office.com/setup INDENT MARKERS In some cases, you may want to have more control over indents. Word provides indent markers that allow you to indent paragraphs to the location you want. - www.office.com/setup The indent markers are located to the left of the horizontal ruler, and they provide several indenting options: First-line indent marker adjusts the first-line indent Hanging indent marker adjusts the hanging indent Left indent marker moves both the first-line indent and hanging indent markers at the same time (this will indent all lines in a paragraph) TO INDENT USING THE INDENT MARKERS Place the insertion point anywhere in the paragraph you want to indent, or select one or more paragraphs. - www.office.com/setup Click and drag the desired indent marke

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

www.office.com/setup Blogs: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form. "We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity." And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working. Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore. Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup Office eve

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

www.office.com/setup Blogs: Microsoft Office www.office.com/setup Blogs: Windows 10 has grabbed the attention of social media and customers alike more so because it is a crucial operating system for Microsoft after the debacle of Windows 8 and a not so great reception for Windows 8.1. But, Microsoft has another major product on their cards now, Office, which enhances the Windows productivity of five major products into a system of applications. With Office 2016, Microsoft plans to build from scratch, a mobile and cloud first approach which is customer centric and doesn't only focus on web compared to Office 365 and 2013. Office 2016 has recently been launched on September 22, 2015. www.office.com/setup The Cost factor The first and the most important thing we look at during major software products and updates is the price tag that comes along with it as there are so multiple updates for major software and it is not feasible to go through each and every revision. The all new Office 2016 suite is free for customers on mobile and tablets (conditions apply) and pretty cheap at $145 for "Office Home & Student 2016" and the RRP version of the same is priced at $165, along with subscription version of the suite (Office 365 Personal) at about $70 per year. Built for collaboration Office suite has changed how businesses operate and more focus is laid on connectivity and collaboration of projects. So, the latest offering from Microsoft, Office 2016 is emphasized on collaborations among spread out team members who may never work in the same office environment, but easily enhance productivity by accomplishing a major task that took a week to get it done. Touch centric user interface If you have used the Office for Windows 10, it is quite evident that Microsoft has given a universal app style for the apps and a touch friendly UI which is more familiar to the iPad owners. For instance, in Word, Microsoft lays focus on providing touch friendly controls for ease of

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

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: 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: INTRODUCTION www.office.com/setup Blogs: PowerPoint is a presentation program that allows you to create dynamic slide presentations. These presentations can include animation, narration, images, videos, and much more. In this lesson, you'll learn your way around the PowerPoint environment, including the Ribbon, Quick Access Toolbar, and Backstage view. Watch the video below to learn more about getting started with PowerPoint. GETTING TO KNOW POWERPOINT PowerPoint 2016 is similar to PowerPoint 2013 and PowerPoint 2010. If you've previously used these versions, PowerPoint 2016 should feel familiar. But if you are new to PowerPoint or have more experience with older versions, you should first take some time to become familiar with the PowerPoint 2016 interface. THE POWERPOINT INTERFACE When you open PowerPoint for the first time, the Start Screen will appear. From here, you'll be able to create a new presentation, choose a template, and access your recently edited presentations. From the Start Screen, locate and select Blank Presentation to access the PowerPoint interface. Creating a blank presentation - www.office.com/setup Click the buttons in the interactive below to become familiar with the PowerPoint interface. www.office.com/setup Working with the PowerPoint environment The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in PowerPoint. Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON PowerPoint uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. For example, the Font group on the Home tab contains commands for formatting text in your document. Groups on the Ribbon - www.office.com/setup Some groups also have a small arrow in the bottom-right corner that you can click for even more options. More options in groups - www.office.com/setu

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Word 2016 is a word processing application that allows you to create a variety of documents, including letters, resumes, and more. In this lesson, you'll learn how to navigate the Word interface and become familiar with some of its most important features, such as the Ribbon, Quick Access Toolbar, and Backstage view. Watch the video below to become more familiar with Word 2016. GETTING TO KNOW WORD 2016 Word 2016 is similar to Word 2013 and Word 2010. If you've previously used either version, then Word 2016 should feel familiar. But if you are new to Word or have more experience with older versions, you should first take some time to become familiar with the Word 2016 interface. THE WORD INTERFACE When you open Word for the first time, the Start Screen will appear. From here, you'll be able to create a new document, choose a template, and access your recently edited documents. From the Start Screen, locate and select Blank document to access the Word interface. creating a new blank document - www.office.com/setup Click the buttons in the interactive below to learn more about the Word interface: the Word 2016 interface - www.office.com/setup WORKING WITH THE WORD ENVIRONMENT Like other recent versions, Word 2016 continues to use features like the Ribbon and the Quick Access Toolbar-where you will find commands to perform common tasks in Word-as well as Backstage view. THE RIBBON Word uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, which you can find near the top of the Word window. tabs on the Ribbon - www.office.com/setup Each tab contains several groups of related commands. For example, the Font group on the Home tab contains commands for formatting text in your document. the Font group on the Home tab - www.office.com/setup Some groups also have a small arrow in the bottom-right corner that you can click for even more option

A few weeks ago, preview versions of Microsoft Office products for 2016 were released. The release included Microsoft Office 2016 suite products, plus Project and Visio. All the products are available in desktop and office 365 formats for trials. We shared the links to download/install preview of Microsoft Office and Project 2016 in this post a while ago. Since then, I wanted to write my first hand review of Project 2016, so here it goes. INSTALLATION OF PROJECT 2016 First things first, installation challenges. Prior to installing Microsoft Project 2016 (this is the same for Office 2016) you will need to uninstall the 2013 version of the same product, as they can't both be installed at the same time. It's easy to uninstall and then reinstall a new version, right? Not really. Unfortunately, this isn't as simple as it sounds particularly if you have ever had Microsoft Project 2013 office 365 version installed on your machine along with Project 2013 desktop version. At least in my case, I have tried every possible way of removing 2013 version, but Microsoft Project 2016 kept crashing soon after it started. Here, and may be few other places, described a solution to an issue but it never worked for me and eventually I end up installing to a fresh VM that has no traces of prior version.

In order to be taken seriously, small businesses need to convince customers of their professional ability and their value. Small businesses can punch above their weight by taking the time to go to market with a professional set of business documents, templates and content to ensure customers aren't dismissing them before they have a chance to pitch the value of their product or service. But how can small businesses deliver a professional image when they don't have the same resources as big businesses? Web-based solutions, also known as 'cloud solutions,' help small businesses maintain professional-looking documents even while collaborating and editing with employees in real-time from different locations. Gone are the days where employees hoped documents maintained proper spacing and margins; small businesses can now create materials in confidence and showcase their professional ability to customers. Below are just a few of the ways small businesses can ensure they are maintaining a professional appearance when it comes to the business communications: MAKE THE FIRST IMPRESSION A PROFESSIONAL ONE An email newsletter is often a small business' first connection with a potential customer; they can keep it professional by registering a business email domain (johndoe@yourbusiness.com) and sending all communications to customers and potential customers from there. Most cloud solutions offer a cost-efficient and easy way to customize emails with basic client information - small businesses should take the time to add a personal touch to connect with their customers. Messages should be short and to the point to ensure their email will bring value to potential customers. Email signatures should be simple, clean and professional, and employees shouldn't forget to run a spell-check before hitting send. CREATE CUSTOMER-READY DOCUMENTS Whether creating documents on an office desktop or on-the-go on a mobile or tablet device through Office Mobile Apps in Office 3

Most people know that you can create PowerPoint presentations with pictures, music, images, web content, and text, but one little known trick is the ability to save PowerPoint presentations as videos. PowerPoint presentations have been a long time favorite for use in business and academic presentations all over the world. They are highly versatile and offer a wide variety of features that you can use to enhance them. In order to save your PowerPoint as a video you will first need to create a presentation or download the sample we used for this tutorial. Once you have the document open, you will need to save it as a video. Begin by pressing "File." sshot-1 - www.office.com/setup Instead of following the logical train of thought and opening the "Save" section, you will need to click on "Export," then click on "Create a video." sshot-2 - www.office.com/setup Once you do this, you will see the "Create a Video" option. This will offer a few options in the form of two drop-down menus and a time value box. sshot-3 - www.office.com/setup The first drop-down box is where you will choose the quality of your exported video. These three options will also determine the size of your exported video file. For the purposes of this example, we will choose the second option to reduce the size of the video without compromising too much video quality. sshot-4 - www.office.com/setup The second drop-down menu allows you to include or exclude any timings or narrations that you inserted on your PowerPoint presentation. Since the sample document has no timings or narrations, we will leave this as is. The "Use Recorded Timings and Narrations" will be unavailable if you don't have any of them in your presentation. sshot-5 - www.office.com/setup The time value box is where you can edit the amount of time that your slides will appear in the video. The default time is set at 5 seconds. For this tutorial, we will set it to 3 seconds. Lastly, you need

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION 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 exampl

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

How to Use the New Microsoft Forms - www.office.com/setup www.office.com/setup Blogs: Have you seen the new Microsoft Forms? One of the most popular articles on my blog in the last 12 months was related to its predecessor - Excel Surveys. Not only did that post get a lot of views, but it also got a lot of comments from people with questions about the features of Excel Surveys, or more importantly for some, the features it did not have. You can still use Excel Surveys, but Microsoft are in the process of transitioning to something better - Microsoft Forms. This version includes automatic grading and built-in student feedback. Here's what you need to know. GETTING STARTED You can find the homepage for Microsoft Forms by going to forms.office.com, or you may see Forms listed in the Office 365 App Launcher. Both links go to the same place. Technically, Forms is still in Preview but you can sign in with your Office 365 Education account today and start creating surveys and quizzes. The new Microsoft Forms work on desktop and mobile browsers. Once you are logged in, click the New button to create your first form. Replace Untitled Form with a title of your choice, and add a description underneath if you want to provide any directions or information for students or parents who are filling out your Form. BUILDING A FORM Tapping the Add Question button gives you access to the question types that are available to you in this new version of Microsoft Forms. The options include: Choice: for creating multiple choice questions! Tap or click the slider to allow people to select multiple answers. You can also tap or click the ellipses button to shuffle answers. Quiz: a multiple choice question that you allows you to select a correct answer for automatic grading. Tapping the comment icon on each answer choice lets you add student feedback for each selection. Multiple answers and shuffled answers are also available to you when working on Quiz questions. Text: to collect