Computer Helpers from Boreham Library

Tips, Hints and Links for University of Arkansas - Fort Smith Students, Faculty and Staff

Archive for the 'Microsoft Excel' Category


DocSyncer for Google docs

Posted by dvanarsd on May 19, 2008

Somebody had to come up with a way to synchronize the documents you edit in Microsoft Office so they are available in Google Docs.

Try the free service at DocSyncer to migrate files to Google.

Posted in File conversion, Google, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Word, Online Software | Tagged: , , , , , , , , | No Comments »

Excel 2007 shortcuts

Posted by dvanarsd on May 16, 2008

PC Magazine (June 200 8) has a list of “11 Killer Excel 2007 Shortcuts”:

Ctrl-Shift-& Apply the outline border to the selected cells
Ctrl-Shift-# Apply the Date format with day, month and year
Ctrl-Shift-@ Apply the Time format: hour, minute, AM or PM
Ctrl-Shift-: (colon) Enter current time
Ctrl-; (semi-colon) Enter date
Ctrl-O Hide selected columns
Ctrl-’ (single quote) alternate: cell values/formulas
Ctrl-H Find and replace
Ctrl-F2 Print Preview
Ctrl-F6 next workbook
Alt-F8 macro dialog box

Posted in Macros & Shortcuts, Microsoft Excel, Microsoft Office 2007 | Tagged: , , , , | No Comments »

Here’s looking at you, Office

Posted by dvanarsd on December 11, 2007

Microsoft Office viewers are available if you don’t have Microsoft Office programs. Click here for the download page for viewers for all MS Office products, Word, Powerpoint, Excel, Outlook, Access, and Visio.

Remember: you can see the files with these viewers, but you cannot edit them in any way.

You can also use OpenOffice (freeware compatible with MS Office Suite before 2007) to view Word, Powerpoint, Excel, and Access files (before 2007) as well as edit and save them to MS Office formats such as 97-2003 formats.

Remember: you must not use 2007 formats (ending in “x” such as “.docx“) if you want to use other programs such as OpenOffice, WordPerfect, etc. to view or edit them reliably.

Posted in Files, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Windows, Microsoft Word, OpenOffice, viewers | Tagged: , , , , , , , , , , | No Comments »

Microsoft Excel utilities

Posted by dvanarsd on November 6, 2007

Sources of helpful utilities for Excel versions 97 through 2003 are http://www.excel-extools.com and http://www.asap-utilities.com/. Freeware. Recommended by Gizmo’s Tech Support Alert.

Posted in Everything, Freeware/Shareware, Macros & Shortcuts, Microsoft Excel, Microsoft Office Suite | Tagged: , , , | 1 Comment »

Microsoft Excel 2007 - dealing with the bugs

Posted by dvanarsd on November 6, 2007

Windows Secrets has a section on the bugs in Excel 2007 and how to deal with them.

Posted in Everything, Microsoft Excel, Microsoft Office 2007 | Tagged: , , , | No Comments »

Microsoft Excel 2003 cheat sheets for 2007

Posted by dvanarsd on November 6, 2007

USC Marshall has some excellent cheat sheets for Excel 2007 giving the equivalents for Excel 2003.

Posted in Everything, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite | Tagged: , , , , | No Comments »