Group items tagged

EMAILS STUCK IN YOUR OUTBOX? www.office.com/setup Blogs: A common complaint of Outlook users is that their email send process takes too long, "hangs," or traps messages in the outbox. Has that ever happened to you? We collected some troubleshooting instructions that should help you get your messages traveling smoothly again. These steps apply to Outlook 2013 and Outlook 2016.

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: If you need to share information from your database with someone but don't want that person actually working with your database, consider creating a report. Reports allow you to organize and present your data in a reader-friendly, visually appealing format. Access makes it easy to create and customize a report using data from any query or table in your database. In this lesson, you will learn how to create, modify, and print reports. 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 creating reports. TO CREATE A REPORT: Reports give you the ability to present components of your database in an easy-to-read, printable format. Access lets you create reports from both tables and queries. Open the table or query you want to use in your report. We want to print a list of cookies we've sold, so we'll open the Cookies Sold query. The Cookies Sold query - www.office.com/setup Select the Create tab on the Ribbon. Locate the Reports group, then click the Report command. Clicking the Report command - www.office.com/setup Access will create a new report based on your object. It's likely that some of your data will be located on the other side of the page break. To fix this, resize your fields. Simply select a field, then click and drag its edge until the field is the desired size. Repeat with additional fields until all of your fields fit. Resizing fields in the report - www.office.com/setup To save your report, click the Save command on the Quick Access Toolbar. When prompted, type a name for your report, then click OK. Saving and naming the report - www.office.com/setup Just like tables and queries, reports can be sorted and filtered. Simply right-click the field you w

www.office.com/setup Blogs: Another tool you can use to connect to a webpage, file, email address, or slide is called an action button. Action buttons are built-in shapes you can add to a presentation and set to link to another slide, play a sound, or perform a similar action. When someone clicks or hovers over the button, the selected action will occur. Action buttons can do many of the same things as hyperlinks. Their easy-to-understand style makes them especially useful for self-running presentations at booths and kiosks. Optional: Download our practice presentation. Watch the video below to learn more about using action buttons in your presentations. INSERTING ACTION BUTTONS You can insert action buttons on one slide at a time, or you can insert an action button that will show up on every slide. The second option can be useful if you want every slide to link back to a specific slide, like the title page or table of contents. TO INSERT AN ACTION BUTTON ON ONE SLIDE: Click the Insert tab. Click the Shapes command in the Illustrations group. A drop-down menu will appear with the action buttons located at the very bottom. - www.office.com/setup Select the desired action button. Insert the button onto the slide by clicking the desired location. The Action Settings dialog box will appear. Select the Mouse Click or Mouse Over tab. Selecting the Mouse Click tab means the action button will perform its action only when clicked. Selecting the Mouse Over tab will make the action button perform its action when you move the mouse over it. - www.office.com/setup In the Action on click section, select Hyperlink to:, then click the drop-down arrow and choose an option from the menu. - www.office.com/setup Check the Play Sound box if you want a sound to play when the action button is clicked. Select a sound from the drop-down menu, or select Other sound to use a sound file on your computer. When you're done, click OK. - www.office.com/setup TO INSERT AN ACTION BUTTON ON A

WWW.OFFICE.COM/SETUP BLOGS: INTRODUCTION www.office.com/setup Blogs: While there are four types of database objects in Access, tables are arguably the most important. Even when you're using forms, queries, and reports, you're still working with tables because that's where all of your data is stored. Tables are at the heart of any database, so it's important to understand how to use them. In this lesson, you will learn how to open tables, create and edit records, and modify the appearance of your table to make it easier to view and work with. 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 tables in Access. TABLE BASICS TO OPEN AN EXISTING TABLE: Open your database, and locate the Navigation pane. In the Navigation pane, locate the table you want to open. Double-click the desired table. Opening a table - www.office.com/setup The table will open and appear as a tab in the Document Tabs bar. The open table - www.office.com/setup UNDERSTANDING TABLES All tables are composed of horizontal rows and vertical columns, with small rectangles called cells in the places where rows and columns intersect. In Access, rows and columns are referred to as records and fields. A field is a way of organizing information by type. Think of the field name as a question and every cell within that field as a response to that question. In our example, the Last Name field is selected, which contains all the last names in the table. Fields and field names - www.office.com/setup A record is one unit of information. Every cell on a given row is part of that row's record. In our example, Quinton Boyd's record is selected, which contains all of the information related to him in the table. Records and record ID numbers - www.office.com/setu

