Group items tagged

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

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.

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: www.office.com/setup Visit the "How to set up a product-centric website in SharePoint Server 2013" blog series overview page for the complete list of current and upcoming posts.

Hey guys, I am back with the last blog in the series for the webinar, 'Making Learning Stick', by Jay Cross. You can check out Part 1 and Part 2 of this series here. This time we are going to talk about some basics of making learning stick. I am sure you must be wondering why I am going the opposite way by starting off with the complexities and summing it up with basics. Well, basics are the most important component in 'Making Learning Stick' and I wanted you to remember them the most. So I decided to focus on them in the end. We will begin with glancing through some brain rules by John Medina that will help you align better both physically and mentally while recalling things, followed by some interesting and simple everyday techniques for better recall ability.

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

www.office.com/setup Blogs: Presentations are used every day to educate, enlighten and energize. Head teachers will have to present to teachers, teachers will need to present daily to their students, and those students will have to present on many occasions throughout their education and beyond. Because of this, it is important that presentations are engaging, modern and easy to create, in order to have the impact that is intended. This tutorial in our Sway series will show you how Sway can be used to make great presentations, and how you can make the most of the easy to use features to make your presentation as interactive and informative. Recently we're been working our way through a number of Sway video tutorials, and this next offering demonstrates the ways you can use Sway to create and liven up your presentations: In education planning is key, so most educators and students will draw up a plan of their presentation before they start creating it and, now you have Sway, it has never been easier to transform your plan into fun, interactive content in just a few clicks. If you write up an outline in Word for example, just drop it into Sway and it will automatically create headings and sections based on your document. You can then update and change the formatting of the text cards by using the emphasis and accent features, which draw attention to what matters to you in your presentation. To support the messaging in your text, you can then add some helpful or exciting images to the storyline, categorising them easily with the grouping tool and using focus points to make sure you don't lose what is important. If, like many educators, you like to have visual signposts in your presentation, then you can use the images and text as headings to section your work. This will make it easier for the student navigating the presentation, and allow you to keep the flow when you are presenting. And if you like to have a brief preview of what is coming in the presentation

If you're looking for something other than usual gay sex scenes, take a look at Friends & Buddies, the first ever gay adult sitcom with a story-line, recurring characters, love and of course a lot of sex.

misplace your phone? How about your keys? Your camera? A combination of iPhone case an app and series of tags for tracking

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/

a series of talk regarding open source

Evanta Technologies delivers a full series of Web Services training courses. Our Web Services training courses are instructor-led and can be taken online

WWW.OFFICE.COM/SETUP BLOGS: USING THE FORMAT PAINTER IN POWERPOINT AND WORD www.office.com/setup Blogs: Themes can be a great way to make your PowerPoint presentation or Word document look nice, but sometimes you might want to add custom design elements to your project. Custom formatting can be tedious, though, especially when you're doing a lot of it. For instance, take this PowerPoint slide. Let's say you've applied a series of effects to the photo on the left, and now you'd like to do the same to the photo on the right. Screenshot of Microsoft PowerPoint - www.office.com/setup You could try to remember all of the effects applied and apply them to the second photo as well-or you could save some time and use the Format Painter. The Format Painter is a tool in Word and PowerPoint that lets you copy all of the formatting from one object and apply it to another one. Think of it as copying and pasting for formatting. USING THE FORMAT PAINTER Select the object with the formatting you want to copy. Screenshot of Microsoft PowerPoint - www.office.com/setup Click the Format Painter icon. It may be located in a slightly different place, depending on your version of Office, but it always looks like a paintbrush. Screenshot of Microsoft PowerPoint - www.office.com/setup Select the object you want to apply the formatting to. The object will be formatted. Screenshot of Microsoft PowerPoint - www.office.com/setup See? Simple! That was much quicker than applying the individual effects one at a time. If you want, you can even use the Format Painter to apply the formatting to multiple objects. Just double-click the Format Painter icon instead of clicking it once. Screenshot of Microsoft PowerPoint - www.office.com/setup Even though weonly looked at using the Format Painter for photos in PowerPoint, you can use it for anything you can apply formatting to in Word or PowerPoint. This includes text, table cells, and shapes. Once you start using it, you'll be surprised how often

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

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

