Chrome Cheat Sheet

 Here’s a “Cheat Sheet” For All My Fellow Chrome Users:  userfiles/Chrome Shortcuts.pdf

SPT Specializes In:

 

SharePoint and Visio

 We now offer training in Visio and SharePoint 2010!


Contact Mike for more details.

mike@sptmn.com

651.252.4778 

How to Embed Music in a PowerPoint Presentation

Excel - Keystroke for bolding in Excel

 CTRL+2 Applies or removes bold formatting. 

How to quickly delete blank rows in Microsoft Excel 2007

In Microsoft Excel 2007, go to the Home Tab > in the Editing Group select Find and Select.  Choose Go To Special… > select Blanks and then ok.  Then in the Cells Group > use the down arrow on the Delete command and chose Delete Cells, then Shift cells up.  That will do it.

AutoCorrect feature in Microsoft Office

The AutoCorrect feature in Microsoft Office is a great tool!  [Office 2003 = Tools menu, click AutoCorrect Options. Office 2007 = Click the Microsoft Office Button , and then click Word Options.  In the Word Options dialog box, click Proofing, and then click AutoCorrect Options.]


Here are some useful ones:

More Keyboard Shortcuts – this time for Microsoft Excel

F2: Edit a cell's contents.
Ctrl-1: Open the Format Cells dialog.
Ctrl-Page Up: Move to the next sheet in the workbook.
Ctrl-Page Down: Move to the previous sheet in the workbook.
Ctrl-Shift-": Copy the value from the cell above into the current cell.
Ctrl-': Copy the formula from the cell above into the current cell.
Ctrl-R: Fill contents of active cell into selected cells to the right.
Ctrl-D: Fill contents of active cell into selected cells down.
Ctrl-`: Toggle between showing cell values and formulas in cells.

Ever want to turn a document into a PDF file? Here is a quick and easy way to turn just about any file into a PDF and it is FREE.

Have you ever wanted to share a document with someone who doesn't have the same software as you.  Or, maybe you wanted to share a document with someone but you want it to be unchangeable.  The PDF file format is a great solution to both of these senarios.  Almost every computer can open a PDF file now, and if they can't all they need is the free Adobe Reader from http://www.adobe.com to open a PDF file.

Here's how to make just about any file into a PDF:

Syndicate content