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

 Click here to learn how to embed music in your PowerPoint

Excel - Keystroke for bolding in Excel

 CTRL+2 Applies or removes bold formatting. 

Interactive: PowerPoint 2003 to PowerPoint 2007 command reference guide

   Click icon to start the interactive guide.  

Interactive: Outlook 2003 to Outlook 2007 command reference guide

  Click icon to start the interactive guide.  

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.

Syndicate content