Group items tagged

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 example, we'll select cell D9. A border will app

www.office.com/setup Blogs: While you can always enter data directly into database tables, you might find it easier to use forms. Forms ensure you're entering the right data in the right location and format. This can help keep your database accurate and consistent. This lesson will address the benefits of using forms in a database. You will review examples of different forms and form components. Finally, you will learn how to use forms to enter new records and view and edit existing ones. 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 working with forms in Access. WHY USE FORMS? Many of us fill out forms so often that we hardly notice when we're asked to use them. Forms are so popular because they're useful to the person asking for the information and to the person providing it. They are a way of requiring information in a specific format, which means the person filling out the form knows exactly which information to include and where to put it. Illustration of a paper form - www.office.com/setup This is just as true of forms in Access. When you enter information into a form in Access, the data goes exactly where it's supposed to go: into one or more related tables. While entering data into simple tables is fairly straightforward, data entry becomes more complicated as you start populating tables with records from elsewhere in the database. For instance, the orders table in a bakery's database might link to information on customers, products, and prices drawn from related tables. For example, in the Orders Table below the Customer ID field is linked to the Customers table. The Customer ID field links to the Customers table - www.office.com/setup In fact, in order to see the entire order you would also have to look at the

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Even though PowerPoint presentations are designed to be viewed on a computer, there may be times when you want to print them. You can even print custom versions of a presentation, which can be especially helpful when presenting your slide show. The Print pane makes it easy to preview and print your presentation. Optional: Download our practice presentation. Watch the video below to learn more about printing in PowerPoint. PRINT LAYOUTS PowerPoint offers several layouts to choose from when printing a presentation. The layout you choose will mostly depend on why you're printing the slide show. There are four types of print layouts. Full Page Slides: This prints a full page for each slide in your presentation. This layout is most useful if you need to review or edit a printed copy of your presentation. preview of a full page slide printout - www.office.com/setup Notes Pages: This prints each slide, along with any speaker notes for the slide. If you've included a lot of notes for each slide, you could keep a printed copy of the notes with you while presenting. previewing the notes pages layout - www.office.com/setup Outline: This prints an overall outline of the slide show. You could use this to review the organization of your slide show and prepare to deliver your presentation. preview of an outline printout Handouts: This prints thumbnail versions of each slide, with optional space for notes. This layout is especially useful if you want to give your audience a physical copy of the presentation. The optional space allows them to take notes on each slide. preview of a handouts printout - www.office.com/setup TO ACCESS THE PRINT PANE: Select the File tab. Backstage view will appear. selecting the File tab - www.office.com/setup Select Print. The Print pane will appear. clicking Print in the Backstage view - www.office.com/setup Click the buttons in the interactive below to learn more about using

Microsoft today detailed the new features and improvements that it delivered to Office 365 users this month. Key among them are new Excel co-authoring capabilities, Microsoft Teams, and new OneNote inking and accessibility updates. "Office 365 provides the broadest and deepest toolkit for collaboration between individuals, teams and entire organizations," Microsoft corporate vice president Kirk Koenigsbauer explains. Here's what's new in March.

Project managers can do their best work when life is easy for their team members. With the release of the new Project, now there are new and improved ways for team members to do their part in keeping the project on track with minimal process friction. To help, we rounded up some of our most popular articles and organized them by common work responsibilities. Here, the focus is on team members, with topics including consolidated task management, quick collaboration, and streamlined time tracking-which should put a smile on everyone's face.

At Microsoft's annual Public Sector CIO Summit, we were pleased to announce a growing community of public sector customers who've adopted Office 365 including the City of Kansas City, MO; the City of Seattle; King County, WA; the San Diego County Regional Airport Authority, Dupage County, the University of Miami, the University of Colorado Colorado Springs, Sacramento (Sacramento State) and California State University - all who've moved to the cloud to increase IT efficiencies while improving their communication and collaboration capabilities.

We're all creators-each in our own way. I'm part of an organization that advocates for those who are creatively talented or gifted: artists, creators, and entrepreneurs. But I've found that we all bring creativity to our jobs in some form or another. I know that I can approach problems in a more creative way and find innovative solutions when I have the right tools and information within easy reach. At Copyright Alliance, we're a small team that serves more than 40 institutional members and thousands of artists around the country. For each of us, the ability to find and share files while on the go is a huge priority, especially because we tend to fill in for each other on different projects at a moment's notice. Balancing tasks like writing opinion pieces for news publications, giving talks at conferences, and meeting with members-all in the same day-is the norm. In the past, technology issues sometimes sapped my creative energy, making it difficult to stay focused on the task in front of me. Instead, I would have to scramble to find a document or a presentation that I needed. We had a file server at the office and I would routinely download all the documents I thought I would need before dashing off to the next engagement. This not only took extra time out of my day, it also wasn't a foolproof system. There were times when I just couldn't access the information I needed while out in the field. With Microsoft Office 365, all that has changed. Now that we have an online suite of tools for creating documents and managing them in a systematic way, we can all work together more fluidly. The menus and navigation in Microsoft SharePoint Online are simple to use, and it's reassuring to see exactly when a document was last updated. We're looking forward to using more of the tools in Office 365, including Microsoft Lync Online to make calls and hold meetings-all in a couple of clicks. I hardly think about the technology we use anymore. The transition to

