Group items tagged

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ

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

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

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

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

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook. Watch the video below to learn more about modifying columns, rows, and cells. TO MODIFY COLUMN WIDTH: In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. positioning the mouse over the column line - www.office.com/setup Click and drag the mouse to increase or decrease the column width. increasing the column width - www.office.com/setup Release the mouse. The column width will be changed. the resized column - www.office.com/setup With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible. TO AUTOFIT COLUMN WIDTH: The AutoFit feature will allow you to set a column's width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. autofitting the column width - www.office.com/setup Double-click the mouse. The column width will be changed automatically to fit the content. the autofit column width - www.office.com/setup You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height. autofitting column width for multiple columns - www.office.com/setup TO MODIFY ROW HEIGHT: Position the cursor over the row line so the cursor becomes a double arrow. hovering over a <a href=row line - www.of

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences. Go to the Insert tab and click Table. insert table - www.office.com/setup Mouse over the squares in the table grid to select the number of columns and rows you want in the table. Click on the last square to insert the table. Word will now switch you to the Design tab for formatting the table. Click inside the table. Select a style from the Table Styles gallery and take note of the style name. You'll need the name in the steps below. table style - www.office.com/setup table style gallery - www.office.com/setup Click the down arrow next to the Table Styles and select New Table Style. table style new - www.office.com/setup Give this table style a new name. table style create - www.office.com/setup Select the table style you want to base yours on in the dropdown box next to "Style based on" option. table style create select - www.office.com/setup Select your formatting options. For example, you can change the font and font style, change the border and cell colors, and change the text alignment. table style options - www.office.com/setup For additional formatting options, click the Format button at the bottom left of the window. table style format - www.office.com/setup Select "New documents based on this template" so the table style will be available in future Word docs. table style newdocs - www.office.com/setup11. Click OK.

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: 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: 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: 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: 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

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

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: As you design your document and make formatting decisions, you will need to consider line and paragraph spacing. You can increase spacing to improve readability and reduce it to fit more text on the page. Optional: Download our practice document. Watch the video below to learn how to fine tune line and paragraph spacing in your documents. ABOUT LINE SPACING Line spacing is the space between each line in a paragraph. Word allows you to customize the line spacing to be single spaced (one line high), double spaced (two lines high), or any other amount you want. The default spacing in Word is 1.08 lines, which is slightly larger than single spaced. In the images below, you can compare different types of line spacing. From left to right, these images show default line spacing, single spacing, and double spacing. - www.office.com/setup Line spacing is also known as leading (pronounced to rhyme with wedding). TO FORMAT LINE SPACING Select the text you want to format. - www.office.com/setup On the Home tab, click the Line and Paragraph Spacing command, then select the desired line spacing. - www.office.com/setup The line spacing will change in the document. FINE TUNING LINE SPACING Your line spacing options aren't limited to the ones in the Line and Paragraph Spacing menu. To adjust spacing with more precision, select Line Spacing Options from the menu to access the Paragraph dialog box. You'll then have a few additional options you can use to customize spacing. Exactly: When you choose this option, the line spacing is measured in points, just like font size. For example, if you're using 12-point text, you could use 15-point spacing. At least: Like the the Exactly option, this lets you choose how many points of spacing you want. However, if you have different sizes of text on the same line, the spacing will expand to fit the larger text. Multiple: This option lets you type the number of lin

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: Evernote and OneNote are two of our favorite tools, but both have changed substantially since we last compared these two apps-in some ways, not for the best. Here's where these two stand today. www.office.com/setup LIFEHACKER FACEOFF: ONENOTE VS. EVERNOTE Now that Microsoft OneNote is free for Mac and Windows, the price and cross-platform barriers to…Read more WHAT'S NEW IN EVERNOTE In the last year, Evernote introduced a new pricing plan, redesigned its webapp, and added new features for its Android and iOS apps. THE FREE PLAN LOSES A FEATURE, BUT NOW THERE'S A MORE AFFORDABLE PAID PLAN Let's talk price first with Evernote, since it's the biggest change in the last year. The free plan no longer lets you email notes to Evernote, something most users enjoyed and used often prior to that change. Although you can get around this limitation with an IFTTT recipe, you won't get the full flexibility of Evernote's email-to-notes feature, such as specifying your destination notebook in the email subject line. So that's a bummer. On the positive side, however, Evernote introduced a new, more affordable paid plan called Evernote Plus. For $25 a year, you get offline notebooks for Evernote's mobile apps and the ability to lock the app on your phone with a PIN. Both of these used to require Evernote's Premium plan, which used to cost $45 a year. Finally, Evernote's Premium plan now costs $50 a year. But in return for those five extra bucks, you get larger upload limits: 10GB a month, instead of the previous 4GB data cap. With Evernote Premium, you can search attachments, scan business cards, view previous note versions, annotate PDFs, and use the new note presentation mode. EVERNOTE'S USER INTERFACE KEEPS EVOLVING www.office.com/setup Last year, Evernote took its redesigned, minimalist web client out of beta. Though slicker and easier on the eyes, the makeover also made the webapp less functional. You can't order