Group items tagged

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

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

Let's say you really like the style of a theme, but you'd like to experiment with different color schemes. That's not a problem: You can mix and match colors, fonts, and effects to create a unique look for your presentation. If it still doesn't look exactly right, you can customize the theme any way you want. If you're new to PowerPoint, you may want to review our lesson on Applying Themes to learn the basics of using themes. Optional: Download our practice presentation. Watch the video to learn more about modifying themes in PowerPoint. TO SELECT NEW THEME COLORS: If you don't like the colors of a particular theme, it's easy to apply new theme colors; everything else about the theme will remain unchanged. From the Design tab, click the drop-down arrow in the Variants group and select Colors. - www.office.com/setup Blogs Select the desired theme colors. The presentation will update to show the new theme colors. - www.office.com/setup Blogs TO CUSTOMIZE COLORS: Sometimes you might not like every color included in a set of theme colors. It's easy to change some or all of the colors to suit your needs. From the Design tab, click the drop-down arrow in the Variants group. Select Colors, then click Customize Colors. - www.office.com/setup Blogs A dialog box will appear with the 12 current theme colors. To edit a color, click the drop-down arrow and select a different color. You may need to click More Colors to find the exact color you want. - www.office.com/setup Blogs In the Name: field, type the desired name for the theme colors, then click Save. - www.office.com/setup Blogs The presentation will update to show the new custom theme colors. With some presentations, you may not notice a significant difference when changing the theme colors. For example, a textured background will not change when theme colors are changed. When trying different theme colors, it's best to select a slide that uses several colors to see how the new theme colors will affect your prese

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Access offers several advanced options for creating and modifying reports. The Report Wizard is a tool that guides you through the process of creating complex reports. Once you've created a report-whether through the Report Wizard or the Report command-you can then format it to make it look exactly how you want. In this lesson, you'll learn how to use the Report Wizard to create complex reports. You'll also learn how to use formatting options to format text, change report colors and fonts, and add a logo. 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 the Report Wizard in Access. THE REPORT WIZARD While using the Report command is a quick way to create reports from the current object, it's not as helpful if you want to create a report with data from multiple objects. The Report Wizard makes it easy to create reports using fields from multiple tables and queries. It even lets you choose how your data will be organized. TO CREATE A REPORT WITH THE REPORT WIZARD: Select the Create tab and locate the Reports group. Click the Report Wizard command. Clicking the Report Wizard command - www.office.com/setup Blogs The Report Wizard will appear. In the procedures below, we'll discuss the different pages in the Report Wizard. The Report Wizard dialog box - www.office.com/setup Blogs STEP 1: SELECT THE FIELDS TO INCLUDE IN YOUR REPORT Click the drop-down arrow to select the table or query that contains the desired field(s). Selecting a table that contains fields to include in the report - www.office.com/setup Blogs Select a field from the list on the left, and click the right arrow to add it to the report. Adding fields to a report - www.office.com/setup Blogs

www.office.com/setup Blogs: Sway: Microsoft Office presentation software. PowerPoint: Microsoft Office presentation software. So what's the difference? You're watching Jeopardy! when the presenter utters the following answer in keeping with the game show's famous format: "A software tool from Microsoft for creating presentations, web-based reports and projects." Quick as a flash you spit out the question in unison with the contestant: "What is PowerPoint?" To your astonishment, presenter Alex Trebek shakes his head and utters a curt "No". The correct question was "What is Sway?" To the best of our knowledge, that scenario has yet to surface on the American quiz show, but it's hypothetically possible. After all, there are a number of similarities between PowerPoint and Sway on first inspection: Both are part of Microsoft Office Both can be used to create rich presentations Both support multimedia including video, audio and images Both feature customisable templates There's no disputing that there are areas where PowerPoint and Sway overlap. But if you're thinking Sway is just a web-based clone of PowerPoint, think again - each piece of software has highly specific functions. It's well worth familiarising yourself with the differences between the two, cos if you Sway when you're meant to PowerPoint, you're gonna have a bad time. POWERPOINT IN A PARAGRAPH As the world's preeminent slideshow software, PowerPoint requires no introduction. From classroom projects to delivering keynote addresses, Microsoft's easy to use presentation software has graced overhead projectors on every continent. Slides; audience handouts; speaker's notes. Whatever you choose to create and however you choose to deliver your story, PowerPoint makes it simple. SWAY IN SUMMARY Sway is an online presentation and storytelling app that's free for anyone with a Microsoft or Office 365 account. The newest addition to Microsoft Office, Sway helps

