Creating Effective Forms with Excel – The Simple Data Form (Part 1 of 3)
Have you ever gotten an online form from a company or government organization and received a PDF that you had to print out and fill out by hand (and you’ve probably even seen one that looks like a scan of a scan of a poorly built form on an old IBM typewriter)? What’s the point? [...]
Read More About - Creating Effective Forms with Excel – The Simple Data Form (Part 1 of 3) »
Excel: Automatically consolidate data from multiple worksheets?
We had a question at #ExcelHelp this week from somone who wanted to consolidate data from multiple worksheets to a master sheet. My first thougt was use Excel’s native PivotTable functionality for multiple consolidations ranges (easier than it sounds, just follow the Wizard), but this case just needed to move an inconsistent range of worksheets [...]
Read More About - Excel: Automatically consolidate data from multiple worksheets? »
Excel VBA Training & Certification
If you’ve followed any of our posts, then you’ll see that we’re huge proponents of using VBA (Visual Basic for Applications) as a means of automating everyday tasks in the Office environment. One of the most frequent forum comments/requests that we see is for how to learn VBA. Most of the advice that you’ll get [...]
Create Outlook email and appointments from Excel with VBA
The power of Microsoft Office is quite undeniable. The premier application of the suite is Excel. The love/hate relationship we have all had with it endures. Often times you may find the need to utilize multiple Office applications from within one another. An extremely common request is to create emails and appointments in Outlook, all [...]
Read More About - Create Outlook email and appointments from Excel with VBA »
