Group items tagged

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

www.office.com/setup Blogs: Previews of PowerPoint2013 show that it will be easier to create and share professional presentations with a range of new and improved features. 1. NEW RANGE OF DESIGN THEMES Powerpoint 2013 start screen - www.office.com/setup Easier inclusion of videos, or pictures to give a more professional edge to presentations. Easy access to a collection of new themes available via the start screen. The ability to quickly change themes using theme variants. Alignment Guides have been added that make it easier to align text boxes, graphics and shapes with text. Merge Shapes tools -2013 includes Union, Combine, Fragment, Intersect, and Subtract tools making it easier for the user to merge two or more shapes into the shape required. 2. IMPROVEMENTS TO THE PRESENTER'S VIEW AND ORGANISATION OF THE PRESENTATION. The One click Slide Zoom allows the user to zoom in and out on diagram, or chart. The addition of a presenter's Navigation Grid, making it easier for the presenter to switch slides within a sequence using a navigation grid that the audience cannot see. The ability to easily project a presentation on a second screen using Auto-extend. 3. IMPROVED COLLABORATION WITH EASIER SHARING AND CO-AUTHORING. The Reply Comment feature. PowerPoint 2013 makes it easier to add and track comments next to the relevant section of text. Everyone working on the presentation can follow the discussion easily and act on any suggestions. Collaboration and Sharing. With Microsoft's emphasis on improved collaboration, the new default setting means that presentations are saved online to SkyDrive or SharePoint . This allows the author to send a link to the same file to everyone involved, complete with personalised viewing and editing permissions, so that everyone is working on the same version. The PowerPoint Web App Co-authoringfeature via PowerPoint Web. 2013 makes it easier for several people to work on the same presentation at the same time from the desktop or in bro

www.office.com/setup Blogs: Office 2016 for Mac is here, so we bring you everything you need to know about the new version of Office for Mac 2016, including Office 365, UK pricing, new features and more. OFFICE FOR MAC 2016 FIRST LAUNCHED AS PART OF OFFICE 365 IN JULY OF 2015, BUT MAC USERS WANTING TO BUY A COPY OUTRIGHT, RATHER THAN SUBSCRIBE, HAD TO WAIT FOR MICROSOFT TO LAUNCH THE BOXED VERSION. THAT FINALLY HAPPENED IN SEPTEMBER 2015, WHEN THOSE MAC USERS GOT THEIR WISH AND OFFICE 2016 FOR MAC BECAME AVAILABLE FOR £119.99 UPFRONT. HERE, WE TALK YOU THROUGH THE FEATURES IN OFFICE FOR MAC 2016, AND HELP YOU DECIDE WHETHER TO SUBSCRIBE TO OFFICE 365 OR BUY A COPY OUTRIGHT. PLUS, WE SHARE OFFICE FOR MAC 2016 UK PRICING FOR EACH VERSION. A number of new features for the MacBook Pro Touch Bar have been added as of February 2017, these are discussed here. Don't expect Microsoft Office for Mac 2017 anytime soon (or at all, for that matter). There was a five year gap between this current version of Office for Mac and its predecessor, Microsoft Office for Mac 2011. However, those with an Office 365 account will get regular, automatic updates since it is an online subscription. If you buy Office outright as a one-time software download, you won't get these benefits, so something to bear in mind. MICROSOFT OFFICE FOR MAC 2016 UK PRICE: HOW MUCH DOES OFFICE FOR MAC 2016 COST? Office Home & Student 2016 for Mac costs £119.99 ($149.99) and includes Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. Office Home & Business 2016 for Mac costs £229.99 ($229.99) and includes Outlook as well as Word, Excel, PowerPoint and OneNote. It's available to buy from Microsoft UK here or Microsoft US here. These versions are only available for one Mac. To install on more than one Mac Microsoft appears to be pushing users towards the 365 subscription model. If you buy a copy outright, you will only be able to install the copy on

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

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: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

