Merge Add-in for Excel 2011 for the Mac

By Diane Ross | January 18, 2013

Briefly! RDBMerge is a user friendly way to Merge Data from Multiple Excel workbooks into a Summary Workbook. By Ron de Bruin Excel Automation

Install the RDBMerge utility Download the file. Copy RDBMergeMac.xlam to the folder you want on your Mac. Tip: Use one folder for all your add-ins (easy to backup your add-ins this way) Start Excel and open a workbook.

Excel 2011

Click Tools, click Add-Ins, use “Select” to go to and select the . . .

Continue Reading: Merge Add-in for Excel 2011 for the Mac

Filed under "Excel", "", ""

Use Outlook with Excel add-on RDBMailMac to email Workbooks

By Diane Ross | October 5, 2012

Ron de Bruin, Office MVP-Excel has provided a Mac version, “RDBMailMac” of a popular Excel/Outlook add-on for Windows “RDBMail or SendMail add-in”. RDBMailMac puts emailing of Excel sheets, data, and workbooks where you want it and when you want it as Workbook.

Download links

Windows version: http://www.rondebruin.nl/mail/add-in.htm

Mac version:  http://www.rondebruin.nl/mail/helprdbmailmac.htm

. . .

Continue Reading: Use Outlook with Excel add-on RDBMailMac to email Workbooks

Filed under "Excel, Outlook", "", "", ""

Track New Year resolutions with Excel

By William Smith | December 30, 2011

For anyone who makes lots of New Year resolutions or needs to track progress with other long term goals, Excel can make the magic happen. Fellow MVP Purna Duggirala posted an Excel spreadsheet template that takes advantage of conditional formatting and check-boxes to create a list of goals and track progress as they’re completed. Check completed items and watch as the progress thermometer moves toward 100%.

The template was designed to track 101 things in 1001 . . .

Continue Reading: Track New Year resolutions with Excel

Filed under "Excel", "", "", ""

Convert old Excel (.xls) files to standard (.xlsx) files

By Diane Ross | January 8, 2011

Mac MVP James Gordon has posted directions on how to convert old Excel (.xls) files to standard (.xlsx) files using Automator.

What does this converter do? You choose one (.xls) file, several (.xls) files, or an entire folder filled with (.xls) files and the converter will save a copy of each Excel file in standard open XML file format, better known as the “new” (actually more than 5 years old now) Excel (.xlsx) format. This . . .

Continue Reading: Convert old Excel (.xls) files to standard (.xlsx) files

Filed under "Excel", "", "", "", "", "", "", ""

Access buried features in Excel with a free toolbar

By William Smith | November 20, 2010

Fellow MVP Jim Gordon, co-author of the soon to be released book Office 2011 for Mac All-in-One For Dummies, has posted a free toolbar for Excel 2011 for Mac. The toolbar contains more than 30 generally convenient commands, form controls for worksheets and dialog sheets, VBA commands and some not so convenient tools.

Download the toolbar from his website and open the Excel document. The new toolbar will appear above the new Excel window but . . .

Continue Reading: Access buried features in Excel with a free toolbar

Filed under "Excel",

Excel 2011 defaults to 1900 date system

By William Smith | October 19, 2010

Effective with Office 2011, Excel’s preferences will now default to using the 1900 date system instead of the 1904 date system. From Excel 2008 to 2011, this change is as simple as unchecking one preference selection, however, all new workbooks will now use the different date system by default.

What is significant about 1900 and 1904?

That could be a chicken-and-egg discussion. Excel for Mac uses the 1904 date system and Excel for Windows uses . . .

Continue Reading: Excel 2011 defaults to 1900 date system

Filed under "Excel", ""