If you are working with Excel files on a regular basis, chances are that you have seen your fair share of big and chaotic workbooks that you sadly need to keep things going at work. However, without an engaging, well-organized, and intuitive interface, users quickly grow weary of using these workbooks.
The goals of dashboard & interface design are to…
Let’s be honest: How many times did you have to wait for other users to close a workbook before you could start using it? How often did you have to make the same changes in several places?
When developing Excel solutions – especially if these solutions are meant for multi-user environments – one of the biggest challenges is setting up a database structure which a) allows for synchronizing data between all users, and b) enables users to collaborate.
I can help you to achieve the following goals:
Apart from data storage, one of the most commonly undertaken tasks in Excel is basic data analysis using spreadsheet functions such as CountIf or Sumifs. However, the insights provided by these formulas pales in comparison to what is possible thanks to the introduction into Excel of Power Pivot.
Driven by the DAX functions language, Power Pivot allows users to conduct advanced data analysis and derive truly new concepts from data models.
Excel projects can vary much in terms of scope and desired outcomes. While my largest projects have taken up to a year from start to completion and involved the development of a complete enterprise resource system, others have ranged from a few hours to a few weeks and have involved tasks such as improving the performance of slow and large workbooks.
Here is an example of various projects that clients have trusted me with:
With Microsoft’s release and constant enhancements of the “Power” applications, Excel can now be enhanced by three different programming languages. Combining all languages allows for creating fascinating business intelligence solutions which were previously unthinkable. Thanks to being profficient in and up to date on all languages, I can help you in matters concerning, for instance, cleaning up large datasets, automating tasks, and doing advanced data analysis. Full-scale solutions can be achieved when combining all of these tools.
I am not using any third-party tools or add-ins, which could create incompatibility issues and security concern for some firms.