www.office.com/setup Blogs: In today's post we take a look at the key admin setup steps of a Office 365 license. If you'd like the complete guide to Office 365 setup, you can download it here. This guide will walk you through the necessary steps to establish your Office 365 account, add your end users, and jumpstart collaboration. In today's post, we'll be discussing the setup process for you and your employee's Office 365 accounts from start to finish. What to Expect During The Setup Process Office 365 The process begins with the purchase of Office 365 licenses for all of your employees. There are different plans available, with options that include the full Microsoft Office downloadable suite of tools, and those that only provide the online, or web-based versions of the Office suite. There are plans available for an individual, small business, and for the enterprise. Each license type includes options for online and offline apps, email, and productivity solutions. Purchasing a New Office 365 Plan Once your plan is selected, you as the Administrator will walk through the purchasing process, allowing you to associate your new plan with any existing subscriptions, as well as associate your account to your personal Microsoft ID. If you've ever attended a Microsoft event or webinar, or purchased software from the Microsoft store, you probably already have a personal Microsoft ID. You can connect this to your new Office 365 account, or create a new Microsoft ID. The signup process has four simple steps: Provide your contact details Create a new ID (or associate your account with an existing ID) Review your order Place your order Once purchased, you will receive a welcome letter as the new Office 365 Administrator with details on signing onto the platform and getting started. If the license was purchased on your behalf, your profile will be added to the company account, and you will likewise receive a welcome email with your User ID and a temporary passw

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

www.office.com/setup Blogs: The new admin center reached general availability one month ago. This was a big milestone in our mission to provide you with a first-class admin experience, with tools that enable you to efficiently manage all aspects of the service. We continue to evolve the admin center. This month, we focused on providing you with additional usage insights, including new usage reports, the preview of the Office 365 adoption content pack in Power BI and more role-based permissions through a new Power BI admin role. Here's a summary of the October updates: NEW USAGE REPORTS STARTING TO ROLL OUT TODAY In March, we launched the new reporting dashboard in the Office 365 admin center that makes it easier for you to efficiently monitor your service, identify issues, plan training and report back on the investment to your management. Today, we are happy to announce four new usage reports for active users, Email clients, Skype for Business clients and Office 365 Groups, that provide you with additional insights about how users in your organization are using and adopting Office 365. Here's a look at each report: Active Users report-Lets you see which of your users actively use one or more of the different Office 365 services. This report is especially helpful for admins to identify users for whom they might want to plan some additional training and communication. Often, after being assigned an Office 365 license, users need a helping hand to get started with the different services. They might not know how to activate the product or how the product can help them to be more productive. The image below shows all users that are licensed for one or more products and the last date they used any of those products. By clicking the Column icon, admins can modify the table to see which license has been assigned to a user, as well as when the license was assigned to the user. admin-center-october-1 - www.office.com/setup Blogs Skype for Business clients used r

News hub is a free news app that brings the latest and best news from multiple national and international sources and summarizes them to present in a short format, personalized for you, in both, English or Hindi. All summarized stories contain only headlines and facts, to help you stay updated with the current affairs. Whether it's the latest updates in government policies or shakeups in Bollywood, we get them covered and delivered super-fast! Stay updated with the latest news and current affairs in a second!

www.office.com/setup Blogs: Office 365 is a subscription based package that buys you time limited access to a number of Microsoft services and software packages, including the latest desktop Office suite, an online version of Office, cloud storage, and premium mobile apps.Stop Bashing Microsoft: 5 Ways In Which They're Awesome Stop Bashing Microsoft: 5 Ways In Which They're AwesomeMicrosoft doesn't always get fair treatment. When it comes down to it, they're a pretty awesome company. There's been enough Microsoft bashing, now it's time for some love.READ MORE Office 365 follows a business model known as Software as a Service (SaaS), which has commonly been used for deploying enterprise software. With subscription-based services like Spotify, Napster, or Amazon Prime, it has found its way into the consumer software market some time ago. Does Office 365 provide enough value to be worth the money? CAN YOU STILL USE IT ON YOUR DESKTOP? Yes, absolutely! Microsoft isn't moving Office entirely into the cloud just yet. While you can access Office Online via the browser and store your documents on OneDrive, Office 365 offers many other ways to access and edit your documents. The current package of Office 365 includes the Office 2013 desktop suite (Office 2011 for Mac users). In the summer or fall of this year, you will be able to upgrade to Office 2016.Don't Pay For Word! 5 Reasons You Should Use Office Online Don't Pay For Word! 5 Reasons You Should Use Office OnlineOffice Online is the free and cloud-connected version of Microsoft Office. Limitations are compensated by features, useful even to users of desktop Office. Best of all is itsREAD MORE Microsoft Office - www.office.com/setup WHAT IS INCLUDED & WHAT IS THE PRICE TAG? The exact composition of the package depends on the Office flavor you choose. Office 365 Home, Office 365 Personal, and Office 365 University include the following software: Word Excel PowerPoint OneNote (now free for everyone) Outlook Publ

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

