Group items tagged

www.office.com/setup Blogs: Signing up for the Office 365 is a really straight forward process. You can buy licenses and start the tenant creation, or you can start a trial (30 days) and then add licenses with in that 30 days. Scroll down below where I will walk you through the Office 365 tenant creation. IMPORTANT INFORMATION Microsoft has two main service lines for Office 365 and three main pricing options (SKUs) within each service line; Office 365 Business and Office 365 Enterprise. For an interactive workbook to compare all the features of all the plans, use the following link; Office 365 Service Comparison. FAQ What are the major differences between Office 365 Business and Office 365 Enterprise? Short answer is that it's all about the features you get and size of your business. Office 365 Business has a cap of 300 licenses, so if you are over that the go right to Enterprise. With the Enterprise SKUs, you get more features, but you have to pay a bit more. Take note that with the Business plans, there are limitations not seen in the Enterprise plans. Those limitations include: Microsoft support, Exchange hybrid, Active Directory Connect, SharePoint Online features, Exchange Online features, Microsoft FAST Track support/migrations and Office features. Make sure to do the research and buy the right plan for your business. Can I switch between Office 365 Plans? YES, you can upgrade/downgrade and switch between Office 365 Business and Enterprise plans. Can I mix Office 365 Plans? YES, you can have one tenant with some Office 365 Business licenses and some Office 365 Enterprise licenses. Keep in mind the 300 license cap for the Business licenses. IMPORTANT DECISIONS The decisions here will be needed for the next section, where you will be opening your trial tenant. There are two important pieces of information that need to be taken seriously and cannot be changed once the tenant is created. It's impossible for you and/or Microsoft to change this information

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/setup Click and drag the desired indent marke

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

How to Use the New Microsoft Forms - www.office.com/setup www.office.com/setup Blogs: Have you seen the new Microsoft Forms? One of the most popular articles on my blog in the last 12 months was related to its predecessor - Excel Surveys. Not only did that post get a lot of views, but it also got a lot of comments from people with questions about the features of Excel Surveys, or more importantly for some, the features it did not have. You can still use Excel Surveys, but Microsoft are in the process of transitioning to something better - Microsoft Forms. This version includes automatic grading and built-in student feedback. Here's what you need to know. GETTING STARTED You can find the homepage for Microsoft Forms by going to forms.office.com, or you may see Forms listed in the Office 365 App Launcher. Both links go to the same place. Technically, Forms is still in Preview but you can sign in with your Office 365 Education account today and start creating surveys and quizzes. The new Microsoft Forms work on desktop and mobile browsers. Once you are logged in, click the New button to create your first form. Replace Untitled Form with a title of your choice, and add a description underneath if you want to provide any directions or information for students or parents who are filling out your Form. BUILDING A FORM Tapping the Add Question button gives you access to the question types that are available to you in this new version of Microsoft Forms. The options include: Choice: for creating multiple choice questions! Tap or click the slider to allow people to select multiple answers. You can also tap or click the ellipses button to shuffle answers. Quiz: a multiple choice question that you allows you to select a correct answer for automatic grading. Tapping the comment icon on each answer choice lets you add student feedback for each selection. Multiple answers and shuffled answers are also available to you when working on Quiz questions. Text: to collect

