Wednesday, January 29, 2014

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

Monday, January 27, 2014

New Features in Microsoft Excel 2013 - Coming this Summer 2014

One workbook, One Window

Two workbooks, two windows
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

New Web 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


Chart Tools
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.
Widescreen friendly


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.
Line up and space objects equally

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.
Motion path improvements

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.
Use the eyedropper for color matching

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.
Save your files to the cloud

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


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.
Track changes on the Word ribbon
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.
The line at the margin to show a tracked change is at that location
Word shows a little balloon where someone’s made a comment.
The comment icon in Simple Markup
To see the changes and comments, click the line or the balloon. That switches Word into All Markup view.
Track changes showing in All Markup view
If you’d rather see all the comments, but not all the changes, click Show Comments.
Show Comments command

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.
Lock changes command on the Track Changes menu
  1. Type a password, and then type it again in the Reenter to confirm box.
  2. 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.
The Accept, Reject, and Next buttons
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.


     

Thursday, January 23, 2014

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.