Make the following updates to the IT 1150 Week 4 Office Document:

Change the font used for all of the regular text show in the body of the document from New Times Roman to Ariel by modifying and applying the Normal Style.

Change the Size of the Heading 2 items from 13 to 16 by using Styles.

Add a Table of Contents on its own separate page after the title page

Add an Index that lists all Heading 2 text from the document on a separate page at the end of the document.

Use one column and right align all page numbers All main topics should be presented as Heading 1 and all paragraph titles should be Heading 2

o NOTE: Nothing else should be use these headings

Add an Ion (light) Cover page that includes:

o Title "NEW FEATURES IN WORD AND EXCEL 2013"

o No Subtitle

o List the current year where appropriate

NEW FEATURES IN WORD AND EXCEL 2013

With the new release of Office 2013, Microsoft delivers a metro user interface with a modern, clean-cut look. The new release of Office products include the operating system Windows 8 and Office Suite 2013.

New features in Word 2013

Word 2013 entails a smoother text flow, PDFs, editing and collaboration via the cloud, World Wide Web, and SkyDrive account. Word 2013 also allows users to create more professional-looking documents with advanced technology such as embedding online video clips and storing files on the cloud. Some of these features are described below.

Text

In the Tracking group of the Review tab on the Ribbon, there is a new addition to the latest version of Word called Simple Markup. Compared to the current All Markup function, the Simple Markup feature provides a cleaner and less complicated view of your track changes in the document. Also, comments next to the relevant discussion in the document now have a reply button. You can mark any discussion that no longer require attention. The comments will be grey out but not deleted.

Another advanced Word feature is resume reading, in which the software will automatically bookmark the position in the document where you last visited, and then it will open to that specified position the next time you open the document. For documents with columns, the text will also reflow automatically when read on different computing instruments.

When you click on New of the File tab, the Backstage view will open a new full screen that now provide all the document templates that you can choose from. This feature is available on all Office 2013 applications.

PDF Files

In the past version, users can save their Word documents as PDF files. With the later version of Word, users can now open a PDF file and edit its contents, which could include bullet lists and tables, using Microsoft Word 2013.

Online Pictures and Videos

Besides having access to pictures and photos on the hard drive or jump drive, Word 2013 allows users to easily insert images or videos from online sources such as Office Clip Art, Flickr, SkyDrive, YouTube, or Bing Image/Video Search without needing to save them to the hard drive first. The online component is available to the reader as long as there is an active Internet connection. A live preview is also available while you crop and move pictures, photos, charts, and SmartArt diagrams around in your document. You can visit the online sources by clicking the Insert tab on the Ribbon.

Layout Options

When you click on an image, a new Layout Options button will appear at the top right corner of the image, as illustrated in Figure 1. The Layout Options dialog box provides an easier way to format your image. The image can also be a video, shape, Excel chart, SmartArt, or textbox.

Figure 1 Layout Options in Word 2013

Source: http://blogs.office.com/b/microsoft-word/archive/2012/09/19/working-with-images-gets-simpler-in-the-new-word.aspx Collaboration

The cloud technology makes it much easier and efficient for you to collaborate and share your documents with others, especially with those who do not have Word installed on their computers. When you save your documents to your SkyDrive account, even if your reviewers do not have Word, they can still read your online presentation while you make changes. It is important to specify the viewing and editing permissions for your viewers. Some users like to save their documents to SkyDrive as a backup. Others enjoy the ability to instantly publish their Word document as a blogpost.

New features in Excel 2013

The new Excel application comes with a modern feel, simpler navigation, a new design, a modern splash screen, and a powerful user interface. Some of the new features will be discussed in this article.

General Features

For a start, there is a new layout design for templates in Excel 2013. When you click on New in the File tab, the Backstage view will open automatically to the list of templates. The new Flash Fill functionality makes it easier and quicker to automatically fill out columns. It recognizes similar patterns in the data set, and apply and fill other similar data set automatically with the same pattern. The Quick Analysis feature allows the user to hover over the data set and receive formatting suggestions to turn the data set into tables and charts. It has a shortcut to data analysis.

Formulas Tab

Many new mathematical functions are available with the new version of Excel. Excel 2013 comes with a new tab. The Formulas tab has a Function Library group, which contains all the functions classified under various categories such as Financial, Logical, Text, Date & Time, Math & Trig, etc., as shown in Figure 2.

Figure 2 Formulas Tab in Excel 2013

Charts

When you selected a data set, the new version of Excel will automatically recommend the most suitable charts for your data. The Chart Options Buttons will allow you to fine tune the selected charts easily and quickly by changing any of the chart elements, styles, or data set. A rich and enhanced data labels adds visibility to the chart. The best feature is that you can watch immediate animated changes to the chart when the source data is modified.

If you want to create a PivotTable, Excel 2013 will automatically recommend specific PivotTables based on the highlighted data set. On the other hand, PivotCharts can be created independently of the PivotTable. This version of Excel permit users to import millions of rows of data from multiple data sources, thereby eliminating the use of separate add-ins as in the past.