Group items tagged

Videos of the Office 15-Minute Webinars are available in new apps for Windows 8 and Windows Phone 8. These videos can help you get the most out of Word, Excel, Outlook, OneNote, PowerPoint, and other Office applications. Watch on your phone or Windows 8 computer, or use the app as a second screen as you follow the steps in the demo on your main screen. So now you have another option to view past Office Webinars in addition to the Office Blog, Office YouTube channel, or joining live-plus participate in the live Q&A session-every Tuesday at http://aka.ms/offweb. Windows 8 App Windows Phone 8 App Or just search for "Office Webinars" next time your are at the Windows Store. -Doug Thomas

Ever wish Word had an encyclopedia you could tap, or Excel could generate some dummy numbers? Office add-ins provide this kind of added functionality to Word, Excel, PowerPoint, and other Microsoft Office apps. Here are some of the handiest add-ins you can install for Office 2013 and above to get more out of your office suite. We previously highlighted Office add-ins and apps for Office 2013 and earlier, but since then Microsoft has renamed "Office Apps" to "Office Add-ins". Now there are more than a handful of these plugins you can install to enhance Microsoft Office, whether you're using Office 2013 or 2016, Office Online, or Office on the iPad.

A teacher would never be satisfied with her performance if she discovered that the entire back row of her classroom was unable to hear her lecture. In the world of cloud services for business, we see things the same way. With Office 365, every user counts! Google has a different approach. It starts counting downtime only after at least 5 percent of users are affected. Imagine if 100 of your 2,000 users had no access to email. Would you, as an IT professional, be satisfied with your performance? Would your business hold you accountable for your performance? The answers to these questions are clear. Calculating downtime only after 5 percent of your users cannot access email, as Google does, makes it more difficult for you to assess impact to user productivity. Google's approach doesn't help your business with meaningful performance metrics. With Office 365, every affected customer and every service counts when we calculate downtime. Downtime means the total minutes in a month during which service is unavailable, excluding scheduled downtime. For services like email, there is no scheduled downtime, an experience that our many Exchange Server customers have long been accustomed to-system maintenance while they continue to be productive in their Outlook inboxes. In addition to the way it calculates downtime, Google also combines consumer and commercial service availability when reporting the availability of Gmail. This means if you are considering Google Apps for Business, you cannot get accurate information regarding the availability of the commercial service that you need. On the other hand, Microsoft's approach to calculating downtime, which includes every user minute, helps you understand whether your users' productivity is being impacted by downtime of email. Google takes a "use at your risk" approach around Google+, Hangout and Google Voice. These services are not part of Google Apps for Business and are excluded from the SLA. Excluding these serv

Believe it or not, proficiency in Microsoft Word ranks among the top 20 skills required for positions that have the highest growth and wage potential between now and 20201. This finding is part of an extensive IDC study, which also found that core skills such as communication and presentation will be in high demand among employers regardless of industry. That said, being just so-so at Microsoft Word won't boost your chances at landing a high-paying job or at getting promoted. To become more productive, more efficient, or more creative at using Microsoft Word, you can check out and unleash dozens of add-ins that are designed to augment Word's already powerful features. So here's a list which includes more than 50 of the best Microsoft Word add-ins to get you started.

Today's post was written by Jacob Guttman, IT Manager, Menchies It's hard to believe it when you look at our rapid growth, but Menchies is still a very young company. We were founded in 2007 with a single store in Valley Village, California. Now, we have more than 300 franchise locations around the world. Maintaining connections between Menchies headquarters, the franchise community, and our guests is critical to our success. In the past, we used hosted services for email, collaboration, and document management. And we used a separate, Java-based application for instant messaging. One of the most persistent challenges I faced was trying to support our company's growth with a set of applications that weren't tightly linked together and that didn't fit the day-to-day work needs of our employees. An increasing number of our employees want to be able to access email and other applications on a range of different devices, including their smartphone or tablet. Ultimately, they want to be able to connect with colleagues and seamlessly move information between applications without having to think much about the underlying technology. When we started looking at moving to a new productivity and collaboration solution, the major factors influencing our decision were ease of use, anywhere access, simplified administration, and cost-effective scalability. As we took a closer look at Microsoft Office 365, it was the obvious choice. And, with help from our partner Cal Net Technology Group, we were able to make the switch to Office 365 quickly and easily. With Office 365, we get online access to all of the capabilities we need-email, calendaring, document management, and unified communications-all rolled into one solution. And it automatically works together with the Microsoft Office tools that our employees use every day. One great example of how Office 365 supports the business needs of Menchies and fits the way our people like to work is through our use of Micro

