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

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

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: In the previous lesson, you learned how to create a simple query with one table. Most queries you design in Access will likely use multiple tables, allowing you to answer more complex questions. In this lesson, you'll learn how to design and create a multi-table query. 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 how to create a multi-table query (Part 1). Watch the video below to learn more about joins and query criteria (Part 2). DESIGNING A MULTI-TABLE QUERY Queries can be difficult to understand and build if you don't have a good idea of what you're trying to find and how to find it. A one-table query can be simple enough to make up as you go along, but to build anything more powerful you'll need to plan the query in advance. PLANNING A QUERY When planning a query that uses more than one table, you should go through these four steps: Pinpoint exactly what you want to know. If you could ask your database any question, what would it be? Building a query is more complicated than just asking a question, but knowing precisely what question you want to answer is essential to building a useful query. Identify every type of information you want included in your query results. Which fields contain this information? Locate the fields you want to include in your query. Which tables are they contained in? Determine the criteria the information in each field needs to meet. Think about the question you asked in the first step. Which fields do you need to search for specific information? What information are you looking for? How will you search for it? This process might seem abstract at first, but as we go through the process of planning our own multi-table query you sho

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: Microsoft Office 2016 Landed in late September, and it brought a number of changes with it. On the slightly less-exciting side are the transformations to the update system. Microsoft Office 2016 will be running an auto-update feature, similar to Windows 10, as well as a number of different servicing branches, also similar to the new operating system. Let's explore what that means for your Office 2016 installation. OFFICE 2016 UPDATE Since the September 22 release, Microsoft has likely fielded thousands of questions regarding the new Office update system. One of the most pertinent will concern Office 2016 adoption of the somewhat overbearing Windows 10 auto-update system. Office 2016 logo - www.office.com/setup The Office 2016 system will use a similar style to the Windows 10 update branches, locking those with Office 2016 into a cycle of updates depending on their version. The branches are: Current Branch (CB): features monthly updates, potentially including new and/or improved features, security patches, and non-security bug fixes. Current Branch for Business (CBB): features a four-monthly update schedule, with the same content as the current branch, delivered slowly to enable any preceding issues to be alleviated. Failure to install the CB updates will, as with Windows 10, result in a severance from scheduled security updates rendering consumers vulnerable to attack. CBB works slightly differently: business will be able to defer one four-month update, but must pick up the next offering or face the same perilous fate. It is one thing to pressure home users, but forcing businesses to update lest Microsoft expose them to vulnerabilities is another. Furthermore, there will be no Long Term Servicing Branch equivalent, the Windows 10 branch eschewing all but security patches over long periods of time. IS IT YOUR TURN TO UPDATE? The combination of Office 365 Business, Office 365 ProPlus, Office 365 Home, Personal, and University, pl

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: INTRODUCTION www.office.com/setup Blogs: Indenting text adds structure to your document by allowing you to separate information. Whether you'd like to move a single line or an entire paragraph, you can use the tab selector and the horizontal ruler to set tabs and indents. Optional: Download our practice document. Watch the video below to learn more about how to use indents and tabs in Word. INDENTING TEXT In many types of documents, you may want to indent only the first line of each paragraph. This helps to visually separate paragraphs from one another. - www.office.com/setup It's also possible to indent every line except for the first line, which is known as a hanging indent. - www.office.com/setup TO INDENT USING THE TAB KEY A quick way to indent is to use the Tab key. This will create a first-line indent of 1/2 inch. Place the insertion point at the very beginning of the paragraph you want to indent. - www.office.com/setup Press the Tab key. On the Ruler, you should see the first-line indent marker move to the right by 1/2 inch. The first line of the paragraph will be indented. - www.office.com/setup If you can't see the Ruler, select the View tab, then click the check box next to the Ruler. - www.office.com/setup INDENT MARKERS In some cases, you may want to have more control over indents. Word provides indent markers that allow you to indent paragraphs to the location you want. - www.office.com/setup The indent markers are located to the left of the horizontal ruler, and they provide several indenting options: First-line indent marker adjusts the first-line indent Hanging indent marker adjusts the hanging indent Left indent marker moves both the first-line indent and hanging indent markers at the same time (this will indent all lines in a paragraph) TO INDENT USING THE INDENT MARKERS Place the insertion point anywhere in the paragraph you want to indent, or select one or more paragraphs. - www.office.com/set

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint allows you to add audio to your presentation. For example, you could add background music to one slide, a sound effect to another, and even record your own narration or commentary. You can then edit the audio to customize it for your presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting audio in PowerPoint. TO INSERT AUDIO FROM A FILE: In our example, we'll insert an audio file saved locally on our computer. If you'd like to work along with our example, right-click this link to our example file and save it to your computer (music credit: Something Small (Instrumental) by Minden, CC BY-NC 3.0). From the Insert tab, click the Audio drop-down arrow, then select Audio on My PC. Inserting audio from a file - www.office.com/setup Locate and select the desired audio file, then click Insert. Selecting the desired audio file - www.office.com/setup The audio file will be added to the slide. The inserted audio file - www.office.com/setup RECORDING YOUR OWN AUDIO Sometimes you may want to record audio directly into a presentation. For example, you might want the presentation to include narration. Before you begin, make sure you have a microphone that is compatible with your computer; many computers have built-in microphones or ones that can be plugged in to the computer. TO RECORD AUDIO: From the Insert tab, click the Audio drop-down arrow, then select Record Audio. Clicking Record Audio - www.office.com/setup Type a name for the audio recording if you want. Renaming the audio recording - www.office.com/setup Click the Record button to start recording. Clicking the Record button - www.office.com/setup When you're finished recording, click the Stop button. Clicking the Stop button - www.office.com/setup To preview your recording, click the Play button. Previewing the recording - www.office.com/setup When you're done, click OK. The au