www.office.com/setup Blogs: Microsoft Office files are still very common, but if you're more of a Google Docs, Sheets, and Slides user, you can still edit Word, Excel, and PowerPoint files in Google Drive-if you know how. On the desktop, you'll need to use the Google Chrome browser and an official Chrome extension to edit Microsoft Office documents, using Google Drive's Office Compatibility Mode (OCM). You can edit them like that, or convert them to Google Docs format, which will provide more features. (Don't worry-even if you convert them to Google Docs format, you can re-download them in Microsoft Office format later). You can also edit Microsoft Office files using the Google Drive app and the Google Docs, Google Sheets, and Google Slides apps on iOS or Android. We'll show you both methods in the guide below. HOW TO WORK WITH MICROSOFT OFFICE FILES ON GOOGLE DRIVE ON A PC OR MAC Let's start with the desktop. If the Office file you want to edit and share is still on your PC's hard drive, you can easily upload it to Google Drive and open it for editing in Chrome using a Chrome extension. Open Chrome, go to the Office Editing for Docs, Sheets & Slides extension page, click "Add to Chrome", and follow the on-screen instructions to install it. 01_adding_extension_to_chrome - www.office.com/setup Blogs Once the extension is installed, drag the Office file onto the Chrome window until you see a copy icon as shown below. For my example throughout this article, I'm going to use a Word/Google Docs file, but the procedure is the same for Excel/Google Sheets files and PowerPoint/Google Slides files. 04_dragging_word_file_onto_chrome - www.office.com/setup The first time you drag an Office file onto the Chrome window, the following dialog box displays. Click "Got it" to close the window. You won't see this dialog box again. 05_office_editing_popup - www.office.com/setup Blogs The Office file is uploaded to your Google Drive account and

WWW.OFFICE.COM/SETUP BLOGS: HAVE YOU EVER GOTTEN THIS ERROR MESSAGE? MICROSOFT TELLS YOU, "SORRY, SOMETHING WENT WRONG," BUT YOU DON'T KNOW THE BEST, MOST EFFECTIVE WAY TO TROUBLESHOOT THE PROBLEM. www.office.com/setup Blogs: great way to rescue your PC now We know this error can be frustrating. If you've gotten the "something went wrong" error during an Office 365/Office 2013 (or 2016) installation, we want to help! First, go to this Microsoft troubleshooting article and run the "Fix it" tool. This automated tool will take you through a process of uninstalling Office so you can re-install a clean version. Tip: we've seen the advice to NOT use Internet Explorer to run the tool, but rather another browser like Chrome or Firefox, so you can keep it running even when other Windows applications need to close. Be sure to select "Apply this fix" when offered. Once you're done running the Fix it tool, restart your computer and try re-installing Office. Often, this fix will suffice. If not, move on to alternate methods: Check your internet connection. Make sure you're not on a limited connection and your router's firmware is up to date (to do this, you may need to check with your router manufacturer). Clear your browser cookies & cache and reset Internet Explorer settings. Make sure you've removed older versions of Office. Uninstall earlier Office versions from the Control Panel, or visit this article for more help: How to uninstall Office 2003, Office 2007 or Office 2010 suites if you cannot uninstall it from Control Panel. Temporarily disable your antivirus software. Hopefully you're on your way with Office! But if these solutions don't work, you can find more detailed instructions in this Microsoft support article. If you still need help, post a topic on the Office 365 Community forum.

www.office.com/setup Blogs: The OneNote API team is pleased to announce that we have enabled application-level permissions support for the OneNote API. Until now, OneNote API calls could only be made with user-delegated permissions. This meant that your application would be restricted to scenarios that required a user to be signed in. With application-level permissions support, your application now supports scenarios that do not require a user to be signed in! Read the MSDN article for details of the OneNote API application-level permissions support. With the availability of OneNote API application-level permissions support, many new scenarios that weren't possible earlier are now enabled. Some example scenarios include: Analytics (based on OneNote metadata and content exposed by the OneNote API). Dashboards (based on OneNote metadata and content exposed by the OneNote API). Background provisioning of OneNote content. Background update of OneNote content. During the development process of building the new application-level permissions support for OneNote API, our Product Management and Engineering teams worked closely with third-party partners to ensure that relevant and key education scenarios were implemented. We also ensured that our API would work well with new and upcoming third-party solutions. One of these education companies we worked closely with during the API development was Hapara. "The Hapara Dashboard provides educators with a bird's-eye view into student work across the Office 365 platform. With Dashboard, educators view and access student work from OneDrive and OneNote Class Notebooks from a central hub, making it easier to engage with students and their work across the Office 365 platform. Hapara relies on the new OneNote API to help co-teachers, counselors, coaches and school administrators gain appropriate access to student work in any classroom, something that previously required manual sharing and significant administrative effort by th

