Group items tagged

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: 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: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -

Save an extra 10% when you apply this coupon. Get $50 off instantly: Pay $0.00 upon approval for the Amazon Rewards Visa Card. No annual fee. * Ensure Safety: Unique high-tech design makes the blades stop blading automatically when the body and cup separate. Equipped with a built-in 4000mAh rechargeable battery that can be easily charged by powerbank, laptop, computer, and other USB devices. * 40s Stronger Power: Up to 22000 rmp/min motor speed, rotating speed is much faster than average portable blender. 7.4V motor comes with 6 stainless food grade ultra-sharp blades, fast performance makes your favorite drinks like smoothies and shakes will be ready within 40 seconds. * One Button Blending/Cleaning: No need to spend extra money on larger blenders with added bells and whistles when TENSWALL simple button touch do. When cleaning, just put some water in the cup, press the button to start automatic cleaning. * 380ML Portable Blender: This handheld blender comes with a travel lid, portable and convenient. You can drink nutritious juice, shakes or smoothies anywhere you want, such as home, office, gym, travel or any other outdoor activities. Besides, it can be taked on the plane. * Eco-friendly: The juicer smoothie blender cup is made of food-grade non-toxic and eco-friendly PCTG material, high quality ABS shell, food grade 304 stainless steel. A good day starts with healthy and nutritious juice by TENSWALL portable blender Multifunctional Portable Blender Built-in safety function: The devices will not operate when the components are not properly assembled. USB Rechargeable: 4000mAh lithium-ion battery, 15 cups of juices can be squeezed on a single charge, which can be charged by powerbank. car, laplop etc. 6 Pcs Blades: More poweful than ordinary portable blender, perfect for making green fruit smoothie, milkshake, juice, protein shake,baby food etc. One Button Cleaning: Average speed is upt to 22000 rpm±15%, simply press the button twice in rapid successi

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: 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: 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: Last week, Outlook for Mac released two highly requested features designed to help you get more done, quickly. First, we added support for the Touch Bar for MacBook Pro users. Through the Touch Bar, we intelligently put the most common inbox, formatting and view commands at your fingertips-all based on what you're doing in Outlook. Additionally, we're bringing your favorite apps to your inbox with add-ins for Outlook for Mac. Whether it's translating emails on the fly or updating your notes or project board, you will now be able to accomplish all this and more right from your inbox. These add-ins are also available across Outlook for Windows, iOS and the web, so your favorite apps are always there to help you accomplish tasks quickly. Here's a look at what's new! INTUITIVE COMMANDS AT YOUR FINGERTIPS WITH TOUCH BAR SUPPORT IN OUTLOOK FOR MAC The Touch Bar in Outlook intelligently provides quick access to the most commonly used commands as you work on email and manage your calendar. When composing a new mail or meeting request, the Touch Bar displays the common formatting options. When viewing your calendar, you can switch between different views. And when viewing the reminders window, you can join an online meeting with one tap on the Touch Bar. www.office.com/setup Support for Touch Bar in Outlook for Mac is available to all Office 365 subscribers, as well as all Office 2016 for Mac customers. ACCOMPLISH TASKS QUICKLY WITH NEW ADD-INS Add-ins bring your favorite apps right inside Outlook, so you can accomplish tasks quickly without needing to switch back and forth between email and other apps. Last year, we announced the rollout of add-ins to Outlook 2016 for Mac in Office Insider. We are now making add-ins available to all Outlook 2016 for Mac customers who have Exchange 2013 Service Pack 1 or higher, or Office 365 or Outlook.com mailboxes. Use these add-ins to translate emails on the fly, edit a record in your CRM s

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

