New Functions Coming in Excel 2013

You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, look-up and reference, logical, and text function categories. Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services.  To get more information on each Function, Click here.

FUNCTION NAME	TYPE AND DESCRIPTION
ACOT function	Math and trigonometry:    Returns the arc-cotangent of a number
ACOTH function	Math and trigonometry:    Returns the hyperbolic arc-cotangent of a number
ARABIC function	Math and trigonometry:    Converts a Roman number to Arabic, as a number
BASE function	Math and trigonometry:    Converts a number into a text representation with the given radix (base)
BINOM.DIST.RANGE function	Statistical:    Returns the probability of a trial result using a binomial distribution
BITAND function	Engineering:    Returns a 'Bitwise And' of two numbers
BITLSHIFT function	Engineering:    Returns a value number shifted left by shift_amount bits
BITOR function	Engineering:    Returns a bitwise OR of 2 numbers
BITRSHIFT function	Engineering:    Returns a value number shifted right by shift_amount bits
BITXOR function	Engineering:    Returns a bitwise 'Exclusive Or' of two numbers
CEILING.MATH function	Math and trigonometry:    Rounds a number up, to the nearest integer or to the nearest multiple of significance
COMBINA function	Math and trigonometry:     Returns the number of combinations with repetitions for a given number of items
COT function	Math and trigonometry:    Returns the hyperbolic cosine of a number
COTH function	Math and trigonometry:    Returns the cotangent of an angle
CSC function	Math and trigonometry:    Returns the cosecant of an angle
CSCH function	Math and trigonometry:    Returns the hyperbolic cosecant of an angle
DAYS function	Date and time:    Returns the number of days between two dates
DECIMAL function	Math and trigonometry:    Converts a text representation of a number in a given base into a decimal number
ENCODEURL function	Web:    Returns a URL-encoded string
FILTERXML function	Web:    Returns specific data from the XML content by using the specified XPath
FLOOR.MATH function	Math and trigonometry:    Rounds a number down, to the nearest integer or to the nearest multiple of significance
FORMULATEXT function	Lookup and reference:    Returns the formula at the given reference as text
GAMMA function	Statistical:    Returns the Gamma function value
GAUSS function	Statistical:    Returns 0.5 less than the standard normal cumulative distribution
IFNA function	Logical:    Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression
IMCOSH function	Engineering:    Returns the hyperbolic cosine of a complex number
IMCOT function	Engineering:    Returns the cotangent of a complex number
IMCSC function	Engineering:    Returns the cosecant of a complex number
IMCSCH function	Engineering:    Returns the hyperbolic cosecant of a complex number
IMSEC function	Engineering:    Returns the secant of a complex number
IMSECH function	Engineering:    Returns the hyperbolic secant of a complex number
IMSINH function	Engineering:    Returns the hyperbolic sine of a complex number
IMTAN function	Engineering:    Returns the tangent of a complex number
ISFORMULA function	Information:    Returns TRUE if there is a reference to a cell that contains a formula
ISOWEEKNUM function	Date and time:    Returns the number of the ISO week number of the year for a given date
MUNIT function	Math and trigonometry:    Returns the unit matrix or the specified dimension
NUMBERVALUE function	Text:    Converts text to number in a locale-independent manner
PDURATION function	Financial:    Returns the number of periods required by an investment to reach a specified value
PERMUTATIONA function	Statistical:    Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects
PHI function	Statistical:    Returns the value of the density function for a standard normal distribution
RRI function	Financial:    Returns an equivalent interest rate for the growth of an investment
SEC function	Math and trigonometry:    Returns the secant of an angle
SECH function	Math and trigonometry:    Returns the hyperbolic secant of an angle
SHEET function	Information:    Returns the sheet number of the referenced sheet
SHEETS function	Information:    Returns the number of sheets in a reference
SKEW.P function	Statistical:    Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean
UNICHAR function	Text:    Returns the Unicode character that is references by the given numeric value
UNICODE function	Text:    Returns the number (code point) that corresponds to the first character of the text
WEBSERVICE function	Web:    Returns data from a web service.
XOR function	Logical:    Returns a logical exclusive OR of all arguments

 IMPORTANT   The calculated results of formulas and some Excel worksheet functions may differ slightly between
 a Windows PC using x86 or x86-64 architecture and a Windows RT PC using ARM architecture.

Inserting Online Videos and Play Right in Word 2013

In Word 2013, watch online Video’s, right in Word, without having to leave the document, so you can stay focused on the content.

Here’s how:

In Word 2013, click to open a new document.

On the Word Ribbon, click Insert.  Click the Online Video.

Click the Online Video.  There are 2 options to add Online Videos.  Search using Bing, or search for an URL.

Type what to search for, then Click the Search icon.

Here is a video on Saint Mary’s University.  The video will play in without leaving Word. 
To end the video, hit the Esc key.

Converting PDF to Word 2013

New in Word 2013, convert a PDF file to a Word document.

Here are the steps to follow:

Open Word 2013
Find a PDF file you want to edit/convert.  The following window will appear.

 Another window appears

Word will continue to open the PDF file.
Once open, at the top of the screen there will be an highlighted message.  See image below.  Click on Enable Editing.

     In the window that appears, click OK

        You will get a final window that says some features my not be supported.  Click OK.  See image below

    The PDF will now open in Word and can be edited, etc.  Then saved as a PDF again or as a .docx file.

New Features in Microsoft Excel 2013 - Coming this Summer 2014

One workbook, One Window

In Excel 2013 each workbook has in its own window, making it easier to work on two workbooks at once. It also makes life easier when you’re working on two monitors.

New Excel Functions

You’ll find several new functions in the math and trigonometry, statistical, engineering, date and time, look-up and reference, logical, and text function categories. Also new are a few Web service functions for referencing existing Representational State Transfer (REST)-compliant Web services.

Changes to the Ribbon for Charts

The new Recommended Charts button on the Insert tab lets you pick from a variety of charts that are right for your data. Related types of charts like scatter and bubble charts are under one umbrella. And there’s a brand new button for combo charts—a favorite chart you've asked for. When you click a chart, you’ll also see a simpler Chart Tools ribbon. With just a Design and Format tab, it should be easier to find what you need.

New Features in Microsoft PowerPoint 2013 - Coming this Summer 2014

Widescreen Friendly

Much of the world’s TVs and video have gone to widescreen and HD formats, and so has PowerPoint. There’s a 16:9 layout, and new themes designed to take advantage of widescreen possibilities.

Line-up and Space Objects Equally

No more eyeballing objects on your slides to see if they’re lined up. Smart Guides automatically appear when your objects, such as pictures, shapes, and more, are close to even, and they also tell you when objects are spaced evenly.

Motion Path Improvements

Now when you create a motion path, PowerPoint shows you where your object will end up. Your original object stays put, and a “ghost” image moves along the path to the endpoint.

Improved Video and Audio Support

PowerPoint now supports more multimedia formats, such as .mp4 and .mov with H.264 video and Advanced Audio Coding (AAC) audio, and more high-definition content. PowerPoint 2013 includes more built-in codecs so you don’t have to install them for certain file formats to work.
Use the Play in Background feature to play music while people view your slide show.

New eyedropper for color matching

You can capture the exact color from an object on your screen, and then apply it to any shape. The eyedropper does the match-up work for you.

Share and Save

Share and save your Office files to the cloud

The cloud is like file storage in the sky. You can get to it anytime you’re online. Now it’s easy to save your Office files to your own SkyDrive or to your organization’s site. From there you can access and share your PowerPoint presentations and other Office files. You can even work together with your colleagues on the same file at the same time.

New Features in Microsoft Word 2013 - Coming this Summer 2014

New in Word 2013

Now you can grab any content you want from a PDF and open it in Word 2013.
Convert a PDF file in Word 2013 by clicking File > Open and selecting a PDF file. Word opens the content in a new file.