www.office.com/setup Blogs: Last summer we introduced Ink math assistant in OneNote-a digital tutor that gives you step-by-step instructions on how to solve your handwritten math problems. Today, we are excited to announce that Ink math assistant can draw graphs of your equations, all within OneNote for Windows 10. Now, when you write your math equations, the Ink math assistant quickly plots an interactive graph to help you visualize those difficult math concepts. You can zoom in and move the graph to observe intersection points or change values of parameters in your equations to better understand how each of them reflects on the graph. Finally, you can save a screenshot of the graph directly to your page to revisit it later. www.office.com/setup FIVE STEPS TO GRAPH AN EQUATION IN ONENOTE Begin by writing your equation. For example: y=x+3 or y=sin(x)+cos(2x). Next, use Lasso tool to select the equation and then, on the Draw tab, click the Math button. From the drop-down menu in Math pane, select the option to Graph in 2D. You can play with the interactive graph of your equation-use a single finger to move the graph position or two fingers to change the zoom level. Use + and - buttons to change the values of the parameters in your equation. Finally, click the Insert on Page button to add a screenshot of the graph to your page. Availability: Ink math assistant is available in OneNote for Windows 10, for Office 365 subscribers. As always, we would love to hear your feedback, so please make comments below or suggest and vote on future ideas on OneNote UserVoice page. For more information, check out our support page. Get OneNote: Mac | iOS | Android | Windows Help: Answers.Microsoft.com -Mina Spasic, program manager for the Math team

www.office.com/setup Blogs: With the release of Office 2016, you might wonder how you can get the latest version of Office if you a one-time purchase of Office 2013 or an existing Office 365 subscription. If you're not sure what version of Office you have, see What version of Office am I using? If you want to upgrade to Office 2016 from an Office 365 for business subscription, see How do I get the new Office 2016 apps using Office 365 for business? GET OFFICE 2016 USING AN OFFICE 365 SUBSCRIPTION OR A ONE-TIME PURCHASE OR OLDER VERSION OF OFFICE For Office 365 Home, Personal, or University subscriptions If you want to install the 64-bit version or install Office in another language, follow the step-by-step instructions in Install Office on your PC or Mac. Otherwise, use the steps below to install Office 2016. Go to www.office.com/myaccount. Sign in with your Microsoft account. This is the account you associated with the version of Office you're trying to install. On My Office Account, select Install. The process to uninstall Office 2013 and install Office 2016 can take some time. When the installation completes, you'll see a welcome video that explains how to find your apps and start Office 2016. For a one-time purchase or older version of Office If you installed a one-time purchase of Office 2013, you can't upgrade directly from within the Office 2013 software. You'll need to either purchase one of the Office 2016 suites of products, such as Office Home & Student 2016, or purchase an Office 365 subscription. For more information about the different options available for purchasing Office 2016, see Choose your Office.

In a slow economy, where training budgets are often slashed, instructional designers must develop training on a limited budget. But how do you cut costs without sacrificing quality? Here are four cost-saving tips to help you save money and time.

There are 5 critical components of elearning that make instructional design successful. This article discusses these five areas.

Instructional uses of web-based survey software

After we posted a list of the Top 47 eLearning & Workplace Learning Blogs last month, we have received several more recommendations for adding more blogs to that list. Apart from these, we've discovered a few more blogs worth following - and these have been added to the list. A total of 27 blogs have been added to the original list. 1. Occasional Rants 2. Mind Leaders 3. Social Enterprise Blog 4. Discovery Through eLearning 5. Mission to Learn 6. Virtual Learning 7. Brandon Hall Analyst Blog - Janet Clarey 8. Speak Out 9. The Leadership Compass by Dr. Michael O'Connor 10. eLearning Roadtrip 11. Nancy White's Full Circle Blog 12. Business of Learning by Doug Howard 13. Aaron Silvers 14. Emerging Internet Technologies for Education 15. Langevin - Blog 16. Learning Technology Learning 17. PsyBlog 18. ZaidLearn 19. eLearning Acupuncture 20. Daan Assen's Learning 21. E L S U A 22. Electronic Papyrus 23. aLearning Blog 24. Lars is Learning 25. Writers Gateway 26. Free as in Freedom 27. Instructional Design: On the road to learning

The Best Cooking and Recipe Tips, Advice, Programs and Products. Detailed instructions on making the Best Meals from around the Globe. The Most delectable Domestic and International dishes. From the tastiest hamburgers to the most exquisite international gourmet meals! Many different styles of food preparation, recipes and cooking!

A story creates an emotional connection with the learner (Like we related ourselves to story characters in our childhood). This emotional impact makes it easier for the learners to remember the training content. Thus, a story helps influence learners to be engaged in the training and eventually execute the knowledge acquired.