Group items tagged

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

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

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: GO TEAM! THAT'S WHAT OFFICE 2016 IS BUILT TO ENCOURAGE, WITH NEW COLLABORATIVE TOOLS AND OTHER WAYS TO TIE WORKERS AND CONTENT TOGETHER. pcw office primary 2 - www.office.com/setup www.office.com/setup Blogs: Office 2016 is a major upgrade, but not in the way you'd first suppose. Just as Windows 10 ties notebooks, desktops, phones and tablets together, and adds a layer of intelligence, Office 2016 wants to connect you and your coworkers together, using some baked-in smarts to help you along. I tested the client-facing portion of Office 2016. Microsoft released the trial version of Office 2016 in March as a developer preview with a focus on administrative features (data loss protection, multi-factor authentication and more) that we didn't test. I've been using it since the consumer preview release in May. Microsoft seeded reviewers with a Microsoft Surface 3 with the "final code" upon it. That's a slight misnomer, as the Office 2016 apps upon it used the same version that Microsoft had tested with the public, with a few exceptions: Outlook was pre-populated with links and contacts of a virtual company to give reviewers the look and feel of Delve, Outlook's new Groups feature, and more. Office 2013 users can rest easy about one thing: Office 2016's applications are almost indistinguishable from their previous versions in look and feature set. To the basic Office apps, Microsoft has added its Sway app for light content creation, and the enterprise information aggregator, Delve. Collaboration in the cloud is the real difference with Office 2016. Office now encourages you to share documents online, in a collaborative workspace. Printing out a document and marking it up with a pen? Medieval. Even emailing copies back and forth is now tacitly discouraged. office 2016 review powerpoint demo shot - www.office.com/setupMicrosoft Microsoft says its new collaborative workflow reflects how people do things now, from study groups

The new Excel offers a rich set of charting capabilities that make creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane. - www.office.com/setup Until now, precise adjustments to chart elements were made in the Format dialog box. The box sometimes obscured a portion of the chart, changes entered in the box were not visible until you closed it, and you had to select the exact element on the chart in order to see the options that were the best fit for the job. In the new Excel, the Format dialog box is replaced by the Formatting Task pane. The pane aligns neatly with the right or left side of the screen, so it's less likely to obscure the chart, and changes happen in real time, so you can immediately see how your choices affect the chart. The Formatting Task pane also offers an element selector so you can jump quickly between different elements without having to select one to modify. The new Formatting Task pane is the single source for formatting-all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel. USING THE FORMATTING TASK PANE The fastest way to open the Formatting Task pane is to double-click a chart element. You can also use the keyboard shortcut CTRL+1 while a chart element is selected. There are two other ways to open the task pane: The first way: On a chart, select an element. On the Ribbon, select the Chart Tools Format tab, then click Format Selection. - www.office.com/setup The second way: On a chart, select an element. Right-click, then select Format where is the axis, series, legend, title, or area that was selected. - www.office.com/setup Once open, the Formatting Task pane remains available until you close it. Since it always stays on the right or left side of the screen, the pane remains unobtrusive as you concentrate on other tasks. The

Amazon announces $99 Fire TV set-top box, Apple and Roku have a replacement contender within the front room. Amazon simply declared its own video streaming device: the $99 Amazon hearth TV. It starts shipping nowadays. "We ought to invent and modify on behalf of consumers," aforementioned Amazon's Peter Larsen. throughout the presentation, Larsen went over 3 pain points of current devices: search, performance, and "closed scheme." fire TV guarantees to avoid the issues that plague different front room hardware.

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

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: The shrouded veil of secrecy has been lifted from the latest edition of Microsoft Office. Excitement for Office 2016 is still lagging behind the Windows 10 enthusiasm camp, but following the July 29 release of Windows 10, attention will return to the world's most popular productivity suite.When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview? When Does Windows 10 Come Out, How Can You Get It & What Happens to the Technical Preview?Windows 10 is coming soon. Still confused about how the upgrade will work and wondering about the timeline? We have some answers, although more questions remain.READ MORE Office 2016, like Windows 10, has been re-designed within a revised Microsoft ethos. Office 2016 has been built from the ground-up with mobile and cloud users in mind, slotting in with the ever expanding fleet of Microsoft productivity applications. Office is, in general, a different set of tools from days gone by. We aren't confined to the five-or-so core products, and we can expand the functionality of the Office ecosystem using a massive range of add-ins and templates. Office 2016 logo - www.office.com/setup I'm using VirtualBox to preview Office 2016. Microsoft strongly suggested uninstalling Office 2013, which isn't currently viable due to work commitments. Using a virtual machine, however is a great way to explore different Office products alongside each other, without having to uninstall your current suite. I've also had a look at Office 2016 on Windows 10 Build 10130. Verdict: good times.How To Use VirtualBox: User's Guide How To Use VirtualBox: User's GuideLearn to use VirtualBox. Get virtual computers up and running inside your computer, without having to buy any new hardware.READ MORE Anyway, enough of that. Let's look at Office 2016. NEW OVERVIEW Much akin to the extended and inclusive testing phase of Windows 10, the Office 2016 preview has now accumulated over 1 million users,

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

