Group items tagged

A since deceased, highly-regarded fellow faculty member, Anthony (Tony) Athos, occasionally sat on a bench on a nice day at the Harvard Business School, apparently staring off into space. When asked what he was doing, ever the iconoclast, he would say, "Nothing." His colleagues, trained to admire and teach action, would walk away shaking their heads and asking each other, "Is he alright?" It is perhaps no coincidence that Tony often came up with some of the most profound insights at faculty meetings and informal gatherings. This story captures much of the sense of the responses to this month's question about why managers don't think deeply. The list of causes was much longer than the list of proposed responses. But in the process, some other questions were posed. Ben Kirk kicked off the list of reasons for the phenomenon when he commented, "… what rises to the top levels are very productive and very diligent individuals who tend not to … reflect and are extremely efficient at deploying other people's ideas," implying that this type of leader is not likely to understand, encourage, or recognize deep thinking in others. Adnan Younis added the possibility that "… managers are not trained for it." Dianne Jacobs cited the possibility that persisting assumptions borne out of success serve as "roadblocks to act on needed change" (proposed by those who engage in deep thinking?). Ulysses U. Pardey, whose comment triggered my recollection of Tony Athos, wrote that "Time-for-thinking is a special moment which can be resource consuming and an unsafe activity …" (Fortunately, Athos held a tenured position in an academic organization.) A number of comments alluded to the triumph of bureaucracies and large organizations over deep thinking. As Lorre Zuppan said, "I think Jeff Immelt's efforts to protect deep thinking reflect a nice sentiment but … If his team could carry the ball, would he need to announce that he's protecting it?" Tom Henkel was more succinct: "Ther

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

While we are lucky enough to work with extremely innovative clients that are eager to embrace the latest technology, we always advise them not to adopt the latest version of software until after the kinks are worked out. For a consumer it's not a big deal to be test driving new features and experimenting with the latest version. For a business user, if there's a bit of a learning curve, buggy features or errors that make an application crash, it can be a huge detriment to productivity. That's why we take a lot of time testing out new applications and operating systems before we encourage our clients to adopt them. You may have read that Microsoft recently unveiled Office 2016. We spent some time with it and have some mixed feedback for our business users. Here's the good, bad and the ugly surrounding the Office 2016 suite: The Good: Built to make business better. Word is probably our favorite when it comes to the new suite of products. While there has been minimal change to formatting and structure - the overall design has definitely gotten a facelift. We're all about function, though and when it comes to function we see definite improvements. Word has many more templates. This allows businesses to refine their documents and be more professional without having to go online and download templates to use inside Word. There are also some pretty awesome co-authoring features that we wrote about in this blog. Attachments in Outlook reference recent documents. This is a great feature since it's available on any device that you use Office on. You can easily attach documents in e-mails in Outlook or reference them in an e-mail on your phone. This is really valuable for mobile users or users that work from more than one machine. (Which, lets face is, 90% of the workforce these days does.) OneDrive is also attempting to make its way into the life of business users by making sharing documents, collaborating on documents and authoring documents across devices a l

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: MS Office 2013 was the Microsoft Office version released in 2012 and was more popular than the Office 2010 version. Later Microsoft released Office 365 and the latest Microsoft Office 2016 for the Windows users. Even though, these tools either come pre-installed with Windows OS or the users have to purchase them online, Office has been the most popular Office suite until now. There is no other Office suite available as of now which can take the crown from Microsoft Office. Microsoft Office 2007 - 2010 - 2013 and the Office 2016 didn't have any major errors, but a minor yet frustrating Office error is "Something went wrong error" in Office 2013 and 2016. The "Something went wrong" error is common among Microsoft Office 2013 and 2016 users, but the fix for them may vary depending on the problem. Therefore, in today's post, I will show you how to fix something went wrong errors in Office 2013 - 2016. Fix Something Went Wrong Errors in Office 2013 - 2016 - 365 in Windows 10 - www.office.com/setup FIX SOMETHING WENT WRONG ERRORS IN OFFICE 2013/2016 Note: This guide is written for Windows 10 users. But, you can try these fixes on Windows 7, 8 and Windows 8.1 running machines as well. As I said earlier; the "Something went wrong error in Office 2013" may occur due to several reasons and at a different point. Some users face the "something went wrong error" while installing Office 2013 or the Office 2016, but some may come across this error while restarting Microsoft Office. There are other few reasons and fixes for them that I will discuss later in the article. Advertisement So, if you are facing the "Something went wrong error" in Office 2013 or Office 2016 then make sure you read the error description before proceeding with the fixes. Click on any of these something went wrong error link to jump to the fix section. Fix something went Wrong Error 1058-13 Fix Something Went Wrong Error While Installing Office

