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: A cut over migration is the simplest way to get all your existing email into Office 365. As the name implies, it's a cutover from one service to another. Cutover migrations are supported for Exchange 2003, 2007 and 2010; for organizations with fewer than 1000 mailboxes. The setup and process is straight forward and nothing complicated. With any successful migration, some planning and testing of existing infrastructure is invaluable. Make sure that you plan and test the migration prior to trying to implement. PLANNING Before we can attempt the migration, we need to know what we are going. Microsoft has done a great job of providing good quality information for administrators to use, to plan the migration to Office 365. I always use the Exchange Deployment Assistant as a guide for all my migrations. This site is up to date and will cover most of all the migrations scenarios to Office 365 Open the Exchange Deployment Assistant site Once the site is launched, you are presented three options. Since I am doing a simple cutover migration from Exchange Server 2003, I am going to use the Cloud Only option Click Cloud Only www.office.com/setup Blogs You are now asked a series of questions on end state goals and existing setup www.office.com/setup Answer all the questions Click the next arrow The Exchange Deployment Assistant will generate a step by step guide for you to follow. Make sure to read and understand what you are doing. www.office.com/setup TESTING EXISTING SETUP Using our guide from the Exchange Deployment Assistant, we need to make sure that our Exchange 2003 infrastructure supports RPC over HTTP and Outlook Anywhere. Use the guide to verify the Exchange 2003 setup. Once the setup is verified to be correct, use the Microsoft Remote Connectivity Analyzer to verify RPC over HTTP and Outlook Anywhere. Open the Microsoft Remote Connectivity Analyzer site Select the Outlook Anywhere (RPC over HTTP) test www.of

Harbinger Knowledge Products at the Learning Technologies. This time around, there were a total of around 220 exhibitors and over 120 seminars. The total number of delegates attending the conference was above 5000 which is huge. That was evident to show why this event is known as one of the largest e-learning events in Europe.

a kindle author talking about writing, about his dragon related research, about his own two real live monsters, about hostile intelligent robots and about life itself.

If you had the choice between reading through a training module or playing a game to learn the same concepts, which would you choose? Most of us would choose game-based learning hands-down over traditional training. Why? It's more fun!

Information about the red equal sign seen all over facebook and twitter, what is the red equal sign.

By now you have probably seen or heard about the pink equal sign with the red background otherwise known as the "Red Equal Sign" but you may be wondering what exactly it is. Have you noticed the Red Equal Sign all over Twitter and Facebook recently?

"Handset makers and wireless carriers love to load up Google's Android platform with custom overlays, user interface tweaks, and third-party programs that don't ship natively with the open source operating system. That's great for them, but most power users would prefer a clean version of Android to work with, which is why the third-party ROM community is popular. Well, following in the footsteps of Samsung and it's custom S4 that was announced at Google I/O, HTC is reportedly kicking around the idea of offering a Google Edition of its One smartphone. News of the custom HTC One comes from Russell Holly over at Geek.com. Citing un-named sources, Holly says the Google Edition device would be offered in the U.S. first, though it's unclear if it would be carried in the Play Store like the Galaxy S4 will be. Other details are equally light and vague, though Holly claims an official announcement could come within the next two weeks, with a release likely planned for sometime this summer." By-The Xpert Crew @ http://techvedic.com https://www.facebook.com/techvedicinc https://twitter.com/techvedicinc http://pinterest.com/techvedic1 http://techvedicinc.tumblr.com/ https://plus.google.com/u/0/110467075169904075419/

