Free Microsoft Office Templates by Hloom.com

Posted on February 26, 2017. Filed under: Freeware/Shareware, Google, Microsoft Excel, Microsoft Office Suite, Microsoft Word | Tags: , , , , , , , , , , , , |

Free Microsoft Office Templates. Download fully customizable professional samples for resume, invoice, flyer, memo, invitation, certificate, fax, cover page. For Word and Excel – also PDF and Google Docs!

Source: Free Microsoft Office Templates by Hloom.com

Read Full Post | Make a Comment ( Comments Off on Free Microsoft Office Templates by Hloom.com )

ASAP Utilities Excel add-in

Posted on September 3, 2011. Filed under: Freeware/Shareware, Microsoft Excel, Utilities | Tags: , , , |

ASAP Utilities has a free edition for home use, students and charitable organizations (Home and Student edition) which is designed to make Microsoft Excel easier and faster to use.  (There’s also a pay version.)

Recommended by TechRepublic.

The tools are organized into the following categories

  1. Vision Control…
  2. Favorites & Shortcuts…
  3. Select…
  4. Sheets…
  5. Range…
  6. Columns & Rows…
  7. Numbers…
  8. Text…
  9. Formulas…
  10. Fill…
  11. Format…
  1. Objects & Comments…
  2. Web…
  3. System…
  4. Information…
  5. Import…
  6. Export…
  7. Start…
  8. ASAP Utilities Options…
  9. Find and run a utility…
  10. Info…
Read Full Post | Make a Comment ( None so far )

Three timesaving Ctrl-key tricks in Excel

Posted on March 28, 2011. Filed under: Macros & Shortcuts, Microsoft Excel | Tags: , , |

TechRepublic has Three timesaving Ctrl-key tricks in Excel.

 

Read Full Post | Make a Comment ( None so far )

Fixing Excel charts

Posted on February 28, 2011. Filed under: Microsoft Excel | Tags: , , , |

Juice Analytics has a CleanCharts addon for Fixing Excel charts.

Recommended by freewaregenius.

Read Full Post | Make a Comment ( None so far )

10 things I can never remember how to do in Excel

Posted on February 27, 2011. Filed under: Microsoft Excel, Techniques | Tags: , |

Okay, I confess — TechRepublic has found the 10 things I can never remember how to do in Excel.

They also explain how to do them.

Read Full Post | Make a Comment ( None so far )

OpenXML/ODF Translator Add-ins for Office

Posted on February 26, 2011. Filed under: File conversion, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Word | Tags: , , , , , , , , , |

OpenXML/ODF Translator Add-ins for Office is a download for your Microsoft Office Suite (or parts thereof) that allow Office programs to read the Open Document formats produced by other programs, such as OpenOffice/OxygenOffice (which is on the Library Software disk).

If you’re using OpenOffice at home, but Microsoft Office elsewhere, this is one way to handle transferring files.

Of course, you can always simply save the OpenOffice files in Microsoft Office format.

Read Full Post | Make a Comment ( None so far )

Shading alternate rows in a filtered Excel worksheet | 10 Things | TechRepublic.com

Posted on June 14, 2010. Filed under: Microsoft Excel, Techniques, Tutorials | Tags: , , , , , |

TechRepublic has 10 steps to shading alternate rows in a filtered worksheet for Excel users.

Read Full Post | Make a Comment ( None so far )

Sparklines in Excel 2010

Posted on February 21, 2010. Filed under: Microsoft Excel | Tags: , , |

Office Watch has information on the new Sparklines in Excel 2010.

“Sparklines are simply tiny charts that show up within a cell in the Excel 2010 worksheet. These miniature charts represent changes for a particular row or column of entries.”

More tips are also available in another post.

Read Full Post | Make a Comment ( None so far )

10 things I can never remember how to do in Excel

Posted on December 7, 2009. Filed under: Microsoft Excel | Tags: , , , |

TechRepublic has 10 things I can never remember how to do in Excel and the answers.

Read Full Post | Make a Comment ( None so far )

Keep Office 2007 Documents Readily Available

Posted on December 7, 2008. Filed under: Help, Microsoft Excel, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Word, searching | Tags: , , , , , , , , , , , , |

Mysticgeek has a post on how toKeep Your Office 2007 Documents Readily Available the Easy Way .

