Archive: MS Office 2010

Excel – Highlight Cells That Meet Specific Criteria with Conditional Formatting

How to use MS Excel conditional formatting to change text/background colors of cells automatically

Excel conditional formatting

When doing some Excel-based marketing report, whether it’s web analytic report or sales related report, most of the times, I used some conditional formatting to automatically highlight cells that meet certain criteria such as highlighting cells of under-performing or over-performing shops, under/over-performing regions for revenue reports; highlighting cells based on contract value; highlighting cells that have “N/A” or negative numbers; or highlighting cells of web pages that have poor performance in page visits for a certain period of time.

Fix MS Word 2010 to PDF Link Problem

Simple way to fix broken links in PDF after converted from Word 2007 or 2010

MS Word 2010 broken link problem

I’ve lived with this bug for quite a while, just now decided to write a short post about fixing the broken links and broken text problem after converting MS Word 2010 document to PDF. If you don’t experience this issue, then lucky you, if you’ve been noticing the issue, then read on as the fix is very simple. By the way, there’re all sorts of issues with Office 2010, another one is the printing issue with PowerPoint 2010.

PowerPoint 2010 Printing Issue and Workaround

PowerPoint 2010 won’t print with comments. Any possible workaround?

PPT 2010 printing issue

Microsoft Office is not my favorite subject, but since switching to MS 2010, I’ve written several posts about it as many issues have arisen. The latest issue I encountered was that I couldn’t print some PowerPoint 2010 slide decks no matter what I tried. After hours of looking into the problem, here’s what I found.

You can’t print PowerPoint 2010 slides with comment(s)

It’s like a bug in PPT 2010 as I saw many people posting the same complaint about the issue, but there was no clear solutions. You can’t print PowerPoint 2010 slides while there’s or are comments inside the file; even if it’s the only one comment located on the last slide.

Display Excel Data On a Web Page

How to quickly display data from a Microsoft Excel spreadsheet to a webpage online

Display Excel data on website

At the company where I’m working we have a marketing calendar in MS Excel showing schedule for different marketing events and activities. The file is maintained by marketing and regularly updated with new speaking engagement opportunities or changes of venues to current events. And every time we updated it, we put a copy on a network or shared drive so that other people can access it. Later, we made it a little easier to access by putting a link to the Excel file on a web page.

MS Office 2010 Menu/Ribbon Reference

Cross-reference between MS Office 2003 and MS Office 2010

MS Office 2010 reference

As a long time MS Office 2003 user – since 2003, switching to MS Office 2010 was not an easy ride because almost all the 2003 menus are changed in the 2010 version. Even the term “menu” was changed to “ribbon” in 2010. The good thing is Microsoft understood the confusion and created a reference between Office 2003 to Office 2010. The reference can be viewed online as an interactive application [with Microsoft Silverlight] or downloaded for offline use as MS Excel spreadsheets. You can find the links to the reference library at the end of this post. However, before going there, there are some tips I want to share first. Hopefully, you’ll find them useful.