While it becomes impossible to live without your iPhone 4S, you must be a bit worried about the habit of the gadget eating up all the battery at inopportune times.there are still some vital tips and tricks you can follow to improve your Smartphones battery life. Low Down The Screen Brightness Just as it goes for your laptop devices, you need to lower down the brightness of your iPhone screen, which will enhance the battery life. Adjust the screen brightness under the Settings tab. Make Use of Wi-Fi When You Can Instead of making Voice calls, downloading apps or browsing the Web over your iPhone 3G or cellular connection, it is recommended to always find a Wifi hotspot or make use of your home network. This will help you keep away not only from data charges but also will aid you have a better battery life as your device will not be searching for the data signals. Remember, if you are in an area where there is no Wi-Fi hotspot, it is better to turn off the search and it will help save the battery life of your iPhone 4S. Do Not Use The GPS Tracking Feature If you are using apps that support the feature of Automatic GPS tagging and location such as Twitter, Instagram and Facebook, your iPhone is working overtime to determine your location. If you do not want to be Geo-tag your updates and posts, must keep the GPS function off. Do Not Use The 'Fetch' & 'Push' feature If you have your iPhone 4S set to 'fetch' the data after every 30 minutes time along with numerous apps to push new alerts and messages as they happen, then you need to turn off this feature on your device. This feature is going to drain your battery. Only use the facility when you really need it otherwise keep it off. Keep Your Notifications In Check To enhance your iPhone 4S battery time, you need to limit your app notifications to just the apps you make use of more often. This actually means that you have to say 'no' to the requests for all kinds of notifications you ge

Would you like to get more power over your life, control over stress, recreate magic in relationships, and achieve more success than ever before ? Think how it would feel as your hear and see yourself achieving admiration of people around you and being a winner !!

The Raptivity team recently presented at a technology event for educators at University of Pune, Maharashtra, India. The presentation was titled 'Innovative Ideas for Making Learning Interactive'. It aimed at showcasing different creative ideas and ways of making learning fun and interactive. Over 65 senior educators from across Maharashtra region attended the session.

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences. Go to the Insert tab and click Table. insert table - www.office.com/setup Mouse over the squares in the table grid to select the number of columns and rows you want in the table. Click on the last square to insert the table. Word will now switch you to the Design tab for formatting the table. Click inside the table. Select a style from the Table Styles gallery and take note of the style name. You'll need the name in the steps below. table style - www.office.com/setup table style gallery - www.office.com/setup Click the down arrow next to the Table Styles and select New Table Style. table style new - www.office.com/setup Give this table style a new name. table style create - www.office.com/setup Select the table style you want to base yours on in the dropdown box next to "Style based on" option. table style create select - www.office.com/setup Select your formatting options. For example, you can change the font and font style, change the border and cell colors, and change the text alignment. table style options - www.office.com/setup For additional formatting options, click the Format button at the bottom left of the window. table style format - www.office.com/setup Select "New documents based on this template" so the table style will be available in future Word docs. table style newdocs - www.office.com/setup11. Click OK.

When FHI 360 wanted to move to cloud-based business productivity services, the organization decided to implement a Microsoft cloud-based solution. We recently spoke to Douglas Wilkins, Director of IT Infrastructure at FHI 360, to learn how the company is benefiting: FHI360 logoQ: Please tell us about FHI 360. Douglas Wilkins: FHI 360 is a nonprofit human development organization dedicated to improving lives in lasting ways by advancing integrated, locally driven solutions. Our staff includes experts in health, education, nutrition, environment, economic development, civil society, gender equality, youth, research, technology, communication, and social marketing-creating a unique mix of capabilities to address today's interrelated development challenges. FHI 360 serves more than 60 countries and all US states and territories. Q: Why did you want to move to cloud-based services for messaging and collaboration? Wilkins: We had a diverse IT infrastructure. Employees in the US had different IT toolsets and Internet access than staff in countries like Mozambique. Subscribing employees to a single, cloud-based solution was the most expedient way to ensure that everyone had the same IT tools, to work efficiently regardless of location. Migrating our communication and collaboration technologies to the cloud reduced much of the time required by our IT staff to manage divergent IT infrastructures and connectivity options found around the world. Q: What criteria did you use to select Microsoft as your vendor for cloud-based business productivity services? Wilkins: We wanted a vendor that demonstrated a real interest in our mission and goals, and that offered online business productivity tools tailored for the enterprise space. The capabilities of the Microsoft Services Consulting team, and the work of Intellinet, the partner Microsoft introduced us to, provided us with that. We migrated our 4,300 staff members around the world from diverse platforms to a Microsoft Offi