When we launched the preview of Outlook.com, our goal was to build the best email service in the world, capable of scaling to over a billion active customers. When Outlook.com came out of preview, it was already the fastest growing email service thanks to your support. The last two months have seen the release of a new, modern Outlook.com calendar, a refreshed Outlook.com app for Android devices, two-factor authentication for your account, new international domains for people around the world, and the release of a preview of Skype calling in Outlook.com. Today, we're excited to announce that we've completed upgrading all Hotmail customers to Outlook.com. Coupled with the growing organic excitement for Outlook.com, this has pushed us to over 400 million active Outlook.com accounts, including 125 million that are accessing email, calendar and contacts on a mobile device using Exchange ActiveSync. We're also pleased to announce that we're adding two new features to Outlook.com: SMTP send, so it's easier to send mail from different email addresses, and deeper integration with SkyDrive.

What is Microsoft Visio used for? Diagrams. That's what Microsoft Visio does, and it does it better than any other app I've seen yet. From flow charts to floor plans, there isn't much it can't handle. Now, being honest, I didn't know much about Visio until recently. But that changed when I decided to take it for a test drive - right out of the latest Microsoft Office. Visio Templates Office 2013 - www.office.com/setup Microsoft Visio can be used to create simple or complicated diagrams. It offers a wide variety of built-in shapes, objects, and stencils to work with. You can also make your own shapes and import them if you're willing to do all that extra work. The driving idea behind Visio is to make diagramming as easy as possible for the user. I think Visio is on the right track for that! Note: Click images below to open them at Full Size. The Visio 2013 welcome screen features a dozen different templates to get you started. Each template equips you with the appropriate menu and objects already open and ready for use. Even more templates can be found in specific categories within the application, or from Visio's online download page. visio welcome screen - www.office.com/setup Visio's primary clientele have been Enterprise users at the corporate level. If you think about it, it's not too often that the home user needs to write up professional diagrams. Usually, a paper and pen will suffice because a home user's diagram isn't being sent out to an entire department. That's why Visio has always been considered a program for "serious" diagrams. But it doesn't have to be. table chart with live data - www.office.com/setup Visio can be used to create 3D map diagrams, though the built-in tools for this are limited. It works well for simple maps that you might print on a brochure or campus directory. visio map - www.office.com/setup Another thing Visio can do is pull in live information from an external source, such as an Excel shee

April's Customer of the Month is Robert Aichele, Senior Manager, Store Communications at Jamba Juice. I've been at Jamba since 2009 managing internal communication, primarily store and field communication, with a hand in some broader projects connecting our strategic vision with the managers in the field. Our Yammer network debuted in 2011, catching on with a small group and then expanding quickly to include our entire Support Center. It was so popular we extended it to our company-owned store managers later that year, and it plateaued happily there for several months as an interesting tool to share ideas and problem solve operational issues when we needed to hear diverse perspectives quickly. I'm a firm believer in story telling as a means to engage employees with the "why" behind what we do as a company - and sometimes what we stop doing - and in the spring of 2012 we had a big story to tell. Our first National Hiring Day was happening in Jamba stores across the country as we prepared to hire thousands of new employees and ramp up for our busy summer season. We'd organized the event through traditional channels: our intranet, email, weekly task management publications, and pre-event conference calls. And we had big plans to collect photographs, interview hiring managers, and write up a recap to share the success stories with everyone after the fact. On the big day I logged into Yammer and got a big surprise. The event was unfolding in glorious detail right as it happened with photos, comments, personal stories, and genuine pride and enthusiasm for the Jamba brand just pouring out. We never wrote that recap.

Bella Engen is a Technical Writer on the SharePoint User Content Publishing team, focused on search-driven experiences. Cross-site publishing is a new publishing method in SharePoint Server 2013 that can help streamline the publishing process in your organization, and at the same time reduce costs associated with maintaining and updating your website. By combining cross-site publishing with SharePoint search features, you can reduce the number of pages needed to maintain your website, and gain flexibility in how content is presented to your customers. In a nutshell, cross-site publishing simplifies the authoring experience by separating the process of how content is authored from the process of how content is displayed. SharePoint search features enable you to add user-specific behavior to your website, such as displaying different content to different customer groups, or displaying recommendations based on user behavior. In a blog series on the SharePoint IT Pro blog, you can learn how you can use SharePoint Server 2013 to set up a website that is based on product catalog data. The blog posts describe the different functionalities that are involved when setting up such a site, and show you step-by-step how the features are configured. To demonstrate how it all comes together, data from a fictitious company is used. The blog posts use several screenshots and diagrams to explain everything from how the cross-site publishing feature works, to how you can use search features to influence how product data is displayed to visitors on a site. To give you an idea of what type of site this blog series describes, here are a few screenshots of the final website: