Group items tagged

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: Part 1: Add An Account Go to Microsoft Office 365 Admin Center. From the top menu, click Admin and select Office 365. www.office.com/setup Blogs From the left navigation, go to USERS > Active Users and then click the + button. www.office.com/setup Blogs Specify Delegate Account information, including a temporary password, and then click Create. www.office.com/setup Blogs Note: Licenses automatically assign to the account. Unassign the license (9) because the Delegate Account does not require a license. Record the Delegate Account credentials (username and password). These credentials are also sent to the email address specified in the previous page. www.office.com/setup Blogs Click Close. Click the Delegate Account display name to configure additional settings. www.office.com/setup Blogs From the left navigation, click settings and then assign the Delegate Account the Service administrator role and specify an Alternate email address. www.office.com/setup Blogs Part 2: Assign Specialized Roles To The Delegate Account From the upper right corner of the screen, choose Admin > Exchange to open the Exchange Admin Center. www.office.com/setup Blogs Click permissions and then the + button to create a New Role Group. www.office.com/setup Blogs Type delegation_service as the name of the new role group. www.office.com/setup Blogs Under Roles, click the + button. www.office.com/setup Blogs Add the ApplicationImpersonation and Mailbox Search roles. www.office.com/setup Blogs Under Members, click the + button. www.office.com/setup Blogs Add the newly created Delegate Account. www.office.com/setup Blogs Click Save. Office 365 updates the organization settings. www.office.com/setup Blogs Sign out of Microsoft Office 365. Part 3: Change The Delegate Account Password Sign in to Microsoft Office 365 using the new Delegate Account credentials. www.office.com/setup Blogs Change the temporary Delegate Account password to a permanent one. www.office.com/se

Sometimes there is frantic need to create links in database table to web pages, files, folders, images, etc. Access 2010 provides a convenient way to link up data field values with anything to complement the database in much better way. In this post we will guide you on creating a table field having Hyperlink data type. To start off with, launch Access 2010 and navigate to Create tab and click Table. createtable1 Create Hyperlink Field In Access 2010 - www.office.com/setup It will create a new table namely Table1. Right-click newly created table and select Design View to add fields with specific Data types. table11 Create Hyperlink Field In Access 2010 - www.office.com/setup Enter an appropriate table name and start adding fields. We will be entering some generic table fields with their data types such as, ID, Name, Phone Number, Email and other Links. design view - www.office.com/setup Select Email table field and under data type options, select Hyperlink. select hyperlink - www.office.com/setup Repeat the procedure for assigning Hyperlink data field for other fields as well. hyperlink other - www.office.com/setup Now close the Design view and save the changes made. Open the database table in Datasheet view. Start filling out table fields with values. In Hyperlink assigned data fields, you will notice that on entering values it will automatically turns them into blue, indicating linked data. hyerplinks created - www.office.com/setup Now we will move to editing Hyperlinks. In Email field, highlight the email address and right-click to select Edit Hyperlink. edit hyperlink - www.office.com/setup It will instantly open Edit Hyperlink dialog. Under E-mail address box, enter the email address, and from Subject box, write the subject of the mail. Click OK. edit hyperlink 1] - www.office.com/setup Upon clicking on hyperlink, it will immediately open Outlook mail compose window, with specified email address and subject inserted. email open - www.office.co

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

WWW.OFFICE.COM/SETUP BLOGS: OFFICE 2016 OFFERS MANY ENHANCEMENTS THAT INTEGRATE MORE TIGHTLY WITH SHAREPOINT AND ONEDRIVE. IT CAN BE CONFUSING TO KEEP TRACK OF ALL THE FEATURES, SO WE PICK 10 YOU ARE SURE TO LOVE. Collaboration is the key to Microsoft's still-ubiquitous productivity suite. To the casual user, the applications that make upOffice 2016 - Word, Excel, PowerPoint and Outlook are the anchor tenants, of course, rounded out by OneNote, Access and Publisher - will be indistinguishable from their predecessors. But make no mistake about it; Microsoft's reboot of its flagship software suite is a major update, offering a wealth of collaboration capabilities that integrate more tightly with SharePoint and OneDrive than before. The many tweaks and enhancements across the board can be confusing though, and we peek under the hood to highlight the features that matter most. 1. REAL-TIME CO-AUTHORING The capability to work on the same document simultaneously with your colleagues comes to the desktop version of the productivity suite in Office 2016. Colleagues can work on the same Word documents and PowerPoint presentations that are saved on SharePoint or OneDrive without overwriting each other's changes. Note that the "real-time typing" feature in which you can see your colleagues working on the same document is only available in Word for now. PowerPoint supports co-authoring, but without real-time typing. 2. SIMPLIFIED DOCUMENT SHARING You can now easily share your documents in Office 2016, courtesy of a prominent "Share" button in the Ribbon. Available across Word, Excel and PowerPoint, the Share button lets you share access to a document to your team members, and serves as a one-stop location to review access permissions or see who is currently working on the document. As with co-authoring, the files must be saved in either SharePoint or OneDrive in order to be shared. 3. CAPABILITY TO SEND LARGE FILES USING ONEDRIVE While the ability to sha

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

Windows 8.1 has officially been unleashed and has gained the attention of many people. A lot was expected from this operating system, as it promised to fetch some key restructurings. Leaks, rumors, and Microsoft's official Press Releases specified the inclusion and involvement of certain characteristics in this latest version.

In case, you find the need to change the DNS server for your entire network on your router or set it individually on a PC or other device then have a look on this tutorial.