In the finale of our three part deep dive on customizing and deploying the new Office, our intrepid hosts demonstrate Office 365 ProPlus Click-to-Run integration with your existing management and deployment tools while exploring pre-installation via Windows image. Watch too as our fearless host Jeremy gets behind the wheel to test if Windows Intune can install Office as fast as a direct install from Office 365 from his car, in the time it takes him to go over Seattle's famous 520 floating bridge.

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

Meeting notes, vacation plans, grocery lists, great quotes, notes to self-let me count the ways to use OneNote. Consolidate all of your crucial information chunks and snippets in one place, then link with OneDrive to share this virtual notebook with yourself (roaming), with other people (collaboration), and with other devices (OneNote ecosystem). Can't view this video? It's also on Microsoft Showcase. Need a peek? Here's a 30-second trailer. Note SkyDrive is now OneDrive, and SkyDrive Pro is now OneDrive for Business. Read more about this change at From SkyDrive to OneDrive. What you will learn at Tuesday's webinar Using OneNote for your next household project Ways to share OneNote meeting notes Share with OneNote, even if you don't have it OneNote for Android, iPhone, iPad. References for this webinar Share your notebook (video) Share notes with other people (how-to) Work together on a shared notebook (OneNote 2010 training course) Share notes in a meeting (how-to) Plan a trip with others (video) OneNote keyboard shortcuts (2010) and (2013) OneNote mobile apps Go to http://aka.ms/offweb for more information on how to join the series. -Doug Thomas

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: A chart is a tool you can use to communicate data graphically. Including a chart in a presentation allows your audience to see the meaning behind the numbers, which makes it easy to visualize comparisons and trends. Optional: Download our practice presentation for this lesson. Watch the video below to learn more about using charts in PowerPoint. TYPES OF CHARTS PowerPoint has several types of charts, allowing you to choose the one that best fits your data. In order to use charts effectively, you'll need to understand how different charts are used. Click the arrows in the slideshow below to learn more about the types of charts in PowerPoint. Slide 1 - www.office.com/setupPowerPoint has a variety of chart types, each with its own advantages. Click the arrows to see some of the different types of charts available in PowerPoint. Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup Slide 1 - www.office.com/setup IDENTIFYING THE PARTS OF A CHART In addition to chart types, you'll need to understand how to read a chart. Charts contain several different elements-or parts-that can help you interpret data. Click the buttons in the interactive below to learn about the different parts of a chart. Book sales chart - www.office.com/setup LEGEND The legend identifies which data series each color on the chart represents. In this example, the legend identifies the different months in the chart. INSERTING CHARTS PowerPoint uses a spreadsheet as a placeholder for entering chart data, much like Excel. The process of entering data is fairly simple, but if you are unfamiliar with Excel you might want to review our Excel 2016 Cell Basics lesson. TO INSERT A CHART: Select the Insert tab, then click the Chart command in the Illustrations group. - www.office.com/setup A dialog box will appear. Select a category from the left pane, an

www.office.com/setup Blogs: Microsoft Word is an essential tool for any individual in today's digital age. Whether you are a working professional, a diligent student or an active retiree, proficiency in Microsoft Word is a vital skill1 that is useful for both complex business requirements as well as basic day-to-day purposes. Not only is Microsoft Word a flexible tool that allows you to achieve many of your digital document needs, it is also one of the most user- friendly applications from the Microsoft Office suite. Below are 10 MS Word features that you should be using at work, school or home but likely aren't. 1. SMART ART The Office 2007 and Office 2010 applications share very similar features for working with a range of graphics including pictures, Clip Art, Shapes, diagrams and Charts. It's easy to confuse SmartArt with the similarly named WordArt. Where WordArt just allows you to display text using a wide variety of different formats and effects, SmartArt is a comprehensive and flexible business diagram tool that greatly improves upon the 'Diagram Gallery' feature found in previous versions of Office. Smart Art screen shot 2 - www.office.com/setup The great thing about SmartArt is the ability to swap between different diagrams, even diagrams from other categories, without losing the information that you have already entered. From the selection available, use whichever SmartArt is appropriate to give your document that little bit extra charm. 2. TURN DATA INTO VISUAL CHARTS Charts are created using the same chart 'engine' that Excel uses. Accordingly, as your chart is created, another window will appear containing the Excel-generated data that the chart is based on. Use the Insert Chart button in the Illustrations group to insert a chart and select from the variety of options. The charts are versatile, just like the user-friendly data represented separately in MS Excel to smooth out the whole data-input-to-graph process. Visual Charts -