Microsoft Excel Should Be Easy to Use Based on my 37 years of programming in Microsoft Excel, I can personally tell you that there is absolutely no reason for Excel to frustrate you, or for Excel to be difficult to use. Simply put, Microsoft Excel should be easy to use. If Excel is not [...]
Why Integrate & Automate Microsoft Excel with Microsoft Access Because Microsoft Excel and Microsoft Access were designed by Microsoft to be fully integrated and automated into one seamless solution, with a point-n-click forms driven graphical user interface to merge power with ease of use. Leverage the power of the Access database calculation engine with [...]
XUMO: Microsoft Access Database Development. XUMO/Comcast needed a fully integrated and automated solution in Microsoft Access and Excel for their Hi-Tech Business Startup. The Project: When new business startup XUMO (Eventually acquired by Comcast) needed a Smarter Microsoft Access database developed, they hired our company to build their new business model, the software [...]
Blog Post: The British Red Cross Case Study This blog post goes over a recent Microsoft Excel and Access training project with the British Red Cross in Lebanon. With this post our goal is to give you an idea of what it is like to engage us for one-on-one Microsoft Excel and/or Microsoft Access training, [...]
If you've used tables before you have seen your formulas automatically expand and contract with your data. This is a pretty handy feature of the tables. Some might say they just copy and paste the formulas, but this is not true. (See this blog post to see why structured table references should be used, which [...]
July 2013 Many people (especially in Finance) use Excel and Access almost interchangeably, feeding data between both applications. But if you've never done it, then how do you? There are several ways to import data from Access to Excel, and you don't even need to have Access open. You can import Tables, as well as [...]
Need: Do you have the need to delete duplicate emails from Microsoft Outlook? Perhaps you have accidentally created hundreds of duplicates, and your pst file is so vast you do not have the time nor the energy to remove each of them manually. In this case it would be nice to have an Excel Macro [...]
There's a new add-in for Excel called Data Explorer. Currently it's in preview (beta), so use at your own discretion and risk. What is it? Well the name really does say it all – it lets you explore data. Think of the current mechanisms we have in Excel for getting data (that doesn't require [...]
Slicers were introduced in Excel 2010 for PivotTables. What are slicers you ask? If you don't know, well, you're in for a treat. Here is some background information to bring you up to speed. Introducing Excel 2010 Slicers Use slicers to filter PivotTable data PivotTable Slicers by Jan Karel Pieterse So you should know that [...]
TEMPLATES Have you seen them? Well, if you have Excel 2013 there's no doubt you have, because it's the opening screen when you open Excel now. Microsoft took a new direction in their featured templates, and has developed hundreds of them which are useful and time-saving. When Excel is opened to the New [...]