www.office.com/setup Blogs: Microsoft Forms is a new part of Office 365 Education that allows teachers and students to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more. When you create a quiz or form, you can invite others to respond to it using any web browser, even on mobile devices. As results are submitted, you can use built-in analytics to evaluate responses. Form data, such as quiz results, can be easily exported to Excel for additional analysis or grading. WHAT YOU'LL NEED An Office 365 Education subscription. If you're not sure you have this, please contact your IT administrator to verify. An organizational or school ID account for yourself with permissions to use Microsoft Forms. Screenshot showing monitor with form open - www.office.com/setup Create forms in minutes Screenshot showing three people sharing a form - www.office.com/setup Send forms to anyone Screenshot of a monitor displaying charts for a form - www.office.com/setup See results in real time Why can't I log in to Microsoft Forms? Microsoft Forms is available only to Office 365 Education subscribers using a school or organization ID account. GET STARTED QUICKLY Clipboard Bring together teachers and students. Get more done! Create a form or quiz with questions, define settings, share your form, and check the results-in a few easy steps. Step 1: Sign in and create a new form or quiz Step 2: Adjust settings for your form or quiz Step 3: Send your form or quiz to others and collect responses Step 4: Check your form results or quiz results Are you an admin? Learn about security and privacy, Microsoft Forms data storage, and how to turn on or turn off Microsoft Forms in your organization. ADD PICTURES AND VIDEOS TO YOUR FORM OR QUIZ People Enhance your quizzes and forms with pictures and videos. Want to add a logo to your form or display pictures or videos next to quiz questions? You can do all of these tasks quickly in Microsoft Forms. Add a picture

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Microsoft Word 2016 is a word processing application that allows you to create a variety of documents, including letters, resumes, and more. In this lesson, you'll learn how to navigate the Word interface and become familiar with some of its most important features, such as the Ribbon, Quick Access Toolbar, and Backstage view. Watch the video below to become more familiar with Word 2016. GETTING TO KNOW WORD 2016 Word 2016 is similar to Word 2013 and Word 2010. If you've previously used either version, then Word 2016 should feel familiar. But if you are new to Word or have more experience with older versions, you should first take some time to become familiar with the Word 2016 interface. THE WORD INTERFACE When you open Word for the first time, the Start Screen will appear. From here, you'll be able to create a new document, choose a template, and access your recently edited documents. From the Start Screen, locate and select Blank document to access the Word interface. creating a new blank document - www.office.com/setup Click the buttons in the interactive below to learn more about the Word interface: the Word 2016 interface - www.office.com/setup WORKING WITH THE WORD ENVIRONMENT Like other recent versions, Word 2016 continues to use features like the Ribbon and the Quick Access Toolbar-where you will find commands to perform common tasks in Word-as well as Backstage view. THE RIBBON Word uses a tabbed Ribbon system instead of traditional menus. The Ribbon contains multiple tabs, which you can find near the top of the Word window. tabs on the Ribbon - www.office.com/setup Each tab contains several groups of related commands. For example, the Font group on the Home tab contains commands for formatting text in your document. the Font group on the Home tab - www.office.com/setup Some groups also have a small arrow in the bottom-right corner that you can click for even more option

Microsoft Word's table templates are great timesavers. With them, you can quickly apply your own custom formatting to any table in Word. Here's how to create your own table style and save it as a template. The easiest way to create your own table template is to start with one of Word's built-in table styles and then tweak it to your preferences. Go to the Insert tab and click Table. insert table - www.office.com/setup Mouse over the squares in the table grid to select the number of columns and rows you want in the table. Click on the last square to insert the table. Word will now switch you to the Design tab for formatting the table. Click inside the table. Select a style from the Table Styles gallery and take note of the style name. You'll need the name in the steps below. table style - www.office.com/setup table style gallery - www.office.com/setup Click the down arrow next to the Table Styles and select New Table Style. table style new - www.office.com/setup Give this table style a new name. table style create - www.office.com/setup Select the table style you want to base yours on in the dropdown box next to "Style based on" option. table style create select - www.office.com/setup Select your formatting options. For example, you can change the font and font style, change the border and cell colors, and change the text alignment. table style options - www.office.com/setup For additional formatting options, click the Format button at the bottom left of the window. table style format - www.office.com/setup Select "New documents based on this template" so the table style will be available in future Word docs. table style newdocs - www.office.com/setup11. Click OK.