Last week, we welcomed Brian Solis, Altimeter principal analyst, thought leader and book author, to Yammer HQ to give a fireside chat, followed by signing of his new book: "What's The Future of Business?" I was thrilled to interview Brian, and we covered a variety of really meaty subjects - just check out the video below! The theme of the evening was transformation - transformation that is happening in our lives as individuals, how we relate to each other through technology and what we as businesses must do to stay relevant to the connected customer. Even the book itself is transformation of the book publishing convention. Unlike a regular, information-dense business book, "What's the Future of Business" attempts to bring together the best of both worlds: hard-hitting facts and practical frameworks, as well as a visual experience. The experience of the book is just as important as the content therein. What is the future of business? The future of business is experience, according to Solis. We as connected consumers make decisions outside of the sales funnel that companies have organized themselves around. We reference experiences of consumers who came before us, and contribute our own experiences to this dynamic tapestry. When consumers share, they are reacting to an experience, and the future of any business depends on its ability to provide experiences that are worth sharing. In his talk, Brian talked about the 4 moments of truth that add up to shareable experiences. At every stage of the customer journey, it is our job as businesses to design an experience to trigger the sharing of a moment. The Zero Moment of Truth comes when the consumer is starting to explore choices and is just becoming aware of needs and possible solutions. 1st Moment of Truth happens when the consumer is ready to buy. Consumer packaged goods companies have perfected providing the right experience at this point. 2nd Moment of Truth happens after the consumer purchases,

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson. TO INSERT A CHART: Select the Insert tab, then click the Chart command in the Illustrations group. - www.office.com/setup A dialog box will appear. Select a category from the left pane, an

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

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: 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: Project 2016 has all the functionality and features you're used to, with some enhancements and the best new features from Office 2016. NOTE: The following feature updates are available to Project Online subscribers. They will first roll out to Office Insider participants. If you have a Project Online subscription, make sure you have the latest version of Office. MARCH 2017 TASK SUMMARY NAME FIELD With long lists of tasks, it can be difficult to know what a task is indented under in the overall project plan. The Task Summary Name field is a read-only field that shows the name of a task's summary task. Adding this field as a column in your Task view can help clarify your project's structure. To add this field, right-click the title of a column (to the right of where you want to add the field), select Insert Column, and then choose Task Summary Name from the drop-down list. Task Summary Name column - www.office.com/setup NOVEMBER 2016 TIMELINE BAR LABELS AND TASK PROGRESS Communicating project progress just got easier! Timeline bars can now be labeled, and task progress is shown right on the tasks themselves, making it simple to quickly illustrate your plan and the work in progress when sharing status. Timeline bars with labels and task progress - www.office.com/setup OCTOBER 2016 IN-APP FEEDBACK Have a comment or suggestion about Microsoft Office? We need your feedback to help us deliver great products. In Project, you can suggest new features, tell us what you like or what's not working by clicking File > Feedback. Click File > Feedback to offer comments or suggestions about Microsoft Project - www.office.com/setup SEPTEMBER 2015 MORE FLEXIBLE TIMELINES With Project 2016, not only can you leverage multiple timelines to illustrate different phases or categories of work, but you can also set the start and end dates for each timeline separately, to paint a clearer overall picture of the work involved. Formatted timeline in Project

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

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

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: Last week, Outlook for Mac released two highly requested features designed to help you get more done, quickly. First, we added support for the Touch Bar for MacBook Pro users. Through the Touch Bar, we intelligently put the most common inbox, formatting and view commands at your fingertips-all based on what you're doing in Outlook. Additionally, we're bringing your favorite apps to your inbox with add-ins for Outlook for Mac. Whether it's translating emails on the fly or updating your notes or project board, you will now be able to accomplish all this and more right from your inbox. These add-ins are also available across Outlook for Windows, iOS and the web, so your favorite apps are always there to help you accomplish tasks quickly. Here's a look at what's new! INTUITIVE COMMANDS AT YOUR FINGERTIPS WITH TOUCH BAR SUPPORT IN OUTLOOK FOR MAC The Touch Bar in Outlook intelligently provides quick access to the most commonly used commands as you work on email and manage your calendar. When composing a new mail or meeting request, the Touch Bar displays the common formatting options. When viewing your calendar, you can switch between different views. And when viewing the reminders window, you can join an online meeting with one tap on the Touch Bar. www.office.com/setup Support for Touch Bar in Outlook for Mac is available to all Office 365 subscribers, as well as all Office 2016 for Mac customers. ACCOMPLISH TASKS QUICKLY WITH NEW ADD-INS Add-ins bring your favorite apps right inside Outlook, so you can accomplish tasks quickly without needing to switch back and forth between email and other apps. Last year, we announced the rollout of add-ins to Outlook 2016 for Mac in Office Insider. We are now making add-ins available to all Outlook 2016 for Mac customers who have Exchange 2013 Service Pack 1 or higher, or Office 365 or Outlook.com mailboxes. Use these add-ins to translate emails on the fly, edit a record in your CRM s