Uncategorized

Utilizing the Immediate Window The immediate window is a console of sorts that allows the user to enter VBA code that can be directly evaluated or executed during the development or debugging process. It is useful for checking values and states at various points in the execution of a routine. It can also be used […]

Excel is a spreadsheet. At least that is the extent many users get with Excel. It is capable of so much more. Rather than organize customers and accounts, you can organize map locations, health, damage, locations and other parameters that games must manage as well. It can be taken even farther and build the games […]

One is a database. One is a spreadsheet. However, Microsoft Access and Microsoft Excel go together like spaghetti and meatballs or ice cream and hot fudge. They serve different purposes, but together they create something extremely useful. Common uses of Excel: data analysis for calculations/statistical comparisons to make charts Common uses of Access: data management […]

With the right Excel consulting service and/or Excel training, even the most complicated spreadsheets can be streamlined and automated.

Custom applications written in VBA for Excel enable you to leverage Microsoft Office Software that is likely already loaded on your computer. These applications can analyze large data sets using powerful analytic techniques and generate summaries with understandable visuals that give healthcare providers insights into patient health, patient care, and practice performance like never before. […]

Dynamic tables provide you with a host of additional features that a simple manual data list will not. For instance, look at the first section (A1:F6). This is how most manual lists are maintained within a simple Microsoft Excel worksheet. By simply selecting the range, in this example: (A9:F14), selecting the Insert Tab in the […]

Coatue Management, a top hedge fund based out of New York City, had 2 custom night time Excel training sessions at their midtown location and video conferenced their California office as well. Custom course materials were provided and training was delivery by David G. Although, we did not supply the Sushi on the back table, […]