www.office.com/setup Blogs: Having come around to the idea that it needed different versions of Office for different kind of users, Microsoft introduced lightweight versions of Word, Excel, Power Point and OneNote that are neither as pricey or as feature laden as the main versions included in Office. iPad users were the first to get their hands on this new take on Office. With Windows 10, the free Microsoft Office Mobile apps have arrived for some Windows users. 10 Things to Love About Windows 10 (7) - www.office.com/setup Blogs Read: Windows 10 Review - A Love Affair Here's how to get that free Microsoft Office in Windows 10, and what you need to know about it why it's possible for some to take advantage and not possible for others. HOW TO GET FREE MICROSOFT OFFICE IN WINDOWS 10: WHAT IS IT? Microsoft Office is wildly successful. Everyday millions of users all open it to get work done. Millions of documents are written in Microsoft Word. Millions of budgets and sales breakdowns are created in Microsoft Excel. Everyone has created a Microsoft PowerPoint presentation at some point in their life. Screenshot (236) - www.office.com/setup Blogs Windows and Microsoft Office are synonymous. Because the two are often used together and both made by Microsoft, many assume that one comes included with the other. That's never been true. Windows device makers often included shortcuts to trials for Microsoft Office with new PCs. Some even bundled it with their PCs, passing the cost on to buyers. Microsoft Office costs $149 if purchased outright or $6.99 a month through Microsoft's Office 365 subscription service. Office Mobile is what Microsoft collectively calls the free Microsoft Office apps that are now available. Word Mobile lets Windows 10 users view documents. Excel Mobile focuses on spreadsheets. PowerPoint Mobile lets users look at presentations. Outlook is separated into to apps, Outlook Calendar and Outlook Mail. Outlook Mail and Outlook Calendar are a

www.office.com Blogs: Microsoft Office is an integrated suite of business software applications for Windows and Macintosh computers. Office includes word processing, spreadsheet, presentation graphics and email communication programs that provide functionality which is commonly used to run a business office. Office 2010 for Microsoft Windows and Office 2008 for the Macintosh computer are the versions available as of July 2010. ... - www.office.com/setup Blogs Microsoft Office is a suite of software. WORD PROCESSING Microsoft Office includes Microsoft Word for word processing functionality. The program uses a menu interface to provide many advanced word processing features that can be used easily by business and home users. Word includes templates to design documents used routinely in office environments such as sales letters, mailing label formats and invoices. Word documents can contain graphics, sound and video to create multimedia reports. SPREADSHEETS Microsoft Office includes Microsoft Excel to create spreadsheet solutions for home and business use. A spreadsheet is an electronic grid of rows and columns that can be used to enter, organize and calculate data. Separate spreadsheets can be linked to consolidate data across categories such as time, function, or geographic region. Templates for income statements, balance sheets and expense reports are featured within the program. Excel spreadsheets allow you to analyze and report on large amounts of data quickly and easily. PRESENTATION GRAPHICS The Microsoft Powerpoint application is used to create and deliver presentations that can include text, graphics, sound and video. Powerpoint presentations can be delivered in a slide show format using a computer and projection screen, emailed to other users for review or delivered remotely over the Internet. EMAIL COMMUNICATIONS Microsoft Outlook Express is used to create, send and receive e-mail communications. The program automates the linking and embedding of sp