WWW.OFFICE.COM/SETUP BLOGS: SIMPLE RULES FOR BETTER POWERPOINT PRESENTATIONS www.office.com/setup Blogs: Have you ever given a PowerPoint presentation and noticed that something about it just seemed a little … off? If you're unfamiliar with basic PowerPoint design principles, it can be difficult to create a slide show that presents your information in the best light. Poorly designed presentations can leave an audience feeling confused, bored, and even irritated. Review these tips on making your next presentation more engaging. DON'T READ YOUR PRESENTATION STRAIGHT FROM THE SLIDES If your audience can both read and hear, it's a waste of time for you to simply read your slides aloud. Your audience will zone out and stop listening to what you're saying, which means they won't hear any extra information you include. Instead of typing out your entire presentation, include only main ideas, keywords, and talking points in your slide show text. Engage your audience by sharing the details out loud. FOLLOW THE 5/5/5 RULE To keep your audience from feeling overwhelmed, you should keep the text on each slide short and to the point. Some experts suggest using the 5/5/5 rule: no more than five words per line of text, five lines of text per slide, or five text-heavy slides in a row. Screenshot of Microsoft PowerPoint DON'T FORGET YOUR AUDIENCE Who will be watching your presentation? The same goofy effects and funny clip art that would entertain a classroom full of middle-school students might make you look unprofessional in front of business colleagues and clients. Humor can lighten up a presentation, but if you use it inappropriately your audience might think you don't know what you're doing. Know your audience, and tailor your presentation to their tastes and expectations. CHOOSE READABLE COLORS AND FONTS Your text should be easy to read and pleasant to look at. Large, simple fonts and theme colors are always your best bet. The best fonts and colors can va

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Excel is a spreadsheet program that allows you to store, organize, and analyzeinformation. While you may believe Excel is only used by certain people to process complicated data, anyone can learn how to take advantage of the program's powerful features. Whether you're keeping a budget, organizing a training log, or creating an invoice, Excel makes it easy to work with different types of data. Watch the video below to learn more about Excel. GETTING TO KNOW EXCEL If you've previously used Excel 2010 or Excel 2013, then Excel 2016 should feel familiar. If you are new to Excel or have more experience with older versions, you should first take some time to become familiar with the Excel interface. THE EXCEL INTERFACE When you open Excel 2016 for the first time, the Excel Start Screen will appear. From here, you'll be able to create a new workbook, choose a template, and access your recently edited workbooks. From the Excel Start Screen, locate and select Blank workbook to access the Excel interface. The Excel Start screen - www.office.com/setup Click the buttons in the interactive below to become familiar with the Excel interface. - www.office.com/setup WORKING WITH THE EXCEL ENVIRONMENT The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in Excel. The Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON Excel 2016 uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. You will use these tabs to perform the most common tasks in Excel. Each tab will have one or more groups. Groups on the ribbon - www.office.com/setup Some groups will have an arrow you can click for more options. Some groups have a menu for more options - www.office.com/setup Click a tab to see more commands. Tabs on the ribbon - www.office.c

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: PowerPoint is a presentation program that allows you to create dynamic slide presentations. These presentations can include animation, narration, images, videos, and much more. In this lesson, you'll learn your way around the PowerPoint environment, including the Ribbon, Quick Access Toolbar, and Backstage view. Watch the video below to learn more about getting started with PowerPoint. GETTING TO KNOW POWERPOINT PowerPoint 2016 is similar to PowerPoint 2013 and PowerPoint 2010. If you've previously used these versions, PowerPoint 2016 should feel familiar. But if you are new to PowerPoint or have more experience with older versions, you should first take some time to become familiar with the PowerPoint 2016 interface. THE POWERPOINT INTERFACE When you open PowerPoint for the first time, the Start Screen will appear. From here, you'll be able to create a new presentation, choose a template, and access your recently edited presentations. From the Start Screen, locate and select Blank Presentation to access the PowerPoint interface. Creating a blank presentation - www.office.com/setup Click the buttons in the interactive below to become familiar with the PowerPoint interface. www.office.com/setup Working with the PowerPoint environment The Ribbon and Quick Access Toolbar are where you will find the commands to perform common tasks in PowerPoint. Backstage view gives you various options for saving, opening a file, printing, and sharing your document. THE RIBBON PowerPoint uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, each with several groups of commands. For example, the Font group on the Home tab contains commands for formatting text in your document. Groups on the Ribbon - www.office.com/setup Some groups also have a small arrow in the bottom-right corner that you can click for even more options. More options in groups - www.office.com/setu

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: INTRODUCTION This article is provided as a courtesy to our customers to help you configure your Outlook software to work with (mt) Media Temple's hosting solutions. Third-party software can not be supported directly by (mt) Media Temple. If you have further questions about configuring Outlook, please visit http://support.microsoft.com/. TIP: Check out our automated tool for easy email set up! Automatically configure email clients on your PC, Mac, or iOS device with just a few clicks. REQUIREMENTS Before you start, be sure you have these handy: Your domain name: example.com Your email address: username@example.com For more information, please read this article: Creating a POP/IMAP email account. Your email password. CONFIGURE OUTLOOK 2011 Open Outlook 2011. If this is your first time using Outlook 2011, you'll see a welcome banner like the one in Figure 1.Outlook-00.jpg - www.office.com/setup Figure 1: Click image for a larger view. If you are adding another email account to Outlook, from the top menu, click on Tools. Then click on Accounts. See Figure 2.Outlook11-01.jpg - www.office.com/setup Figure 2: Click image for a larger view. Click on the Email Account icon, see Figure 3.Outlook11-02.jpg Figure 3. This window is where you enter your email information, see Figure 4 below. Figure 4: Enter your email account information in this window. Enter Your Name as you want it to appear. Enter your full email address username@example.com in the Email address: field. Select POP3 or IMAP. We recommend IMAP. Learn more about the differences here. Enter your full email address, username@example.com, in the User Name field. Enter your email password in the Password: field. TIP: If you experience any difficulty with the default outgoing SMTP Port 25, you can check the box Override default port and enter 587. We also strongly recommend using SMTP and port 465 with Outlook. For more information, please see: Next, we'll configure your Outgoing s

