Find and Replace in an Entire Folder of Excel Workbooks Using Easy-XL

Say that you have hundreds of similar Excel workbooks in a folder and you need to globally change "2009 Budget" to "2010 Budget" in all of the workbooks. This will be a long tedious process for someone. The Easy-XL program makes...

Excel 2010 Might Be Slower Than Excel 2003 For Power Users

The pricing for Excel 2010 is about the same as the pricing for Excel 2003. It makes you feel like you are trading one piece of real estate for a similar piece of real estate. If you think that you are simply upgrading to a...

Data Mashups, Hundreds of Million Rows in Excel 2010 Using PowerPivot

Excel 2010 introduces slicers, sparklines, the AGGREGATE function, the Equation Editor and a smoother way to paste, but by far, the best feature in Excel 2010 did not come from the Excel team. After installing Excel 2010, download...

Provide a Custom Theme With Your Company Colors for All Office 2007/2010 Users

Office 2007 introduced the concept of themes to Excel and Word. If someone is designing a report in both Word and Excel, they could choose the identical theme from both Word and Excel to ensure that the documents have the same look...

Tiny, Word-Sized Charts in Excel 2010

Back in 2004, data visualization guru posted an article on his website about small intense charts that he dubbed sparklines. The idea is to fit a lot of data points into a chart that is about the same size as a word. In Excel 2010,...

Tips For Finding Commands on the Excel 2010 Ribbon

As an Excel pro, I could use the old Excel 2003 menus with my eyes closed. I knew where commands were located. I knew the Alt shortcut keys for the commands that I used frequently. Alt+E+S+V was Edit, Paste Special, Values. Alt+E+I+J...

Dashboarding with Excel 2010 Slicers and Multiple Pivot Tables

One of the new features in Excel 2010 is a type of visual pivot table filter called a Slicer. In typical fashion, the most valuable setting for slicers is buried where most users will never find it. A slicer could be a list of...

Load More