www.office.com/setup Blogs: PowerPoint allows you to insert a video onto a slide and play it during your presentation. This is a great way to make your presentation more engaging for your audience. You can even edit the video within PowerPoint and customize its appearance. For example, you can trim the video's length, add a fade in, and much more. Optional: Download our practice presentation. Watch the video below to learn more about inserting videos in PowerPoint. TO INSERT A VIDEO FROM A FILE: In our example, we'll insert a video from a file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example video and save it to your computer. From the Insert tab, click the Video drop-down arrow, then select Video on My PC. Inserting a video from a file - www.office.com/setup Locate and select the desired video file, then click Insert. Selecting a video to insert - www.office.com/setup The video will be added to the slide. The inserted video - www.office.com/setup With the Screen Recording feature on the Insert tab, you can create a video of anything you are doing on your computer and insert it into a slide. the Screen Recording button on the Insert tab - www.office.com/setup TO INSERT AN ONLINE VIDEO: Some websites-like YouTube-allow you to embed videos into your slides. An embedded video will still be hosted on its original website, meaning the video itself won't be added to your file. Embedding can be a convenient way to reduce the file size of your presentation, but you'll also need to be connected to the Internet for the video to play. Inserting an online video - www.office.com/setup WORKING WITH VIDEOS TO PREVIEW A VIDEO: Click a video to select it. Click the Play/Pause button below the video. The video will begin playing, and the timeline next to the Play/Pause button will advance. The Play/Pause button and the timeline - www.office.com/setup To jump to a different part of the video, click anywhe

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

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

Adata is clearly making a fashion statement with the redesigned heatspreaders it slapped onto its new XPG V2 series of DRAM products designed for 3rd Generation Intel Core processors and the Z87 platform. While beauty might be in the eye of the beholder, performance is in the hands of the designer and Adata's binning process. The new modules will come in dual-channel kits of 8GB and 16GB ranging in frequency from 1600MHz to 2800MHz. The highest frequency kits (8GB and 16GB DDR3-2800) will run at CL12-14-14-36 with 1.65V, while the rest are rated slightly tighter at CL11-13-13-35 at either 1.65V or 1.5V, depending on the kit. By-The Xpert Crew @ http://techvedic.com https://www.facebook.com/techvedicinc https://twitter.com/techvedicinc http://pinterest.com/techvedic1 http://techvedicinc.tumblr.com/

WWW.OFFICE.COM/SETUP BLOGS: FREE RESOURCES FOR LEARNING OFFICE FOR MAC www.office.com/setup Blogs: Our Microsoft Office tutorials are some of the most popular courses we offer. These tutorials, however, are designed for those using Office on computers with Microsoft Windows, so perhaps it's no surprise that we frequently hear from learners who want to know why we don't offer tutorials on Office for Mac. While Office for Mac shares a lot of functionality with the Windows version, its interface and design are different enough that we would need to create entirely new courses. Image of Office for Mac 2011 Product Box - www.office.com/setup With our small staff, it would be a real challenge to produce the same kind of detailed tutorials for the Mac-friendly Office we provide for the Windows version. We may consider adding some type of Office for Mac tutorial in the future, but for now we'd like to share a number of excellent-and mostly free!-resources that can help you learn how to use Office for Mac. Office 2016 for Mac is very similar to the Windows version. So if you have Office 2016 for Mac, check out our Office 2016 tutorial. FREE OFFICE FOR MAC TUTORIALS If you're using Office for Mac, the Office for Mac team has provided great series of tutorials and how-to guides to help you get started and even learn advanced skills: If you're just getting started, check out the Office 2016 for Mac Quick Start Guides, which provide an overview of each Office for Mac product. If you're looking for even more, the Office for Mac Blog and YouTube channel provide the latest news and step-by-step videos to guide you through. If you're using an earlier version of Office for Mac, check out the video below from the Office for Mac team on the Word 2011 Interface. Of course, you can also find help on the Microsoft Office for Mac Support page from the Office community and support team. If you need additional support, you might consider purchasing a subscription to Lynda.com to

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