Last week, we welcomed Brian Solis, Altimeter principal analyst, thought leader and book author, to Yammer HQ to give a fireside chat, followed by signing of his new book: "What's The Future of Business?" I was thrilled to interview Brian, and we covered a variety of really meaty subjects - just check out the video below! The theme of the evening was transformation - transformation that is happening in our lives as individuals, how we relate to each other through technology and what we as businesses must do to stay relevant to the connected customer. Even the book itself is transformation of the book publishing convention. Unlike a regular, information-dense business book, "What's the Future of Business" attempts to bring together the best of both worlds: hard-hitting facts and practical frameworks, as well as a visual experience. The experience of the book is just as important as the content therein. What is the future of business? The future of business is experience, according to Solis. We as connected consumers make decisions outside of the sales funnel that companies have organized themselves around. We reference experiences of consumers who came before us, and contribute our own experiences to this dynamic tapestry. When consumers share, they are reacting to an experience, and the future of any business depends on its ability to provide experiences that are worth sharing. In his talk, Brian talked about the 4 moments of truth that add up to shareable experiences. At every stage of the customer journey, it is our job as businesses to design an experience to trigger the sharing of a moment. The Zero Moment of Truth comes when the consumer is starting to explore choices and is just becoming aware of needs and possible solutions. 1st Moment of Truth happens when the consumer is ready to buy. Consumer packaged goods companies have perfected providing the right experience at this point. 2nd Moment of Truth happens after the consumer purchases,

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.

In order to be taken seriously, small businesses need to convince customers of their professional ability and their value. Small businesses can punch above their weight by taking the time to go to market with a professional set of business documents, templates and content to ensure customers aren't dismissing them before they have a chance to pitch the value of their product or service. But how can small businesses deliver a professional image when they don't have the same resources as big businesses? Web-based solutions, also known as 'cloud solutions,' help small businesses maintain professional-looking documents even while collaborating and editing with employees in real-time from different locations. Gone are the days where employees hoped documents maintained proper spacing and margins; small businesses can now create materials in confidence and showcase their professional ability to customers. Below are just a few of the ways small businesses can ensure they are maintaining a professional appearance when it comes to the business communications: MAKE THE FIRST IMPRESSION A PROFESSIONAL ONE An email newsletter is often a small business' first connection with a potential customer; they can keep it professional by registering a business email domain (johndoe@yourbusiness.com) and sending all communications to customers and potential customers from there. Most cloud solutions offer a cost-efficient and easy way to customize emails with basic client information - small businesses should take the time to add a personal touch to connect with their customers. Messages should be short and to the point to ensure their email will bring value to potential customers. Email signatures should be simple, clean and professional, and employees shouldn't forget to run a spell-check before hitting send. CREATE CUSTOMER-READY DOCUMENTS Whether creating documents on an office desktop or on-the-go on a mobile or tablet device through Office Mobile Apps in Office 3

This episode marks the first in a three part series, as hosts Jeremy Chapman and Yoni Kirsh go deeper on automating the new Office for your organization. Watch as they reveal the second XStream install of the season, as host and pilot Yoni attempts an Office 365 ProPlus install, with no Internet access, while performing outrageously high-G aerobatics.

Small businesses have enough to focus on without having to spend time and energy worrying about email, data storage or backup servers. In fact, most small businesses don't know or understand what a server is. The good news is that in today's technology environment, they don't need to. This is because more small businesses are rapidly moving from outdated technology solutions to Web-based solutions to power their company, also known as "moving to the cloud." By moving to cloud solutions like Office 365, small businesses find they can concentrate their resources on growing their business rather than trying to solve technical issues. Large enterprises typically have entire divisions dedicated to supporting and keeping their IT infrastructure up and running. Even though small businesses don't have this luxury, they can still punch above their weight by choosing the enterprise-grade IT services in Office 365 to help solve their most top-of-mind business challenges.

We're excited to announce a major upgrade for our Outlook.com app for Android devices that overhauls the entire user interface and provides a number of new features. You can get the latest app here. www.office.com/setup We believe that the best mobile experience is enabled through Exchange ActiveSync-which provides a rich, powerful, network-optimized experience for Windows Phone, iOS and other mobile devices. However, native support for Exchange ActiveSync on Android devices varies significantly and so we build a separate app to ensure as many people as possible can have a great Outlook.com experience across all their devices. As you've heard us talk about previously, the overall response to Outlook.com has been very positive. However, our Android app has been behind and so we're excited to take this large step forward. Starting today, you can get the same great Outlook.com look and feel you've come to love on Windows 8 and the web on your Android device.

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

May's Customer of the Month is Melanie Hohertz, Online Communications Lead, Cargill. I've been supporting Yammer as a work platform for Cargill for almost a year. We're early in our adoption, but it's been an amazing experience. I am learning, daily, how Yammer can change the way people and teams work and add value in a company that is more than 140,000 strong and spread throughout 65 countries. Our network will pass 10,000 members soon and already, you can't stump us on anything. From food to agriculture to financial and industrial products and services, Yammer is helping Cargill use what Cargill knows, and that's a lot. Yammer can connect people across silos based on organization, geography and hierarchy. I've seen customer reps talking directly to product management, and senior leaders listening to recently-hired employees. We have new ways to realize the power of our communities of practice to speed up ideation and action. Sure, we still have a long road ahead before Yammer is as ubiquitous and instinctive as e-mail, but we throw a heck of a YamJam, and the signal-to-noise ratio in our network is beautiful.