If you've got a really killer PowerPoint presentation but would like to extract all the information to Microsoft Word - you can. Sometimes this is necessary because the size of your PowerPoint presentation is rather large and you would like to share it with others over email or an intranet. Converting it to Word will help reduce the size and make it easier to view for everyone involved. It's also possible that you would like your slides presented as thumbnails, with or without speaker notes included, for easier reviewing, editing, or handing out during the presentation itself. You can convert your presentation in one of three ways.

Every couple weeks, we round up industry news and articles you might have missed. We hope you enjoy our latest selections. Microsoft: Office 365 Cloud Now $1 Billion Business. Office 365 is now a $1 billion business; one in every four enterprise customers now have cloud seats with Microsoft. Office 365 Review. Office 365 "is still the best productivity suite on the market." Its comprehensiveness and the ability to stream a full version of programs give it the edge over Google Apps. What's New in Lync Server 2013. The enhancements to Lync Server 2013 "make Lync 2013 easier and more intuitive to use compared with previous editions." Microsoft Introduces Two-Step Verification for Microsoft Accounts. Microsoft rolls out an optional two-factor authentication service to improve security across all of its accounts. Outlook.com to Support 32 New International Domains and Alias Sign In. Outlook.com will be updated to include support for 32 additional international domains, allowing users to select a mail address in their preferred region. New Microsoft Privacy Campaign Promotes Consumer Control. Microsoft launches privacy campaign that includes privacy education resources on its website and a quiz that consumers can take to find out their "privacy type" and learn how to manage privacy settings. Intel, Microsoft Top Clean Energy Ranking. Microsoft and Intel use the most clean energy to power their U.S. operations, according to a list developed by the EPA's Green Power Partnership.

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

Today's post was written by Howard Kourik, Director, Information Systems, San Diego County Regional Airport Authority The San Diego County Regional Airport Authority manages operations at one of Southern California's busiest regional airports, San Diego International. We were created to serve the public and have a mandate from the state of California to address the local area's long-term transportation needs. While we are a public entity, we function very much like any other business. In fact, we don't accept any tax dollars to support our operations. Instead, we rely on landing fees, the rent we receive from tenants, and a percentage of the profits from concessions-the restaurants, newsstands, and other shops located in the airport-to fund our growth. And like every business, we're constantly looking for ways to bring down our costs by operating more efficiently. We evaluated a lot of technologies to help us trim costs, but we selected Office 365 because it not only saves money, it gives us what we need to meet future IT demands. With our eyes on current and future needs, we did some modeling to gauge regional demand for our airport services over the next decade. It quickly became clear that we needed to add runways, terminals, and other "bricks and mortar" facilities, and upgrade our network infrastructure. Still, the only way we could budget for that expansion was to reduce or eliminate some of our fixed capital costs. I knew that one important way we could trim expenses was by taking a closer look at the technology we use and how we manage it. Our email system offered a prime example of how, by rethinking the way we deliver core IT services, we could cut down on operational "drag" and potentially save our IT team lots of time. Historically, we've managed our email in a clustered environment across four physical servers. So, we were not only worrying about the cost of the servers; we had to invest in mirroring software and an antivirus so

As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address. OPTIONAL TWO-STEP VERIFICATION HELPS KEEP YOU MORE SECURE You can now choose to enable two-step verification for your entire account. Two-step verification is when we ask you for two pieces of information when you sign in to your account-your password plus a code sent to a phone or email that you gave us as security info. Many of you have asked for this and we're delighted to be able to offer this capability. Two-step verification is a great way to add extra protection to your account. Once you've enabled two-step verification, even if a criminal gets your password (for example, through malware on a friend's machine that you used, or if you use the same password for another service that gets breached) they can't access your account. You can read more about two-step verification here, or just start setting it up at https://account.live.com/proofs/Manage -it only takes a few minutes. SIGN IN WITH ANY ALIAS ON YOUR ACCOUNT We've heard from a lot of you that you love using Outlook.com but you wish you had more flexibility signing in. Many of you have added an email alias to your account, but you can't use the alias to sign in to your account. Previously the only option was to permanently rename your account, which is a hassle and requires you to reset certain devices. With this release, you can now sign in with any alias that has been added to your account. We've also simplified the experience of adding and managing aliases, with better advice on when you should add an alias vs. renaming your primary alias.