Part of the thrill of working for the Office Division is the opportunity to tackle thorny business issues on behalf of our customers while providing them with a road map for the future. That may be why an interesting article caught my attention this week. In it, the author examined some of the investments Microsoft is making in the unified communications space. While I didn't agree with all of the conclusions it contained, the article certainly underscored the interest in communications and collaboration and how to make people more productive. Communicating and collaborating with others is really at the heart of what we do every day. Whether at work or at home, people have the need to make meaningful connections with one another. Compounding that need are the realities of the world we live in where instant access to information is expected, friends and coworkers are scattered across geographies and many adults are juggling multiple mobile devices. At Microsoft, we believe technology isn't the problem to these complexities, it's the answer. We're committed to providing capabilities that help people make sense of it all and to do so in a way that is intuitive, barrier free and agnostic to the devices on which we rely. We're incredibly proud of the fact that our long term-term vision for communications and collaboration not only marries the best of the cloud and the desktop, it's a holistic approach that spans "from the living room to the boardroom" placing people at the center of everything we do. Our communication and collaboration vision comes to life utilizing client and cloud assets, including Lync, Skype, Yammer, Outlook and SharePoint. These tools are enabling enterprise social capabilities, HD video conferencing and document collaboration as part of a highly secured, reliable and extensible platform. At the risk of looking geeky, I have to admit that I have a soft spot for Lync and it's comforting to know I'm not alone. More than 90% of