www.office.com/setup Blogs: Last year, we released Microsoft Bookings to customers in the U.S. and Canada, introducing an easy way for small businesses to schedule and manage appointments with their customers. Today, we are pleased to announce that we're beginning to roll out the service to Office 365 Business Premium subscribers worldwide. Based on your feedback, we are bringing several new features to Bookings: Add your Office 365 calendar to Bookings-Connect your Office 365 calendar to Bookings, so that the times you are busy will automatically be blocked in your public Booking page. Add buffer time before and after your appointments-Do you need prep time before or after an appointment? Adding buffer time to a service automatically blocks that time in your Booking page too. Bookings apps for your iOS and Android phone-Now you can book an appointment, contact a customer or check a staff member's appointments while away from the office. Customize your Booking page-We added more color customization options, so you can better personalize your Booking page. These new capabilities will start showing up automatically in Bookings in the coming weeks. Let's take a detailed look at what's new. ADD YOUR OFFICE 365 CALENDAR TO BOOKINGS One of the top pieces of feedback we've heard is that you want to be able to add events from your Office 365 calendar to Bookings. So, we added integration between these calendars to help you avoid booking customer meetings during the time you've set aside for personal appointments, staff and partner meetings or other aspects of running your business. To add Office 365 calendars to Bookings, click the Staff tab on the left navigation panel. On the Staff details page, select the Events on Office 365 calendar affect availability checkbox. www.office.com/setup Add Office 365 calendar events to Bookings. Once you activate this option, the system automatically blocks busy times on the Bookings calendar and on the self-ser

WWW.OFFICE.COM/SETUP BLOGS: WHICH VERSION OF MICROSOFT OFFICE IS BEST FOR ME? www.office.com/setup Blogs: Office 365 and Office 2016 share a lot of similarities, yet deciding between the two involves a lot of factors. Office 365 is a subscription-based service that currently uses Office 2016 apps, but when the next version of Office is released, users will get that as part of their subscription. Office 2016 is a buy-once app suite that brings you the Office 2016 apps as they are, without any available updates in the future. If you want to upgrade to the latest version of Office without paying for a subscription, you'll have to pay full price for the new version - there's no discounted upgrade option. These are only a couple differences between the two products. Looking to invest in Office? We break down the differences between the two products to help you decide which is better for personal and home use. See at Microsoft Store Quick-reference table Apps and pricing Multiple devices Connectivity Support Storage Conclusion QUICK-REFERENCE TABLE Category Office 365 Home Office 365 Personal Office Home & Student 2016 Office Home & Business 2016 Office Professional 2016 Price $99.99 /year $9.99 /month $69.99 /year $6.99 /month $149.99 $229.99 $399.99 Users Up to 5 1 1 1 1 Apps Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Outlook Publisher Access Word Excel PowerPoint OneNote Word Excel PowerPoint OneNote Outlook Word Excel PowerPoint OneNote Outlook Publisher Access Devices 5 PCs or Macs 5 tablets 5 phones 1 PC or Mac 1 tablet 1 phone 1 PC 1 PC 1 PC Skype minutes 60 per month for each user 60 None None None OneDrive storage 1TB each for five users 1TB None None None APPS AND PRICING Office apps on the go. - www.office.com/setup Office 365 is a subscription-based service. If you choose to pay on a yearly basis, you essentially get a discount that works out to two free months per year. If you choose to pay on a monthly b

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-

www.office.com/setup Blogs: Missing a key security signal could mean not catching a breach, but the number of security signals is increasing exponentially. It's becoming impossible to manually prioritize them. That's why Office 365 applies intelligence to help you proactively manage risk and ward off threats. Today, we're pleased to introduce several new capabilities in Office 365 that help you manage risk and stay ahead of threats: Office 365 Secure Score-A new security analytics tool that applies a score to Office 365 customers' current Office 365 security configuration. Office 365 Threat Intelligence Private Preview-Service that leverages billions of data points from the Microsoft Intelligent Security Graph to provide actionable insights to the global threat landscape and help customers stay ahead of cyber threats. Office 365 Threat Intelligence is now in private preview, with general availability planned for later this quarter. Office 365 Advanced Data Governance Preview-Applies machine learning to help customers find and retain the most important data to them while eliminating redundant, obsolete and trivial data that could cause risk if compromised. Office 365 Advanced Data Governance is now in preview, with general availability planned for later this quarter. KNOW YOUR OFFICE 365 SECURE SCORE Do you know how you'd be rated if someone were to evaluate your security configuration? To give you better visibility into your Office 365 security configuration and the security features available to you, we're pleased to introduce Secure Score-a new security analytics tool. Secure Score helps you understand your current Office 365 security configuration and shows you how implementing additional controls can further enhance your security and reduce risk.* Here's how it works: Secure Score Summary-Displays your Secure Score and provides access to view your Score Analyzer. Your Secure Score, the numerator, is the sum of the points associated wi

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