Group items tagged

These days it's all about Sway - the first of many native apps to be rolled out to Microsoft Office 365 subscribers. To put it simply, Sway is a web browser-based storytelling app. It allows anyone with the most basic computing knowledge to create beautiful-looking websites and presentations with images, text, tweets, videos or whatever other media you want to include. It works a bit like Word and Powerpoint combined - and finished products can be used on websites to display family photos, or in a beautiful work presentation.

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

It's been a very busy year for SkyDrive and we'd like to thank all of you for helping us improve the service through your feedback, tweets, Facebook posts, and comments. The service continues to grow: since October 2012 when Windows 8 launched, 50 million more people have started using SkyDrive, helping us reach an important milestone - over 250 million people are now using SkyDrive as the new place to save their files. In just the past few months we've made SkyDrive the default save location for the new Office, updated the SkyDrive app for iOS, and made substantial performance improvements to SkyDrive uploading. Recently, we also announced that Microsoft accounts have grown to 700 million, that we've improved the security of our service with things like two-step verification, and that we now have Extended Validation Certificates integrated on SkyDrive.com. And a few days ago, our friends over at Outlook.com announced that they're rolling out a new feature that allows you to insert anything from your SkyDrive directly into an email message. We continue to push forward to a world where all your stuff is in SkyDrive, so you can always have it with you.

Five shows into the series, we've looked at what your options are, what's changed and what's new with the new Office. We threw skydiver Fully Sik out of a plane to test if Office 365 ProPlus could be installed during 90 seconds of free fall; we took a look at the new Office telemetry to help you optimize your Office configuration; and we've explored identity and data access with the new user-based Office and caught up with Zero Day and Trojan Horse Sci-Fi author and industry renowned cyber-security expert, Mark Russinovich on the security model for online services. We even performed the great race of Office installs. We've received a lot of your questions along the way so, for our sixth show, we changed gears to present a live 60-minute episode of the Garage Series Live! on real world adoption tips and tricks with live Q&A. If you missed the show you can see it again here.

As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address. OPTIONAL TWO-STEP VERIFICATION HELPS KEEP YOU MORE SECURE You can now choose to enable two-step verification for your entire account. Two-step verification is when we ask you for two pieces of information when you sign in to your account-your password plus a code sent to a phone or email that you gave us as security info. Many of you have asked for this and we're delighted to be able to offer this capability. Two-step verification is a great way to add extra protection to your account. Once you've enabled two-step verification, even if a criminal gets your password (for example, through malware on a friend's machine that you used, or if you use the same password for another service that gets breached) they can't access your account.

Social apps can make working with Office 2013 more engaging, efficient, and fun. They combine the networking and outreach capabilities of social media sites with the mobile productivity power of Office. Together, Office and social apps give you more insight into your contacts, allow you to monitor your social channels without using a browser, and can spice up your SharePoint sites in ways that you'll "like" (thumbs up). The LinkedIn for Outlook app is one of the most popular of the social apps. It lets you see LinkedIn profile data for your contacts while you are using Outlook. Not only can this app give you greater insight into your email contacts, it can help you build your professional network quickly from one of your most valuable professional resources: your Outlook contact list. Likewise, if you're an active Tweeter, you may want to add the ExTweet app to your library. It offers a way to display real-time Tweets that match the data in your Excel workbook. From the most popular social media website comes the Facebook Integration App. Use it to add Facebook social plug-ins to your SharePoint site so people can interact with it as they would a Facebook page. It can make your site more social by encouraging increased user engagement and eliciting immediate feedback and comments. Similarly, the ConnectWithUs app lets you connect your SharePoint site to your page on Facebook, Twitter, Pinterest, Google+, or any other community. These are just a few examples of apps that work with the Office applications you use every day to make them even more dynamic and useful. Explore the Office Apps Store to find more apps for Office 2013 that can make your work easier, increase your productivity, and help you have fun.

Today's post was written by Nick Portello, Network Manager, Steve Moore Chevrolet. Read more Office 365 customer stories here. Office 365 Customer Steve Moore Chevrolet_Nick PortelloWhen I joined Steve Moore Chevrolet as the sole IT staffer six months ago, the dealership was in dire need of new technology. Employees coped with aging PCs, an outdated POP3 email service, a poor mobility experience, data loss, and no collaboration tools. Then I heard about Microsoft Office 365, which gives you the latest version of Microsoft Office, plus a suite of cloud-based communication and collaboration tools that solved all our problems. Unlike Google Apps, the UI was familiar to our employees and Microsoft offered a flexible subscription-based payment option, which is ideal for our fluctuating workforce. Now that our documents are stored in Microsoft SharePoint Online and SkyDrive Pro, we have easy access to collaboration tools with robust security. I no longer worry about falling out of compliance with Chevrolet auditors, losing important financial data, or having to pay fines that could reach $250,000. I can also find data on-demand for Chevrolet auditors and use my mobile device to look up information, which saves about 40 percent of every day-I'm no longer running between my computer and the sales, service, and administration departments. I can focus on what I really need to do. Thanks to Office 365, we are all able to get on with our work! Learn more about Steve Moore Chevrolet and Office 365 by watching the video below and reading the case study.

We aim to make SkyDrive the place for all your documents, notes, photos, videos and other files. With the release of Windows 8 and Windows RT back in October, more and more people every day are using SkyDrive for their most important files through the SkyDrive app, as well as through SkyDrive integration in File Explorer. Of course, there are great SkyDrive experiences for Windows devices, but being the place for all your files means we invest a significant amount of effort ensuring you have a great experience across all the devices you want to use. Today, we're excited to release v3.0 of the SkyDrive app for iOS that includes improved photo features, an updated UI, and a number of other new features and enhancements. You can install or update the SkyDrive app for iOS now via iTunes.

This tutorial on using conditional formatting to highlight dates is brought to us by MVP Frédéric Le Guen, with special acknowledgment and thanks to Ken Puls for assistance with translation from French to English. Date functions in Excel make it is possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. The NOW function, which calculates values based on the current date and time, is a great example of this. Taking this functionality a step further, when you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiates between types of days, like weekends and weekdays.