www.office.com/setup Blogs: Evernote and OneNote are two of our favorite tools, but both have changed substantially since we last compared these two apps-in some ways, not for the best. Here's where these two stand today. www.office.com/setup LIFEHACKER FACEOFF: ONENOTE VS. EVERNOTE Now that Microsoft OneNote is free for Mac and Windows, the price and cross-platform barriers to…Read more WHAT'S NEW IN EVERNOTE In the last year, Evernote introduced a new pricing plan, redesigned its webapp, and added new features for its Android and iOS apps. THE FREE PLAN LOSES A FEATURE, BUT NOW THERE'S A MORE AFFORDABLE PAID PLAN Let's talk price first with Evernote, since it's the biggest change in the last year. The free plan no longer lets you email notes to Evernote, something most users enjoyed and used often prior to that change. Although you can get around this limitation with an IFTTT recipe, you won't get the full flexibility of Evernote's email-to-notes feature, such as specifying your destination notebook in the email subject line. So that's a bummer. On the positive side, however, Evernote introduced a new, more affordable paid plan called Evernote Plus. For $25 a year, you get offline notebooks for Evernote's mobile apps and the ability to lock the app on your phone with a PIN. Both of these used to require Evernote's Premium plan, which used to cost $45 a year. Finally, Evernote's Premium plan now costs $50 a year. But in return for those five extra bucks, you get larger upload limits: 10GB a month, instead of the previous 4GB data cap. With Evernote Premium, you can search attachments, scan business cards, view previous note versions, annotate PDFs, and use the new note presentation mode. EVERNOTE'S USER INTERFACE KEEPS EVOLVING www.office.com/setup Last year, Evernote took its redesigned, minimalist web client out of beta. Though slicker and easier on the eyes, the makeover also made the webapp less functional. You can't order

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: FROM USING ONENOTE FOR PROJECT MANAGEMENT TO DISCOVERING HIDDEN FEATURES IN WORD, THERE ARE TONS OF WAYS YOU CAN GET MORE OUT OF OFFICE 365. HERE'S A LOOK BACK AT THIS YEAR'S MOST POPULAR TIPS. @MENTIONS IN OUTLOOK www.office.com/setup Blogs: This is an excerpt from our post Get Someone's Attention in Outlook with @Mentions. Using the @ symbol is a quick way to draw people's attention to important things. Microsoft has rolled this handy feature into Outlook, so here's how you can use it to get people's attention in emails and also save time. (Note: This feature is only available in Outlook 2016, Outlook 2016 for Mac, Outlook on the web for Office 365 Business, Outlook.com, and Outlook on the web for Exchange Server 2016.) ONENOTE FOR PROJECT MANAGEMENT This is an excerpt from our post 5 Keys to Using OneNote for Project Management. Instead of investing in costly project management software, how about using a free program like Microsoft OneNote? OneNote digital notebooks are available on all your devices and can be used for a variety of projects. Whether you are planning a wedding, heading up an office presentation, or writing a thesis paper, OneNote bends to your needs. This post focuses on tips for the office, but personal and school projects can be managed with OneNote using many of these same key principles. HIDDEN FEATURES IN WORD This is an excerpt from our post 3 Hidden & Useful Tricks in Microsoft Word. There are lots of great hidden features tucked away in Microsoft Word that you probably don't know about. From activating research tools, to changing the page color of documents to reduce eye strain, to easily capturing screenshots, here are three tricks that you will enjoy. WORD ONLINE VS. WORD DESKTOP This is an excerpt from our post 3 Things You Can Do With Word Online That You Can't Do With Word Desktop. Word Online isn't just a simple online word processor. To get the full value of the product

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 first hybrid standalone virtual reality console with Lighthouse positional tracking for SteamVR and Android"