Guest blogger Emily Warn is co-owner of Two Pens, which provides blogging services and teaches business how to write content that grows a social media following. My writer friends think I'm a geek. You can do what?! I can create a spreadsheet with book sales numbers that can be sorted by name and number. I know that is only the first rung of Excel Geek-dom, and unlike my compatriots, I aspire to climb into the ranks of those who know how to create snazzy charts and perform other formatting feats. Perhaps I'll be able to brand myself as a writer who plays with numbers.

Ready to get a hands-on, in-person learning experience on how Microsoft Project can help you get more out of your projects and optimize your portfolio? Microsoft and our partner community host events in cities all around the U.S. where you'll have the opportunity to learn more about Project and what it can do to help you streamline your work and achieve your strategic objectives. Please add this page to your Favorites and check back often, as new events are regularly being scheduled! May 30th Cambridge, MA Conference 2014 Roadshow with Project Gold Certified PPM Partner Campana & Schott. Join us for these free half-day events to gain insight on current trends and the latest developments on Project Online and earn 3 PDUs. Registration link You can also register here to attend our free Project webcast series-sessions are held on the 3rd Tuesday of each month!

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

The concept of a 'physical office' as a small business hub of productivity is quickly being replaced by the connected 'mobile office,' which connects employees wherever they happen to be. Today's business landscape favors those who are nimble and able to adapt rapidly by collaborating on the go, sharing ideas quickly and anticipating customer needs. Luckily, small businesses today can achieve this dynamic work environment through the use of Web-based software available for both desktop and mobile platforms. Web-based software is known as 'cloud services' or as 'the cloud' for short. Today, small businesses have access to IT solutions that were previously only available to enterprises - allowing them to punch above their weight class and better compete in their industry. By taking advantage of these Web-based and mobile solutions, small businesses can effectively run their company from anywhere - even from a mobile device or tablet. Here are just a few of the ways technology can help small businesses overcome everyday business challenges: ELIMINATE THE NEED FOR A PHYSICAL OFFICE Starting a business is difficult. Many small businesses owners may not have the capital to lease office space, or they may be hiring friends and staff who aren't based in the same city. Modern cloud technology can unify small business teams, removing the need for a physical office space. WORK WHEREVER IT'S CONVENIENT Cloud services let employees set up a shared folder from a mobile device while taking the bus; create a new spreadsheet on a tablet at lunch; get a presentation from the company's shared drive and make edits from a friend's computer; or schedule a team meeting from a home computer. Office 365 can be installed on up to 5 devices, giving small businesses the ability to do more than just read documents from a mobile device, a tablet, a laptop or even a desktop* by extending the office experience to employees wherever and whenever they need to cond

We're bringing Yammer to a city near you with Yammer on Tour-a free event series that brings together customers, partners and thought leaders for a unique opportunity to hear our vision for enterprise social, network with like-minded peers, and learn directly from customers how to usher in success in today's rapidly changing business environment. Yammer on Tour features an action-packed half-day agenda including: Keynotes and appearances by Yammer co-founder Adam Pisoni and customers Breakout sessions featuring product insights and expert discussions on enterprise social success Hands-on training and certification Networking and demos from Yammer and our partners in the expo hall Join us at Yammer on Tour in the following cities: New York-April 9: Register today Chicago-April 16: Register today Dallas-May 15: Registration opening soon We look forward to seeing you at one of these events!

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

Remember the vintage game "Pull the Rug Out?" It is a board game where players stack different items on top of a rug. Eventually, one of the players tries to pull out the rug without tumbling the pieces stacked on top of it. Google's recent announcement that it is phasing out several additional services, including the highly popular Google Reader, reminded me of this game, as I recall that the stack most always toppled to the ground. Google introduced Google Reader, gradually built up its popularity, and then pulled the rug out with little warning, causing its customers to stumble. As one Google customer put it: "Google spends millions of wasted dollars on pet projects, then kills one of their best products on a whim." Google's most recent spring cleaning brings the total number of services it has discontinued to 70 in just a year-and-a-half. That's right-a whopping 70 services that have been shut down in just 18 months. Among the services Google will discontinue with little warning is Google Cloud Connect, introduced with a lot of fanfare just two years ago. Cloud Connect is a plug-in that enables Google users to share and edit Microsoft Word, PowerPoint and Excel files. To continue collaborating with Microsoft Office, Google users have just four weeks to uninstall Cloud Connect and install Google Drive. Companies that can't get to it by April 30 will be out of luck, leaving them without a way to collaborate on Office documents used by millions of employees, partners, and customers. But of all the services Google is discontinuing this time, the one that's drawing the biggest backlash is Google Reader, a service used by hundreds of thousands of users to keep track of their favorite websites and blogs via RSS feeds. The news of Google Reader's shut down drew outrage from users, who put together a petition demanding that Google reinstate the service. "Our confidence in Google's other products - Gmail, YouTube, and yes, even Plus - requ