How PDF Reflow works
Opening a PDF in Word allows you to copy the content you want—including images and diagrams.
When you copy content directly from a PDF file and paste it into Word, the pasted text doesn’t have any formatting. PDF Reflow reconstructs the original layout elements in a Word document where it’s easy to copy, paste, and change content.

Which documents work best with PDF Reflow?
PDF Reflow works best with documents that are mostly text, such as legal, business, and scientific documents. That’s because it’s optimized to interpret a document’s text layout (including lists, tables, and columns).
If a PDF contains mostly images and diagrams, such as a presentation or a brochure, it might not reflow into Word as expected.

Insert Online Pictures and Video

Add and play online videos inside your Word documents. Add your pictures from online photo services without having to save them first to your computer. Click Insert > Online Video to add a video to a document.

Track changes

Touch Guide

When you want to see who’s changing what in your document, turn on Track Changes.

Tip If you prefer to see all your Track Changes options on one place, see Change options for Track Changes. For even more control, see Advanced Track Changes Options.
Click Review > Track Changes.

Now Word’s in Simple Markup view. Word marks up any changes that anyone makes to the document and shows you where the changes are by displaying a line near the margin.

Word shows a little balloon where someone’s made a comment.

To see the changes and comments, click the line or the balloon. That switches Word into All Markup view.

If you’d rather see all the comments, but not all the changes, click Show Comments.

Keep Track Changes on

Now you can prevent someone else from turning Track Changes off by locking them on with a password. (Be sure you remember the password so you can turn them off when you’re ready to accept or reject the changes.)

1. Click Review.
2. Click the arrow by Track Changes and click Lock Tracking.

3. Type a password, and then type it again in the Reenter to confirm box.
4. Click OK.

While tracked changes are locked, you can’t turn off change tracking, and you can’t accept or reject the changes.
To stop locking, click the arrow by Track Changes and click Lock Tracking again. Word prompts you to type your password. After you type your password and click OK, Track Changes is still on, but you can accept and reject changes.

Turn off Track Changes

To turn off Track Changes, click the Track Changes button. Word stops marking up new changes—but all of the changes that were already tracked stay marked up in the document until you remove them.

Remove tracked changes

Important The only way to get tracked changes out of a document is to accept or reject them. Choosing No Markup in the Display for Review box helps you see what the final document will look like—but it only hides tracked changes temporarily. The changes are not deleted, and they’ll show up again the next time anyone opens the document. To delete the tracked changes permanently, accept or reject them.
Click Review > Next > Accept or Reject.

Word accepts the change or removes it and then moves to the next change.
To delete comments from a document, click each comment and then click Delete, or click Delete All Comments in Document.
Tip Before you share the final version of your document, it’s a good idea to run Document Inspector. This tool checks for tracked changes and comments, hidden text, personal names in properties, and other information you might not want to share widely. To run Document Inspector, click File > Info > Check for Issues > Inspect Document.

     

Google Chrome and Tegrity Playback

Google Chrome and Tegrity Playback

Starting with the latest update of Google Chrome (23) Google is now blocking the plugins required for playback on Windows devices.  If you are experiencing issues with Play back in Google Chrome, please follow these directions to re enable the plugins.  Alternatively, you can use either Firefox or Internet Explorer*.

Also a reminder, that Google Chrome will not work at all on Mac OSX devices because Chrome does not allow Silverlight.  Apple users need to use either Safari or Firefox.

*Note: On Windows 8, please ensure you are using the desktop version of Internet Explorer which has the address bar on the top, not the touch friendly version with the address bar on the bottom.

Microsoft Office Spell Checker Missing

To Add the Spell Checker to the MS Office Suite:

Go to the Control Panel

Click Programs

Click Programs and Features

Find MS Office Professional Plus 2010, click on it to highlight it

Click "Change" from the options in the bar towards the top of the pageA MS Office window will openLeave the radio dot on Add or Remove Features, click Continue

Click the + in front of Office Shared Features

Click to highlight Proofing ToolsClick the Black down arrow to the left, choose Run all from My ComputerClick Continue.This will install the spell checker.