With Google Apps and Office 365 revolutionizing the way people work, you may feel that Microsoft Office is quickly becoming a dated product that will soon be packed away to the back of the closet. But with the 2016 version set to launch in autumn of this year, Microsoft is looking to change your mind. Now they're adapting their classic Office package for today's modern workforce. Here are four of the new features that are reinventing the way you look at your Office applications. CLOUD FOCUS FOR OUTLOOK ATTACHMENTS Microsoft knows that sharing attachments amongst co-workers and teams can be a hassle. With many collaborators still sharing documents and files the old fashioned way - attaching it to an email and then sending to others - it's easy for users to get confused and send an incorrect or outdated version. To solve this problem, Microsoft is gently nudging us to use the cloud. Now when you add an attachment to an email, you're now asked if you'd also like to share a link to a file on your OneDrive, OneDrive for Business or SharePoint account. SHOWCASING EASY WAYS TO USE OFFICE BETTER If you're like most people, you probably aren't using Office to its full potential. And who can blame you? Between Word, Excel, PowerPoint and more, there are literally hundreds of features and tools you can use - if only you had the time to discover them all. To help you get the most out of Office, Microsoft has now added a Tell Me box in the top center of your program title bar. This tool gives you an easy way to get questions answered. For example, if you want to project your desktop screen to a second monitor or create a graph in Excel, simply type your question into the Tell Me box and Microsoft will find the answers that most closely fit your search criteria. SWAY Look out PowerPoint, here comes Sway - the new, hipper Office application that makes creating fluid, stylish presentations easy. With Sway, you can now gather content from various source

Roku streaming players are set-top boxes for delivering over-the-top content. Roku Ultra gives you an ideal streaming experience which supports HDR.

Amazon Fire TV goes official, and is now available on Amazon. It will have to compete with Apple TV, Roku 3 and Google Chromecast to get its feet in today's marketplace, and it's not going to be easy.

Netflix has signed a multiyear deal with Liberty Global to get its internet television service on cable set-top boxes in more than 30 countries.

In-Room Entertainment Market, By Products (Smart/3D/LED/LCD/OLED Tvs, Set-Top Box, Home Theater Systems (Projectors, Audio Equipment), Blu-Ray, Gaming Console); By Technology (Processor, Memory, Sensors, Connectivity); and By Geography

In-Room Entertainment Market, By Products (Smart/3D/LED/LCD/OLED Tvs, Set-Top Box, Home Theater Systems (Projectors, Audio Equipment), Blu-Ray, Gaming Console); By Technology (Processor, Memory, Sensors, Connectivity); and By Geography

In-Room Entertainment Market, By Products (Smart/3D/LED/LCD/OLED Tvs, Set-Top Box, Home Theater Systems (Projectors, Audio Equipment), Blu-Ray, Gaming Console); By Technology (Processor, Memory, Sensors, Connectivity); and By Geography

Netflix is one of the most popular multimedia streaming websites, which are available for different your household devices such as personal computer, laptop, gaming consoles, set-top box, Smartphone as well as some specific Internet-permitted televisions. The company also known for its quality services that can achieved by calling at Netflix customer service phone number...

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