www.office.com/setup Blogs: Another tool you can use to connect to a webpage, file, email address, or slide is called an action button. Action buttons are built-in shapes you can add to a presentation and set to link to another slide, play a sound, or perform a similar action. When someone clicks or hovers over the button, the selected action will occur. Action buttons can do many of the same things as hyperlinks. Their easy-to-understand style makes them especially useful for self-running presentations at booths and kiosks. Optional: Download our practice presentation. Watch the video below to learn more about using action buttons in your presentations. INSERTING ACTION BUTTONS You can insert action buttons on one slide at a time, or you can insert an action button that will show up on every slide. The second option can be useful if you want every slide to link back to a specific slide, like the title page or table of contents. TO INSERT AN ACTION BUTTON ON ONE SLIDE: Click the Insert tab. Click the Shapes command in the Illustrations group. A drop-down menu will appear with the action buttons located at the very bottom. - www.office.com/setup Select the desired action button. Insert the button onto the slide by clicking the desired location. The Action Settings dialog box will appear. Select the Mouse Click or Mouse Over tab. Selecting the Mouse Click tab means the action button will perform its action only when clicked. Selecting the Mouse Over tab will make the action button perform its action when you move the mouse over it. - www.office.com/setup In the Action on click section, select Hyperlink to:, then click the drop-down arrow and choose an option from the menu. - www.office.com/setup Check the Play Sound box if you want a sound to play when the action button is clicked. Select a sound from the drop-down menu, or select Other sound to use a sound file on your computer. When you're done, click OK. - www.office.com/setup TO INSERT AN ACTION BUTTON ON A