www.office.com/setup Blogs: Office 2016 isn't just about new Microsoft Word and PowerPoint layouts. The new productivity suite has a ton of amazing new tricks and features that are designed to make your work (and play) a lot easier. If you still think of Office as something you tinkered with to write terms papers back on Windows 95, well you're in for a treat. Download the new Office 2016 and you'll get access to tools that automatically separate important and unimportant emails, connect to your social media accounts to help you plan your weekend, and help you plan group trips and activities. For the business user, there are a ton of new Office features that help you better communicate, collaborate and create. I'll walk you through some of these new features and how you can use them to improve your Office 2016 experience. 1. CLUTTER Our SPAM folders are amazing. They collect emails from retailers and businesses with whom we don't want to have any contact whatsoever. But what about that uncle you just can't stand? Or that annoying coworker who constantly asks you to go to lunch? With Clutter for Outlook, your email usage signals whether or not emails should actually enter your inbox. For example: if you never, ever open your uncle's emails, Clutter will automatically send those incoming messages to a folder where they will land alongside your annoying coworker's lunch requests. You can access this folder anytime and move messages back to the normal old inbox. If you're worried you'll miss something important, don't fret. Clutter sends you a weekly digest that tells you exactly what was hidden. You can then command Clutter to never pull in that type of content again. 2. SKYPE INTEGRATION Office 2016 - www.office.com/setup Office 2016 Microsoft has made cloud document collaboration possible (years and years after Google, but I digress). Now, you and a friend can edit a Microsoft Word document simultaneously without having to save and share the document via emai

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: Every PowerPoint presentation is composed of a series of slides. To begin creating a slide show, you'll need to know the basics of working with slides. You'll need to feel comfortable with tasks such as inserting a new slide, changing the layout of a slide, arranging existing slides, changing the slide view, and adding notes to a slide. Optional: Download our practice presentation. Watch the video below to learn more about slide basics in PowerPoint. UNDERSTANDING SLIDES AND SLIDE LAYOUTS When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you'll need to choose a slide layout that fits your content. Different slide layouts - www.office.com/setup Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content. In the example below, the slide has placeholders for the title and content. A slide with empty placeholders - www.office.com/setup TO INSERT A NEW SLIDE: Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts. From the Home tab, click the bottom half of the New Slide command. Clicking the bottom half of the New Slide command - www.office.com/setup Choose the desired slide layout from the menu that appears. Choosing a slide layout - www.office.com/setup The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart. The new slide - - www.office.com/setup To change the layout of an existing slide, click the Layout command, then choose the desired layout. Applying a new layout to a

