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.
Click Tools, click Add-Ins, use “Select” to go to and select the . . .
Continue Reading: Merge Add-in for Excel 2011 for the Mac
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.
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
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
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
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
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