www.office.com/setup Blogs: Whenever you use the Internet, you use hyperlinks to navigate from one webpage to another. If you want to include a web address or email address in your PowerPoint presentation, you can choose to format it as a hyperlink so a person can easily click it. It's also possible to link to files and other slides within a presentation. Optional: Download our practice presentation. Watch the video below to learn more about inserting hyperlinks in PowerPoint. ABOUT HYPERLINKS Hyperlinks have two basic parts: the address of the webpage, email address, or other location they are linking to, and the display text (which can also be a picture or a shape). For example, the address could be http://www.youtube.com, and YouTube could be the display text. In some cases, the display text might be the same as the address. When you're creating a hyperlink in PowerPoint, you'll be able to choose both the address and the display text or image. TO INSERT A HYPERLINK: Select the image or text you want to make a hyperlink. Right-click the selected text or image, then click Hyperlink. Alternatively, you can go to the Insert tab and click the Hyperlink command. - www.office.com/setup The Insert Hyperlink dialog box will open. - www.office.com/setup If you selected text, the words will appear in the Text to display field at the top. You can change this text if you want. Type the address you want to link to in the Address field. Click OK. The text or image you selected will now be a hyperlink to the web address. - www.office.com/setup TO INSERT A HYPERLINK TO AN EMAIL ADDRESS: Right-click the selected text or image, then click Hyperlink. The Insert Hyperlink dialog box will open. On the left side of the dialog box, click Email Address. - www.office.com/setup Type the email address you want to connect to in the Email Address box, then click OK. - www.office.com/setup PowerPoint often recognizes email and web addresses as you type and will format them as hyperlin

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: Today marks the general availability of Office 2016 for Windows, a suite of desktop applications that together with new mobile and web apps pushes Microsoft's new vision for PC-based productivity. Office 2016 is available immediately to Office 365 subscribers, as well as to individuals who would prefer to buy the software in standalone form. "We see Office 2016 as being just as important as the first release of Office," Microsoft group program manager Shawn Villaron told me in a briefing last week. "In the early days, Office was about bringing really important tools together to empower the individual for personal productivity. That was the way people wanted to work at that time. And for 20 to 30 years, Office fit right in. Today, things are changing. More people collaborate on work as groups and teams, so Office 2016 represents the change from personal productivity to team productivity." And that, really, is Office 2016 in a nutshell. If you're a typical information worker, student, or other person in need of standard productivity tools, Office 2016 of course works fine and represents an obvious and stable evolution from the Office version you're currently using. But the real meat in this release-now and going forward, as Office will of course be updated regularly, like Windows 10-is the designed around this new way of working. Confusing matters somewhat, Office-not Office 2016, but Office generally-is all over the place now. In addition to the classic, full-featured desktop suites on both Windows and Mac, Microsoft has high-quality Office Online web apps, mobile apps for Android, iOS, and Windows/Windows phones-and Office 365-specific solutions that are often available as web apps but are sometimes just integrated into the desktop applications. This ain't your father's Office anymore. Office everywhere: Microsoft Office is available on virtually any device you care to use. - www.office.com/setup Office eve

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Whenever you work with Excel, you'll enter information-or content-into cells. Cells are the basic building blocks of a worksheet. You'll need to learn the basics of cells and cell content to calculate, analyze, and organize data in Excel. Optional: Download our practice workbook. Watch the video below to learn more about the basics of working with cells. UNDERSTANDING CELLS Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column-in other words, where a row and column meet. Columns are identified by letters (A, B, C), while rows are identified by numbers (1, 2, 3). Each cell has its own name-or cell address-based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5. cell C5 - www.office.com/setup Note that the cell address also appears in the Name box in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected. You can also select multiple cells at the same time. A group of cells is known as a cell range. Rather than a single cell address, you will refer to a cell range using the cell addresses of the first and last cells in the cell range, separated by a colon. For example, a cell range that included cells A1, A2, A3, A4, and A5 would be written as A1:A5. Take a look at the different cell ranges below: Cell range A1:A8cell range A1:A8 - www.office.com/setup Cell range A1:F1 cell range A1:F1 - www.office.com/setup Cell range A1:F8 cell range A1:F8 - www.office.com/setup If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default reference style for Excel. Review our Extra on What are Reference Styles? to learn how. TO SELECT A CELL: To input or edit cell content, you'll first need to select the cell. Click a cell to select it. In our exampl

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Databases in Access are composed of four objects: tables, queries, forms, and reports. Together, these objects allow you to enter, store, analyze, and compile data however you want. In this lesson, you will learn about each of the four objects and come to understand how they interact with each other to create a fully functional relational database. Watch the video below to learn more about objects in Access. TABLES By this point, you should already understand that a database is a collection of data organized into many connected lists. In Access, all data is stored in tables, which puts tables at the heart of any database. You might already know that tables are organized into vertical columns and horizontal rows. Rows and columns in an Access table - www.office.com/setup In Access, rows and columns are referred to as records and fields. A field is more than just a column; it's a way of organizing information by the type of data it is. Every piece of information within a field is of the same type. For example, every entry in a field called First Name would be a name, and every entry in field called Street Address would be an address. Fields and field names - www.office.com/setup Likewise, a record is more than just a row; it's a unit of information. Every cell in a given row is part of that row's record. A record - www.office.com/setup Notice how each record spans several fields. Even though the information in each record is organized into fields, it belongs with the other information in that record. See the number at the left of each row? It's the ID number that identifies each record. The ID number for a record refers to every piece of information contained on that row. Record ID numbers - www.office.com/setup Tables are good for storing closely related information. Let's say you own a bakery and have a database that includes a table with your customers' names and information, lik

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