Liam Bastick has provided financial modelling services and training to clients for more than two decades. A senior accountant and professional mathematician, he has worked in numerous countries with many internationally recognized clients, providing and reviewing strategic and operational models for various key business assignments. You can check out Liam's previous articles at www.sumproduct.com/thought, where you can also subscribe to the monthly tips and tricks newsletter. Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? This article provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems. The functionality is best explained by walking through an example: Ivana: Car Sales has four divisions, cunningly called North, South, East and West. Each quarter, the four divisions are required to submit sales reports detailing the month of sale, the sales person, the car color and the price the car was sold for. www.office.com/setup The question is: how can you determine how many red cars Charlie sold in February in total across all four divisions? The answer would be fairly straightforward if the data were all on one worksheet. For a single criterion, SUMIF would cope admirably well, while for several criteria, SUMPRODUCT could be used to generate the answer (for further information see my blog posts on the SUMPRODUCT function and approaches to addressing multiple criteria in one worksheet).

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several options that let you design and run queries that return exactly the information you're looking for. For instance, what if you need to find out how many of something exists within your database? Or what if you would like your query results to automatically be sorted a certain way? If you know how to use query options in Access, you can design almost any query you want. In this lesson, you'll learn how to modify and sort your queries within Query Design view, as well as how to use the Totals function to create a query that can perform calculations with your data. You'll also learn about additional query-building options offered in Access. 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 modifying queries. MODIFYING QUERIES Access offers several options for making your queries work better for you. In addition to modifying your query criteria and joins after you build your queries, you can choose to sort and hide fields in your query results. TO MODIFY YOUR QUERY: When you open an existing query in Access, it is displayed in Datasheet view, meaning you will see your query results in a table. To modify your query, you must enter Design view, the view you used when creating it. There are two ways to switch to Design view: On the Home tab of the Ribbon, click the View command. Select Design View from the drop-down menu that appears. Switching to Design View with the View command on the Ribbon - www.office.com/setup In the bottom-right corner of your Access window, locate the small view icons. Click the Design View icon, which is the icon farthest to the right. Switching to Design View using the View Icon - www.office.com/setup Once in Desig

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: By default, every row and column of a new workbook is set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells. Optional: Download our practice workbook. Watch the video below to learn more about modifying columns, rows, and cells. TO MODIFY COLUMN WIDTH: In our example below, column C is too narrow to display all of the content in these cells. We can make all of this content visible by changing the width of column C. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. positioning the mouse over the column line - www.office.com/setup Click and drag the mouse to increase or decrease the column width. increasing the column width - www.office.com/setup Release the mouse. The column width will be changed. the resized column - www.office.com/setup With numerical data, the cell will display pound signs (#######) if the column is too narrow. Simply increase the column width to make the data visible. TO AUTOFIT COLUMN WIDTH: The AutoFit feature will allow you to set a column's width to fit its content automatically. Position the mouse over the column line in the column heading so the cursor becomes a double arrow. autofitting the column width - www.office.com/setup Double-click the mouse. The column width will be changed automatically to fit the content. the autofit column width - www.office.com/setup You can also AutoFit the width for several columns at the same time. Simply select the columns you want to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for row height. autofitting column width for multiple columns - www.office.com/setup TO MODIFY ROW HEIGHT: Position the cursor over the row line so the cursor becomes a double arrow. hovering over a <a href=row line - www.of

www.office.com/setup Blogs: Microsoft Office files are still very common, but if you're more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive-if you know how. On the desktop, you'll need to use the Google Chrome browser and an official Chrome extension to edit Microsoft Office documents, using Google Drive's Office Compatibility Mode (OCM). You can edit them like that, or convert them to Google Docs format, which will provide more features. (Don't worry-even if you convert them to Google Docs format, you can re-download them in Microsoft Office format later). You can also edit Microsoft Office files using the Google Drive app and the Google Docs, Google Sheets, and Google Slides apps on iOS or Android. We'll show you both methods in the guide below. HOW TO WORK WITH MICROSOFT OFFICE FILES ON GOOGLE DRIVE ON A PC OR MAC Let's start with the desktop. If the Office file you want to edit and share is still on your PC's hard drive, you can easily upload it to Google Drive and open it for editing in Chrome using a Chrome extension. Open Chrome, go to the Office Editing for Docs, Sheets & Slides extension page, click "Add to Chrome", and follow the on-screen instructions to install it. 01_adding_extension_to_chrome - www.office.com/setup Blogs Once the extension is installed, drag the Office file onto the Chrome window until you see a copy icon as shown below. For my example throughout this article, I'm going to use a Word/Google Docs file, but the procedure is the same for Excel/Google Sheets files and PowerPoint/Google Slides files. 04_dragging_word_file_onto_chrome - www.office.com/setup The first time you drag an Office file onto the Chrome window, the following dialog box displays. Click "Got it" to close the window. You won't see this dialog box again. 05_office_editing_popup - www.office.com/setup Blogs The Office file is uploaded to your Google Drive account and

www.office.com/setup Blogs: Microsoft announced two new tools, Researcher and Editor, for Word 2016 today that introduce better research integration and writing assistance. Word 2016 is the newest version of the popular word editing software that is available to Office 365 users and customers who purchased a standalone copy of Office 2016. The update is available today to all Office 365 subscribers who are using Word 2016 on the Windows desktop according to Microsoft. The easiest way to find out whether you have it or not is to open Word 2016 on the Windows desktop and check whether the new "Researcher" option is available under References when you edit a document. RESEARCHER word 2016 researcher - www.office.com/setup Researcher is a new tool that you may use to find references directly from within Word 2016. The feature uses Bing's Knowledge Graph for that and displays data in a sidebar in the Word 2016 when enabled. You find the new option under References > Researcher. Researcher is a new service in Word that helps you find and incorporate reliable sources and content for your paper in fewer steps. Right within your Word document you can explore material related to your topic and add it-and its properly-formatted citation-in one click. Researcher uses the Bing Knowledge Graph to pull in the appropriate content from the web and provide structured, safe and credible information. You may use the new tool to add quotes and "properly formatted citation" to documents. While this may not be suitable for science-grade documents, it may do for many other types of documents. EDITOR word 2016 editor - www.office.com/setup Editor is touted as a new digital writing assistant that assists you with proofing and editing services. The initial release flags unclear phrases, redundancy or complex words, and makes recommendations by displaying alternatives to you. The service uses machine learning and natural language processing for that, and will improve over time