“How many times have you been looking or a Word of Excel document and what should be an quick retrieval takes several minutes? Sure, you can always search, but for frequently used documents that’s not the best solution.

Today we will look at an easy way to keep your most important documents readily available within Office 2007. This trick works with Word, Excel and PowerPoint just the same… there’s a push pin icon next to each item in the recent documents list.”

Read Full Post | Make a Comment ( None so far )

10 obscure Excel tricks that can expedite common chores

Posted on October 6, 2008. Filed under: Microsoft Excel, Microsoft Office 2007 | Tags: , , |

TechRepublic has 10 obscure Excel tricks that can expedite common chores.

Read Full Post | Make a Comment ( None so far )

Transpose function in Excel

Posted on September 8, 2008. Filed under: Help, Microsoft Excel | Tags: , , , , , , , |

Microsoft Excel has a transpose function that allows you to swap data between columns or rows.

Microsoft Office blog in TechRepublic has instructions.

Read Full Post | Make a Comment ( None so far )

Excel 2007 shortcuts

Posted on May 16, 2008. Filed under: Macros & Shortcuts, Microsoft Excel, Microsoft Office 2007 | Tags: , , , , |

PC Magazine (June 2008) 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
Read Full Post | Make a Comment ( 1 so far )

Here’s looking at you, Office

Posted on December 11, 2007. Filed under: Files, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Windows, Microsoft Word, OpenOffice, viewers | Tags: , , , , , , , , , , |

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 LibreOffice (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 LibreOffice, WordPerfect, etc. to view or edit them reliably.

Read Full Post | Make a Comment ( None so far )

Office 2007 tutorials

Posted on November 8, 2007. Filed under: Everything, Microsoft Office 2007, Microsoft Office Suite, Microsoft PowerPoint, Microsoft Word, Tutorials, wordprocessing | Tags: , , , , , , , , , , , |

Access Librarian Joni Stine recommends the Office 2007 tutorials at Microsoft Online.

Read Full Post | Make a Comment ( 2 so far )

Microsoft Excel utilities

Posted on November 6, 2007. Filed under: Everything, Freeware/Shareware, Macros & Shortcuts, Microsoft Excel, Microsoft Office Suite | Tags: , , , |

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.

Read Full Post | Make a Comment ( 1 so far )

Microsoft Excel 2007 – dealing with the bugs

Posted on November 6, 2007. Filed under: Everything, Microsoft Excel, Microsoft Office 2007 | Tags: , , , |

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

Read Full Post | Make a Comment ( None so far )

Microsoft Excel 2003 cheat sheets for 2007

Posted on November 6, 2007. Filed under: Everything, Microsoft Excel, Microsoft Office 2007, Microsoft Office Suite | Tags: , , , , |

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

Read Full Post | Make a Comment ( None so far )

Microsoft Office 2007 for older versions of Office

Posted on November 6, 2007. Filed under: Everything, File conversion, Files, Microsoft Office 2007, Microsoft Office Suite | Tags: , , , , , , , , |

Office 2007 Formats

Office 2007 uses a new format for Word (.docx), Excel (.xlsx) and PowerPoint (.pptx) files. In order to use these with older versions of MS Office, you will need a “compatibility pack” from Microsoft which works with Office 2000, 2002 (XP), and 2003.

If you don’t want to do that, you must remember to save as an older version format, such as “97-2003”, so your older version can still read it. Office 2007, of course, can still read older formats, but older versions of Office can’t read the newer formats without help.

The following instructions only work if you already have a licensed older version of Microsoft Office.

The Microsoft Knowledge Base article for this is 924074. Remember that Microsoft may change the location of these files, or the wording, but they should have them somewhere on their site.

  1. FIRST download the 2003 viewers for Word, Excel and PowerPoint, and install them. Several versions may be offered, but you want the 2003 viewers.
  2. Then install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats for older Office software (2000, 2002, 2003).

REMEMBER: Office versions older than 2007 currently used on campus cannot read the new formats, so save in an older format if you want to be able to read it without Office 2007.
Be sure to get the free 2003 viewers and install them FIRST before the compatibility pack! They are essential for the compatibility pack to function.

This is NOT for use with other programs such as OpenOffice, WordPerfect, or other software.

Read Full Post | Make a Comment ( None so far )

Liked it here?
Why not try sites on the blogroll...