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-

Opening and editing text documents is a daily task for the majority of computer users. Without doubt, the first word processing software that comes to mind is Microsoft Word. Indeed, this text editor is definitely one of a kind and … Continue reading →

Opening and editing text documents is a daily task for the majority of computer users. Without doubt, the first word processing software that comes to mind is Microsoft Word. Indeed, this text editor is definitely one of a kind and … Continue reading →

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

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

I want to share a fantastic little tool that I've only recently come across; Live.js, written by Martin Kool. This JavaScript file automatically checks for changes to your CSS and JavaScript files, and refreshes them. That means you can have your text editor in one half of the screen, and a web browser in the other. When you save changes in the editor, the updates are reflected immediately in your browser. It really helps to speed up your development time. A lot of text editors offer HTML previews and such, but they only work for plain .html pages. The great thing about Live.js is that it works on any webpage, including a working WordPress theme...............(.read more.)

Email marketing and newsletters are a critical part of the marketing plan of many businesses large and small. If you're not already using email marketing for your own business or offering services for your clients, this is certainly an area to explore. One of the aspects of email marketing is the design of the email itself. While text-based emails can be effective in certain industries, most businesses prefer to have a newsletter or email template that will present the message in an attractive way. While most email list managers will offer some free templates and/or a WYSIWYG editor for designing your own email, there may be times when these options don't meet your needs. In these situations your options will be to design and code a custom template on your own, outsource the work, or purchase a template that does meet your needs. Custom designs are often preferred, and for good reason, but they don't always fit within the budget.

Unless you are really HTML-savvy, writing articles directly using HTML is not ideal. First, you have to wrap the content properly with the tags in order to format it, and secondly you will have to go back and forth from your code editor to the browser to see how it looks. If you are a frequent web writer, I think it's better for you to write using Markdown. Markdown allows you to write content in plain text that later can be translated into a valid HTML format, and with the help of a tool, you can instantly see the output.

With the Magento 2 FAQ, you can make the FAQ section easily accessible to customers by prominently placing links to it on your website. Incorporate it into the main navigation or footer, ensuring that customers can easily find it whenever they have questions. Additionally, consider linking relevant FAQ answers within product descriptions or the checkout process for added convenience.

Magento 2 FAQ Plugin has jQuery-powered animation for displaying FAQs and also Rich text editor for adding answers. Magento 2 FAQ Module allows the admin can create multiple FAQ groups that can be published on different storefront pages.