This post is brought to you by Seayoung Rhee, Product Marketing Manager in the SharePoint Product Marketing Group. Reliable business intelligence and insight are key to a thriving business. Excel, SharePoint and Office 365 make business intelligence (BI) in the new Office more accessible to everyone across an organization as part of their everyday work. New and enhanced features in familiar tools such as Excel empower everyone in a business to easily explore, model, analyze, and visualize data from various sources. With SharePoint, users of all levels can collaboratively develop and share insights through dashboards and scorecards, and this experience continues seamlessly in the cloud with Office 365. For corporate environments, these features are further enhanced by SQL Server for higher levels of performance and scalability both on-premises and in the cloud with BI Azure. Ultimately with Microsoft BI, anyone in the organization can develop the insights that help drive new discoveries and make better, more informed decisions. EXPLORE YOUR DATA PowerPivot was a popular add-in to Excel 2010, allowing users to create large data models with hundreds of millions of rows in Excel. This feature is now natively embedded in Excel to reduce the hassle of downloads and installation. PowerPivot is also supported in SharePoint with SQL Server Analysis Services where the workbooks with PowerPivot models can be shared broadly across the organization. New features like Quick Explore aid users in navigating their data, and Quick Analysis provides previews of their charts, graphs, and scorecards. Users can: Combine and analyze large datasets with PowerPivot Summarize data and discover trends with Quick Explore Instantly preview charts and pivot tables with Quick Analysis www.office.com/setup VISUALIZE YOUR INSIGHTS Introduced with SQL Server 2012, Power View provided a canvas to create visual dashboards in SharePoint. Now this feature is embedded into Excel and SharePoint so

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: 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: We're moving deeper into the modern "walled garden" of digital life. Generally speaking, you choose the garden you like best - be it Apple, Google or Microsoft - and the more time and money you invest, the more painful it is to leave that ecosystem. Similarly, many people pick Evernote or Microsoft OneNote as their repository of choice for digital scraps, doodlings and scanned documents. Then they usually stick with that choice, because it's not easy to toggle between them or switch. About a year ago, I chose Evernote over OneNote, and I started amassing my own digital archive. At the time, Evernote's Mac software was far superior to OneNote's Mac app. However, Microsoft has continually upgraded OneNote for Mac and iOS, and today it's a legitimate Evernote rival; if I were facing the Mac Evernote versus Mac OneNote decision today, it would be a different situation. If you're a Windows user, the choice is even more challenging, because the OneNote 2013 Windows desktop app has valuable features that aren't available in Evernote or OneNote for Mac. To help you decide between these two notebook tools, I've come up with seven things OneNote does that Evernote can't. Of course, this is only one side of the story. For the flip side, read "6 things Evernote does that OneNote can't." 1) ONENOTE IS A DESIGN-FRIENDLY, FREEFORM CANVAS Each OneNote note is a blank canvas, every element its own movable container. If you have a stylus, you can draw anywhere within the note, and you can insert handwriting, blocks of text, images or any other element wherever you want. onenote freeform canvas - www.office.com/setup OneNote 2013 for Windows also lets you customize your notes. For example, you can change the "paper" color, add rule or grid lines, change the dimensions of notes, create new page templates or apply existing ones, and apply text styles. Other versions of OneNote, including the iPad and Mac apps, offer some but not all, of these capab

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

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. THE BASICS OF CONDITIONAL FORMATTING FOR DATES To find conditional formatting for dates, go to Home > Conditional Formatting > Highlight Cell Rules > A Date Occuring. www.office.com/setup You can select the following date options, ranging from yesterday to next month: www.office.com/setup These 10 date options generate rules based on the current date. If you need to create rules for other dates (e.g., greater than a month from the current date), you can create your own new rule. Below are step-by-step instructions for a few of my favorite conditional formats for dates. HIGHLIGHTING WEEKENDS When you design an automated calendar you don't need to color the weekends yourself. With the conditional formatting tool, you can automatically change the colors of weekends by basing the format on the WEEKDAY function. Assume that you have the date table-a calendar without conditional formatting: www.office.com/setup To change the color of the weekends, open the menu Conditional Formatting > New Rule www.office.com/setup In the next dialog box, select the menu Use a formula to determine which cell to format. www.office.com/setup In the text box Format values where this formula is true, enter the following WEEKDAY formula to determ

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: Every PowerPoint presentation is composed of a series of slides. To begin creating a slide show, you'll need to know the basics of working with slides. You'll need to feel comfortable with tasks such as inserting a new slide, changing the layout of a slide, arranging existing slides, changing the slide view, and adding notes to a slide. Optional: Download our practice presentation. Watch the video below to learn more about slide basics in PowerPoint. UNDERSTANDING SLIDES AND SLIDE LAYOUTS When you insert a new slide, it will usually have placeholders to show you where content will be placed. Slides have different layouts for placeholders, depending on the type of information you want to include. Whenever you create a new slide, you'll need to choose a slide layout that fits your content. Different slide layouts - www.office.com/setup Placeholders can contain different types of content, including text, images, and videos. Many placeholders have thumbnail icons you can click to add specific types of content. In the example below, the slide has placeholders for the title and content. A slide with empty placeholders - www.office.com/setup TO INSERT A NEW SLIDE: Whenever you start a new presentation, it will contain one slide with the Title Slide layout. You can insert as many slides as you need from a variety of layouts. From the Home tab, click the bottom half of the New Slide command. Clicking the bottom half of the New Slide command - www.office.com/setup Choose the desired slide layout from the menu that appears. Choosing a slide layout - www.office.com/setup The new slide will appear. Click any placeholder and begin typing to add text. You can also click an icon to add other types of content, such as a picture or a chart. The new slide - - www.office.com/setup To change the layout of an existing slide, click the Layout command, then choose the desired layout. Applying a new layout to a